Hi, my name is Nick Good and I am a BI Engineer. This is my blog for discussing my interests in Microsoft’s SQL Server and its related products. 25 more words
Tags » SSDT
I was made “aware” of the idea of environment-aware scripts by a colleague of mine a while ago on a project.
Listening to the principles, I wondered why hadn’t I think about this myself before. 828 more words
While writing this Stored Procedure I wanted to properly unit test in SSDT, I faced this annoying little issue:
- My Stored Procedure, let’s call it… 1,444 more words
Today we’re going to through some step-by-step instructions on how to integrate monitoring of SSRS report execution times with the SQL Server Data Collector and the Management Data Warehouse in SQL Server 2008 R2 and above. 1,338 more words
UPDATE // Just found out you *can* actually snapshot the MDW, you just have to use the SqlPackage utility do so, as opposed to SSMS. Updated the post accordingly. 818 more words