[Video] Office Hours at Sea: SQL Server Q&A
En route from San Francisco to Juneau aboard the Ruby Princess, I stopped to hit a few of […]
Archives du mois : mai 2023
Database Sequence Objects with dbatools
dbatools bring us a set of useful commands to manage sequence objects in SQL Server. In this article, […]
Last Call for My 21st Anniversary Sale
I’m still blown away that I have a blog post here that says, “Last updated: 21 years ago.” […]
Install SQL Server using Powershell Desired State Configuration (DSC)
Introduction As per Microsoft, Desired State Configuration (DSC) is a management platform in PowerShell that enables you to […]
How Snowflake Creates and Detects Deadlocks
The post How Snowflake Creates and Detects Deadlocks appeared first on SQLServerCentral.
T-SQL Gap-Filling Challenge
A student of mine sent me a T-SQL challenge involving gap-filling of missing dates and balances. I […]
Flyway and SSDT: Extracting a DACPAC from a Flyway-managed Database
The post Flyway and SSDT: Extracting a DACPAC from a Flyway-managed Database appeared first on SQLServerCentral.
Unmasking SQL Server Dynamic Data Masking, Part 1, Intro
This is the beginning of a series on SQL Server Dynamic Data Masking. Dynamic Data Masking is […]
Breaking News: SQL Server 2022 Keeps Getting Worse.
<sigh> Okay, so, the last few Cumulative Updates have had known issues around broken remote queries using the […]
Unlock the Power of Google Cloud SQL: Setting Up SQL ...
Introduction to Google Cloud SQL Google Cloud SQL is a powerful and easy-to-use managed database service that lets […]
Microsoft Build Announcements for Data Professionals
This week was Microsoft Build. After four years, it was back in person in Seattle and available online. […]
Getting Started with Ensemble AI Models in SQL Server
The post Getting Started with Ensemble AI Models in SQL Server appeared first on SQLServerCentral.
A First Look at PostgreSQL Monitoring in SQL Monitor
The post A First Look at PostgreSQL Monitoring in SQL Monitor appeared first on SQLServerCentral.
Private preview announcement of native JSON type & JSON aggregates ...
Please head over to https://aka.ms/json-preview to learn more about the private preview of native JSON type and JSON […]
Announcing Azure Data Studio 1.44
It seems like just last week we were just releasing Azure Data Studio 1.43 (oh wait, that was […]
Who’s Hiring in the Microsoft Data Platform Community? May/June 2023 ...
Is your company hiring for a database position as of May/June 2023? Do you wanna work with the […]
SQL Saturday Haïti 2023, Bien maîtriser Azure Data Studio et ...
Après une première série de sessions lors du SQL Saturday Haïti 2022, j’ai eu un vrai plaisir […]
Azure Data Factory pour les nuls – SQL Saturday Haïti ...
Après une première série de sessions lors du SQL Saturday Haïti 2022, j’ai eu un vrai plaisir […]
SQL Saturday Haïti 2023, Azure Data Factory pour les nuls
Après une première série de sessions lors du SQL Saturday Haïti 2022, j’ai eu un vrai plaisir […]
Microsoft Fabric: Enabling your Free Trial
After the great announcement of Microsoft Fabric this week, it’s time to get a trial and start […]
Microsoft Fabric: Data Warehouse Ingestion using T-SQL and more
.In this blog I will illustrate how we can ingest data from a blog storage to a […]
Data Intelligence on light speed: Microsoft Fabric
This article is based on exciting information just released at Microsoft’s Build conference on May 23, 2023. […]
Using Azure Data Studio to Deploy a SQL Server VM ...
Introduction Sometimes we need to deploy many SQL Servers on Azure in the enterprise environment. Wwe can do […]
Self Review: Practical Graph Structures in SQL Server and Azure ...
I just finished writing this book a few weeks ago, and as I read it, I thought […]
Microsoft Build 2023 Keynote Live Blog: Introducing Fabric
Goooood morning, party people! Today is the opening day of the annual Microsoft Build conference, an event focused […]
[Video] Office Hours: Azure & SQL Server Q&A
Y’all post questions at https://pollgab.com/room/brento, and I go through the top-voted ones on my Twitch channel streams. […]
Optimizing MySQL: Adding Data to Tables
Welcome back to the MySQL optimization series! In case you haven’t been following this series, in the […]
How to Generate Images with AI and Store them in ...
Introduction In this article, we will learn how to generate images with AI. This time we will work […]
PostgreSQL 101: The 10 key differences between SQL Server & ...
The post PostgreSQL 101: The 10 key differences between SQL Server & PostgreSQL appeared first on SQLServerCentral.
Cache SQL Server Data in a .NET Web Application
The post Cache SQL Server Data in a .NET Web Application appeared first on SQLServerCentral.
Common Table Expression Basics
Introduction Firstly, we need to understand what is a common table expression. Common table expressions, also abbreviated as […]
The Journey to Team-based Development with Flyway
The post The Journey to Team-based Development with Flyway appeared first on SQLServerCentral.
REPLACE versus TRANSLATE for SQL Server Text Data Manipulation
The post REPLACE versus TRANSLATE for SQL Server Text Data Manipulation appeared first on SQLServerCentral.
PostgreSQL Basics: A Template for Managing Database Privileges
In the first two articles of this series about PostgreSQL privileges, we reviewed how to create roles, […]
[Video] Office Hours: Professional Development & Training Questions
A lot of today’s questions from https://pollgab.com/room/brento have a common theme, but it’s just a coincidence: Here’s what […]
[Video] Office Hours: 45 Minutes of SQL Server Q&A
It’s a long one, folks! I went through almost 30 of your questions from https://pollgab.com/room/brento to get your […]
Released: Latest Azure VM Marketplace images for SQL Server 2022, ...
Azure Marketplace is an online store that contains thousands of software applications and services built by industry-leading technology companies. […]
SLES 15 SP4 is now supported for SQL Server 2022 ...
We are pleased to announce the support for SQL Server 2022 on SUSE Enterprise Linux v15 SP4. This […]
SQL Server Agent fails to start on Windows Server 2022 ...
Problem A customer recently reported that they tried to build a SQL Server running on Windows Server […]
Demystifying Best Practices and Enhancing RDS security with Amazon GuardDuty
Introduction In today’s rapidly evolving digital landscape, organizations increasingly rely on cloud platforms like Amazon Web Services (AWS) […]
It’s Been 6 Months. SQL Server 2022 Still Isn’t Ready ...
Six months ago today, Microsoft announced that SQL Server 2022 was ready. Except it wasn’t. And it still […]
Changing log growth strategy in SQL Server 2022
When I first saw a bullet item stating SQL Server 2022 would support instant file initialization for […]
7 ways businesses can improve the quality and speed of ...
The post 7 ways businesses can improve the quality and speed of database releases appeared first on SQLServerCentral.
How to Improve Database Design to Speed Up SQL Queries
Mistakes in database design can spell long-term issues that jeopardize efficiency and effectiveness. For online transaction processing (OLTP), […]
Star Schema vs Snowflake Schema Considerations
The post Star Schema vs Snowflake Schema Considerations appeared first on SQLServerCentral.
Modélisation : viol de la première forme normale par « apocope »
La modélisation des bases de données repose sur une théorie mathématique dont le but est de minimiser les […]
Red Hat Enterprise Linux 9.2
Red Hat vient d’annoncer la disponibilité générale de Red Hat Enterprise 9.2. Avec cette mouture Red Hat […]
Azure Storage Blob – Cold tier
Noyé dans un flux de news, j’ai failli passer à côté de celle-ci : un nouveau tier de stockage […]
Understanding how to Successfully Sell the Cloud
The post Understanding how to Successfully Sell the Cloud appeared first on SQLServerCentral.
How to Find the SQL Server Instance Startup Time
This article explains the different methods to find the startup time of an SQL Server. We can use […]