Overview This document will cover procedures for low disk space alert on OS/C: drives as well as general disk space low alert. Low disk space can have potentially negative consequences with a server. Some examples are: Unable to install critical OS security...
SQL Server Blog Posts
Office 365 Email Migration Prep Guide
What is Needed to prepare for an email migration? As a system administrator, I have had my share of email migrations. Some have gone as smooth as can be, others not so much. With every situation being an opportunity to learn and grow, here are some tips I have learned...
JCC Errorcode -4220 After Loading Data
THE PROBLEM While working with a client on a data migration from Microsoft SQL Server 2014 to IBM Db2 11.1, the client reported that the application was displaying the following error when attempting to read records from tables containing LOBs that we had just loaded....
Windows Server 2008/R2 EOL: It’s Not Too Late to Prepare
With Windows Server 2008/R2, along with Windows 7 OS, approaching EOL (End of Life) in mid-January, it is time to start prepping your infrastructure for upgrades. Microsoft announced last year that if you migrate your SQL 2008-2008 R2 environment to Azure, they will...
SQL Server 2019: Top 5 New and Exciting Features
With the release of SQL Server 2019 comes many new and exciting features, we can't wait to share the ones that made our top five list! Overall there were vast improvements in the database engine, security, database recovery, and several other areas. TempDB bottlenecks...
The Worst Call for Sys Admins: Ransomware Attack
The worst call/email to receive, as a sysadmin, is that users are reporting their files "looking funny," only for you to see your client's file server was hit with ransomware. You start saying a prayer hoping your backups that ran overnight were successful, as you...
Removing and Adding a Node From an Availability Group
There may be a situation where you want to remove a node out of an Availability Group (AG) may be due to testing, something wrong with the server and need to build a new one, running out of space on that server so you can move files around, move the server to a...
Cost Threshold for Parallelism
One of the most common missed configuration settings in SQL Server is the cost threshold for parallelism. By default it is set to 5, meaning that when SQL estimates that the cost of a query will be greater than 5 running a serial plan, SQL will split the plan into...
Migrating Your AlwaysOn DR Node to a Different Location
There may be a situation when you need to move one of your servers that is part of an Availability Group to a different data center and the IP address for that server will change. In this example, we will be moving a DR node from one data center to another and change...
WSFC Fixing Errors for AlwaysOn Availability Group or AlwaysOn Failover Cluster Instances (SQL Clustering)
As a SQL Server DBA, there will be times when you will cross over into the system administrator realm of responsibilities or at a minimum explaining them how to fix errors so your SQL environment runs better. WSFC (windows server failover cluster) is setup for...