Blog

SQL Server 2008 Developer Exam Review

Presentations, Speaking, SQL
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.  Since SQL Server 2008 R2 will have launched on April 22, there is sure to be comparison's of new features in the test answers.
Read More

SQL 2008 R2 New Features

SQL
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 Reporting Services Blog http://blogs.msdn.com/robertbruckner/ Ping me if you want slides or resources.
Read More

70-452 SQL 2008 BI Exam Walkthrough

Presentations, Speaking, SQL
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 concepts that don't map well to other technologies.. it's unique, with it's own query language, MDX, and many new concepts. SSIS is the most interesting topic, moving data from anywhere, to anywhere, and transforming the data in multiple ways. Reporting is the most intuitive for me, built on top of SQL queries and .Net syntax.  My strengths are in SQL admin and development, it's a stretch for me to take on this topic, but it's a…
Read More

More speaking – Excel 2007 and SQL 2008 Data Mining

Presentations, Speaking, SQL
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 to do Data Mining with Excel as a client, with SQL 2008 Analysis Server as the data mining 'brain'. I've been speaking more and more recently.. I'm an introvert by nature, despite being a trainer for 7 years, and several speaking engagements, this stuff still makes me nervous, but I can't think of anything else in my career that's challenged me as much, and helped me grow in confidence. I recommend speaking at a user…
Read More

I’m BACK!

General
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 talking on the Windows Azure SDK, a toolkit to enable .NET developers to write cloud based applications. It's like writing ASP.NET, but without concern for the web server, since it could be hosted on any server in the cloud, and without SQL Server database access or file access but using Windows Azure Storage Services instead. Stay tuned..
Read More

CLR Profiler

.Net
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 memory intensive app, give it a try. The 'others also downloaded' links at the bottom lead to the 1.1 and 2.0 CLR profilers. Here's the link
Read More

Dave’s got a weblog…

General, SQL
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 product, the most useful features that are planned, and doing some demonstrations on the functions that are supported as of CTP 4, release in July. I'll put my code samples here, as well as links to resources I've found useful. Check the links below and to the side, and feel free to contact me if you need help finding something. -Dave UPDATE: spoke at the user group meeting tonight, and got good feedback. Here's a…
Read More