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

Today I want to talk about Log Shipping. Log Shipping is an easy way to implement a high availability solution. It uses SQL Server’s...

After my last post about monitoring deadlocks, I will now show a way to prevent deadlocks and unnecessary locks and to improve system...

What comes first, the chicken or the egg? What happens first – update statistics or re-compilations? The Statistics life cycle As a...