Developers Rate Azure One of Their Favorite Tools

Yeah, Azure.
How we program, what we program and where we program is changing. All the time. This excellent article lays...

DMV-14 : Which Table has Max. rows & Size……..sys.dm_db_partition_stats

sys.dm_db_partition_stats DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms187737.aspx
Returns page and row-count information for every partition in the...

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