SQL Server 2016: What Time Is It?
Today I found that SQL 2016 introduces a function to help alleviate the issues we have when it comes to finding the current time.
SQL Azure
HOW TO: Change the Compatibility Level of an Azure SQL Database
Here’s an example of something I came across for Azure SQL Database V12 that I don’t see documented anywhere (yet): You can change the compatibility level of an Azure SQL Database.
SQL Server Backup Audit
I had a question come up last week from someone that wanted to know a few basic facts about their SQL Server backups for audit purposes. The facts they wanted were straightforward: Who took the backup? When was it taken? Where was it written? Simple questions that are answered with a simple script. As usual, here’s … Read more
Get All Endpoints for VMs in an Azure Subscription
I wrote a post recently about troubleshooting connectivity for endpoints on Microsoft Azure VMs. The day the post went out I was greeted with this tweet: http://t.co/Ww3MyYjwPu right on time context post for me @SQLRockstar tx sir. Need to see on ports for my #linux vms with #mysql running 🙂 — Shyam Viking (@myluvsql) April 30, … Read more
Troubleshooting Azure Connectivity: Ports and Endpoints
It was a simple enough question, or so I thought. One I felt should be either a simple “yes” or “no”. “Do we block remote desktop connections here?” Sure enough, I got back the quick and simple answer I expected, along with a question for myself. “Nope. We don’t block any RDP sessions. Maybe you … Read more
An incompatible SQL Server version was detected
Hope this helps you understand the “An incompatible SQL Server version was detected.” error, and what to do to fix.
