09Jan 2009 by Grant Fritchey 4 Comments

Something Wicked This Way Comes

T-SQL
I sure hope peoples thumbs are pricking. I found this on the Apress web site. I guess it's OK to talk about it now that the first draft is finished. The second draft only has one chapter left and I finished copy editing on Chapter 6 of 16 yesterday. In other words, I'm going to have a new book published soon. The original plan was for May, but I heard a rumor that it might come out in March.
Read More
07Jan 2009 by Grant Fritchey 1 Comment

New England Data Camp v.1.0

PASS, T-SQL
It's getting a lot closer to the 24th.  On Saturday, January 24th, the first ever New England Data Camp will launch. We've got a number of speakers registered. Aaron Bertrand and Andrew Novick are guys I've got a lot respect for. I've been to their presentations before and they've been consistently very good.  We've got a few guys I haven't heard of personally, Talbott Crowell, Ayad Shammout, Sunil Kadimdiwan, Igor Moochnick. I'm going to present on execution plans and multi-environment deployments using DBPro (updated from the PASS presentation).  The other presentations cover topics from using the Resource Governor on SQL Server 2008 to Defending SQL Server from Injection Attacks to Create better and more Useful Cubes. It's shaping up to be an actual event. If you're in the neighborhood (New…
Read More
07Jan 2009 by Grant Fritchey No Comments

Table Valued Functions

T-SQL
I've been blogging for a whole nine months now. I decided to look back and see what's bringing people to the site. The number one search phrase is "sql server 2005 service pack 3" but the overwhelming topic that most people are using to get to the site are user defined functions, specifically multi-statement table valued user defined functions. It's completely understandable. Ever since I first saw these things in use back in SQL Server 2000, I thought they were slick. Unfortunately appearances can be deceiving. The reason so many people are searching out information on these things is because they just don't work very well. SQL Server can't create statistics on the tables generated through the multi-statement UDF. Because it has no statistics to work with, the query optimizer…
Read More