Monthly Archives: June 2014

How In-Memory Database Objects Affect Database Design: Or does it?

This part is part of an ongoing series of blogs I am writing while preparing to give a presentation based on the prefix of this blog’s title. It is a work in progress as I explore the effects of the new in-memory model. I would love comments that tell me that I am wrong (especially if it turns out that I am!) Before I start describing what I have discovered so far along the way, let’s make a few educated guesses. I have my data model from the previous blog entry ( here ), and I have a plan of attack…(read more)

Successfully Virtualizing SQL Server

This session will help clarify the decision process that goes into deciding to virtualize and guide you on how to deploy or migrate successfully to a virtual platform. It will guide you on how to monitor the environment, and how to avoid the common pitfalls of moving to a virtual platform.

Finding Unused SQL Server Stored Procedures With PowerShell

We currently possess over 300 servers, most of which have at least 10 databases and most of those databases contain at least 100 stored procedures. We know that we only use a small fraction of these procedures and for our cleaning effort (or, in some cases, an effort to upgrade to 2012), we would like to know how to automate finding unused stored procedures.

Fix for SQL Server 2012 SP2 Data Corruption Issue Now Available

Microsoft recently announced service pack (SP) 2 for SQL Server 2012. However, we were aware of a potential data corruption issue related to online index rebuilds, so we had been recommending that customers avoid installing it until the fix was available.

That hotfix is now available: http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2969896&kbln=en-us 

Note that there is also a fix for SQL Server 2012 SP1 and for SQL Server 2014 RTM.

How In-Memory Database Objects Affect Database Design: The Logical and Physical Models

This part is part of an ongoing series of blogs I am writing while preparing to give a presentation based on the prefix of this blog’s title. It is a work in progress as I explore the effects of the new in-memory model. I would love comments that tell me that I am wrong (especially if it turns out that I am!) Now that I have the conceptual model I want to work with (and bunch of “life” tasks out of the way), I head now into fleshing out the model. I go ahead and add attributes, along with domains…(read more)

The Power Query story keeps getting better

It seems like anyone that’s talked to me this year has heard me going on and on about how Power Query is just the nicest new bit of tech that’s come from Microsoft lately. We cover it as part of our one-day Power BI Core Skills training class and as part of day 2 in our BI Core Skills classes that we recently updated for SQL Server 2014. Out of all the technologies that people see during that week, Power Query is the one that seems to promote the biggest discussions.


It’s also a product that keeps getting improved constantly. Another new update for Power Query is out and you can find it here: http://www.microsoft.com/en-us/download/details.aspx?id=39379&WT.mc_id=Blog_PBI_Announce_DI


Here is a video that shows what’s been updated: https://www.youtube.com/watch?v=Q9boOzu298Q 


The blog post from the team that shows what’s changed is here: http://blogs.msdn.com/b/powerbi/archive/2014/06/26/6-new-updates-in-power-query-june-2014.aspx


For me, the one big thing that Power Query is now missing is a corporate story beyond Excel/Power BI. The queries that you create in Power Query are actually M language queries. This is a very capable language (unrelated to what the industry used to call the M language), that Microsoft have documented here: http://go.microsoft.com/fwlink/?LinkID=320633


I would so love to be able to take the queries that I generate in Excel and paste them into an SSIS data source, or use them as a data source in SSAS tabular. Once those types of options appear (surely they must), this is going to be even more of a killer application. 

SQL Server 2014 Cumulative Update #2 is Available

Microsoft has released Cumulative Update #2 for SQL Server 2014. Important! This Cumulative Update fixes the data loss / corruption issue with online index rebuilds that I talked about in this blog post on sqlperformance.com . KB Article: KB #2967546 48 fixes listed publicly at time of publication (52 total) Build number is 12.0.2370 Relevant for @@VERSION 12.0.2000 through 12.0.2369 (And no, they haven’t fixed the license terms screen yet; it still makes it seem like an update for SQL Server 2014…(read more)

PASS and Summit 2014 Session Selections

Earlier this week, the Professional Association for SQL Server (PASS) announced speaker and session selections for the Summit 2014 and there was spirited community feedback, questions, and debate. I offer the following analysis and opinions: In Defense of PASS… Full disclosure: I was selected to present this year and have been selected to present for several past years. In 2012, I was selected to co-present a full-day, paid, pre-conference session in 2012 but not selected to present during the Summit…(read more)