Deprecated Database Features: SQL 2005 – SQL 2014 Links

Below are reference links to Microsoft documentation web pages listing deprecated database features from SQL 2005 to SQL 2014….   2005   2008   2012 2014  

Read More

Database Snapshot

Sample T-SQL Code for creating a database snapshot. use AdventureWorks2012 go sp_helpfile — used to get the logical database name needed for below CREATE DATABASE AWSnapshot ON ( NAME = ‘AdventureWorks2012_Data’, FILENAME=’’ ) AS SNAPSHOT OF AdventureWorks2012; –using it USE AWSnapshot; GO SELECT * FROM Sales.SalesOrderDetail WHERE ProductID = 53; –reverting from snapshot RESTORE DATABASE […]

Read More