Database fixed roles are predefined roles with specific permissions that allow their members to take actual roles in the organization....

Working as an operation manager and DBA often requires me to examine and produce statistical reports and devise actions based on them. I...

SQL Server Magazine is a great resource for SQL Server DBAs. It offers professional articles, white papers, code samples, blogs, and...

If you ask any SQL Server DBAs about cursors, they will tell you it’s a big no-no. If you search for T-SQL best practices on the web, in...

Recently I was asked by one of our customers about querying XML in a relational format. “Sure”, I answered, “you can use OPENXML to...

If you want to monitor job executions, usually the easiest way is to use the Job Activity Monitor or the Job History Viewer in SQL Server...

This question sounds really easy! The query performance depends essentially on the execution plan, which in its turn isn’t dependent on...

SQL Azure is a Microsoft solution for relational database cloud computing.  It comes as part of the Azure platform.  As with the Azure...

In most sites I’ve been working at, developing Analysis Services solutions, most people were treating the Analysis Services server as a...

This article may be useful when you want to relocate your system databases to another disk on the same server (same instance).  There...