SQL Server 2008 Diagnostic Information Queries (May 2012)

Since tomorrow is May 1, I think it is time to publish the latest set of SQL Server 2008 Diagnostic...

SQL Server 2012: Biggest Little Core-house

You sure do got a 'purty motherboard...
Now that SQL Server 2012 is generally available to the public, many companies are...

SSAS File System Error

I received this error the other day when trying to process a particular SSAS cube:
Error      18           File system error: The...

There is awesomeness to be had at #SQLRally

Two days of precons.
60 regular sessions over two days.

The now-famous Women in Technology luncheon.

Open access to Microsoft Customer Service and...

Updated Thoughts on Antivirus on SQL Servers

I hate running antivirus on SQL Servers. I agree antivirus is a necessary evil on most systems, but I don't...

You need to run DBCC CheckDB regularly

You never know when you’ll encounter corruption. It can happen at any time, usually due to some sort of hardware...

Always use Configuration Manager for changing service account

When your service account is expired/disabled or is not having access than sql service could not able to start and you may...

Exposing OData Endpoints using the ASP.Net MVC Web API

The new Web API that comes with ASP.Net MVC 4 has been getting a lot of posts on creating RESTful...

SQL Saturday 130 Deck & Scripts Live

Hello Dear Reader, greetings from SQL Saturday 130 in Jacksonville.  This is just a quick post to say that the...

Appending New Rows Only

I saw a question in the forums related to inserting new rows into a SQL Server table only if they...