Monthly Archive: January 2011

Capturing index operations using a DDL trigger

Capturing index operations using a DDL trigger

Today on twitter the following question came up on the #sqlhelp hash tag, from DaveH0ward: Is there a DMV that can tell me the last time an index was rebuilt? SQL 2008 My initial...

How I use PowerShell to collect Performance Counter data

How I use PowerShell to collect Performance Counter data

In a current project, I need to collect performance counters from a set of virtual machines that are performing different tasks and running a variety of workloads.  In a similar project last year, I...

PowerShell, Start-Job, -ScriptBlock = sad panda face

PowerShell, Start-Job, -ScriptBlock = sad panda face

I am working on a project where I am using PowerShell to collect a lot of performance counters from a lot of servers.  More on that later.  For now I wanted to highlight an...

Greatest Hits : A reflection on my 2010 blog posts

Greatest Hits : A reflection on my 2010 blog posts

Okay, I'm following the lead of Joe Webb (blog | twitter), who recently posted "My Most Popular Posts From 2010."  I think it can be a very useful exercise to go back and look...

Deprecate UPDATE FROM?  Not if I can help it!

Deprecate UPDATE FROM? Not if I can help it!

Fellow MVP Hugo Kornelis (blog) has suggested that the proprietary UPDATE FROM and DELETE FROM syntax, which has worked for several SQL Server versions, should be deprecated in favor of MERGE.  Here is the...

Downgrading a database : "You can't get there from here!"

Downgrading a database : "You can't get there from here!"

I see this question a lot: "I have a SQL Server 2008 R2 database.  Can I attach it to a SQL Server 2008 SP2 instance?" Part of this stems from the confusion over exactly...

New Cumulative Updates for SQL Server 2008 are available

New Cumulative Updates for SQL Server 2008 are available

If you are using SQL Server 2008 SP1 or SP2, the release services team yesterday issued cumulative updates for both branches.  (And if you are still on SQL Server 2008 RTM, I can only...

Troubleshooting Error 18456

Troubleshooting Error 18456

I think we've all dealt with error 18456, whether it be an application unable to access SQL Server, credentials changing over time, or a user who can't type a password correctly. The trick to...

A quick note about the end of SQL Server 2005 mainstream support

A quick note about the end of SQL Server 2005 mainstream support

In a previous blog post about Service Pack 4, I said the following: "…from this point forward all you're likely to see are cumulative updates to the SP3 and SP4 branches and, roughly a...

T-SQL Tuesday #14: Resolutions

T-SQL Tuesday #14: Resolutions

This month, T-SQL Tuesday is being hosted by freshly minted MVP Jen McCown (blog | twitter), and her topic is "Resolutions!"  I already gave a rough sort of overview on my goals for 2011,...

SQL Server v.Next (Denali) : Changes to performance counters

SQL Server v.Next (Denali) : Changes to performance counters

In a previous post about changed system objects in Denali, I talked about the changes to memory-related DMVs due to underlying changes in the memory manager.  The SQLOS team has posted a great introduction...

The fallacy of preventing plagiarism

The fallacy of preventing plagiarism

If you're not living in a cave, you are probably aware of the blog posts and twitter discussions that resulted from an innocent post by Tom LaRock (blog | twitter) yesterday (original post).  This...

A better way to search Connect

A better way to search Connect

I recently spotted a comment from Microsoft on a Connect item with 13 total up-votes.  The comment went something like, "wow, due to the explosive response to this issue, we're going to deal with...