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 […]
Archives du mois : juin 2024
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 […]
SQL Server : ménage de printemps
Trous de sécurité, ressources consommées inutilement : il est temps de faire le ménage de printemps… – Combien […]
[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 […]
Getting started with delivering generative AI capabilities in SQL Server ...
AI is transforming everything we do, including how we interact with data. Data is the fuel for AI. […]
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 […]
How to perform unattended uninstall for SQL Server Express
Recently, I received a question about unattended uninstall for SQL Server Express edition. This article describes how to perform this […]
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 […]
Announcing the Availability of adutil for RHEL 9 and Ubuntu ...
We’re thrilled to share that adutil, the Active Directory Utility for SQL Server, is now officially supported on RHEL 9 and Ubuntu […]
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 […]
Près de 20 % des Microsoft SQL Server en service ...
Près de 20 % des Microsoft SQL Server en service ont dépassé la fin de la période […]
Azure Arc enabled SQL Server – determine your Azure SQL ...
Azure Arc enabled SQL Server enables you to manage, secure and govern your SQL Server estate from Azure. […]
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 […]
Migration sql server from sql 2017 to sql 2022 with ...
Below is our suggestion for the migration activity: Always on High Availability DB Mirroring Logshipping SQL Always on […]
Cumulative Update #27 for SQL Server 2019 RTM
The 27th cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft […]
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 […]
SQL Server 2022 is EAL 2 Common Criteria certified!
In a previous blog post in 2023 we mentioned that two Common Criteria (CC) certifications of SQL Server […]
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. […]
Nettoyage des instances et bases de données SQL Server
Avec Frédéric Brouard, SQL Spot : https://www.linkedin.com/in/frederic-brouard-alias-sqlpro-914761 et Arian Papillon, Datafly, MVP : https://www.linkedin.com/in/arianpapillon/ – Combien de […]
Migration de base de données SQL vers le cloud – ...
Avec David Barbarin, Migros Online : https://www.linkedin.com/in/mikedavem/ Si vous envisagez de migrer votre plateforme de base de […]
Amélioration des performances par partitionnement
Cas Client: amélioration des performances et de la maintenance des tables volumétriques et fortement sollicitées Avec Clément […]
Azure Arc
Azure Arc étend les services Azure aux instances SQL Server hébergées en dehors d’Azure. Azure Arc vous […]
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 […]
Datafrogs juin 2024 : ménage de printemps
Pour cette session des Datafrogs, le 1er juin, le sujet de notre présentation était « Ménage de printemps ». Il […]
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 […]
Database mail and connection pool depletion
Database Mail (DBMail) in SQL Server is a feature that allows you to send emails directly from SQL […]
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 […]