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
Gouache painting of three bowls of seeds beside a mixing bowl with a vermilion wooden spoon

Random Password Procedure in SQL Server with CRYPT_GEN_RANDOM

August 15, 2018
Pinal Dave
SQL Tips and Tricks
SQL Password, SQL Random, SQL Scripts, SQL Server Security, SQL Stored Procedure

A random password procedure for SQL Server should use CRYPT_GEN_RANDOM, skip lookalike characters and guarantee every kind of character. This post builds one with a length and character switches, then tests 1,000 passwords. It also covers errors and safe handling.

Read More
Certificate in SQL Server Registry Editor.

SQL SERVER – Unable to Load User-Specified Certificate [Cert Hash(sha1) “Thumbprint.here”]. The Server Will Not Accept a Connection

August 6, 2018
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Encryption, SQL Server Security

While preparing a security demo, I broke my SQL Server and it would not start: Unable to load user-specified certificate. Here is how I fixed error 26014.

Read More
SQL SERVER - ERROR: Failed to verify the Authenticode signature of FileName

SQL SERVER – ERROR: Failed to verify the Authenticode signature of FileName

August 4, 2018
Pinal Dave
SQL Tips and Tricks
File format, SQL Error Messages, SQL Server, SQL Server Security, Windows

SQL Server logged: Failed to verify the Authenticode signature of sqlservr.exe. Here is what the message means and why it can point to malware on the machine.

Read More
Gouache illustration of a scoped firewall opening: a narrow side hatch opens through a gate whose other sections remain closed.

SQL SERVER – Scoped Firewall Rules Instead of Disabling the Firewall

August 3, 2018
Pinal Dave
SQL Tips and Tricks
Computer Network, PowerShell, SQL Scripts, SQL Server, SQL Server Security

A firewall rule should permit the required SQL Server or management connection narrowly. My original automation case needed remote access.

Read More
Different wooden shapes fit their corresponding recesses in a sorting board

How to Convert Hex Windows Error Codes to the Meaningful Error Message – 0x80040002 and 0x80040005 and others? – Interview Question of the Week #182

July 15, 2018
Pinal Dave
SQL Interview Questions and Answers
SQL Error Messages, SQL Server, SQL Server Security

Seen hex error codes like 0x80070070 in the ERRORLOG? Here are the simple steps I use to convert hex Windows error codes into meaningful error messages.

Read More
SQL SERVER - Backup to URL - Script to Generate the Create Credential and Backup Command using Access Keys

SQL SERVER – Backup to URL – Script to Generate the Create Credential and Backup Command using Access Keys

July 9, 2018
Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Backup and Restore, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security

Backup to URL can use a SAS token or access keys. Here is a script that builds the CREATE CREDENTIAL and BACKUP commands from your Azure storage access keys.

Read More
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
Previous 1 … 11 12 13 14 15 16 17 … 57 Next
  • Books
  • Testimonials
  • Privacy Policy

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