Resources from my TechEd talks are available

The demos from my TechEd talks in Orlando and in Amsterdam are posted on the SQLskills website under Resources. Sorry for the delay. TechEd Amsterdam isn't near finished yet tho', and I'll be at the Ask-The-Experts tomorrow and at one of the Windows Azure SQL Database booths on Friday morning. If you're around, stop by and […]

Does everybody get that? (generalizing esoteric optimization techniques)

This post is an example of the "bring your own problem" approach in the classroom, inspired by upcoming SQLskills Immersion Events in August. See previous posting for the reason behind the blog post title.  Figured that I couldn't wrap up this series without mentioning T-SQL, as most of the "bring your own problem"-type problems have […]

Loading ShapeFiles into SQL Server 2008 and 2012

Since I find myself "in a spatial mood", I thought I'd write one more today. About importing data from shapefiles. According to Wikipedia "The Esri shapefile or simply a shapefile is a popular geospatial vector data format for geographic information systems software". And the question always goes something like this: "Does SQL Server have anything […]

Does everybody get that? (Spatial Index Reprise)

This post is an example of the "bring your own problem" approach in the classroom, inspired by upcoming SQLskills Immersion Events in August. See previous posting for the reason behind the blog post title. I believe it was John Lennon who wrote: "You say you got a real solution. Well, you know, We'd all love […]

Does everybody get that? (XML or relational for “multi-table” XML documents)

This post is an example of the "bring your own problem" approach in the classroom, inspired by upcoming SQLskills Immersion Events in August. See previous posting for the reason behind the blog post title. SQL Server is a relational database that supports XML. But just because your data is received in XML format doesn't necessarily […]

Does everybody get that? (Type system compatibility mode in drivers)

This post is an example of the "bring your own problem" approach in the classroom, inspired by upcoming SQLskills Immersion Events in August. See previous posting for the reason behind the blog post title. The SQL Server "MAX" data types (VARCHAR(MAX), NVARCHAR(MAX), VARBINARY(MAX)) have been around for some time (SQL Server 2005) now. And the […]

Does everybody get that? (SQLCLR)

Just came back from TechEd, where I had a bit of time to think about training vs speaking. When I'm teaching, I'm not just speaking facts and doing neat demos (ta da!) at folks. I look at their eyes to make sure they "get it" and aren't satisfied until they do. During the presentation, I'd […]

Immersion Events: IEDev, IE4, and similar (but not the same) topics

SQL Server Immersion Events are coming up in August. I deal with two different groups of people, developers and DBAs, on a variety of topics. When it comes to the specialized SQL Server topics (like SQLCLR, SQLXML, Service Broker, etc), I though that it would be best to address the seperate groups, each with a different […]

Using PowerShell with DAC 3.0

At my DAC talk at TechEd last week, the thing that seemed to cause the most interest was the PowerShell scripts to use DACPACs/BACPACs. I thought I'd post that here, along a question about cmdlets in general. Using PowerShell against the library allows admins to use all of the functionality that's in SSMS, with the […]

I’ve got the last talk at TechEd and its almost LAST CALL

I've been at TechEd North America in Orlando this week and have seen some amazing new things. Upcoming operating systems, new hardware, and a detailed technical followup on the Azure (cloud) announcements from last week, including some Windows Azure SQL Database (was SQL Azure) upcoming enhancements. I've spend quite a bit of time at the […]