(Ashish Kumar Mehta) I have installed a new instance of SQL Server 2008 Analysis Services and I am unable to find the Surface Area Configuration tool that I used to use in SQL Server 2005. How can I manage the Analysis Services features in SQL Server 2008?

(Denny Cherry) SQL Server 2008 introduced the world to the auditing concept, which went well beyond the basic login success and failure that prior versions had allowed us to do with the error log.

I’m sure most of you use DBCC commands and have experience with the WITH TABLERESULTS option to put their output into a table. Did you know that most of the DBCC CHECK commands also accept WITH TABLERESULTS:

(Brian Swan) In a recent post I took a look at how to get started with SQL Server Reporting Services (SSRS). In this post I’ll dive into the SSRS SDK for PHP that was recently released by the Interoperability team here at Microsoft. The SSRS SDK for PHP allows you to render render reports from withi

(SQL Master) From SQL Server 2005 version onwards database mirroring has been a good resource to provide High Availablity for the systems without having special hardware requirement.

(Deanna Dicken) I had a dilemma the other day. I have a feeling there are quite a few folks out there in a similar predicament, so I thought I’d share. We have some legacy tables that were created in one of our databases. The problem is they no longer serve the purpose they were originally intended

(Jason Thomas) Writing a blog is an exhausting experience, most of the times you would be writing your blogs at the expense of your sleep or after a hard day’s work. But then there is a very fulfilling feeling, a joy that you get when you come to know that your work is helping people all around the

(Sankar Reddy) We have many SQL Server instances in our enterprise with several hundreds of jobs across all servers created by many resources from the past and present each with a unique style of verbose logging options. Now, we are standardizing the verbose logging options to always append to a fil

This was a question from one of our readers: “We have a report in which we aggregate the product sales in a wide variety of ways. And then when we drill into it, we want to show the data on a daily basis – which works fine when there is a sale for a product on that day but if […]

(Richard Espinoza) Microsoft SQL Server has a lot of components that you can use. If you want a DBMS, you the SQL Server Database Engine is a really good choice.