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)
Category: SQL Server
View SQL Server Properties
This script gives you basic information on a SQL Instance such as version, edition, server collation, and instance level switch info.
View SQL Server Mail Items
Sometimes you need to investigate emails being sent from SQL Server. This query the last 100 items.
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