Junk Dimensions with no Loading Needed

When you are working with dimensional modeling there are some situations where several dimensional attributes don’t make since to be...

My 2013 PASS Suggestion Tsunami List

Back in August I posted about an approach that Aaron Nelson and I thought of to try to get more...

How do the fixed Database and Server roles map to more specific permissions?

I recently asked what the difference is between granting SELECT to a user (at a database level) and adding the...

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