(Jeremy Kadlec) Our organization has sensitive SQL Server data we need to protect as we migrate the production database to lower life cycle environments. We need to move our production databases on a regular basis to testing, development and training environments to conduct user testing, performanc

(Kenneth Fisher) I’m a big fan of the sp_help system stored procedures, which is why I’ve been a bit disappointed that the sp_helpindex stored procedure is rather badly flawed. It doesn’t have the included columns from the index.

(Greg Larsen) There are times where you might want to programmatically determine which edition of SQL Server is running. When I say “Edition” I don’t mean are you running SQL Server 2012, 2014, 2016, or some other major release of SQL Server.

(Chris Webb) My second-favourite feature in SSAS Tabular v.next after Power Query integration is the Detail Rows expression property for measures – it not only brings drillthrough on measures to Tabular, it means that we can define meaningful drillthrough on any measure, no matter how it is calculat

(Scott Murray) I heard Power BI Desktop has a focus mode? Is that for images? What exactly does it do? How can I better manage the visualizations in Power BI? How can I embed my images in Power BI?

(Arun Sirpal) I did not want to miss out on this one because I want to mention a connect item that I logged last year which is still active.

(Melissa Coates) As I put together a new presentation on my current favorite topic (modern data warehousing), it occurred to me that others might feel like there’s some confusion and/or overlap with terminology.

(Eli Leiba) You need to write a query that creates a bunch of LIKE statements for an unknown number of values, such as the code sample below:

(Ujjwal Patel) In this post we would like to explain one of the interesting issues that we encountered while upgrading a SQL Server Instance.

(James Serra) In a perfect world a data warehouse would always return all queries very quickly, no matter what the size or complexity of the data warehouse.