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 the Linux community and interoperability between Microsoft Windows and Linux.…
Category: SQL
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 available to consume. There are some really great new features…
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. In this post, let’s take a look at three lesser…
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 Server running the upgrade to SQL Server 2016. ย It was…
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 upgrading existing SQL Server 2014 installations to SQL Server 2016.…
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 of the SQL Cluster not bringing the SQL resources online…
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 to SQL is happy and healthy in your respective environments.…
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 troubleshooting SQL Server linked server connectivity. ย You may have setup…
SQL 2014 Setup Failed Analysis Services
Recently in building up a SQL 2014 Standard edition VM running on Windows Server 2012 R2, I ran into a peculiar issue with the SQL install with Analysis Services relating…
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 2014, I was asked to troubleshoot an issue where distributed…