This is dark theme I created for SSMS 2017 Once you download it; you’ll need to remove the .doc Mikes Dark SSMS Theme (SSMS 2017) https://mikesdatawork.files.wordpress.com/2017/07/mikes_2017_ssms_fonts_and_colors-vssettings.doc Advertisements
From time to time you’ll need to visit your license costs, and to do so you’ll need to run some queries against sys.dm_os_sys_info so you can get the number of cores for […]
Here’s some quick SQL logic that will backup all databases to a folder, then create database restore template syntax for each backup file that was created. This is the process.. 1. Backup […]
Here is an incredibly simple way to automatically configure new databases for AlwaysOn. Is there a better way? Of course; but this is just one method to get you going in the […]
It’s always a good idea to create some Standard AlwaysOn jobs for management purposes whenever you’re first learning, or experimenting with the AlwaysOn configurations. You’ll find times when you need to remove […]
Someone recently asked me how to setup a job to run on a certain day. In this case it’s the 3rd day of the month. There is one simple solution which can […]
Suppose you’re doing yet another database migration and find yourself again changing the Object Ownership aka Schema Ownership in the post 2012 world… Here’s some quick logic to transfer all object ownership […]
In this example we have a generic database server with SQL Server 2014. There are 6 instances. DEFAULT SQLSHARE01 SQLSHARE02 SQLSHARE03 SQLSHARE04 SQLSHARE05 Now; according to SQL 2014; you are still unable […]
Here’s a quick query to find databases that haven’t been added to the AlwaysOn configuration. In other words they haven’t been added to the availability group.
Here’s another quick way you can query the primary server. I’ve posted about this before sure; but that was using a precise result. If you wanted to see all servers involved you […]
Whenever you’re setting up a Failover Cluster Configuration in a post Server 2012 world… You’ll need to prestage the cluster objects in Active Directory. Microsoft offers some good documentation on the steps […]
If you’re here… This means you want a solution to sending an email notification about a particular Job and it’s history and maybe add the Job step durations along the way. Here’s […]
Here’s some quick SQL Logic which basically shows you the job history, with step history and step durations.
You’ll notice there is a border around the current line in SSMS. This can be disabled ( by unchecking the option ). Here’s how. From Management Studio go to Toos, Options, and […]