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 […]
Bob Beauchemin
SQL Server Blog
Resources from my TechEd talks are available
Posted on: June 27, 2012 1:35 pm
Does everybody get that? (generalizing esoteric optimization techniques)
Posted on: June 22, 2012 4:17 pm
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
Posted on: June 21, 2012 1:50 pm
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)
Posted on: June 21, 2012 11:43 am
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)
Posted on: June 20, 2012 3:12 pm
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)
Posted on: June 19, 2012 11:03 am
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)
Posted on: June 18, 2012 3:08 pm
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
Posted on: June 18, 2012 2:03 pm
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
Posted on: June 18, 2012 10:34 am
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
Posted on: June 14, 2012 8:15 am
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 […]
