SQL Server MVP Deep Dives 2, Chapter 58
No matter how good and sophisticated a BI tool is, business users will invariably export data to Excel. – Chapter 58, SQL Server MVP Deep Dives V2
SQL Server MVP Deep Dives 2, Chapter 10
I’m finally back to my chapter reviews and I restarted with a fun one. I know enough to be dangerous with powershell, but I don’t use it enough to keep it fresh in my brain. Right off I liked the idea of this chapter because I got to play with scripting and do something a little different (at least for me). I know there are other ways of gathering this type of data us ing T-SQL (Brent Ozar’s sp_blitz being the first one that comes to mind), but I haven’t done it with powershell before and I certainly never used powershell with Excel before.