Custom Keyboard Shortcuts in SQL Server Management Studio (SSMS)

You might not be aware that you can create your own keyboard shortcuts in SSMS. Which is handy when you have some SQL but want to perform a quick action without typing it out, for example inspecting tables like below. Example So in the below example I've highlighted my table and hit Ctrl + 3 … Continue reading Custom Keyboard Shortcuts in SQL Server Management Studio (SSMS)

Create SQL Server Database Snapshot Dynamically

Create a SQL Server database snapshot dynamically without having to write the file names and paths. This script generates a snapshot of your database with two variable inputs; database name, and snapshot name appended. The snapshot will be named @SourceDatabase + '_' + @SnapshotAppend. So for example 'DemoDb_Snap_20180810.ss'. You can also override the file path … Continue reading Create SQL Server Database Snapshot Dynamically