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

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

Speaker of the Month: September 2013

This is my second post in what I hope will be an ongoing series. You can see the rules for...

SQL PASS Virtualization VC Presentation Wednesday September 11 at 11AM MST

Next Wednesday I will be delivering a session for the SQL PASS Virtualization virtual chapter entitled “SQL Server High Availability...

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