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.
MSSQL
ISNULL (Title, “NULL is an UNKNOWN, Not Empty!”)
It’s no secret that I hate NULL values. Well, to be clear, I hate working with NULL values. I’ve written before about why I dislike NULLs. I’ve even had public debates (which I won) about the topic. What I’ve gradually come to realize over time is that it is not the NULL values themselves I … Read more
The Real SQL Server 2014 Power Feature (It May Not Be Hekaton)
Just a quick post today to tell you about a webinar I am doing on the 27th of August, 2014. The title is “The Real SQL Server 2014 Power Feature (It May Not Be Hekaton)”, and it is me talking about the new cardinality estimator (CE) in SQL Server 2014. You might recall that earlier … Read more
HOW TO: Find Currently Running Long SQL Agent Jobs
A while ago I had posted a script to help find jobs that were currently running longer than expected. Since I’ve been sharing some scripts recently, I decided to verify that this script still works for finding long running jobs in SQL Agent for SQL Server 2014. Why This Script Matters Because you want the opportunity … Read more
HOW TO: Know What That Installer Did to Your Database
Remember when I told you I had come across and old script that checked your SQL Server configuration setting? Well, here’s another old script of mine I think is worth sharing. The idea was that I wanted to verify what changes (if any) were made to my SQL Server instance as a result of a 3rd party vendor … Read more
SQL Server Configuration Check
I was going through some old files recently and I came across a folder that was essentially a junk drawer of scripts I’ve put together over the years. I don’t know what to do with most of them now. For example, the isql scripts for some Sybase ASE 11.5 instances aren’t very helpful for many these … Read more
