It’s important to write the right code on the right server, since each mistake can be very expensive in this area. Below are a few common...

Imagine the following scenario: After a very nice weekend, you get up in the morning with a smile on your face, get to work and drink...

Cursors (and partially while loops) have a really bad reputation in the SQL Server world. Basically, there are three good reasons that...

Before I became a SQL Server DBA, I used to be a web developer in ASP3. Since then, I sometimes maintain the websites I still have. Fix...

Dynamic Search Queries SQL Injection is a widely known issue with databases that work as back-ends for websites and applications. In the...

SQL Server 2012 introduced a new feature – code snippets inside Management Studio. And even better, you can create your own snippets....

I came across Bob Beauchemin’s post, stating that the SQL Azure default isolation level is read committed snapshot. This is generally...

One of our main processes was performing badly. During the investigation, we found that most of the time is wasted on creating temporary...

On some occasions, migrating from text, ntext or image to varchar(max), nvarchar(max) or varbinary(max) can hurt performance. How is that...

Today I attended SQL in the City in London. The event was (very well) organized by Red Gate. I got to meet some great SQL Server MVPs and...