I have not been able to write on my blog for quite some time. I am currently in NY for an onsite assignment and have been quite busy lately. I hope my life will get back to normal soon :-)
I will be presenting at the New Jersey SQL Server User Group on 24th October 2009 on “Best practices for exception handling and defensive programming in SQL Server”. I am glad to have the honor of presenting with two great SQL guys, Michael Coles and Robert Perl.
Speakers and Sessions
Michael Coles ["Where in the World?" -- Spatial Data in SQL Server 2008 ]
SQL Server 2008 introduces two new core data types for storage and manipulation of geospatial data. You can use SQL Server's built-in library of spatial operations to perform complex geographic calculations quickly and easily, and interface the spatial data types with front end mapping tools. The R2 release of SQL Server 2008 adds even more spatial data functionality to the Microsoft BI stack via Reporting Services improvements. In this session attendees will learn how to store, manipulate, and perform calculations with geospatial data in SQL Server to enrich their applications.
Robert Pearl [Who Did it and Ran?']
Robert Pearl brings us a SQL caper that takes us on a journey through the depths of the sql server internals world, putting us on the trail of who did what and when to your database. This presentation will be an exercise in database forensics that will apply computer investigation and analysis techniques to set up auditing and evidence collection, by leveraging the native SQL Server features out-of-the-box. We'll explore the Transaction Log, SQL 2008's Change Data Capture (CDC), and other methods to secure your database (to put us in compliance (ie: SOX, HIPAA, etc.)
Jacob Sebastian [Best practices for exception handling and defensive programming in SQL Server ]
This session focuses on understanding errors and error handling in SQL Server. We will see a number of demos that show how to detect errors, control errors and handle errors. It also focuses on exposing some of the common programming mistakes and pitfalls.
I hope to see many of you at the event.