Mar 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 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
All Articles python3-600x203

Install Python3 on Linux

April 21, 2021
Pinal Dave
SQL Tips and Tricks
Kali Linux, Linux, Python

My major focus is always on SQL Server. I know a little bit about other technology as well. It is very straightforward to install Python3 on Linux.

Read More
All Articles UnsolvedCASEExpression-600x209

SQL Puzzle – Unsolved CASE Expression

April 20, 2021
Pinal Dave
SQL Puzzle
SQL CASE, SQL Scripts, SQL Server

Lots of people have asked me to share another puzzle. Well, let us see a very simple puzzle of Unsolved CASE Expression in today’s blog post.

Read More
All Articles changepassword-600x296

SQL SERVER – Change Password at the First Login

April 19, 2021
Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Scripts, SQL Server, SQL Server Security

Just like many other databases and applications, SQL Server also supports the feature to change password at the first login.

Read More
All Articles adhocqueries-600x345

SQL SERVER – AdHoc Queries and Optimize for Adhoc Workloads

April 16, 2021
Pinal Dave
SQL Tips and Tricks
Ad Hoc Query, SQL CPU, SQL Scripts, SQL Server, SQL Server Configuration

Discussion with a client during the Comprehensive Database Performance Health Check.  The topic is AdHoc Queries and Optimize for Adhoc Workloads.

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

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