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 response: I don't believe so, you'd have to be monitoring for that … perhaps a DDL […]

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 used LogMan to collect performance data.  This time I decided to try PowerShell because, well, all […]

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 important lesson I learned when trying to use Start-Job to call a PS script using -ScriptBlock […]

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 at what blog posts were popular and, arguably more importantly, which posts were most thought-provoking and […]

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 Connect item he raised: #332437 : Deprecate UPDATE FROM and DELETE FROM As you can see, […]

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 ask, "Why?") SQL Server 2008 SP1 Cumulative Update #12 – build #10.0.2808 SQL Server 2008 SP2 […]

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 troubleshooting this error number is that the error message returned to the client or application trying […]

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, but I thought I would be able to dig a little deeper with enough relevance to […]

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 to these changes, and they plan to post more details in future posts.  In the meantime, […]

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 led to at least the following three posts, and maybe others I haven't noticed yet: Jonathan […]