SQL STRING_AGG Function Use and Examples
The post SQL STRING_AGG Function Use and Examples appeared first on SQLServerCentral.
New Objects in SQL Server 2025 – And Thousands of New Undocumented Feature Flags!
The first public preview of SQL Server 2025 dropped yesterday, and here’s what’s new under the hood as compared to today’s SQL Server 2022 CU19. Forgive me – this is quite a lengthy post, and it’s mostly a data dump. There are new stored procedures, ex …
How to Migrate Data to a New SQL Server Database
This guide demonstrates how to efficiently migrate existing data, including data from SQLite, into a SQL Server database.
SQL Server 2022 on Ubuntu 24.04 step by step
Microsoft does not yet support this edition of Ubuntu, but there are some workarounds to make it work. This should not be used for production usage and this blog is for educational/testing purposes only. For my installation, I am using an AWS EC2 Ubunt …
First LLM Technical Editor Test – Office and Web-based Copilot with a VERY wrong article
Next up, I am going to give Microsoft Copilot its chance to check for technical inaccuracies in my obviously very wrong articles. This article is going to build upon the last two (You can see the series here.), and as I continue this series, I am going …
Fabric Is Just Plain Unreliable, and Microsoft’s Hiding It.
Last week, Microsoft Fabric went down yet again for hours on multiple continents. Oh, you didn’t hear about it? Let’s talk about why. First, Fabric’s status page is fabricated bullshit. The link https://aka.ms/fabricsupport takes you to a localized sta …
Helpful Management Studio Settings and Features
Working with SSMS can sometimes be quite frustrating, but there are many options provided to make your day easier. The default configuration works fine for most people and many do not explore the various configuration or functionality settings that Mic …
Securing the DevOps Pipeline Part 2: Hardening Kubernetes and Cloud Security
The post Securing the DevOps Pipeline Part 2: Hardening Kubernetes and Cloud Security appeared first on SQLServerCentral.
What are the Key DevOps Performance Metrics You Should Track?
Successful DevOps teams rely on data-driven decision-making to continuously improve software delivery and operational performance. Understanding the right DevOps performance metrics is crucial for identifying bottlenecks, improving efficiency, and main …
How to Safely Remove a SQL Server Data File Without Downtime
Introduction Removing SQL Server Data File Without Downtime is one of important activities in enterprise production scenarios. Managing storage efficiently in SQL Server is crucial, especially when dealing with multiple data files (.ndf) on different …
SQL ASCII Function Use and Examples
The post SQL ASCII Function Use and Examples appeared first on SQLServerCentral.
[Video] Office Hours at the Hoover Dam
Dam! I took your top-voted questions from https://pollgab.com/room/brento without making any dam or beaver puns. Rather proud of myself for that one. Here’s what we covered: 00:00 Start 02:20 The Princess and the Frag: On SQL Server 2019 or later, are …
MySQL Shell Basic Configuration Management (Part 4 – Optimizing MySQL Performance)
Welcome back to our journey of understanding MySQL performance tuning using MySQL Shell. So far, we’ve covered essential topics like configuring MySQL, optimizing memory and CPU usage, and enhancing disk I/O performance. These are important building bl …
Predicting When SQL Server Will Hit the CPU Wall
Most of the time, we use wait stats to identify SQL Server’s bottleneck and focus on what to tune. However, let’s say you’ve got a really well-tuned SQL Server where: Queries finish in milliseconds (think 5-20 milliseconds, super quick) Everything your …
Introduction to PostgreSQL for the Data Professional
Learning something new has elements of bliss and terror. We all know the bliss of learning something new. The first time you figure out how to do something is a magical feeling that one never tends to lose. Stuck in the back of your mind is the first t …