Configure Microsoft Fabric Database Mirroring for Snowflake
The post Configure Microsoft Fabric Database Mirroring for Snowflake appeared first on SQLServerCentral.
Four steps towards tackling the complexity of managing multiple database platforms
The post Four steps towards tackling the complexity of managing multiple database platforms appeared first on SQLServerCentral.
Updated, Larger Stack Overflow Demo Database
Stack Overflow publishes a data dump with all user-contributed content, and it’s a fun set of data to use for demos. I took the 2024-April data dump, and imported it into a Microsoft SQL Server database. It’s an 31GB torrent (magnet) that e …
T-SQL Tuesday #176 Roundup of advice
There was a lot of great advice, and I really wonder how much of this I would have listened to myself back in the day. In no order other than the order I found them in my comments and then XTwitter. This was fun, and if you are just now hearing of T-SQ …
Making Temporal Databases Work. Part 2: Computing Aggregates Across Temporal Versions
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 …
Prompt+ EAP: your AI-powered database development partner in the making
The post Prompt+ EAP: your AI-powered database development partner in the making appeared first on SQLServerCentral.
Exploring Generative Adversarial Networks (GANs) for Butterfly Image Generation
Introduction In the realm of image generation, Generative Adversarial Networks (GANs) have emerged as powerful tools, capable of creating remarkably realistic visuals. For professionals with decades of experience, witnessing this transformation is akin …
Add Indexes to Improve SQL DELETE Performance
The post Add Indexes to Improve SQL DELETE Performance appeared first on SQLServerCentral.
Streaming Event Data through RabbitMQ to a Microsoft Fabric Eventstream
In this fast-changing world of data, businesses are looking for more insights in their data to remain competitive. They want these insights delivered faster and faster, up to the point where real-time intelligence – through the use of streaming data – …
Save $200 by registering for a PASS Summit 2024 3-day ticket before July 16
The post Save $200 by registering for a PASS Summit 2024 3-day ticket before July 16 appeared first on SQLServerCentral.
Working with Documents in the MongoDB Compass GUI
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the items in the series, click here. Throughout this series, I’ve discussed various ways to work with the documents in a MongoDB collection. If you’ve been following …
[Video] Office Hours in Bulgaria
I went through your top-voted questions from https://pollgab.com/room/brento while in front of the National Gallery for Foreign Art in Sofia. Here’s what we covered: 00:00 Start 03:12 MyTeaGotCold: If all of my columns are nvarchar, is the …
Announcing Free SQL Server Monitoring.
You already use sp_Blitz and the rest of the free, open source First Responder Kit to give your SQL Servers a health check now and then. But let’s be honest: you don’t do it often enough. You wish you had an easier way to know when your bac …
Manage OneLake Storage With PowerShell – Data Engineering with Fabric
Microsoft Fabric has OneLake Storage at the center of all services. This storage is based upon existing Azure Data Lake Storage and can be accessed with familiar tools Previously, we talked about how Azure Storage Explorer and AzCopy both needed manu …
Redgate recommended in Bloor Test Data Management market update
The post Redgate recommended in Bloor Test Data Management market update appeared first on SQLServerCentral.