11Aug 2009 by Grant Fritchey 3 Comments

Some Statement Start Times!

SQL Server, T-SQL
I thought I had captured statement start times within the DMV sys.dm_exec_sessions. I was absolutely wrong. However, this has sparked a bit of discussion, as you can see in the link to my correction. John Vanda (I couldn't find a blog by him, but I think this is his LinkedIn profile), suggested possibly joining between the sys.dm_exec_requests and sys.dm_tran_active_transactions through the transaction_id available in the requests DMV. He ran a series of tests that showed it to be promising. I re-ran my original test, a few long-running statements within a batch; BACKUP, CHECKDB, etc.. This time I captured the transaction information along with the other DMV's. The results were interesting. Rather than pull together any particular set of data as I was testing, I just collected all three DMV's once…
Read More
09Aug 2009 by Grant Fritchey No Comments

Microsoft Thrive

Misc
I was introduced to the Thrive program when my user group held a Thrive event back in March. Since then I've referenced some of their material several times. It's a decent little program from Microsoft to try to help out IT pros in this tough economy. Hopefully this won't create a circular reference and bring down one or more web sites, but I got picked to be the IT Pro of the month for August over at Thrive. Nothing comes with it except ever-lasting glory (measured in weeks).
Read More
08Aug 2009 by Grant Fritchey No Comments

Active August #2

Misc
Hrmmm... 198. Up four pounds. That just doesn't seem possible. I did a tabata on Monday. I did have a light workout on Thursday, but I went walking several days this week and I haven't been overeating (except last night at sushi...hmmmm sushi). It may just be last night & a bit of water. However. I will try to be more aware of my intake and try to get an extra workout or two in during the coming week.
Read More
03Aug 2009 by Grant Fritchey 2 Comments

Pain of the Week Webcast

Misc
Thursday this week I get to hang out, virtually, with some of the heavy hitters of the industry, Brent Ozar, Ross Mistry and Kevin Kline. We'll be talking about SQL Server books. Writing them, reading them, reviewing them, finding the right one at the store... It'll be fun. All the details are on the Quest web site.  Come and see why I have a perfect face for radio.
Read More
03Aug 2009 by Grant Fritchey 8 Comments

SQL Server Standard

Misc, PASS
PASS is relaunching the SQL Server Standard with a wholly new approach and format. I'll put more out about it as it becomes available. I just wanted to get the word out now, as far and as wide as I can. Basically submissions are open for articles. We're only interested in publishing experienced writers who've published in some other tech-reviewed medium (Simple-Talk, books, SQL Server magazine, the old SQL Server Standard, are a few examples).  If you're interested, send me a direct tweet @GFritchey or an email to grant.fritchey -at- sqlpass.org. All the details will be published soon over at the PASS web site. Short info for those interested: experienced writers who are members of PASS abstracts can be 4-6 sentences describing the thrust, scope & length of the article…
Read More
03Aug 2009 by Grant Fritchey 5 Comments

24 Hours of PASS

PASS
I'm fairly certain Jack Bauer isn't involved with this new initiative from PASS. Just as I'm also certain I won't be the only person to invoke 24 while referring to 24 Hours of PASS. But even without Jack Bauer, I'm on the edge of my seat. 24 different sessions by top names in the industry from all around the world. I wonder if I can do this without sleep? Probably not. I'll still being trying to attend as many of these as I can work in. I'm really looking forward to it.  People you want to hear are going to be there. Jessica Moss is going to talk about Reporting Services. Adam Machanic is going to introduce CLR. Gail Shaw will be presenting (at something like 2:oh my flipping god…
Read More
01Aug 2009 by Grant Fritchey No Comments

Active August #1

Misc
I like to blog about technical topics and community, not personal stuff. However, this is a community post. A number of active SQL Server DBA's & Developers on Twitter have decided to make August a self-help, support-group month for eating well and being active, Active August. I'm taking part. I'll be posting updates on my weight and general activity once a week. Today, I start with a weight of 194.5.  I went to sword class this morning and spent almost three hours outside splitting wood (with a splitter, I don't have to use the maul these days).
Read More
31Jul 2009 by Grant Fritchey No Comments

PASS & SQL Bloggers

PASS
PASS is trying to find better ways to reach out to SQL Bloggers. They're going to experiment with taking advantage of the new subgroup features offered by LinkedIn. Membership to the subgroup will come fromthose currently listed in the PASS blog directory. If you're looking to get into a tighter, more direct, communication with the PASS organization, be sure you've got a LinkedIn account and that you get your blog listed on the PASS web site (requirements are pretty simple, blog regularly about SQL Server topics).
Read More
31Jul 2009 by Grant Fritchey 13 Comments

No really. When did this statement start?

SQL Server
I thought I had an interesting answer to the question. Unfortunately Adam Machanic, who has been working in this specific area quite a bit longer than I have, and, let's face it, is a bit smarter, pointed out (in the comments) the possibility that I didn't have this quite right. I ran all his tests and sure enough, it wasn't working the same way that I saw it work. First, I tried modifying his query so that it ran the SELECT statements from the DMV's between the operations, but this didn't change the results, start_time and last_request_start_time were the same. From a scientific stand-point, if no one can replicate your results, the experiment failed. So I went back and tried again. To be sure I got things right and wasn't, somehow,…
Read More