List Query Store Enabled Databases in SQL Server
This query will bring back only those databases where the Query Store is enabled in the SQL Server instance. — Show All Query Store Enabled Databases select name as ‘DATABASE … Continue Reading →
Resolutions found with SQL Server and other types of databases
Microsoft SQL Server database system
This query will bring back only those databases where the Query Store is enabled in the SQL Server instance. — Show All Query Store Enabled Databases select name as ‘DATABASE … Continue Reading →
If the Query Store, from an SQL Server 2016 instance or greater, information is missing, it may be because the version of the SQL Server Management Studio is not at … Continue Reading →
Warning: this method of changing SQL Server’s default collation is not supported by Microsoft The issue was an instance of SQL Server was installed with the default collation (SQL_Latin1_General_CP1_CI_AS), and … Continue Reading →
After reading an old article about the SQL Server DMV sys.dm_os_wait_stats running on SQL Server 2005. I learned about the undocumented trace flag 8001, which enables all the wait types … Continue Reading →
When attempting to change an email account in my Database Mail, I received the following error: Msg 14604, Level 16, State 1, Procedure sysmail_verify_account_sp, Line 14 Both account parameters (id … Continue Reading →
This is something that I wish I had discovered years ago. I have put together my nine most used queries, functions, or system stored procedures that I use most everyday. … Continue Reading →
Problem: When I attempted to logon to one of individual node for my AlwaysOn Availability Group, I received the connection error shown below. TITLE: Connect to Server Cannot connect to … Continue Reading →
Problem: When attempting to install the command line tools for SQL Server on Ubuntu 16.04.3, I would get the error: “E: Unable to locate package mssql-tools” Resolution: Note: SQL Server … Continue Reading →
Problem: I was working with a SQL Server 2014 two node cluster in our test environment. After the cluster had been setup, I was asked to change the drive letters … Continue Reading →
Problem: A user that was not part of the sysadmin role attempted to change its own password using the SQL syntax, “ALTER LOGIN WITH PASSWORD”. Returned is the following error: … Continue Reading →