22Feb 2011 by Grant Fritchey 15 Comments

What Should PASS Be?

PASS
Andy Warren posted a question the other day (well, issued a challenge actually), “What Should PASS Be?” I’ll let you go and read that & wait here… Done? Cool. Moving on. I have thoroughly enjoyed my associations with PASS over the years. I’ve been a first-time attendee, a volunteer and a presenter at the PASS Summit. I’ve volunteered with the PASS organization with the Special Interest Groups, the Editorial Committee, and as Editor of the SQL Standard. I’ve taken part in 24 Hours of PASS as a presenter, host and attendee. I have helped to put on SQL Saturday events, attended them and presented at them (and we have another one coming up on April 2nd in the Boston area, please register here.). I was one of the founding officers…
Read More
17Feb 2011 by Grant Fritchey 1 Comment

SQL Rally

PASS
I believe I’ve been far too quiet about this event. In May, in Orlando Florida, there will be a two day SQL Server conference called SQL Rally put on by PASS. This is a somewhat unique event since the sessions have all been chosen by the community. That’s right, a series of votes was held online (and if you missed it, you weren’t paying attention) so that all of you were able to decide which sessions you’d most like to see. I’m bringing this up because, now, it’s up to you to register and go. Did I mention the pre-con? No? Well, there will be a one-day pre-conference seminar. There are multiple sessions of excellent material at the pre-con. These were also voted on by the community. One of them…
Read More
15Feb 2011 by Grant Fritchey 3 Comments

UN-SQL Friday #003–Vendor Love

Misc
The love that dare not speak it’s name… Yes, love for vendors. <shudder> Oh, I mean I love my new employer, but other vendors, no never. Although, there was this one time, at band camp… Well, I don’t think we need to go into the details here, Let me just express a little love for a vendor that might not hit everyone’s radar every day, but one that I use almost daily, especially while I’m working on a book. That’s TechSmith, and their excellent tools Camtasia and Snagit. I was introduced to Snagit by Apress, who required their authors to use the tool while working on screen captures. They even provided a licensed copy. I dutifully installed it and started using it. I was impressed. Although, I found out it…
Read More
15Feb 2011 by Grant Fritchey No Comments

SQL Saturday #60, Cleveland Speaker Evals

PASS
I just received 35 speaker evaluations from SQL Saturday #60 in Cleveland. It was a great event (although I had a hard time getting there) and I really enjoyed giving my presentation on “Gathering and Interpreting Performance Metrics” (a warm-up presentation of part of my SQL Rally pre-con). Feedback is a wonderful gift. Thanks to everyone who filled out the eval and especially to those who commented. The evals have six questions and an area for comments. The questions are rated from Very Poor to Excellent. I’ve decided to assign them number values from 1-5. The overall average is 4.82. Here are the breakdowns per question: How would you rate the usefulness of the session information in your day-to-day environment: 4.79 How would you rate the Speaker’s presentation skills: 4.85…
Read More
14Feb 2011 by Grant Fritchey 6 Comments

DBA 101: Why Don’t People Run Backups

SQL Server, T-SQL
It happened multiple times this week. It happens multiple times every week. Some poor soul is posting on a message board, usually with the heading “URGENT” (why that one word so frequently, I just don’t know), that they deleted production data/dropped a production table/updated production data/dropped a database/received a data corruption error/whatever. Now, they need to get the data back. “URGENT, What do I do now?” And so you ask, as you should, what kind of backups do you have? Over and over the answer is: “Backups? What’s a backup” or “Oh, the system guys backup of the MDF files every night” or “We don’t really need those” or “We don’t have room to back up our databases” or some other excuse that simple comes down to, we didn’t set…
Read More
08Feb 2011 by Grant Fritchey 8 Comments

TSQL Tuesday #15–Automation in SQL Server

SQL Server, T-SQL
Automation is the separation point for the professional DBA from the amateur. That makes this a very important topic. Thanks to Pat Wright (blog|twitter) for coming up with something great to write about and hosting the event. I recently wrote an article for the SQL Spackle series over on SQL Server Central on how to “Set Up and Schedule a Server Side Trace.” That covers well what to do to set up a trace on your system so that you can automate it. But I think I left out a few details that I think are worth pointing out here. The basics on creating the Server Side Trace using Profiler and scheduling it using SQL Agent are well covered in the article. The extra areas I want to address are…
Read More
07Feb 2011 by Grant Fritchey 13 Comments

SQL Saturday #60: The Saga

PASS
First, let me thank Erin Stellato (blog|twitter) and all the volunteers for running such a great event. Nicely done. This event was to be my very first walk on to the public stage as a Red Gate employee, so I was excited about getting there. About 10 minutes before I left for the airport, I got a call from the airline. My flight had been cancelled, but no worries, they rescheduled everything for me. Instead of flying to LaGuardia and then on to Cleveland, I would fly past Cleveland to Chicago and then back to Cleveland, getting there at 7:30PM instead of 4:30PM. Ah well. What are you going to do. I’d prefer not to go to Chicago, but everything should be fine… The plane was supposed to leave Chicago…
Read More
02Feb 2011 by Grant Fritchey 25 Comments

PASS Summit Location

PASS
Andy Warren has posted another one of his excellent summaries of what’s going on at the PASS Board. Andy, thanks for what you do. Those of us who care about what goes on at PASS really appreciate your posts. The discussion under consideration this time is the location of the PASS Summit. As you may be aware, it’s been held in Seattle for several years now and will be there for at least two more years going forward. It seems that the board is leaning, extremely heavily, towards making it a permanent fixture in Seattle. I can see why they might do this. First, and biggest, it’s next door to Microsoft. That means the Summit gets tons and tons of Microsoft Employees in attendance, which is a huge draw and…
Read More