Category Archives: Katmai

Spatial Demo Goodness

If you’re someone who presents on SQL Server topics, you have probably run into something of a wall when it comes to getting interesting spatial data sets to demonstrate. The spatial data included with the SQL Server 2008 sample databases … Continue reading

Posted in Katmai, SQL Server, Training | 1 Comment

Christmas Came Late!

Santa has just delivered the gift that many SSIS developers have had on their Christmas lists: more samples and options for programmatically building SSIS packages. Although in this case, the role of Santa is played by Matt Masson of the … Continue reading

Posted in BI, dev, Katmai, SQL Server, SSIS | 1 Comment

Changes in SQL Server 2008

MCT Russ Loski recently shared this great link with the SQL Server trainer community: http://msdn.microsoft.com/en-us/library/cc280407.aspx This is the top-level "Backward Compatibility" topic from SQL Server 2008 Books Online, and includes sub-topics for the DRBMS, SSAS, SSIS, SSRS and replication, covering … Continue reading

Posted in BI, Katmai, SQL Server, SSIS | Leave a comment

"Bonus" Technical Deep Dive Session at the MCT Summit – Redmond and Prague

The vast majority of the content at the 2009 MCT Summit events is heavily weighted toward the IT Professional audience. This is largely due to the fact that the major developer and database product releases took place in 2007 and … Continue reading

Posted in BI, Conference, Katmai, SQL Server, SSIS, Training | 2 Comments

SQL Server 2008 – Free with Classroom Training

Talk about synchronicity – the old and the new have come together with a great big bonus for SQL Server professionals who are seeking training on SQL Server 2008. Microsoft Learning[1] is teaming up with the SQL Server[2] team to … Continue reading

Posted in Katmai, SQL Server, Training, Work | Leave a comment

T-SQL Fundamentals is (Almost) Here!

Not too long ago I posted about Itzik Ben-Gan’s excellent book Inside Microsoft SQL Server 2005: T-SQL Querying and how valuable I’ve found it. Well, Itzik has just completed work on his next book: Microsoft SQL Server 2008 T-SQL Fundamentals. … Continue reading

Posted in Book, Katmai, SQL Server, T-SQL | Leave a comment

New SSIS Article Online on MSDN

I have a new article on the SSIS Developer Center on MSDN, focusing on Data Sources and Configurations as tools for connection reuse across sets of SSIS packages. I wrote it months ago (looking at it now it seems even … Continue reading

Posted in BI, Deployment, Katmai, SQL Server, SSIS | Leave a comment

VDUNY Meeting Tonight

Just as a quick reminder, I will be presenting on new features in SQL Server 2008 at the Visual Developers of Upstate New York user group tonight at 6:00 PM in Rochester, New York. If you’re in the Rochester area, … Continue reading

Posted in Katmai, Presentation, SQL Server, Training | Leave a comment

One More Reason to Attend

I’ve posted a few times already[1] about the SSWUG Business Intelligence vConference that I have been helping to organize. Well, the conference is now less than a month away, and there is more news to share: We’re giving away a … Continue reading

Posted in Beginners, Best Practices, BI, Conference, Data Mining, dev, Katmai, Office 2007, Performance, Presentation, SQL Server, SSIS, T-SQL, Training, Webcasts | Leave a comment

SQL Server Sample Install Epiphany

(Warning – this post has turned into a long drawn-out rant. If you want to skip to just the useful stuff, scroll down to the third and final bulleted list way down there at the bottom. I won’t mind, I … Continue reading

Posted in dev, Katmai, SQL Server, tools | 3 Comments