(Bob Ward) In December of last year, I announced some changes made to improve the performance DBCC CHECKDB. To be perfectly transparent, I created a very short tale of these changes because the Cumulative Update was just shipped and I was going to be out of the office for the rest of the year. Afte

(Marcin Policht) In one of our recent articles published on this forum, we provided a comprehensive listing of new and enhanced features introduced in the Integration Services incorporated into soon-to-be released SQL Server 2012.

(Andrew J. Brust) The SQL Server relational engine matured a long time ago. There have been advances, of course, in performance, fault tolerance and high availability, not mention encryption, compression and file-system integration.

(Chris Shaw) Database mirroring is a great option for many disaster scenarios. If using a witness server automated failovers can be achieved. However, just like any other disaster recovery solution database mirroring should be tested. Before you execute your first test of failing over a database f

(Stacia Misner) In one my recent MDX classes, a student asked about automation of MDX queries for the purposes of testing query performance, so today I’ll answer that question and draw your attention to a few resources available.

(Pinal Dave) Earlier I wrote the blog post SQL SERVER – Disable Guest Account – Serious Security Issue, and I got many comments asking questions related to the guest user.

(Ashish Kumar Mehta) SQL Server 2012, code named Denali, has new features to perform Logical Functions such as CHOOSE and IIF that can be used to perform logical operations. In this tip we take a look at some basic examples of how this could be used.

(Satnam Singh) A couple of days back at I got a call from my support team informing me that one of our database located on the Production Server went into Suspect Mode. The version used was SQL Server 2005 Service Pack 3. Being a Production Database server, it was a Priority 1 incident and the expec

(Sam Vanga) No matter how simple it is, new things come with some confusion; at least until you get used to it. Analysis Services 2012 Tabular is no different. This post will look at steps to create your first Tabular project.

(Buck Woody) I don’t normally like to discuss things in terms of tools. I find that whenever you start with a given tool (or even a tool stack) it’s too easy to fit the problem to the tool(s), rather than the other way around as it should be.