Grant Fritchey

22Apr 2010 by Grant Fritchey No Comments

PASS Summit Content Survey Results

PASS

The results of a survey conducted by the PASS organization have been posted (thanks to the Board for all their work, again). Since getting to speak at PASS is a competition, I really shouldn't be pointing this out, because I'd like to speak again. However, if you're trying to decide whether or not a detailed discussion of Windows Server 2008 Collation would be more interesting to the attendees than a session on Filtered Indexes (it wouldn't) you can go check it out on the survey. It should help you make better choices for what the attendees want to see. Of course, if everyone runs off and submits sessions on the same four or five topics, that's going to open up others. Regardless, this is a service to the attendees because…

21Apr 2010 by Grant Fritchey No Comments

SQL Server Standard: Volume 7, Issue 3

Misc

FINALLY! It's not like Don Gabor had the article done in January or anything...oh wait. He did have the article done in January. However, it looks like we might be breaking the log jam and we'll be publishing a number of SQL Server Standard issues. Anyway, do you want to learn how to talk techie to non-techies? You do? That's excellent because I've got a fantatic article by Don Gabor (blog), just for you. Please go and read it.

20Apr 2010 by Grant Fritchey 2 Comments

SQL Saturday #39, New York, New York

PASS

A town so big they named it twice. If you're not excited about SQL Saturday in NYC this weekend... why not? Take a look at the schedule. There are some excellent speakers presenting there. This is going to be a great opportunity to learn a lot of stuff, network with your peers, and possibly pick up a bit of free swag. What's not to like? See old friends, meet new friends, learn stuff and all for free. I'm presenting a session called MUQT (pronounced "MUCK" the T is silent because we shouldn't be doing this).

19Apr 2010 by Grant Fritchey No Comments

Powershell Script for Verifying Space

PowerShell

First let me say, I know my Powershell skills are sub-par. I'm working on it. Slowly but surely. That said, I had a problem to solve. It's one that I could have done with TSQL, but it would be very ugly TSQL, probably involving dynamic queries, and even for admin scripts, I try to avoid that. So, I went for SMO and WMI wrapped by Powershell to solve the problem. What was the problem you ask? We automate as many of our processes as we can. One process we do is resetting databases from production or other sources. Our processes work very well, but we occasionally run into a problem where the source system db has grown and the target system doesn't have the required disk space. So, we needed…

16Apr 2010 by Grant Fritchey 10 Comments

Powershell SMO Problem

PowerShell

We've been running the Enterprise Policy Management tools available from Codeplex for a few months now (Thanks to Buck Woody's (blog | twitter) session at the PASS Summit). They're honestly great. It's a fantastic way to use Policy Based Management on 2000 and 2005 servers. We did hit some issues with timeouts and looking at the script, it made a call to invoke-sqlcmd, but didn't pass the -querytimeout value. That means it default to 30 seconds and the import to database process was taking more than a minute for some of our queries. I did a little looking around and decided to just disable the timeout by passing a value of zero (0). But, I still got timeouts. Finally, after a bit of searching around, I found a closed (because…

16Apr 2010 by Grant Fritchey 7 Comments

Confio Ignite: Part II

Tools

I'm continuing to evaluate Confio's Ignite database monitoring tool. I've had it collecting data on a couple of production servers for about a week now. Based on what I've seen so far, it's looking like a pretty good piece of software. Breaking with the usual tradition, I'm going to talk about the things I'm not crazy about with the software, before I start singing its praises. The first thing, thatÂ I thoughtÂ was missing, but is actually just hard to find,Â is the ability to look at the query information that Ignite collects, broken down by database. It looks like you should be able to get to it by looking at the Databases tab, but instead you have to first drill down into a time-period, then select specific databases within that time period,…

14Apr 2010 by Grant Fritchey 3 Comments

SNESSUG 4/14/2010

Misc, Visual Studio

Tonight's Southern New England SQL Server Users group is sponsored by Idera. Our presenter is Scott Abrants of Iron Mountain. He's talking about deploying databases using Visual Studio Team System:Database Edition. We have a good turnout with 12 people (yeah, we're small). Scott's presentation was a lot of fun and very informative. He's very involved with automating his deployments to a fare-thee-well. He really has Visual Studio dancing and singing. It was a very thorough overview of the VSTS:DBE soltuion.Â Other user groups should be jealous that we got to see this presentation.

14Apr 2010 by Grant Fritchey 23 Comments

The SQL Server Community

PASS

I attended, and spoke at, the inaugural meeting of the Seacoast SQL Server User's group last night. There were about 60 people in attendance. An excellent turn-out and congratulations go out to Mike Walsh (blog | twitter) and the other organizers. I was curious about something after watching Mike present the PASS monthly slide-deck. He asked how many people were PASS members. Approximately a third of the audience raised their hands. When it was my turn to speak, I asked how many people had heard of Buck Woody (blog | twitter). I was honestly shocked when only about 6 people raised their hands. Then I asked how many had heard of Paul Randal (blog | twitter). This time I had about 9-12 people. Finally, I asked about Brent Ozar (blog…

13Apr 2010 by Grant Fritchey 1 Comment

Southern New England SQL Server Users Group

Misc

Tomorrow, Wednesday April 14th, is the next SNESSUG meeting. We're going to get a great presentation from Scott Abrants on using Visual Studio Team System for database deployments. I saw Scott presenting this at SQL Saturday:Boston to a packed room. If you didn't get to see it then, come on down to Rhode Island tomorrow evening. You won't be sorry.

12Apr 2010 by Grant Fritchey 5 Comments

Seacoast SQL Users Group

Misc

Tomorrow is the Seacost SQL Server User's Group inaugural meeting. I'll be presenting a session called "Understanding Execution Plans." It's my introductory session on execution plans and I love giving it. Please come by and support this new user group. Mike Walsh (blog | twitter), the new user group president, is under the impression I draw a big crowd. While that isn't true, please show up anyway just so that Mike has a successful first meeting. I promise a bit of free stuff. Remember, interactivity is bribed encouraged.