Migrating SSIS Packages from SQL 2005 to SQL 2008

Did a talk at South Florida SQL Server User Group up in West Palm Beach a few months ago. Spoke on my experience migrating over 70 packages and 12 SQL jobs from SQL 2005 to SQL 2008. I encountered many obstacles in the process, and hope my experience in overcoming them will be useful to […]

SQL Server 2008 Developer Exam Review

Another SQL Exam review! Daniel and David bring back their popular Microsoft Certified Professional exam review.  In this meeting format the boys review sample questions from Exam 70-433: TS: Microsoft SQL Server 2008, Database Development.  This is a fun way to hone your Database Development skills whether are preparing to take the test or not.  […]

SQL 2008 R2 New Features

Speaking at GoldCoast Users Group today on new SQL 2008 R2 features. StreamInsight, Gemini, SQL Server Utility Control Point, Data Tier Application (DAC), and Report Builder 3.0 with map support are the coolest new features. Helpful resources I’ve found so far: SQL 2008 R2 Books Online http://msdn.microsoft.com/en-us/library/bb418432%28SQL.10%29.aspx Johan Åhlén StreamInsight Blog http://blogical.se/blogs/jahlen/ Robert Bruckner’s Advanced […]

70-452 SQL 2008 BI Exam Walkthrough

Tomorrow I’m speaking with Joe Homnick and Shervin Shakibi on the 70-452 SQL 2008 BI exam. Here’s the details. We’ll walk through a test prep that covers SQL 2008 SSAS, SSIS and Reporting Services. Of all the aspects of SQL, SSAS is the biggest challenge, its a broad and deep subject with a lot of […]

More speaking – Excel 2007 and SQL 2008 Data Mining

Just spoke last night at South Florida SQL Server User Group on using Microsoft SQL Server 2008 Data Mining Add-ins for Microsoft Office 2007 . Gave a similar presentation last month at Gold Coast User Group. This is a great free tool (if you already have Office 2007 and SQL 2008 Enterprise or Developer) that makes it simple […]

I’m BACK!

16 month without a post, must be some kind of record… I have been busy. I got married and had a child, so I’m sure that’s all the excuse for not posting that I need 🙂 I’m speaking tomorrow at Code Camp 2009 , on something new to me but very interesting, cloud computing. I’m […]

CLR Profiler

Hi! I dug in a little today to learn about memory leaks in .Net, I have a 1.1 application that was sucking up memory. I found this link for MSDN TV, the Microsoft employee in it spends 15 minutes demonstrating the CLR profiling tool, was actually useful and informative. If you have a slow or […]

Dave’s got a weblog…

Hello All, Ok, I finally created a blog. I’ll try to keep the narcissism to a minimum, and focus on useful stuff. I’ve set up this site as a resource to folks that are investigating SQL Server 2008, due out in February of 2008. I’m giving a short talk today on the vision for the […]

Social

Content

Speaking

All Rights Reserved Theme by 404 THEME.