What Would You Ask Your Predecessor? Get Answers with ChatGPT.
So many times in my career, I’ve come across a questionable query, table design, or server configuration decision, and I just wanted to reach out to The Last Person™ to find out what the hell they were thinking. Now, with ChatGPT, I can. Here …
Exploring PostgreSQL Indexes
In this blog, we continue our exploration on PostgreSQL indexes which we started here. In that article, we learned what an index is, and how exactly indexes can help with query execution. But there is much more to learn about indexes! In this blog, we …
What is subsetting, what are the advantages, and how does it make test data management easier?
The post What is subsetting, what are the advantages, and how does it make test data management easier? appeared first on SQLServerCentral.
Identify log write limits on Azure SQL Managed Instance using QPI library
The post Identify log write limits on Azure SQL Managed Instance using QPI library appeared first on SQLServerCentral.
SQL Window Functions Series: LAG() and LEAD()
In the realm of data analysis, being able to understand the relationships between sequential data points is paramount. Whether you’re analyzing sales trends, monitoring server performance, or studying user engagement, there will inevitably come a time …
How using a database monitoring tool helps DBAs create value for the whole organization
The post How using a database monitoring tool helps DBAs create value for the whole organization appeared first on SQLServerCentral.
Window Function Basics – PARTITION BY
One of the things that I’ve done over the last year to improve my T-SQL skills is learn to work with the various window functions that exist in the language. These were added in 2012 and there have been a number of improvements across the last decade. …
Learn Spark SQL Date and Time Functions
The post Learn Spark SQL Date and Time Functions appeared first on SQLServerCentral.
SQL Server: Optimize for Ad Hoc Workloads – use or not use
I used to believe this option was something almost absolute: it should be enabled as best practice. I was in some way happy when all my demos for SQL Server 2022 started to fail, and I discovered it was because this option was enabled by default. This …
How Has Inflation Affected Your Salary? Let’s Find Out Together.
The 2020s have been tough: a pandemic, a recession, layoffs, and inflation. Inflation makes things particularly tricky because your costs for everything have risen a lot in the last year, but at the same time… has your salary? What about your pee …
Plansplaining, part 20. SQL Graph (part 1)
The post Plansplaining, part 20. SQL Graph (part 1) appeared first on SQLServerCentral.
Who’s Hiring in the Microsoft Data Platform Community? December 2023 Edition
Is your company hiring for a database position as of December 2023? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must i …
Understanding SQL Join Types
Understanding how to join the data in one table to another is crucial for any data analyst or database developer working with a relational database. Whether you’re a beginner or an experienced SQL user, this article will help you strengthen your …
GitHub Copilot – Our Best Ally to for T-SQL
Introduction Previously, we wrote about Copilot and showed how to install and work with it. A GitHub copilot is an AI programmer who can help a lot of developers with daily tasks. In this article, we will learn the following things: First, we will use …
Championing DevOps: A Panel Webinar
The post Championing DevOps: A Panel Webinar appeared first on SQLServerCentral.