Install SQL Server Management Studio (SSMS) 2016 Without Internet Access: One of my frustrations with SQL Server 2016, is that the SQL Server Management Studio (SSMS) is no longer included with the database instance installation. It is now has its … Continue Reading →
Using Ola Hallengren Backup Procedure with Cohesity
Note: I was asked to run a proof of concept with Cohesity for SQL Server using Ola Hallengren’s backup stored procedure. What is shared here is what I wish Cohesity … Continue Reading →
Query – Percentage of Physical Memory SQL Server is Currently Using
Note: Unlike other queries I have share here at TheSQLReport, I am the author of this one. Sharing because I could not find it in my Google Searches. Tested … Continue Reading →
Using Microsoft’s TroubleShootingScript Version 2 (TSSv2) Toolset to Collect Support Information
(If pictures are not being displayed below, try viewing this post in Microsoft Edge browser) When opening a support case with Microsoft for SQL Server, sometimes they ask for information … Continue Reading →
Error: 18452 – login is from an untrusted domain and cannot be used with Windows authentication
Note: This is just a work around & not root cause. This does not work in all cases, and is environment dependent. Problem: Being in a new environment, sometime … Continue Reading →
Excel Error: SSL Provider, error: 0 – The certificate chain was issued…
Note: I did not resolve this issue, but am sharing this because of the unsuccessful time spent on Google trying to find a resolution to to this issue. Hoping it … Continue Reading →
SQL Server – List of All Databases with Compatibility Levels
Adding this because I was not able to find this query on the first page of my Google search. Wanted a list of all the databases in the SQL Server … Continue Reading →
Setting A Teradata Maintenance Window – Updated 2021
Teradata in a recent design change moved where to set the Maintenance Window with the roll out of their newer equipment. Note: The reason that you would want to set … Continue Reading →
After Azure SQL Login Password Change – Error 916
My organization requires periodic password changes on all its accounts. After changing a password for a local login for a Azure SQL Instance, this account was able to login into … Continue Reading →
FileStream – High Number In The Num_Unprocessed_Items Column After Running Garbage Collection
First, I am by no means a FileStream expert. I am a DBA that was thrown a FileStream support ticket. Problem, the developer ran the delete from the filestream table, … Continue Reading →
Bitnami MariaDB Virtual Machine – How To Enable Port 3306 for MariaDB
Bitnami virtual machines are great for quickly enabling an environment for testing or learning. Sometimes they can be a challenge when I want to use other software with them. Problem: … Continue Reading →