The Cloud Is Scary – #TSQL2sDay #49

It’s T-SQL Tuesday time! I haven’t contributed in a while, so I really wanted to participate this time. The topic...

T-SQL Tuesday #48 – Cloud Atlas

T-SQL Tuesday is a recurring blog party, that is started by Adam Machanic (Blog | @AdamMachanic). Each month a blog will...

In-Memory OLTP and the Identity Column

Over the past month I've been playing around with the new In-Memory OLTP (code name: "Hekaton") features within SQL Server...

Index Fragmentation : Quick Tip

Fragmentation can cause issues for performance to the point of having queries not resolve at all. Your normally scheduled maintenance...

Prevent creating stored procedures with RECOMPILE hint – Policy Based Management is your friend !

I got motivated to write this post as there was a question on twitter which was like  -

The user was...

How SQL Server Full Backups Work

I’m writing this in support of a few talks I give that talk about backups. This is how I see...

Last Weeks Top “Reading” Links #57

Monday morning and it’s time for weekly round-up.  If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...

For the Aspiring DBA

Getting started as a data professional is an incredibly daunting task. If you’re not concerned that you’re going to mess...

PowerShell – Service Comparison GUI Tool

Service Comparison GUI Tool  does comparison of all the services of any given two servers. The output is a grid view...

Testing network throughput with iperf

Have you ever wondered if that black box in your datacenter called the network is performing as well as it...