Jan 2026 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
All Articles apache2linux-600x162

Apache2 Linux – Common Commands

May 5, 2021
Pinal Dave
SQL Tips and Tricks
Apache2, Linux

I do not remember all the commands all the time so I had written down a few of the commands which I was using with Apache2 Linux.

Read More
All Articles queuecount-600x264

SQL SERVER – List Service Broker Queue Count

May 4, 2021
Pinal Dave
SQL Tips and Tricks
Service Broker, SQL Scripts, SQL Server

Clients ask me questions, I try my best to help if I know the answer. Recently I was asked if I know the how-to List Service Broker Queue Count.

Read More
All Articles disablealltriggers-600x416

SQL SERVER – Enable or Disable All Triggers

May 3, 2021
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Trigger

As soon as we did disable all triggers on the tables, we were able to see a huge performance improvement. Let us learn how we can do it.

Read More
All Articles CalculateSimpleInterest-600x119

SQL SERVER – Function to Calculate Simple Interest

April 30, 2021
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server

It was very surprising that they would write a complicated function. Let us see a very simple way to write Function to Calculate Simple Interest.

Read More
All Articles counts-600x131

SQL SERVER – Difference Between Count and Count_Big

April 29, 2021
Pinal Dave
SQL Tips and Tricks
Data Type, SQL Scripts, SQL Server

Let me answer you first – there is no difference between Count and Count_Big in terms of functionality. They are almost the same.

Read More
All Articles Slowloris-600x202

Impact with Slowloris – DDoS and Red Team Engagement

April 28, 2021
Pinal Dave
SQLAuthority News
Pluralsight, SQL Server Security

I am super excited to share with all of you that today, I released my 40th Pluralsight course. The topic of the course is Impact with Slowloris.

Read More
All Articles learning-resources-600x127

Learning Resources I Use and Recommend (Updated: April 2020)

April 27, 2021
Pinal Dave
SQL Tips and Tricks
Instant Learning

In today’s blog post I will be sharing a few of the learning resources which I have been using to further train my skills. 

Read More
All Articles 160-Bitwise-Puzzle-yt-600x338

Bitwise Puzzle – SQL in Sixty Seconds 160

April 26, 2021
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Scripts, SQL Server

Many did not believe in the real world and based on the request, I have made the recent video on the same topic of the bitwise puzzle. 

Read More
All Articles talkback-600x1340

Android Greenbox Around Icon – Unable to Scroll

April 23, 2021
Pinal Dave
SQL Tips and Tricks
Android

I thought it might be just a temporary thing and I had restarted it but that was not the case. In My android phone, I had a Greenbox Around Icon.

Read More
All Articles jointypes-600x314

SQL SERVER – Change Join Type for Query

April 22, 2021
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Joins, SQL Operator, SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

“Can I Change Join Type for Query?” I was recently asked this during  Comprehensive Database Performance Health Check. Of course Yes!

Read More
Previous 1 … 36 37 38 39 40 41 42 … 580 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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