Skills I Used Last Week

Ever thought about what your average week looks like? What are the real core skills your environment uses every day...

Unknown Unknowns: Analysis Services Failing to Start

70-457 Reviewer #12, Restoring SQL Server Databases

This lesson is the third and last part of topic for Managing Data which covers 20% of the certification exam....

A tour of the transaction log: Part 1 INSERT operations

The transaction log is a very important part of SQL Server. Every data modification operation is logged in the transaction...

Be Careful in Business

I like most of the SQL Server people I meet. Most of you are polite, cheerful, friendly, and it’s nice...

Converting SQL_VARIANT on PDW

There are a number of data types that are currently unsupported on PDW. Among those are SQL_VARIANT. The interesting part...

Cumulative Updates - SQL Server 2012 RTM CU9

A 9th Cumulative Update is available for those users still on the RTM branch of SQL Server 2012. This is in keeping with Microsoft’s Incremental Service Modelling.
http://support.microsoft.com/kb/2867319You may have...

PowerShell – Delete Registry Entries – Remote Machines – Example Profile Deletion

 
#The following SID registry entry to be deleted across all mutiple Machines, SID is a user #who owns this user...

Reblog: August 30 to September 5

I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...

Share Your Ideas for Improving PASS on September 9th (Suggestion Tsunami!)

My friend Aaron Nelson was in Florida recently for SQLSaturday #231 and we always find a few minutes to catch...