May 2011 - Posts

• May SolidQ Journal is out early!

  We're finally getting the SolidQ Journal out earlier in the month! It's now available at: http://www.solidq.com/sqj . This month, I've continued my 3 part series on SQL Server encryption by specially covering column-based encryption. Next month, I'll Read More... Posted Saturday, May 28, 2011 6:23 PM by Greg Low | 0 Comments

• UPDATE against a table-valued function when declared inline

  The other day I mentioned to a friend that you could only perform an UPDATE against a table-valued function in T-SQL when the function was declared as an inline TVF. He basically didn't understand the point being made at all. That's not really suprising Read More... Posted Sunday, May 22, 2011 3:01 PM by Greg Low | 10 Comments

• Ola Hallengren's Database Maintenance Scripts

  Our buddy Ola Hallengren has released another version of his database maintenance tooling. (Free !) I've seen quite a lot of people using Ola's scripts rather than standard database maintenance plans, and with happy outcomes. In the new version, he has Read More... Posted Friday, May 20, 2011 5:38 PM by Greg Low | 1 Comments

• Skype Error: Exception EXMLDocError in module ezPMUtils.dll at 000E8FCA

  Skype sent down an auto-update today. Looks like it's now 5.3.0.111. Regardless, every time I started Skype, it said: Exception EXMLDocError in module ezPMUtils.dll at 000E8FCA Reboots, etc. didn't fix it. What did fix it was moving the file ezPMUtils.dll Read More... Posted Sunday, May 15, 2011 10:53 PM by Greg Low | 17 Comments

• Microsoft EDW Architecture, Guidance and Deployment Best Practices

  A team from SolidQ has been working with the SQL product team members and reviewers to produce a series of enterprise data warehouse guidance documents. They cover the following topics: Chapter 1 - Overview Chapter 2 - Data Architecture Chapter 3 - Integration Read More... Posted Thursday, May 12, 2011 8:58 PM by Greg Low | 0 Comments

• Changing drive letters: "The parameter is incorrect"

  This error that I came across today typifies what I hate about error messages that I see in various programs. I was trying to change a drive letter in the system management console in Windows Server 2008 R2. I had upgraded my drive to a new drive and Read More... Posted Thursday, May 12, 2011 4:54 PM by Greg Low | 0 Comments

• More free goodness: SolidQ Journal for April is live

  Hi Folks, Great to see that Mai and the team *just* managed to get the April edition of the SoliqQ Journal out in April -> on the last day. I've been meaning to write a short series on SQL Server encryption for some time, so I've provided the first Read More... Posted Monday, May 02, 2011 5:06 PM by Greg Low | 1 Comments