14Jan 2009 by Grant Fritchey 1 Comment

SQL Server 2008 Upgrade Lab at Microsoft

Tools
I got an invite to take part in a lab at the Microsoft Technology Center in Waltham. I took advantage of it. I'll use this post to describe the experience so that anyone else with the opportunity will know what to expect.  [caption id="attachment_333" align="alignnone" width="450" caption="They knew I was coming"] [/caption] First, you recieve a very explicit set of pre-requisites. You need to install the SQL Server Upgrade Assistant, a tool that Microsoft licensed Scalability Experts to create for them. You have to run this against a small database, >25gb. The tool backups up all the databases from the server (so you need to put it on to a test box, rather than try to move an entire production system worth of databases). It then starts a trace that captures all the…
Read More
13Jan 2009 by Grant Fritchey No Comments

Red Gate Crib Sheet Compendium

SQL Server, T-SQL
Red Gate has compiled a bunch of it's Cribsheets into a single E-book, the SQL Server Cribsheet Compendium. It's pretty cool. I've got two entries in there, performance tuning and backups & restores, along with great articles from Robyn Page, Phil Factor, Robert Sheldon and Amirthalingam Prasanna, pretty heady company. It's worth a look.
Read More
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
18Dec 2008 by Grant Fritchey No Comments

2008 Index Fragmentation

Uncategorized
I forgot all about this, but a script I wrote on using all the new functionality of dynamic management views & functions to do index defragmentation and rebuilds got published over at SQL Server Central. It could stand a bit of tweaking, but gets the job done on several of the systems I've tested it on so far.
Read More
18Dec 2008 by Grant Fritchey 15 Comments

Profiler Research

SQL Server
A question came up on SQL Server Central as to why or how Profiler could bring down the production server.  I was aware of the fact that Profiler caused problems and that's why you should always use a server-side trace on production systems. Duh! Of course.... But why? I didn't have an answer. I just "knew" what everyone told me. So I set out to do some research. Initially I hit my favorite source of information on SQL Server (and it should be yours too) the Books Online. Here is what I was reading on the architecture of Profiler. Good, but not enough. I still want more information, so I've gone out a'wanderin' through the interwebs. First, Linchi Shea has this great set of tests comparing Profiler to server side…
Read More
15Dec 2008 by Grant Fritchey 10 Comments

PASS Evaluation Results

PASS
I received my evaluation results this afternoon (thanks so much Marcella). I had about 35 people attend the session and 11 took the time to respond. Overall, the session seems to have been well received. I had one person ding me for finishing early. I did finish early, but then we actually went over time on the Q&A session, so I think it was a wash. For my first time presenting in this type of environment, I find this to be useful feedback. I can see where Andy Warren is coming from in suggesting some questions that would be specifically helpful to the speaker would be nice. The questions are primarily aimed at determining whether or not the topic will be useful next year and whether or not the speaker…
Read More
11Dec 2008 by Grant Fritchey 2 Comments

New England Data Camp v1.0

Misc, PASS
Adam Machanic of the New England SQL Server Users Group (among other things), has contacted the Southern New England SQL Server Users Group to ask us to take part in a one day SQL Server code camp. Of course we said yes. It's taking place at the Microsoft facility in Waltham on Saturday, January 24th. You can register here. If you're interested in speaking, speaker registration is here. I'll be listing the sponsors as they become available, but it will be a PASS event. As information gels around this, I'll continue posting updates.
Read More