SQL
-
Install SQL Server 2017 on Ubuntu Server
Microsoft has certainly been headed in a very cool direction in the past couple of years and have definitely embraced…
Read More » -
Upgrade SQL Server 2016 to 2017
Recently, SQL Server 2017 was released as GA to the masses. This represents the latest and greatest SQL server technology…
Read More » -
Three lesser known ways to test SQL connectivity
In troubleshooting a SQL connectivity issue recently, I tried multiple tests in connecting to SQL to help troubleshoot the issue.…
Read More » -
SQL Server 2016 Upgrade Error Valid Database compatibility level
In updating a few SQL Server 2014 servers recently, I ran into an error with a new SQL Server 2014…
Read More » -
How to Upgrade SQL Server 2014 to SQL Server 2016
With SQL Server 2016 currently at SP1 as well as a CU1 under its belt, many may be thinking of…
Read More » -
SQL Cluster computer account could not be configured
In working on an older Microsoft SQL Cluster server configuration recently, I ran into an issue with a lab copy…
Read More » -
Troubleshooting general SQL connectivity issues
There are quite a few things that an administrator may need to check when it comes to making sure connectivity…
Read More » -
See what user you are connecting to linked SQL server
I wanted to share with you guys a really handy little SQL query that is extremely useful if you are…
Read More » -
OLE DB provider SQLNCLI11 for linked server unable to begin distributed transaction
Today in working with a new virtual machine that was spun up with Windows Server 2012 R2 and SQL Server…
Read More »