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

In my previous post, I’ve demonstrated how Foreign keys can help the optimizer make better decisions when creating an execution plan....

One of the basic rules when creating or altering a table is to configure and adjust the right columns properties such as data types and...

On February 20th I attended the Microsoft event – A Journey into SQL Server 2012. The event was very interesting, and included many great...

I love foreign keys. In my opinion they just make perfect sense. They keep my data “clean” and consistent. Whenever two tables need to...

At first, let’s start with a cool relaxation exercise. Close your eyes and imagine that your DBA work environment includes only one...

Microsoft SQL Server Reporting Services is an excellent and easy-to-use platform for creating, viewing, managing, and subscribing to...