Category Archives: Presentations

SQL cluster on the cheap with Hyper-V and iSCSI

Speaking on how to set up SQL clustering in a virtual environment, for development and testing. Discuss options for production deployment.
Now, how to compress 9 hours of setup into a session…
Expect some smoke and mirrors along with some neat technology.

Does anyone have some SSDs I can borrow? 🙂

July 23rd http://itcampsaturday.com/southflorida/

Tentative outline:

  • Setup Hyper-V Host
  • Install two virtual networks (lan,iscsi)
  • Create OS template
  • Deploy and install 3 servers
  • Configure iSCSI storage and targets
  • Configure Windows Cluster
  • Install SQL Node 1
  • Add SQL Node 2
  • Test
  • Discuss production deployment options
  • Q & A

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.  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.

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 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 good stretch. I hope the UG members like to stretch themselves as well.

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 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 group for any technical professional that wants to grow their confidence and career.