Database Sharding: Strategies for Seamless Scaling and Performance Optimization
Companies of all sizes and across industries are struggling to cope with an explosion of data never before seen in the short history of computing. As applications reach new levels of sophistication and become deeply interconnected, these companies find …
Introducing the New Stars of Data speakers for PASS Summit 2024
The post Introducing the New Stars of Data speakers for PASS Summit 2024 appeared first on SQLServerCentral.
[Video] Office Hours: Database Q&A
I went live on TikTok and took your top-voted questions from https://pollgab.com/room/brento: Here’s what we covered: 00:00 Start 00:23 Andrea Hardesty: Do you have any recommendations for reproducing parameter sniffing issues? I have a copy of a …
Query Exercise: Why Are These 3 Estimates So Wrong?
Our prior Query Exercise introduced SQL Server’s 201 buckets problem: its inability to accurately estimate rows for more than 201 outliers in a table. I followed up with a solution using filtered statistics to help with the next 200 outliers, and …
Making Temporal Databases Work. Part 3: Saving Data
The temporal database is a database that can keep information on time when the facts represented in the database were, are, or will be valid. We briefly described major concepts of temporal databases and discussed types of queries that such databases c …
Devising the Perfect Index for Your Use Case – MySQL Edition
Introduction If you’ve been following SimpleTalk for a while, you will be aware that I’ve recently blogged about MySQL indexes. I’ve already told you about the nuances of indexes in MySQL, vanilla B-Tree indexes, composite B-Tree indexes, and other kin …
Event Streams for Persistent and Asynchronous Microservice Communication
The post Event Streams for Persistent and Asynchronous Microservice Communication appeared first on SQLServerCentral.
Delta Table Performance Is Governed By Transaction Size: Data Engineering with Fabric
Relational Databases are known for their atomic, consistent, independent and durable properties (ACID). The first version of Apache Spark was released in 2014 However, the tables in the hive catalog did not have any ACID properties at that time. Tha …
PASS Data Community Summit Prices Are About to Go Up!
Next Tuesday, pricing on the 3-day tickets for the PASS Data Community Summit goes up to $2,295. But if you register right now, plus use coupon code BRENTO24, it’s just $1,945. It’s one in-person conference that covers Microsoft SQL Server, …
Uniqueness, Keys, and Identity
If you’ve ever had a traditional logic course, you’ll have run into “The Law of Identity” as the founding principle of all Western thought. It says that: “To be is to be something in particular; to be nothing in particular or anything in general, is to …
What Did AI Ever Do for Me?
Let me start with a simple confession, and I hope it’s not too shocking for anyone; I’m old. When I was a teenager, a fantastically funny film was released called “Monty Python’s The Life of Brian”. While I recognize there is some controversy around th …
GitHub Desktop Tutorial
Introduction Previously, we created a tutorial to connect Visual Studio Code with GitHub. Now, we will show another useful tool to track changes in our SQL code. The tool is GitHub Desktop. What is GitHub Desktop? It is a free tool that works with Git …
PostgreSQL Backups to Support Point In Time Recovery: Learning PostgreSQL with Grant
The focus of your backup strategy should not be backups. Instead, you should be focused on restoring databases, because, after all, that’s what matters. Simply having a backup is fine. However, if you can’t restore your data from that backup, it doesn’ …
Using Containers to Avoid Installing SQL Server
I got a new laptop recently and instead of installing SQL Server, I decided to try and use containers to see how well this works. This article looks at how I got this working relatively quickly. The short list of things I did is: Install Docker Desktop …
SQL ROUND Function vs. Bankers Rounding with T-SQL
The post SQL ROUND Function vs. Bankers Rounding with T-SQL appeared first on SQLServerCentral.