Overview This doc is a general overview of symptoms to look for in the event of a potential virus alert from your service support product, or a user calls in regarding a potential virus. We'll also cover what to do in the event of a potential virus on a PC. We are...
SQL Server Blog Posts
Setting up Azure Active Directory Domain Services (Azure AD DS)
Microsoft's Azure Active Directory Domain Services (Azure AD DS) provides managed domain services such as domain join, group policy, lightweight directory access protocol (LDAP), and Kerberos/NTLM authentication that's fully compatible with Windows Server Active...
Low Disk Space on Server
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...
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 send...
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...