Automate Data Workflows with SQL Server Stored Procedures is aimed at enhancing your skills in creating, fine-tuning, and securing SP.
Detailed Summary of “Selling the Invisible: A Field Guide to Modern Marketing” by Harry Beckwith
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.
SQL Server Functions for Smart Data Handling – Video Course
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.
Capturing Stored Procedure Executions with Extended Events in SQL Server
We’ll go through the steps to set up an Extended Events session, run a sample stored procedure, and then query the captured data.
A Walkthrough – DATETRUNC Function in SQL Server
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.
Functions and Missing Indexes – SQL in Sixty Seconds 204
In this blog post, we will discuss the relationship between Functions and Missing Indexes Hints in SQL Server. Functions can reduce query performance.
3 ChatGPT Tricks to Tune SQL Server – SQL in Sixty Seconds 203
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.
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.
Pinal has authored 14 SQL Server database books and 94 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.
Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.
Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).
Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.