I’m speaking on SQL Server service accounts next week

Just to let you know. The Portland (Oregon) SQL Server User Group has invited me to speak at the meeting on Thursday, Jan 24 at 6:30pm. I’ll be speaking on SQL Server service accounts, entitled “Who’s running my SQL Server services?”. I’ll be covering the evolution of service account choices and management in later versions of […]

Getting Windows Azure SQL Database diagnostics using Windows Azure cmdlets

I’ve been trying out the new supported Windows Azure PowerShell Cmdlets this week and I’d have to say I’m impressed. I’ve only used the ones for setup (Get-AzureSettingsFile and friends) and the ones for Windows Azure SQL Database (WASD) so far, and there’s a new one for WASD I really like. The original Codeplex WAAPS […]

I’m doing Expertseminarium in Stockholm in March

I’m happy to announce that I’ll be in Stockholm Mar 12-13 as a speaker in AddSkills’ Expertseminarium program. I’ll be doing 2 days full of SQL Server query optimization and internals information, troubleshooting, and analysis techniques. We’ll be diving into SQL Server using tools like Extended Events to get a good look into what’s going […]

Choosing Paths for Selective XML Index – Part 2 – Using the SXI XEvents

In part 1 of this series, we tried a simple example from the Books Online without any SXI index at all, and an SXI with all the paths covered. No XEvents were emitted in either case. Now let’s change the XSI around (by dropping and recreating, although we could use ALTER, so envision a drop […]

Choosing Paths for Selective XML Index – Part 1

About a month ago, I wrote a series of blog entries on the Selective XML Index introduced in SQL Server 2008 SP1. Just to summarize before I start up again, the Selective XML Index (I’ve abbreviate as SXI) is a feature introduced to allow indexing of only certain paths in an XML column. It uses […]

New XEvent events in SQL Server 2012 SP1

I’ve been looking a bit more into the SQL Server 2012 SP1 release, mostly to find diagnostics related to the Selective XML Index (SXI). I found some additional extended events for SXI (there are four of them in the “index” category) and I’ll cover them in, as well as exercise them, the next posting. But […]

Speaking at DevWeek London in March

Lucky me, I’ll be speaking at DevWeek in London again this year. The festivities start off with pre-cons on March 4, I’ll do a whole day on writing best-performing T-SQL and application code. After that, I’ll be doing breakout talks on a variety of topics, from SQL Server Extended Events, to Data Movement in Windows Azure […]