Auditing SQL Server – Part 2 – Hardware Audit
This is the second part of my series on auditing SQL Server. In the first part, I […]
Sites anglophones
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 ...
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 […]
T-SQL Tuesday #176 Roundup of advice
There was a lot of great advice, and I really wonder how much of this I would […]
Making Temporal Databases Work. Part 2: Computing Aggregates Across Temporal ...
The temporal database is a database that can keep information on time when the facts represented in […]
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 […]
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. […]
Save $200 by registering for a PASS Summit 2024 3-day ...
The post Save $200 by registering for a PASS Summit 2024 3-day ticket before July 16 appeared first […]
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 […]
[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 […]
Announcing Free SQL Server Monitoring.
You already use sp_Blitz and the rest of the free, open source First Responder Kit to give your […]
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 […]
Redgate recommended in Bloor Test Data Management market update
The post Redgate recommended in Bloor Test Data Management market update appeared first on SQLServerCentral.
Docker Logging Guide Part 1: Basic Concepts and Importance
The post Docker Logging Guide Part 1: Basic Concepts and Importance appeared first on SQLServerCentral.
Hot off the press
Every day an avalanche of news hits us from all directions in all kinds of media. So […]
Use “We” Not “You”. #tsql2sday
For T-SQL Tuesday this month, Louis Davidson suggested we give our past self some advice. I’d tell myself, […]
It’s a recovery strategy, not a backup strategy
I’ve talked about it before; you shouldn’t have a backup strategy, you should have a recovery strategy. […]
General program for PASS Summit 2024 now available
The post General program for PASS Summit 2024 now available appeared first on SQLServerCentral.
Meet the new Google AI Assistant Gemini
Introduction to Gemini Gemini’s intro. In the beginning, there was Bard. A powerful language model, crafted by Google AI, […]
What does SQL NULL mean and how to handle NULL ...
The post What does SQL NULL mean and how to handle NULL values appeared first on SQLServerCentral.
How much Space can I expect to recover from a ...
In my last article – Identify Tables With Dropped Columns – we saw how we can identify tables […]
[Video] Office Hours in Sofia, Bulgaria
I was honored to speak at the Present to Succeed conference in Sofia, Bulgaria, run by a former […]
Microsoft Fabric, the Land of Wizards and Trolls
In my previous article (What is Microsoft Fabric All About) I explained what Microsoft Fabric is, how […]
Summer School Savings SALE is live!
Happy Fourth of July to all who celebrate! I’m looking forward to a great view Thursday evening looking […]
Save $350 on the PASS Summit if You Register Now.
Next Tuesday, pricing on the 3-day tickets for the PASS Data Community Summit goes up to $2,095. But […]
Prevent Duplicate Records in SQL using Filtered Index
The post Prevent Duplicate Records in SQL using Filtered Index appeared first on SQLServerCentral.
Does Bit Column Order Matter in Tables?
At the PGConf.dev, where Postgres developers get together and strategize the work they wanna do for the next […]
T-SQL Tuesday #176: One piece of advice you wish Past ...
After so many years, here in July 2024, I am finally hosting T-SQL Tuesday. The challenge One […]
Updated First Responder Kit and Consultant Toolkit for July 2024
The next release would normally be August, but I’m doing a release a little early in order to […]
Extending Get-Process to show the Process Chain using PowerShell Proxy ...
A proxy function or wrapper function allows you to deploy a custom version of a function or […]
Getting Your DBA Teams Scripts into Git
One of the things that many teams of DBAs have is a set of scripts they use in […]
Saving Data Historically with Temporal Tables: Part 1: Queries
In this article we discuss how to store data temporally in PostgreSQL. Temporal database store data in […]
Build Chatbot with Large Language Model (LLM) and Azure SQL ...
The post Build Chatbot with Large Language Model (LLM) and Azure SQL Database appeared first on SQLServerCentral.
Set up a Windows Server Fail-over Clusters (As a Precursor ...
In this walkthrough, we will be setting up WSFC (Windows Server Failover Cluster) in Windows Server. An WSFC […]
[Video] Office Hours: I Don’t Have All the Answers
When I went through the top-voted questions at https://pollgab.com/room/brento, I didn’t have all the answers today: Here’s what […]
Join Me in Seattle for Watch Brent Tune a Query ...
The PASS Data Community Summit session lineup for Nov 4-8 in Seattle was just announced, and I’ve been […]
Control OneLake with Storage Explorer – Data Engineering with Fabric
OneLake Storage What is a Lakehouse in Azure Fabric? Borrowing a quote from MS Learn – « Microsoft Fabric […]
The SQL Language is Just a Hurdle You Gotta Overcome.
I’m not talking just about Microsoft SQL Server specifically here, nor T-SQL. Let’s zoom out a little and […]
Deleting Documents from a MongoDB Collection
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
How to Rename a Column in SQL Server
Recently, I was working on a project to analyze the schema of a third-party vendor. In our organization, […]
XML Performance Tuning and Added Options
SQL Server provides a variety of ways to tune XML so that it provides consistent performance, consumes […]
How I Used PostgreSQL RLS To Avoid Code Changes During ...
Overview Our application is a microservice that stores metadata for actual data and is backed by Amazon Postgres […]
[Video] Office Hours: Database Answers from a Hotel Room
I went through your top-voted questions from https://pollgab.com/room/brento before heading out to PGConf.dev in Vancouver. Here’s what we […]
Query Exercise Answer: Beating ChatGPT at Finding Good Question Times
For this week’s Query Exercise, I asked you to write a better query than ChatGPT wrote. Your goal […]
SQL Server TRY CATCH, RAISERROR and THROW for Error Handling
The post SQL Server TRY CATCH, RAISERROR and THROW for Error Handling appeared first on SQLServerCentral.
Unzipping Word Documents in T-SQL
In the databases I am currently working with, there are some tables containing Word documents stored as binaries […]
Join Me in San Diego for SQL Saturday!
I’m coming to San Diego on Sept 13-14 for SQL Saturday San Diego! I’m teaching a one-day pre-conference […]