SQL Server Consolidation at #SQLExcursions
The fifth and final session that I’ll be presenting at SQL Excursions is on SQL Server Consolidation. There are lots of ways to consolidate SQL Server databases, and some times the wrong method of consolidation is selected by people. Knowing all of the options when working on a SQL Server Consolidation project is key to […]
Take a virtual motorcycle ride around Ketchikan, AK
A few weeks ago I went on SQL Cruise with Kris (my wife) and a bunch of other SQL geeks. When the ship was stopped in Ketchikan, Alaska while a bunch of people were going in the water (crazy right?) I hopped on the back of a Harley and went riding through town as part […]
SQL Excursions and Index Internals #sqlexcursions
The fourth session that I’ll be giving at SQL Excursions will be on index internals. In this session we’ll dig into the internal structures of indexes. We will explore the differences between clustered and non-clustered indexes, what’s laid out within each page of the indexes and how the SQL Server uses the data within the […]
High Availability and SQL Excursions
My third SQL Excursions session I’d like to talk about is going to be about high availability. There are lots of high availability options for SQL Server, especially when SQL Server “Denali” is one of the high availability options. In this session we’ll be looking at all the available HA options so that you understand […]