Resolutions found with SQL Server and other types of databases
Microsoft SQL Server database system
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 →
Problem: About once a month, I get support ticket regarding SQL Server dropping an application’s or user’s connection. The problem is SQL Server does not just randomly drop a connection … Continue Reading →
Problem: With the new install of Ubuntu 16.04.3 LTS (GNU/Linux 4.4.0-87-generic x86_64), different attempts at installing SQL Server resulted in the error: “E: Unable to locate package mssql-server”. Resolution: On … Continue Reading →
My goal was create a filename with the DateTime format to the millisecond to be used in a stored procedure. First was to get the DateTime format I wanted without … Continue Reading →
Troubleshooting the following Error: 2017-06-01 18:00:00.000 Logon Error: 17189, Severity: 16, State: 1. 2017-06-01 18:00:00.000 Logon SQL Server failed with error code 0xc0000000 to spawn a thread to process a … Continue Reading →
Problem: Received an e-mail alert for one of my SQL Servers: SQL Server Alert System: ‘Error Number 825’ occurred on < my SQL Server > DESCRIPTION: A read of the … Continue Reading →
Problem: Received a request for a list of all identity columns existing in a database. The example is from the SQL 2016 sample database: WideWorldImporters SELECT o.name as ‘OWNER’, t.name … Continue Reading →
Problem: Received a support ticket requesting help with the FILESTREAM database for a SQL Server. Was given only the server name. This server had over 50 databases in the SQL Server … Continue Reading →
Situation: We had a very busy SQL Server, that could not have “DBCC CHECKDB” run during business hours with out impacting others. I was being asking for the output from … Continue Reading →
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 →