01Apr 2010 by Grant Fritchey 5 Comments

Renewed as an MVP

Misc
I received my renewal notice and, after checking the message header, it is April 1st, I got very happy. I'd try to wax poetic about this, but I just read Paul Randal's (blog | twitter) comments on the fact that he and Kimberly Tripp (blog) were just renewed. As in lots of things, he did a better job than I can in describing exactly what this means.
Read More
23Mar 2010 by Grant Fritchey No Comments

SQL Saturday #39 New York

PASS
New York, New York, it's a hell of a town. The Bronx is up and the Battery's down. The people ride in a hole in the ground... Anyway, my abstract for SQL Saturday #39 in New York was accepted a while ago, but I just got all my reservations set, so I'm going for sure. This should be a pretty exciting event based on the people and the schedule. Hope to see you there.
Read More
18Mar 2010 by Grant Fritchey 5 Comments

Undocumented Virtual Column: %%lockres%

SQL Server, T-SQL
One of my development teams needed a mechanism for identifying the value of a key that was part of a lock (don't ask). I'd never tried doing that before. Obviously if you hit the DMV sys.dm_tran_locks you can see the hash of the key in the resource_description column. But how to pull the value back. After some research, I first found this excellent article by the late, great, Ken Henderson (I really wish he was still around). The article outlined, among other things, the use of an undocumented "virtual" column called %%lockres%%. Some more searching then uncovered this great article by James Rowland-Jones, AKA Claypole. He described how, in a very high volume system, he used %%lockres%% to identify the source of a deadlock as the internal mechanisms that SQL Server uses to manage locks, the hash…
Read More
15Mar 2010 by Grant Fritchey 1 Comment

SNESSUG March Meeting

Misc, SQL Server
Aaron Bertrand showed up to teach us tips and tricks for SQL Server Management Studio. We had to move our meeting night because of a conflict at our wonderful host, New England Tech. But we still had 12 people show up. For SNESSUG, that was a good turnout. I gave away some swag that I had received from Microsoft and some stuff that we had purchased. Bribary works (at least that's my theory, so feel free to bribe me, whenever). Aaron's presentation was great. He's just showing nothing but meat. There's no fluff. He's just showing a series of tips & tricks in SSMS and explains why you want to use them. First revelation, -nosplash has no effect whatsoever on load time. He called it a placebo. It just kept…
Read More
11Mar 2010 by Grant Fritchey 9 Comments

Location of the PASS Summit Follow-up

PASS
I got a little distracted after lunch and was reading through some of the various bloggers reactions to the decision to keep the Summit in Seattle for the forseeable future. I enjoyed Brent Ozar's take on the situation, but the thing that struck me square in the eyes and inspired me to add one more post of my own, was a comment on Brent's post by Aaron. Scroll down and read it. Here's the part that really made an impact: This whole situation is making me less interested in supporting the organization. As a relative newcomer to PASS and having never attended a Summit, I’m turned off by the “come talk to Microsoft employees” stance. I’d rather them say come and talk to (or sing Karaoke with?) cool guys like…
Read More
10Mar 2010 by Grant Fritchey No Comments

Location of the PASS Summit

PASS
There has been some discussion recently around the location of the PASS Summit. The debate was centered on the results from a recent survey hosted by PASS. Today's Community Connector has an editorial by the PASS President, Rushabh Mehta, explaining why those of us on the East Coast will be flying to the other side of the continent for the next two years, and supplying the results of the survey I get why they're doing this. Microsoft really will commit more resources to an event that is in their back yard. I get it. I also understand, that those of us who consider the PASS Summit a big part of our "community" are actually in the minority. Most people attending the Summit aren't involved in the community, aren't interested in…
Read More
09Mar 2010 by Grant Fritchey 4 Comments

Blog Anniversary

Misc
Two years old. In March of 2008 I received a whopping 96 visits. I'm up to 1900 so far this month. I'd call that a positive growth trend. Thanks for stopping by, especially if you've been here more than once.
Read More
08Mar 2010 by Grant Fritchey 2 Comments

MacGyver?

Misc
Who the heck is MacGyver? Television program you say? Hang on. I need to visit imdb.com... Oh, the late eighties... Yeah, I wasn't watching TV in the late eighties. Actually I didn't own a TV in the late eighties. But reading a few of the plot lines (you guys watched this?) I get the idea. Nuts. I don't think I'm MacGyver. Can't we just buy something to fix the problem? Honestly, the only thing that comes to mind was the time when I needed to get alerts when jobs failed, but I couldn't install DBMail on the server because our admin types didn't want mail clients on our machines. What to do? Use event forwarding. Instead of setting up the mail client on a server, I got it installed on a…
Read More
01Mar 2010 by Grant Fritchey 3 Comments

Powershell for Batch Operations

PowerShell
I'm right in the middle of moving one of our databases from Oracle to SQL Server (and I just love saying that, over & over). Evidently the most common practice in Oracle is to leave all the tables as heaps. That's a tad bit problematic approach for SQL Server. We moved the structure from Oracle to SQL Server with almost no changes and now we're cleaning up the mess fixing the structure iterating the design. I needed to drop & recreate 250 plus indexes.  Remember, I'm lazy. A few minutes bouncing around the web and looking at the wonderful book "SQL Server 2008 Administration with Windows Powershell" and I put together a simple little script that generates a script for dropping and recreating all the primary keys on the tables and, as a…
Read More
26Feb 2010 by Grant Fritchey 2 Comments

Help with Learning Powershell

PowerShell
If you're not reading Buck Woody's blog, why not? Today he posted a helpful hint for getting performance counters directly out of PowerShell v2. I'll add a little bit to the hint, don't try running this on your XP boxes. It doesn't hurt anything, but you get a helpful little message "Get-Counter : This cmdlet can only run on Vista and above."
Read More