Question: How to Generate Random Password in SQL Server?
Answer: This is a fantastic question and here is the script to generate a random password in SQL Server
SQL SERVER Analysis Services – Unable to Start Service. Error: The Filename, Directory Name, or Volume Label Syntax is Incorrect
SQL Server Analysis Services would not start: the filename, directory name, or volume label syntax is incorrect. Here is what the event log showed and the fix.
Listing Server Credentials and Where They Are Used
Credentials hide their secrets but still tell you who depends on them. Build a small demo and follow a credential to its login, proxy and job step.
SQL SERVER – Unable to See SQL Server Configuration Manager. How to Open it?
A reader had no Start menu shortcut for SQL Server Configuration Manager and could not find it. Here is how to open it anyway.
SQL SERVER – Database Mail Error: The SMTP Server Requires a Secure Connection or the Client Was Not Authenticated. The Server Response Was: 5.5.1 – Using Gmail
In my earlier blog, we saw one possible cause database mail error due to SSL settings. Today we will learn about another Database Mail Error.
Verify a Migrated Database: Row Counts and Checksums per Table
You can verify a migrated database with two numbers per table: a row count and a checksum. In this test the row counts matched in both copies while the checksums exposed a changed price and a changed city. It also shows the case change that one checksum function missed and another caught.
SQL SERVER – gMSA: The Service Did Not Start Due to a Logon Failure
SQL Server running under a gMSA would not start: the service did not start due to a logon failure, yet no password had expired. Here is the real cause.