Dedupe Data CTE

As a DBA working with SQL Server, some data issues arise that need to be fixed.  One such data issue is the duplication of data.  Duplicate data can happen for a number of reasons.  One […]

SQL Server Standard Reports Winforms

In SQL Server, there is a good set of preloaded reports to help you monitor the Instance.  These reports can be found under the Standard Reports and can be reached via context menu.  To find […]

DB Benchmarking

As database professionals, we have a need to benchmark performance of the database, processes, and essentially overall performance.  When benchmarking, it is preferable to get a baseline and then run the same benchmark tests on […]

SQL Bitwise Operations

How many DB professionals have never had to deal with bitwise operations in SQL Server?  Who has never had a single value in the database represent more than one data value?  Have you ever had […]

Database Maintenance

I often see a request for some scripts to help with database maintenance.  Sometimes those questions come in the form of recommendation requests for maintenance plans.  As many already know, there are some really good […]

March SSSOLV Reminder

This is just a quick reminder about the meeting coming up on March 10, 2011 at 6:30 PST.  You can find more information about the event from here. I am looking forward to this presentation. […]

Re-purpose my TableSize Script

Last Year I introduced a couple of scripts that I worked on.  Those scripts developed into a series covering the comparison of some methods and MS provided stored procs that could help you in the […]

S3OLV March 2011

The Ides of March are upon us and that means that we have another opportunity to learn some stuff about SQL Server.  We have that opportunity because it is time for the monthly S3OLV User […]

SQLServerPedia Blogger Awards

Several moons ago I learned that I had won one of the categories for the 2010 SQLServerpedia Blogger Awards.  You can read about that here.  Of all of the promises made in that post, I […]

PASS Summit Volunteers Needed

Well, we are coming around into a new year.  With this new year there is once again PASS Summit preparations that are well under way.  Time has come again for people to volunteer to help […]