Michael Otey, Senior Technical Director for SQL Server Pro, outlines in this webcast video how to take advantage of all the options for SQL Server vitualization while also gaining the most performance advantages....More
Query plans of T-SQL solutions based on the Decrease and Conquer algorithm contain extra work to deal with Halloween protection. Itzik presents an alternative generic pattern that removes the need for Halloween protection....More
I've been involved in virtualization projects for about 10 years now. In that time, I've had the opportunity to track my own list of best practice items. It's a list I share freely with customers that seek out virtualization advice....More
After having used PowerShell to manage SQL Server since 2006, when PowerShell was first introduced, I'm pretty comfortable with it. Everyone has to start somewhere, though, so I'd like to share some basics with you....More
As far as I'm concerned we'll likely always have SQL Injection around to haunt us. Even though this attack vector has been well-publicized and well-documented for well over a decade (and then some), failure to account for it continues to pop all the time—even in catastrophic places....More
Some say performance tuning SQL Server is an art; others say it’s a science. It’s a bit of both of those, but also more. Many factors determine how well (or poor) SQL Server will perform, and it starts well before any application database is installed into an instance.
November 2013 - Many types of tasks involve handling date and time intervals and computing counts related to those intervals. Learn how to compute the maximum count of concurrent sessions during every fixed interval within a certain input period.