Loadbalancing SQLServer

Loadbalancing SQLServer is not something that comes straight out of the box. If you want to use load balancing you...

Cargo Cult Data Professionals

Ever since David Moutray introduced me to the concept of cargo cult programming, it’s been running round and round in...

T-SQL Tuesday – Cloud Atlas – #TSQL2sDay

This month, Jorge Segarra (Blog | @SQLChicken) is running T-SQL Tuesday on the cloud.  T-SQL Tuesday is a monthly blogging event where a number...

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