High Availability within Windows Azure VMs – An exciting opportunity !

Windows Azure Virtual Machines is a real game changer as it gives us ability to spin up VMs in no...

A Short Treatise on Studying (#mcmstudy)

So I’m studying a lot these days, and I find myself evaluating and reconsidering the theories of “study” that I’ve...

PowerShell – Uptime of Multiple Machines – Example for Custom Formatting and Grid View

This post is to help you out in finding UpTime of one or more computers also you can pass file...

Last Weeks Top “Reading” Links #48

Monday morning and it’s time for weekly round-up.  This edition makes number #48.  As a change to this week’s post,...

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