Grant Fritchey

31Aug 2009 by Grant Fritchey No Comments

24 Hours of PASS

PASS

Or, as you should tell your boss, 24 hours of free training by many of the leaders of the industry presenting original sessions that will teach you about topics from SSIS to Spatial Data to Index Selection to CLR performance to... well, you get the idea. This shouldn't be a hard sell for anyone to their boss. "Hey, remember that problem we had the other day with the database that was in simple recovery mode? Yeah, well, Kalen Delaney is presenting for an hour on just that topic." Your follow-up question to the boss, should then be, not, can I, but "Do you want me to get a meeting room and project this for everyone?" Developers, designers, architects, administrators, and managers are going to be able to find something interesting…

29Aug 2009 by Grant Fritchey No Comments

SQL Server Standard Update

Misc

We've received wonderful support from the community. Brad McGehee has a list with great people on it who have volunteered to be technical editors. A bunch of people have inquired about writing for the reincarnation of SQL Server Standard (SSS). I've accepted, to date, eight different abstracts. I've started learning what it means to be an editor. I've gone through first drafts on four articles from some great people. They're smart and you're going to love the information they're putting together for you. But, we need more. A lot more. Please look over the requirements and if you meet them, consider sending us an abstract (send it to grant.fritchey -at- sqlpass dot org). A few suggestions to help you out. Right now, we're looking for technical articles. But that doesn't…

29Aug 2009 by Grant Fritchey 2 Comments

#ActiveAugust Final Post

Misc

I haven't done well with this. I missed a post. I missed a bunch of workouts. I put on weight. Basically #ActiveAugust for me was one giant bag of FAIL. Anyway, I finished up the week with a couple of days teaching karate. I did workouts before class, including a tabata on the heavy bag and just general calisthenics, shadow boxing andÂ practicing techniques. I got my chainsaw back from repairs today. I cut & split wood for about 2 1/2 hours. Final weight 201 from a start of 194. That's +7 in four weeks. Not good. Is the next month going to be #StarvationSeptember? That's what I need.

25Aug 2009 by Grant Fritchey 6 Comments

PASS Board Nominations

PASS

I think the Professional Association of SQL Server users (PASS) is an extremely important organization for SQL Server DBA's. Even if you're not a member, you've never attended the Summit, gone to a local chapter meeting, read the magazine (while it was in print), took part in the special interest groups, or even read the technical articles available on the web site, you know, or work with, someone who has. What's more, the people who get involved with PASS are the ones that are growing and expanding. PASS members are the ones that are becoming leaders in the industry. PASS members influence the direction Microsoft takes with its products. PASS, it's members and volunteers,Â foster and grow the speakers, teachers, writers and MVP'sÂ that are showing you how toÂ performÂ your craft as a…

24Aug 2009 by Grant Fritchey No Comments

New Book

Uncategorized

Well, three chapters. The latest book I worked on is up at Apress. I only have three chapters in this one, backup, restore & performance monitoring & tuning. It's written as an introductory book, targeted to helpÂ get people started as a DBA. I haven't read the chapters from the other authors, but Rob Walters is aÂ terrific writerÂ & a great guyÂ and Carmen Taglienti has a wonderful reputation, so I suspect their work will be everything you could ask for. Of course, it's not real until you can get it on Amazon.

21Aug 2009 by Grant Fritchey 15 Comments

What happens when you use WITH RECOMPILE

SQL Server, T-SQL

I saw this question and my immediate thought was "Well, duh, the execution plan is recreated by a recompile." But, someone a bit smarter than myself suggested that, in fact, no plan was stored in cache, forcing a new plan to be created each time the query was run. So, which is it? Does a plan get added to cache and then removed every time the procedure is called, or do you get nothing in cache and the "recompile" is actually a compile every time? As Mr. Owl says, let's find out. I have a small script that looks like this: CREATE TABLE [dbo].[Test]( [col] [varchar] (10) NULL ); CREATE TABLE [dbo].[Test2] ( [col] VARCHAR(10) NULL ); INSERT INTO dbo.Test (col) VALUES ('Val1'), ('Val2'), Â ('Val3') ; INSERT INTO dbo.Test2…

20Aug 2009 by Grant Fritchey 3 Comments

Two Book Recommendations

PowerShell, SQL Server

I have two new books that I can heartily recommend. This isn't a review of either book since I've only just started reading them. However, I've used each to solve a couple of small problems within a day of having them on the shelf. To me, that proves their worth. First up is Michael Coles new book "Pro SQL Server 2008 XML." I'm still a bit jittery with XQuery... OK, I have a hard time writing XQuery and I have to look up how to do every step and I still get things wrong. Anyway...Â There are two entire chapters devoted to how to use XQuery and an appendix with anÂ XQuery & XPath reference. Great stuff. Look for an extended review several weeks from now after I've had a chance to…

13Aug 2009 by Grant Fritchey No Comments

SQL Server Standard Writing Guidelines

Misc

Well, actually, these are the guidelines for submitting anything to SQLPASS, but it includes the guidelines for SQL Server Standard. If you're considering submitting an abstract (and please, don't consider it, do it) read through there for the basic information. I've accepted six different abstracts so far on a variety of topics. It's going to be some good stuff from some really smart people. A sampling of topics includes; expanded use of tally tables (table of numbers), designing partitioning schemes (I'm looking forward to this one), multi-level SSIS project dependency and communication, how to read and interpret execution plans (not by me), and a full description on triggers. We need more. If you've got writing experience, please, write an article for SQL Server Standard. Abstracts are all that is required…

12Aug 2009 by Grant Fritchey 3 Comments

Excellent Blog List

SQL Server, T-SQL

For the one or two you that are not reading Buck Woody's blog (and why aren't you), you may not have seen that he's posted a recommended reading list of the blogs that he reads on a regular basis. This list must be reviewed by you, now. Go on, I'll wait here till you get back.

12Aug 2009 by Grant Fritchey 4 Comments

SQL Quiz 5: SANs Mirroring

SQL Server

My turn to answer Chris Shaw's questions "Do I feel I have a reliable SAN solution?" and "Describe Database Mirroring for the layman?" Thanks Tim. I've a feeling you're going to be disappointed. SAN: Hell, how should I know? Want to talk about a black box? Our SAN, as far as I'm aware, is run by a group of crack-shot ninja assassins and powered by pureed virgin unicorn. This strange mix of esoteric skill, magic and bloodÂ is evidently able to provide us with just about perfect up time. Once, one of the ninja's must have gone rogue (speculation)Â and had to be put down by his brother ninjas because we had a drive disappear on the cluster server. It took us a couple of hours, but it recovered as if it…