Working around schema drift in SQL Server
At Stack Overflow, our environment has multiple implementations of a largely – but not 100% – identical schema. (By “schema,” I mostly mean the set of tables within a database.) I sometimes need to retrieve or update data across …
Bing vs Bard (Chatbot wars)
Introduction about Bing vs Bard You heard it well Chatbot wars, the war between Bing vs Bard. Ladies and gentlemen, in the Google corner we have the challenger, Bard! And in the Microsoft corner, we have a powerful AI-based in ChatGPT 4, the stupendous …
Managing the challenge of migrating to the cloud
The post Managing the challenge of migrating to the cloud appeared first on SQLServerCentral.
Dive into RDS Custom for SQL Server – Leverage your existing licenses and high availability
The post Dive into RDS Custom for SQL Server – Leverage your existing licenses and high availability appeared first on SQLServerCentral.
Database Concurrency in PostgreSQL
Concurrency control is an essential aspect of database systems that deals with multiple concurrent transactions. PostgreSQL employs various techniques to ensure concurrent access to the database while maintaining data consistency using atomicity and is …
How Would You Design This: Tracking Travels
One of the challenges for many database developers is coming up with a good design that not only meets the specifications but also performs well in queries. Relational databases often seek some level of normalization, which reduces the update load for …
Data Transfer from Azure Blob Storage to Snowflake Using Pipelines
The post Data Transfer from Azure Blob Storage to Snowflake Using Pipelines appeared first on SQLServerCentral.
PostgreSQL 101: The ten PostgreSQL extensions you need to know about
The post PostgreSQL 101: The ten PostgreSQL extensions you need to know about appeared first on SQLServerCentral.
Going to a conference where hardly anybody knows my name
On Friday and Saturday August 11 and 12, I am going to do something I haven’t done in a long time. I am going to a conference where I may not know anyone (I did learn about the conference from one of the people that run it who was also at SQL Sat …
[Video] Office Hours: Stump Me On SQL Server
I went through the top-voted questions from https://pollgab.com/room/brento and discussed ’em live on my Twitch channel. Here’s what we covered: 00:00 Start 00:39 tanchenglai: Hi Brent! We bought your Level 2 Bundle last year. Recent …
[Video] Office Hours: Extended Answers Edition
Y’all posted so many good questions at https://pollgab.com/room/brento that I went longer than usual this time: Here’s what we covered in this episode: 00:00 Start 02:17 Tanchenglai: Hi Brent, recently we always ran into thread pool issue. …
Meet the Summit 2023 Sponsors
The post Meet the Summit 2023 Sponsors appeared first on SQLServerCentral.
Upserts in Amazon Redshift
Amazon Redshift was first announced in 2012 as a new cloud-based analytical data warehousing service. Since then, it has evolved into a robust analytical database that has become an essential tool for businesses of all sizes. With its roots in Postgres …
Standard Sponsor Rates End August 30!
The post Standard Sponsor Rates End August 30! appeared first on SQLServerCentral.
A Beginners Guide to MySQL Replication Part 4: Using GTID-based Replication
Welcome back to another replication series! As a quick reminder, we explored various methods of using MySQL’s replication capabilities in our previous discussions. Initially, we employed the traditional binary-log-based replication approach to se …