Free Database Indexing Session
That’s right, I said free. On July 1st, 2014 at 9am Pacific/Noon Eastern I’ll be presenting an hour long session titled “Table Indexing 101” in which we will review some of the basics of SQL Server table indexing and how these indexes can be used to improve performance of your Microsoft SQL Server database applications. […]
Getting Replication Distribution Back After a MASSIVE Failure
Recently I had to upgrade a SQL 2008 R2 server to SQL Server 2014 on the fly, because the server in question was the SQL Server replication distributor and a couple of databases which were being replicated were being moved to a SQL Server 2014 instance. The Distributor’s upgrade didn’t go well. After I got […]
Recommended reading from mrdenny for June 13, 2014
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. Ask Slashdot: How Long Will the Internet Remember Us? How is a Salary is Determined? Ask Slashdot: Why Are We Still Writing Text-Based Code? Xbox MVPs vSphere Upgrade Saga: vSphere 5.5 Host […]
Any Little Thing Can Kill a SQL Server Upgrade
So I was going along upgrading a SQL Server 2008 R2 RTM server to SQL Server 2014. I had to install SQL 2008 R2 SP2 or newer before I could upgrade. That’s fine, I can live with that. Then I get to the SQL 2014 installer. I get all the way to the end, when […]