I was referred to someone on twitter today who wants to email query results without setting up database mail. I explained this in Post 6 of PowerShell Week at SQL University but that example...
This is just a quick blog to help out with something I saw discussed on twitter yesterday. When I do my presentations I have a set of scripts that have the name of the...
In the previous posts we’ve just been poking around with PowerShell and trying to make the examples something that actually means something to a SQL person whenever we ca. There are quite a few...
Recap So far we’ve walked though how to turn on PowerShell and add modules, adding SQL Server 2008 snapins and using PowerShell variables, what cmdlets and functions are, what providers are and how to...
Last week Nicolas Cain ( blog | twitter ) Rob Farley ( blog | twitter ) Aaron Bertrand ( blog | twitter ) and I were all working together on a small skunk-works project...
Late last year I contributed three guest blogger posts to a full week of posts about PowerShell and SQL Server. The posts were published a week before the PASS Summit. In them I tried...
SSIS Tips & Tricks 12/28/2010 12 Noon Eastern Time (GMT-5) Josef Richberg Learn some of the quirks and capabilities of SSIS. Learn about the pitfall of “parallel path choicing”. Use the Script Component as...
Last week Norm Kelm ( blog | twitter ) asked me on twitter ‘What cmdlets/features are missing from SQLPS.exe? Get-Snapin, etc. Where’s a doc that explains?’ To get the cmdlet half of this answer...
Available from dbatools.io and github
SQL PASS PowerShell
Virtual User Group
SQLvariations: SQL Server, a little PowerShell, maybe some Power BI
