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.
New Trends and Challenges in Database Administration
DBAs now handle development, DevOps, NoSQL and cloud moves on top of tuning. Here are three new trends and challenges in database administration today.
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.
How to Check Edition Specific Features Enabled In SQL Server? – Interview Question of the Week #180
Moving databases to another edition? Here is a simple script for SQL Server 2008 and later that lists the Edition specific features each database uses.