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

In the last SQL Server users group meeting (#120) on July 9th I spoke about common pitfalls when analyzing execution plans. Here are the...

In my previous blog post: Suggestion: “USE” Keyword with Linked Servers, I talked about the suggestion I’ve posted on Microsoft Connect...

Using special functions for querying and executing commands at linked servers is not very convenient, and sometimes even very problematic....

Introduction Service Broker is a cool new feature since SQL Server 2005. Yes, SQL 2012 just came out so it’s hardly “new” anymore. But in...