SQL Server security precon at TechEd 2010.

This blog posting is meant to bring attention to the fact that I'm doing a preconference talk, "A Day of SQL Server Security" at TechEd 2010 in New Orleans in June. OK, the TechEd folks asked me to publicize it. I'm also doing two breakout sessions, one on "Entity Framework and LINQ2SQL vs. Stored Procedures", […]

DAC support SQL Azure and vice-versa. It’s live.

Last week I did a talk at SQLConnections on SQL Azure Database and Data-Tier Applications (DAC). At the time (it was the day of Visual Studio 2010 launch), I explained that conference abstracts had to be submitted 6 months ago. At the time, because of some coincidental feature correspondence (e.g. the DAC whitepaper suggests only using […]

Geocoding and AdventureWorks 2008 data

I did a few demos in the spatial visualization talk at SQLConnections using the AdventureWorks 2008 data. The Person.Address table is all geocoded and so I did a quick map in SQL Server Reporting Services 2008 R2 using individual addresses. Followed up later in the talk with addresses using ESRI's MapIt product, their Spatial Data […]

Thanks for a great SQLConnections!

I had a great time at SQLConnections last week, and got to talk to a lot of the attendees and speakers during lunches and breaks. It was interesting talking about some controversial topics (like Entity Framework/TSQL or the Data Tier Application) and I hope folks got enough information to make up their own mind. And I hope […]