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
SQL Audit Collection - Log File Viewer.

SQL SERVER – SQL Audit Date Time Does Not Match Machine Date Time – Solution

May 9, 2017
Pinal Dave
SQL Tips and Tricks
SQL Audit, SQL DateTime, SQL Scripts, SQL Server

A bank DBA noticed SQL Audit log times did not match the server clock. Here is why the audit time looks off and how to see it in local time.

Read More
Three sorting tray sections hold different numbers of cached pebbles while other pebbles remain outside

How to Find SQL Server Memory Use by Database and Objects? – Interview Question of the Week #121

May 7, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL Cache, SQL DMV, SQL Memory, SQL Scripts, SQL Server

Which database uses the most buffer pool? Queries on sys.dm_os_buffer_descriptors to find SQL Server Memory use by database and by object.

Read More
A ticket window with its shutter pulled halfway down and a paper slip left behind on the ledge.

SQL Azure Database – Msg 40197, Level 20 – The Service has Encountered an Error Processing Your Request. Please Try Again. Error Code 40549

May 4, 2017
Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Error Messages, SQL Scripts, SQL Server

A bulk insert from Azure Blob Storage failed hours in with Msg 40197, error processing your request, code 40549. Why long transactions get killed, and the fix.

Read More
SQL Server database mirroring error.

SQL SERVER – Database Mirroring Login Attempt Failed With Error: ‘Connection Handshake Failed. There is No Compatible Encryption Algorithm. State 22

May 3, 2017
Pinal Dave
SQL Tips and Tricks
SQL Connection, SQL Error Messages, SQL Mirroring, SQL Scripts, SQL Server

Moving from database mirroring to an AlwaysOn AG failed with a handshake error: no compatible encryption algorithm. Comparing the endpoints showed why.

Read More
A fixed-base storage box has expanded sides to hold more sheets

What is the Initial Size of TempDB? – Interview Question of the Week #120

April 30, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server, SQL TempDB, Starting SQL

Question: What is the Initial Size of TempDB? Trust me, this question is way more complicated than you read in one line.

Read More
SQL server command prompt.

SQL SERVER – Unable to Start SQL Service – OS Error 5 (Access is denied.) for TempDB

April 27, 2017
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL TempDB, Starting SQL

I moved TempDB files and SQL Server would not start, with OS Error 5 (Access is denied). The message was misleading, and here is the real mistake.

Read More
Step-by-step differential backup diagram.

SQL SERVER – FIX : Msg 3178, Level 16 – File SQLAuthority is Not in the Correct State to have This Differential Backup Applied to it

April 25, 2017
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Error Messages, SQL Scripts, SQL Server

Msg 3178 says a file is not in the correct state to have this differential backup applied to it. Here is how I reproduced it, and the fix.

Read More
Previous 1 … 128 129 130 131 132 133 134 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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