SQL Server Ledger – has taken data integrity to the next level, integrating blockchain-style data verification directly into the database.
Understanding the AUTO_DROP Option in SQL Server 2022
One such feature is the AUTO_DROP option for statistics. In this blog post, we’ll explore what the AUTO DROP option is, how it works.
FinOps Observability Fireside Chat: Elevating Database Management
FinOps Observability, the need for cost-efficient solutions in the database world is more critical than ever.
Optimize Data Manipulation Performance in SQL Server – Video Course
“Optimize Data Manipulation Performance in SQL Server,” which focuses on advanced indexing, query tuning, and concurrency control.
Why ‘Max Server Memory’ Isn’t Always the Limit
What if I told you that setting a limit with “max server memory (MB)” doesn’t always mean SQL Server will stick to that limit?
Automate Data Workflows with SQL Server Stored Procedures – Video Course
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.