How are default column values stored?

An interesting question came up in class yesterday: how is a default column value stored, and what if some rows exist when a column is added and then the default value changes? An example scenario is this: Step 1: Create a table with two columns Step 2: Add 10 rows Step 3: Add a third column to the […]

October 2017 classes in Chicago open for registration

I’ve just released our final set of 2017 classes for registration, including the new two-day class on Azure and the new three-day class on upgrading and migrating. Our classes in October will be in Chicago, IL: IEPTO1: Immersion Event on Performance Tuning and Optimization – Part 1 October 2-6 IESSIS1: Immersion Event on Learning SQL Server […]

SQLskills SQL101: Restoring to an earlier version

As Kimberly blogged about recently, SQLskills is embarking on a new initiative to blog about basic topics, which we’re calling SQL101. We’ll all be blogging about things that we often see done incorrectly, technologies used the wrong way, or where there are many misunderstandings that lead to serious problems. If you want to find all of our SQLskills SQL101 […]

New course: Understanding and Using Azure SQL Database

And to coincide with our new training class on Azure, we’ve just published a new Pluralsight course on Azure too! Tim’s latest Pluralsight course – SQL Server: Understanding and Using Azure SQL Database – and is just under two hours long and is based on his very popular user group and conference session. The modules are: Introduction Understanding Azure SQL Database […]

New class: Immersion Event on Upgrading SQL Server

We have a second exciting new class debuting this October in Chicago: Immersion Event on Upgrading SQL Server. It’s a 3-day class, taught by Glenn Berry and Tim Radney. We’ve seen a huge surge in clients upgrading from out-of-support versions of SQL Server, so this class will be really useful to many organizations. The modules are […]

New class: Immersion Event on Azure SQL Database and Azure VMs

We have a really cool new class debuting this October in Chicago: Immersion Event on Azure SQL Database and Azure VMs. It’s a 2-day class, taught by Tim Radney. Azure is getting more and more popular, and we’re seeing many clients using it. The modules are as follows: Azure Virtual Machines Migrating to Azure Virtual Machines Azure SQL […]