Today I look at something very old: the global variable @@DEF_SORTORDER_ID, from the days before collation when servers had a default sort order.
How to Check Edition Specific Features Enabled In SQL Server? – Interview Question of the Week #180
Moving databases to another edition? Here is a simple script for SQL Server 2008 and later that lists the Edition specific features each database uses.
SQL SERVER – Identifying Deprecated SQL Server Features with Extended Events
With Extended Events, you can identify all the deprecated SQL Server features your code still uses. It is very handy before you change compatibility level.
How to Find SQL Server Deprecated Features Used by the Application? – Interview Question of the Week #165
Is your application using deprecated features that a future SQL Server may remove? Here is how SQL Server helps you find them, starting with a Profiler event.
SQL Server – Knowing the Use of Deprecated or Discontinued Features
After an upgrade, a DBA’s management asked if any deprecated or discontinued features were still in use. Here is how to find that out on a live server.
SQL SERVER – Thinking about Deprecated, Discontinued Features and Breaking Changes while Upgrading to SQL Server
In this blog post we Nakul will talk about Thinking about Deprecated, Discontinued Features and Breaking Changes while Upgrading to SQL Server.
SQLAuthority News – Bookmark – Deprecated Database Engine Features in SQL Server 2008
Asked if a feature still exists or will be removed? Bookmark Microsoft’s list of deprecated database engine features in SQL Server 2008 and 2008 R2.