Create Database Snapshot Dynamically
Dynamic SQL can be used to generate a database snapshot. Useful for a database with a number of files.
2018-08-23 (first published: 2016-11-04)
3,518 reads
snapshot
Automated Rapid Recovery during Database Code Releases using Snapshots
Leveraging snapshots across multiple databases simultaneously to allow for quick rollback in case of a problem deploying code
2015-12-08
2,150 reads
2014-03-20
2,274 reads
2016-04-12 (first published: 2014-03-12)
2,376 reads
Successfully execute an INSERT, UPDATE and DELETE against a Database Snapshot
Not too long ago an ISV that developed solutions using SQL Server as the RDBMS, asked me how they could query a database as at a point in time. This was a relatively easy answer, thanks to the Database Snapshot feature. I was however surprised at the next question “Can we update the database snapshot?”
2011-12-21
2,509 reads
2009-07-27
3,125 reads
Blogs
SQL Server 2025 Generally Available
By Brian Kelley
This was announced last week at Microsoft Ignite and it's been covered by others...
Chatting with Power BI: Who Benefits from This Conversation?
By Rayis Imayev
"Dave: Open the pod bay doors, HAL.HAL: I’m sorry, Dave. I’m afraid I can’t...
A Quick Look at Redgate Data Modeler
By Steve Jones
Redgate acquired a data modeling tool from Vertabelo recently and I wanted to explore...
Forums
The Ending Substring
Comments posted to this topic are about the item The Ending Substring
Done is Better than Good
Comments posted to this topic are about the item Done is Better than Good,...
Configuring the On-Premises Data Gateway: The Fabric Modern Data Platform
Comments posted to this topic are about the item Configuring the On-Premises Data Gateway:...
Question of the Day
The Ending Substring
In Azure SQL Database and SQL Server 2025, if I run this, what is returned?
SELECT '[' + SUBSTRING('Steve Jones', 7) + ']' See possible answers