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 […]
Sites anglophones
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 […]
Working with SQL Server in Visual Studio Code
Introduction Visual Studio Code (VSCode) is a free and light source code editor created by Microsoft. It can […]
Fine-grained Access Control for Stored Procedures
Synopsis Modern relational databases have comprehensive security mechanisms to enforce fine-grained access control for tables and views. But when […]
Power BI Treemap Chart Step-by-Step Tutorial
The post Power BI Treemap Chart Step-by-Step Tutorial appeared first on SQLServerCentral.
[Video] Creepy Office Hours in Vancouver
While in a hotel room in Vancouver for PGconf.dev, I strapped on my Apple Vision Pro headset to […]
Query Exercise: Beat ChatGPT at Finding Good Question Times
What are the best days of the week and times of the day to post a question at […]
Memory Grant Feedback Persistence in SQL Server 2022
As a SQL Server DBA, effectively controlling memory allocations is essential to guaranteeing optimal query performance. In SQL […]
PostgreSQL is Now Faster than Pinecone, 75% Cheaper, with New ...
NEW YORK – June 11, 2024 – Timescale, the PostgreSQL cloud database company, has unveiled two groundbreaking open-source […]
There’s a 6-Month Statute of Limitations on “The Last Person.”
“The last person must have set it up that way.” “The last person wrote that code.” “The last […]
Choosing Between the Lakehouse and Warehouse in Microsoft Fabric
Microsoft Fabric is a new centralized, AI-powered cloud data platform hosted by Microsoft. It combines several services […]
Concepts and Issues in Test Data Generation
Data generation is the science and art of providing data for database development work that is as […]
How to Sort String Date Values on a Power BI ...
The post How to Sort String Date Values on a Power BI Slicer Visual appeared first on SQLServerCentral.
How to Set Up Microsoft Fabric Database Mirroring for Azure ...
Microsoft Fabric is a new centralized, SaaS data analytics platform which has been generally available since November 2023. […]
Identify Tables With Dropped Columns
In my last article – What happens when we drop a column on a SQL Server table? Where’s […]
Sails.js for web development
Sails.js is a robust web development framework that runs on top of Node.js and uses JavaScript’s asynchronous […]
Suivi en temps réel de ma production solaire et de ...
Microsoft Fabric is a cloud-based platform that lets you, among other Data Activity, stream, analyze, and visualize […]
[Video] Office Hours in a Hotel Room
While in Nashville for a creators conference, I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we […]
Auditing SQL Server – Part 1 – Discovery and Documentation
Inheriting a server, whether as an inexperienced user or an experienced DBA, has many challenges. It’s very […]
The signs of a new era: Prompt Injection
More than 20 years ago, I wrote a book about SQL Injection and how dangerous it can […]
Two Tweaks for Faster Backups with Ola Hallengren’s Scripts
Ola Hallengren’s free maintenance solution is widely used as a replacement for SQL Server maintenance plans. It’s a […]
WITspiration – Year 2
The post WITspiration – Year 2 appeared first on SQLServerCentral.
Basic Always On Availability Groups in SQL Server Standard
Introduction In this walkthrough, we will be setting up a Basic Availability Group in SQL Server Standard edition […]
Who’s Hiring in the Microsoft Data Platform Community? June 2024 ...
Is your company hiring for a database position as of June 2024? Do you wanna work with the […]
Effective Strategies for Storing and Parsing XML in SQL Server
XML is a common storage format for data, metadata, parameters, or other semi-structured data. Because of this, […]
Bridging Snowflake and Azure Data Stack: A Step-by-Step Guide
In today’s era of hybrid data ecosystems, organizations often find themselves straddling multiple data platforms for optimal performance […]
Powershell and SQL on the River
We are having a conference in Chattanooga, TN on Aug 16 and 17, the primary topics of […]
[Video] Office Hours: 16 Questions
Like Sixteen Candles, but different: I go through your top-voted questions from https://pollgab.com/room/brento. Strangely, my video and audio […]
PostgreSQL UNION, INTERCEPT & EXCEPT Operator
Overview In this tutorial, you will learn how to use the PostgreSQL Union, Intercept and Except operators to […]
SQL Bulk Insert Command Examples
The post SQL Bulk Insert Command Examples appeared first on SQLServerCentral.
Coming in Entity Framework 9: Better Query Parameterization
Hallelujah. With current versions of Entity Framework, when developers add a mix of parameters and specific values to […]
This Is It! The Last 3 Days of My Anniversary ...
Every year in May, I look back at when I first registered BrentOzar.com way back in May 2001. […]
Enhancing Web Application Performance through Database Optimization: A Comprehensive Study
Introduction In today’s digital age, web applications serve as the backbone of online services, catering to a myriad […]
Updated First Responder Kit and Consultant Toolkit for May 2024
If you’ve hard-coded installer file names, there’s a big change in this release. There are now just 2 […]
Snake draft sorting in SQL Server, part 4
In the previous posts in this series (part 1, part 2, part 3), I described how I […]