This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
A varied sequence of wooden tokens drawn from a bag beside a brass padlock

How to Generate Random Password in SQL Server? – Interview Question of the Week #181

July 8, 2018
Pinal Dave
SQL Interview Questions and Answers
SQL Random, SQL Scripts, SQL Server, SQL Server Security

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

Read More
Two picnic baskets carry different sets of equipment

How to Check Edition Specific Features Enabled In SQL Server? – Interview Question of the Week #180

July 1, 2018
Pinal Dave
SQL Interview Questions and Answers
SQL Deprecated Feature, SQL Scripts, SQL Server, SQL Upgrade

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.

Read More
A hand sowing seeds into a red clay pot while a clogged mechanical seeder stands idle

SQL SERVER – Many BACKGROUND Threads with Command VDI_CLIENT_WORKER

June 29, 2018
Pinal Dave
SQL Tips and Tricks
SQL CPU, SQL Error Messages, SQL Scripts, SQL Server, SQL Wait Stats

Seeing many BACKGROUND threads with command VDI_CLIENT_WORKER? Here is what the VDI_CLIENT_WORKER and VDI_CLIENT_OTHER wait types mean.

Read More
SQL Server database size.

SQL SERVER – Unable to Start SQL Resource in Cluster – HUGE Master Database!

June 26, 2018
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL Server Cluster, System Database

A client’s SQL Resource would not come online on either cluster node. The ERRORLOG showed a very slow recovery of a huge master database. Here is the fix.

Read More
Gouache painting of a row of deck chairs alternating cream and slate blue with one vermilion chair

Alternate Row Colors in an HTML Table Using T-SQL

June 25, 2018
Pinal Dave
SQL Tips and Tricks
HTML, SQL Scripts, SQL Server

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.

Read More
Different service keys and blank colored fobs hang above separate locks

How to Find Service Account for SQL Server and SQL Server Agent? – Interview Question of the Week #179

June 24, 2018
Pinal Dave
SQL Interview Questions and Answers
SQL Log, SQL Scripts, SQL Server, SQL Server Security, SQL Server Services

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.

Read More
Milk pouring into a whole row of glass bottles at once from a bar of spouts in a dairy

Tally Table: Replacing WHILE Loops With a Set of Numbers

June 22, 2018
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server 2022, SQL String

Use a tally table or GENERATE_SERIES to replace repeated date, character, and missing-number loops with ordered sets of rows.

Read More
Previous 1 … 96 97 98 99 100 101 102 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com