08Apr 2009 by Grant Fritchey 15 Comments

PASS Summit 09 Call For Speakers Deadline Extended

PASS
It's now running until Friday April 24th. That's good news if you couldn't get yourself together by this Friday. However, I wonder if they're also extending the time for the committee to make it's decisions? That means extended worry and sweat for those of us who have already submitted abstracts. But, on the other hand, if they haven't extended the committee's deadlines, then that means those guys are going to be working their behinds off to meet the original date (end of May). I also wonder if it means that they're not getting enough abstracts or if the quality of the abstracts has slipped? New this year you can check out the abstracts to see what others have submitted. That makes for some interesting reading, but now I'm wondering if it's…
Read More
07Apr 2009 by Grant Fritchey 3 Comments

SQL Server Standard Article Available

PASS, SQL Server, T-SQL
Unfortunately PASS decided to put the SQL Server Standard to sleep right after I got an article published in it (and no, it wasn't my fault). However, PASS, being the service oriented organization that they are, has decided to make back issues of the magazine available online. So, to read the article I wrote comparing various methods of retrieving versioned data using different TSQL constructs, click this link. Go to page 14. Oh yeah, and you can see other peoples articles here too. There are other things coming out of the editorial committee soon (although I need to get one of them done myself... yikes).
Read More
07Apr 2009 by Grant Fritchey 6 Comments

NULL Is Not NULL

SQL Server, T-SQL
NULL as a concept seems so easy but it leads to so many problems for people. To put it as simply as possible, NULL does not equal anything. It does not "not equal" anything either. It can't be compared to other values in any way. There was a recent post over at SQL Server Central where the user had a query problem that one of the great people over at SSC solved, handily. They also pointed out that the bit of code being used "WHERE nt.NullableString NOT LIKE 'null%'" was also a problem. The user insisted that it was eliminating the NULL values. Well, yeah, sort of, it was, but not because it was actually applying a filter to the NULLs. Remember, a NULL does not equal or "not equal"…
Read More
30Mar 2009 by Grant Fritchey 4 Comments

Reading to Learn

Spatial Data
I just finished chapter 1 of Alastair Aitchison'snew book on SQL Server spatial data, "Beginning Spatial with SQL Server 2008." If this is the beginners book... oh boy. The advanced book must be insane. Seriously though, Mr. Aitchison seems to have written a fantastic book. I'm going to tear through it as fast as I can because I've got two projects that are looking to start using spatial data and quite frankly, I'm a bit lost. There's a great discussiongoing on over at SSC as to the worth of technical books for DBA's. It's based on this editorialby Tony Davis. I'm surprised by the number of people who say they don't use books. It seems that a lot more people use blogs and articles and discussion groups to learn. Maybe…
Read More
27Mar 2009 by Grant Fritchey 5 Comments

Connect Works

Uncategorized
Microsoft Connect works. I've said it before and I'll say it again, but it really does work. You will get the attention of MS developers and they will respond. It's not always fast, but it gets there. Of course, I was trying to create samples for the book, which came out almost two weeks ago, so this is a bit late for me personally... HA! But it really does work.
Read More
26Mar 2009 by Grant Fritchey No Comments

INNER JOIN Experiment in Order

SQL Server, T-SQL
And a new blog. Christopher Stobbs, one of the frequent posters over at SSC decided to try his hand at blogging. His first post is up and it's pretty interesting. He ran an experiment with all different orders of tables, largest to smallest, smallest to largest to see if the order in the joins made a difference. For the answer, click
Read More
25Mar 2009 by Grant Fritchey No Comments

Microsoft Links to Help Your Career

Misc
I received this list of links from my Microsoft rep. It was really an impressive list. So I asked if I could post it to the blog. Figures, it was already out there. Buck Woody had compiled it. It's worth a look through. There really is a lot of information that focuses on you and your career available from Microsoft. Who knew that a big company like that could be so helpful. Also, how great was it that Buck Woody pulled it all together for convenience.
Read More
24Mar 2009 by Grant Fritchey No Comments

Community

Misc, PASS
I'm always impressed and amazed with what happens in the SQL Server community. If you need help, there almost always seems to be a willing and able hand that reaches down to pull you up. It happens again and again, all around. I take part in SQL Server Central, one of the best, and biggest, communities out there for SQL Server. The people that pitch in every day are some of the nicest you're ever going to meet, but they're also extremely well informed. I regularly benefit from people swinging by this blog to offer suggestions or solutions or improvements to my ramblings. I've been making friends and developing contacts at the PASS Summit for the last four years and at my local user's group for the last two.  I've also been…
Read More