September 2013 – Monthly SQL Server Checklist

It’s the first Monday of September and it’s time to check up on your SQL Servers.  In truth, it’s the...

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...