Russell Smith is a technology consultant and trainer specializing in management and security of Microsoft server and client technologies. He is a Microsoft Certified Systems Engineer with more than 15 ...

SQL Server and Azure SQL Database have a property called compatibility level. Microsoft supports compatibility levels back to SQL Server 2008 and has committed to keep those in newer releases of the ...

For those of you still using SQL Server 2005, Microsoft will completely end support on April 12th 2016. You can head over here to check out upgrade guidelines, download migration tools, and read more ...

I've been able to move databases with sp_detach and sp_attach. Obviously, connections to that database will be dropped, but it shouldn't affect any others.