June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
Has DB Access

SQL SERVER – List Databases Where User Has DB Access

November 26, 2021
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Security

This is a very interesting function and it helps us to list databases where User Has DB Access. Well, it is pretty straightforward to know with the help of function HAS_DBACCES.

Read More

Get Current Time Zone – SQL in Sixty Seconds #187

November 23, 2021
Pinal Dave
SQL Video
SQL DateTime, SQL in Sixty Seconds, SQL Scripts, SQL Server

Lots of people often ask me how to get the current time zone in SQL Server when I am working on Comprehensive Database Performance Health Check.

Read More
memory pressure

Detecting Memory Pressure – SQL in Sixty Seconds #186

November 17, 2021
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Memory, SQL Scripts, SQL Server

Lots of people who watched the video also asked me to build a similar video. Let us see today a video where I explain how to detect memory pressure. 

Read More
select sleep

MySQL – Wait For Seconds Using SELECT SLEEP()

November 15, 2021
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Scripts

Recently my client asked me if there is the equivalent command of WAIT FOR of SQL Server in MySQL. Of course, there is and a very simple one. 

Read More
timezone

SQL SERVER – List All Available TimeZone

October 29, 2021
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Scripts, SQL Server

Let me ask you a quick question – how many timezone SQL Server supports? The answer is for SQL Server 2019 it is 141. Yes, it is true.

Read More
DBCC FLUSHAUTHCACHE

SQL SERVER – Empty Database Authentication Cache with DBCC FLUSHAUTHCACHE

October 26, 2021
Pinal Dave
SQL Tips and Tricks
SQL Cache, SQL Scripts, SQL Server, SQL Server DBCC

A very interesting DBCC command I recently came across and that is DBCC FLUSHAUTHCACHE. DBCC function applies to Azure SQL Database.

Read More
Last Used Stored Procedure

SQL SERVER – Last Used Stored Procedure

October 25, 2021
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Stored Procedure

“Is there any way to know the last used stored procedure in SQL Server?” Well, I was asked this during Health Check. 

Read More
Previous 1 2 3 4 5 … 318 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version