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
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
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.
To get alternate row colors in an HTML table from T-SQL, number the rows with ROW_NUMBER and pick a color by odd or even. This post builds the whole table with STRING_AGG, escapes special characters, colors one cell by value, and explains why the numbering must follow the display order.
How do you find the Service Account for SQL Server and SQL Server Agent? Here are three ways: Configuration Manager, services.msc, and a T-SQL query.
Use a tally table or GENERATE_SERIES to replace repeated date, character, and missing-number loops with ordered sets of rows.