Checking Your Service Account with T-SQL

Somehow this slipped by me, but there were some new DMVs added in SQL Server 2008 R2 SP1. I suspect...

Choosing the Right Microsoft Reporting Technology Part 1: Report Services

As Business Intelligence has evolved over the years the number of tools we have to choose from for presenting data...

Linked Servers

Do you have linked servers that have been created in your environment?  Do you know what these linked servers are?

Finding...

Linked Servers

Do you have linked servers that have been created in your environment?  Do you know what these linked servers are? Finding Linked Servers SQL Server has provided us means...

March Question: What tool(s) do you use to help you identify and tune slow performing queries?

Tuning poorly performing queries is one of the most important jobs of the DBA. With this in mind, this month’s...

Smart Car Charging

I don’t know if electric cars are the answer, but I do think electricity will play a larger part of...

Speaking at oPASS on March 8th

I will be at oPASS on March 8th (Thursday) in Orlando, Florida. I'll give a preview of the talk I'm giving...

SQL Saturday # 103 in Curacao a Success

On 25th of February 2012, Curacao hosted its first SQL Saturday event. The event was held at the University of...

sql server scripts and managing databases

Managing a large SQL Server inventory requires an efficient management processes.
Following on from DBA  productivity and less is more  , this...

A Script A Day - Day 25 - Performance Counters

Today’s script is based on performance counters and in particular the sys.dm_performance_counters DMV.  There are many ways in which to...