May 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
All Articles sellingtheinvisible-600x903

Detailed Summary of “Selling the Invisible: A Field Guide to Modern Marketing” by Harry Beckwith

August 5, 2024
Pinal Dave
SQLAuthority News
SQL Book

Let me tell you about a book that seriously changed the way I think about marketing services. It’s called “Selling the Invisible” by Harry Beckwith.

Read More
All Articles sqlserverfunctions-600x335

SQL Server Functions for Smart Data Handling – Video Course

August 1, 2024
Pinal Dave
SQL Video
Pluralsight

I’m excited to introduce my latest offering, the “SQL Server Functions for Smart Data Handling” course, designed to enhance your skills in advanced data handling techniques.

Read More
All Articles ExtendedEvents-600x601

Capturing Stored Procedure Executions with Extended Events in SQL Server

July 11, 2024
Pinal Dave
SQL Performance
SQL Extended Events, SQL Stored Procedure

We’ll go through the steps to set up an Extended Events session, run a sample stored procedure, and then query the captured data.

Read More
All Articles datetrunc-600x344

A Walkthrough – DATETRUNC Function in SQL Server

June 28, 2024
Pinal Dave
SQL Tips and Tricks
SQL DateTime

One such tool is the DATETRUNC function, introduced in SQL Server 2022. Let’s take a journey to understand how this function can simplify date handling.

Read More
All Articles YouTubeCover-600x338

Functions and Missing Indexes – SQL in Sixty Seconds 204

June 27, 2024
Pinal Dave
SQL Video
SQL Function, SQL Index

In this blog post, we will discuss the relationship between Functions and Missing Indexes Hints in SQL Server. Functions can reduce query performance.

Read More
All Articles CoverYT-600x338

3 ChatGPT Tricks to Tune SQL Server – SQL in Sixty Seconds 203

June 24, 2024
Pinal Dave
SQL Video
ChatGPT, SQL Performance

In this blog post, I will share three quick and effective methods to tune your SQL Server using ChatGPT. These tricks can help you optimize.

Read More
All Articles jng-600x398

Majoring in the Minors in SQL Server Performance Tuning

June 21, 2024
Pinal Dave
SQL Performance
Clustered Index, ColumnStore Index, Execution Plan, SQL Index

We’ll explore how to avoid this common pitfall & Focus the areas that matter for performance improvements. Avoid majoring in the minors. 

Read More
All Articles adtech-600x327

Advanced Data Retrieval Techniques in SQL Server – Video Course

June 1, 2024
Pinal Dave
SQLAuthority News
Pluralsight, SQL Server

The “Advanced Data Retrieval Techniques in SQL Server” course, designed to elevate your proficiency in handling complex SQL Server tasks.

Read More
All Articles SSDM-600x378

SQL Server Data Manipulation Essentials – Video Course

May 1, 2024
Pinal Dave
SQLAuthority News
Pluralsight

In today’s data-driven world, mastering SQL Server for optimal performance and workload management is indispensable. Introducing my latest offering, the “SQL Server Data Manipulation Essentials” course.

Read More
All Articles AIs-600x540

#TSQL2sday Roundup: Has AI Helped You with Your SQL Server Job?

April 12, 2024
Pinal Dave
SQL Tips and Tricks
AI, TSQL2sday

Earlier, I hosted a TSQL2sDay on Has AI Helped You with Your SQL Server Job?. I had lots of fun reading various contributions.

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

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