Here’s some quick SQL logic to create a DDL Trigger which is fired whenever a new database is created. This isn’t too terribly hard to setup, but doesn’t hurt to put a […]
Find Databases Not Part Of AlwaysOn
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.
Backup Readable Secondaries In AlwaysOn
Question: For AlwaysOn… Can you backup readable secondary replicas? Answer: Full Database Backups? NO Transaction Log Backups? YES Here’s what happens whenever you try to run Full Database Backups for readable secondaries […]
Query The Primary Server In AlwaysOn
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 […]
Pesky Special Principal ‘dbo’ Error For Sharepoint Database In SQL Server
If you arrived here then you’ve already seen that pesky “…cannot use the special principal ‘dbo’” error whenever you try to update, or edit permissions for the Sharepoint Config Database. OMG annoying […]
Apply Permissions For Sharepoint Configurations In AlwaysOn
Lets say you have a brand new SQL AlwaysOn environment for SQL 2012 or SQL 2014 and now the Sharepoint Admins are connecting to the Listener name so they can install and […]
Prestage Cluster Configuration – Find The OU
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 […]
Create SQL Job Step Notification
THIS POST HAS BEEN UPDATED HERE
Get Job History With TSQL
Here’s some quick SQL Logic which basically shows you the job history, with step history and step durations.
How To Remove The Current Line Highlight In SSMS 2016
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 […]
How To Use Mikes SSMS 2016 Theme
This theme was created using SSMS 2016 (v. 13.0.14000.36) and here’s what my theme looks like. To skip directly to the download… The Download is available as .doc All you need to […]
How To Modify The SSMS 2016 Theme With Monokai Reference
Here’s how you would normally go about editing the color theme for the 2016 Management Studio. To skip directly to the download… The Download is available as .doc All you need to […]
Installing Sharepoint 2016 on Windows Server 2012 R2 using SQL Server 2014 SP1-CU6 Part 1
How to install Sharepoint 2016 on Windows Server 2012 R2 using SQL Server 2014 SP1-CU6 (Part 1). Part 1 will show everything up to completing the prerequisites installation. Part 2 will pickup […]
How To Install SQL Server 2014 Service Pack 1 and CU6
Here are some quick instructions on Installing the first service pack for SQL Server 2014 ( Service Pack 1 ) then following that up with CU6. A couple of things before we […]
Recent Comments