18Jan 2010 by Grant Fritchey 3 Comments

What three events brought you here?

Misc
Another one of the DBA bloggers games of tag is occurring. I've been asked by Tom LaRock to answer Paul Randal's question; What three events brought you here. Well, mom was a cheerleader and dad was a football player, so... Oh, wait. I guess I misunderstood the question. He means what three events lead me to becoming a data geek. Well, that's completely different. Luckily, no (further) cheerleaders will be harmed in making this (part of the) story. Geek When I was 16 years old and Jimmy Carter was President, Radio Shack was still considered to be the place for aspiring geek wannabe's. It just so happened that I hit $500 in my bank account about the same time they started pushing this radical thing called a "personal computer." I…
Read More
18Jan 2010 by Grant Fritchey 6 Comments

Database Design Process

Misc, Tools
Buck Woody recently asked a question; how do you design a database. He outlined the process he followed and asked four questions about how each of us do our work: What process do you follow? How important are the business requirements? What tool do you use to create the design, do you need it to diagram, do you even care about diagrams? What's your biggest pain-point about designing? Funny enough, I haven't done a full on database design in over a year. My company just finished about 6 years of very hard-core engineering work, designing and building or redesigning and building, the majority of our data input and collection systems. Then, I was doing lots of design work. Now, we're either largely in maintenance mode for most of those systems, or the…
Read More
13Jan 2010 by Grant Fritchey No Comments

SQL Server Standard Volume 7 Issue 1

Misc
Kathi Kellenberger's fantastic new article is available in the latest issue of SQL Server Standard. There are a lot more articles in the hopper. Keep an eye out for them. We're providing you with the best writers giving us some of their best stuff. Go and check it out. If you're not a member of SQL PASS, it's free to join, and you'll get access to this article, lots more like it, as well as other stuff.
Read More
13Jan 2010 by Grant Fritchey 6 Comments

Connections Sessions Evals

SQL Server, T-SQL
I've kind of been embarassed to post these despite the fact that I received them a couple of weeks ago. Overall, I'd say they're very good, and I'm quite proud of them, but one comment still has me upset. Anyway, here we go: DMV's For Performance Tuning (same session as PASS): 7 responses Q1. Speaker's knowledge of topic Your average score for this session: 4.0 Highest score (all SQL speakers for this question): 4.0 Mean average score (all SQL speakers for this question): 3.74 Lowest score (all SQL speakers for this question): 3.0 Q2. Speaker's presentation skills Your average score for this session: 3.86 Highest score (all SQL speakers for this question): 4.0 Mean average score (all SQL speakers for this question): 3.47 Lowest score (all SQL speakers for this…
Read More
12Jan 2010 by Grant Fritchey 4 Comments

TSQL Tuesday #2

SQL Server, T-SQL
I've wracked my brain for some bit of puzzle that I could present as part of TSQL Tuesday #2 and I finally came up with a bit of something. When you're looking at an execution plan for a query, you know that this represents SQL Servers best attempt at a good execution plan. But, it may not represent the best possible plan. Or, it could be the only possible plan. The puzzle is, how do you know what you're looking at? Is this a trivial plan, meaning it's the only possible execution method for the query? Is this plan fully optimized, or did the optimizer go through it's prescribed cycles and simply take the best plan it had generated up to that point? These questions can be answered directly from information…
Read More
11Jan 2010 by Grant Fritchey No Comments

Horror… sort of

Misc
You must read this post from Tim Ford to understand why I might do this on my technical blog. But Tim's a friend and the chance to branch out, at least a little, could not be avoided. I hope I don't lose too many of my eight readers from this.... The sign read "Live Nude Cats," so of course, I had to go and take a look. It wasn't the best part of town and I certainly didn't have any reason to be there, but the sign read "Live Nude Cats." How could I resist? How could anyone? I parked and locked the car, scanning the parking lot. Not good. There must be 50 different ways a person could get jumped in here, and did I mention this part of…
Read More
11Jan 2010 by Grant Fritchey 2 Comments

New England Data Camp v2/SQL Saturdy #34 Update

Misc
The second annual New England Data Camp is shaping up to one excellent event. We've put together a great set of sponsors. Thanks to them we're providing much better food than last year and the chance at a bit of swag, again, better than last year. But, most importantly, we have an excellent selection of speakers. The schedule has been posted so you can go and check it out and start laying out which ones you can hit. Some of the people speaking are known internationally (Adam Machanic, Aaron Bertrand), some are local luminaries, some are up and coming, and several are probably on the fast track to being MVP's. In other words, this is the place to go to learn something about SQL Server in New England. It's not…
Read More
06Jan 2010 by Grant Fritchey 6 Comments

PASS Summit Evaluations

PASS
The big day has arrived and all the speakers are poring over their PASS Summit 2009 evaluations, me included. These things are always a mixed bag. On the one hand you get nice positive reinforcement. On the other, you wonder how you may have fallen short to not get even higher marks. I'd say I take them as guides and move on, but I don't. I really sweat them and worry about lower marks and ways I could improve... makes me a bit crazy. Be that as it may, here are the evals from my two sessions. Best Practices for Working With Execution Plans (AD-419-S), 59 evaluations Usefulness of Session Poor:0 Average:2 Good:19 Excellent:38 Speaker's Presentation Skills Poor:0 Average:2 Good:18 Excellent:39 Speakers's Knowledge Poor:0 Average:1 Good:12 Excellent:45 Accuracy of Session…
Read More
04Jan 2010 by Grant Fritchey No Comments

SQL Server Standard Article Abstracts

Misc
I'd really like to publish your article in SQL Server Standard. All I need from you is an abstract, a description of what the article will be. I've posted this before, but I've never provided examples. So, to get people started, here are a few examples of articles that have been accepted and will be published (shortly I hope). Here's a great example from Andy Leonard. It includes a great amount of detail, more than I need to make my decision, but with this much detail, the decision is much easier because I know exactly what this article is likely to look like:    I'm interested in writing an article on SSIS for SQL Server Standard. I'd like to cover ways packages can exchange information at run-time. There are a couple…
Read More