MySQL Error Log Management in DevOps Operations
When it comes to the development and operations (DevOps), one thing stands out as a critical aspect and that is troubleshooting. The primary goal of a DevOps team is to ensure that the product experiences zero to no downtime because every moment is cru …
[Video] Office Hours: Sunshine Edition
You know how this works: you posta the questions at https://pollgab.com/room/brento, and I giva the answers: Here’s what you asked in this episode: 00:00 Start 03:18 DBA in VA: I recently discovered the “force order” query hint. I …
Fabric Notebooks and Deployment Pipelines
On my article about Fabric source control extended features, I explained how Microsoft included the notebooks on the source control. In this way we can include notebooks on a Software Development Lifecycle (SDLC) for Power BI objects. In this way, the …
[Video] Office Hours: Really Good Questions Edition
Y’all were on fire in this one! You posted great questions at https://pollgab.com/room/brento and I worked through ’em: Here’s what we covered: 00:00 Start 04:06 DislikeEntityFramework: In AWS RDS, we inherited a 9TB table with unique …
SQL GROUP BY Alias – An Oracle feature that would be great in SQL Server
The post SQL GROUP BY Alias – An Oracle feature that would be great in SQL Server appeared first on SQLServerCentral.
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 …