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 →
Resolutions found in SQL Server, Oracle, Teradata, and other issues
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 →
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 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 →
Problem: A developer reach out to me about an error they were getting when attempting to run a stored procedure that used a linked server to pull data from an … Continue Reading →
Someone asked me to look at this error when applying a cumulative update on an instance of SQL Server 2016. It was a strange error because I was able to … Continue Reading →
This is a quick query that I use to check if the on the stats job that ran over night. Much faster then running the “SHOW STATISTICS” for each table. … Continue Reading →
I was patching an old SQL Server 2014 server with Service Pack 3. During the update process, the Service Pack froze at the “Install_sql_common_core_Cpu64_Action : InstallFinalize” for about ten minutes … Continue Reading →
When troubleshooting from SSMS, I need to know which Windows server my clustered instance is running on. Surprised that this query is not already on the first page of the … Continue Reading →
Sadly I have not found a better way to view the available OLE DB Providers on a server. Even though I am using an out of support Windows Server 2012 … Continue Reading →
Working with large sql statements, I find it is easier to have line numbers in the query window. Enabling “Line numbers” process is the same with every version of SQL … Continue Reading →