Hear, hear to Steve's proposal.

Oh, I totally fell for it too.  Nice work Steve!

Vote up/big thumbs up for the 'dbatools' project as well.  Very well designed and super useful.

Good morning all.  

Nothing wrong with these solutions, but I prefer something more direct like just treating the CSV files as virtual tables and reading them using OPENROWSET...

Although I like PowerShell too, as a BI developer, I prefer to keep as much of my code contained within SSIS as possible. So, in similar situations, I would...

Hi Igor,

In the What Index is Used When Using COUNT? section of the article, you write, "If the table has no indexes (hash) ...". I believe that should be...

Yes, I almost always adjust the model db as well. Just like MyDoggieJessie does.

- John B. (Pittsburgh, PA)

Late yesterday (7/8/2015), the Microsoft SQL Server Engineering Team confirmed that the Analysis Services hotfixes were indeed missing from the release of this CU. They intend to fix this in...

Hi Francis,

Generally speaking, I like the new Cluster Shared Volume support with SQL Server 2014 feature a lot, and I have deployed it to one production active-passive cluster built on...

Thank you for this new Stairway series Greg. I think it is a great idea, and helpful for those like studying for the 70-461 exam.

One minor typo: At...