Cloud Nirvana

T-SQL Tuesday is a recurring blog party, that is started by Adam Machanic (Blog | @AdamMachanic). Each month a blog will host the party, and everyone that want’s to can write...

Cloud Nirvana

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

Index Fragmentation : Quick Tip

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

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

Loadbalancing SQLServer

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

Lock Pages in Memory in SQL Server on VMware – Why or Why Not

Two weeks ago I presented my session entitled “Squeezing Top Performance from Your Virtualized SQL Server” at the SQL PASS...

More Azure Goodies

Microsoft keeps sneaking little things under the door for Windows Azure SQL Database. This time it’s a couple of new...

Power BI first impressions

I have been using Power BI the past few weeks (see my video of all the features) after I was invited...

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

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