Managing Change
Change is inevitable… Change for the better is not. (Jeff Moden) Time has taught me to view change (and the decisions that drove change) in a more kindly light. Things that seemed desperately important then seem less so now. Put it this way, Betamax …
PASS Data Community Summit 2023 – Sessions are available to view!
The post PASS Data Community Summit 2023 – Sessions are available to view! appeared first on SQLServerCentral.
The PASS Summit Lineup Is Out and Registration is Open!
This year’s PASS Data Community Summit is November 13-17 in Seattle. (No online version is available this year – you gotta be there in person.) If you’ve attended in person before, you already know the value: it’s like a family …
Discover the Microsoft Fabric Data Wrangler
The Data Wrangler is as interesting as hidden inside Microsoft Fabric. It’s not easy to find and activate it, but it is worth the trouble. Before digging into the Data Wrangler, let’s analyze the data features in the query environment. Data …
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. …