Testing for Object Existence: CREATE OR ALTER
For the longest time, T-SQL writers have had to wrestle with ways of testing for an object’s existence so that it can either be dropped… Read More »Testing for Object Existence: CREATE OR ALTER
Home » Compatibility »
Compatibility
Testing for Object Existence: DROP … IF EXISTS
For the longest time, T-SQL writers have had to wrestle with ways of testing for an object’s existence so that it can either be dropped… Read More »Testing for Object Existence: DROP … IF EXISTS
Configuration Manager Shortcut on Windows 10 and Server 2016
(Last updated 2020-01-07) This is more for my own reference than anything. On newer versions of Windows desktop and Windows Server, we may find that… Read More »Configuration Manager Shortcut on Windows 10 and Server 2016
Temporal Tables and History Retention
I’m a huge fan of Temporal Tables in SQL Server 2016. I first wrote about them, in a four-part series in November 2015, before SQL… Read More »Temporal Tables and History Retention
Wait For Service Pack 1
Conventional wisdom tells us that when Microsoft releases a new version of any server product, we should wait until Service Pack 1 before deploying it… Read More »Wait For Service Pack 1
Should I upgrade SQL Server 2012, or migrate to Azure?
[Last updated February 27, 2020] Brent Ozar Unlimited runs a website called SQL Server Updates which comes in really handy for keeping your on-premises SQL… Read More »Should I upgrade SQL Server 2012, or migrate to Azure?
The Data Migration Assistant
I’ve written quite a lot about Azure SQL Database recently, but that doesn’t mean I’ve forgotten about the on-premises version of SQL Server. What could… Read More »The Data Migration Assistant
The Resilience of the Log Backup Chain
Much has been written about the log backup chain in SQL Server, where we are able to restore a database to a point in time using… Read More »The Resilience of the Log Backup Chain
Cumulative Updates Are First Class
Since 27 January 2016, Microsoft recommends that Cumulative Updates be installed with the same confidence as Service Packs, and installed as they become available. The… Read More »Cumulative Updates Are First Class
Total Recall
This is the final entry in my #SQLNewBlogger challenge. You can read the previous entries here: Part 1: The Intersection of Art and Science Part… Read More »Total Recall
Goodbye, old friend
SQL Server 2000, I will miss you. Two months ago, my last customer running on SQL Server 2000 took the plunge, and upgraded to SQL… Read More »Goodbye, old friend
Duplicate Index Finder updated
The SQL Server 2000 Duplicate Index Finder has been updated. I presented the newest version tonight at the SQLskills.com immersion event open night. Grab the… Read More »Duplicate Index Finder updated
Remove duplicate indexes in SQL Server 2000
With permission from Kimberly Tripp, the creator of the fantastic duplicate index finder for SQL Server 2005 and 2008, I have ported this duplicate index… Read More »Remove duplicate indexes in SQL Server 2000
Link 64-bit SQL Server 2005 to 32-bit SQL Server 2000
For those of you battling with a 64-bit SQL 2005 Server linking to 32-bit SQL 2000 Servers, here’s a handy solution. This problem has been… Read More »Link 64-bit SQL Server 2005 to 32-bit SQL Server 2000
- « Previous
- 1
- 2
- 3
- 4