SQL

  • SQL-Server-2017-database-file-location-Ubuntu

    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. When we look at the strides that have been made…

  • SQL-Server-2017-Upgrade-process-is-successful

    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 that are contained in SQL Server 2017 to be aware…

  • sqlcon07

    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 known ways to test SQL connectivity including ODBC, a UDL…

  • sql16up11

    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 a SQL Server 2016 upgrade error valid database compatibility level.…

  • sql16up01

    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. ย The upgrade process is painless as you will see below.…

  • sqltrouble01

    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. ย As of late, I have put together a checklist of…

  • sql2k14AS02

    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 to permissions. ย The SQL installation went all the way through…

  • msdtc_03

    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 transactions were not working from this particular VM and other…