The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and ...
Introduction In our TB-scale production system, a few queries had MAXDOP 4 hardcoded into them. The goal was […]
sqlservercentral.com
How to Choose the Right Tool for MS SQL to ...
This whitepaper serves as an in-depth guide for database administrators (DBAs), software engineers, data architects, and even semi-technical […]
Inside the Walls of Azure SQL MI
Welcome to the prologue article for a three-part series where I try to infiltrate the OS layer of […]
How to process images and analyze charts with AI
In this article, we will see how to handle images with AI. Sometimes we need to import the […]
Dimensional Modeling Case Study Part 3 – Dynamic Days Dimension
Background In this case study series, we’ve explored how to use age and tally tables to support various […]
Azure SQL Performance Tuning: Mastering Indexes, Partitioning, and Clustered Columnstore
Performance tuning in Azure SQL Database can feel like solving a puzzle—get it right, and your queries fly; […]
SQL Automate – A DBA’s Time-Saving Toolkit
Introduction Installing SQL Server can be a very boring and time consuming task, especially when you have to […]
Index Scans and Table Scans
The post Index Scans and Table Scans appeared first on SQLServerCentral.
Managing Fabric Lakehouse objects with the new CLI: Data Engineering ...
Microsoft Fabric has been evolving since its general availability in November 2023. Developers have asked for a command […]
DMV Comparison for SQL Server 2019 vs Azure SQL Database
The post DMV Comparison for SQL Server 2019 vs Azure SQL Database appeared first on SQLServerCentral.
Parameterize Connections in Microsoft Fabric Data Factory using Variable Libraries
When you create a data pipeline in Microsoft Fabric, you typically use one or more connections. A connection […]
Power BI Mistakes to Avoid – Part 2
The post Power BI Mistakes to Avoid – Part 2 appeared first on SQLServerCentral.
Sentiment Analysis & Key Phrase Detection
Recently I worked on a neat little POC with Patrick Leblanc for a customer in Education who wished to […]
Top 5 Power BI Common Pitfalls
The post Top 5 Power BI Common Pitfalls appeared first on SQLServerCentral.
Introduction to GitHub Actions Part 2: GitHub-hosted runners
The post Introduction to GitHub Actions Part 2: GitHub-hosted runners appeared first on SQLServerCentral.
SQL STRING_AGG Function Use and Examples
The post SQL STRING_AGG Function Use and Examples appeared first on SQLServerCentral.
Helpful Management Studio Settings and Features
Working with SSMS can sometimes be quite frustrating, but there are many options provided to make your day […]
Securing the DevOps Pipeline Part 2: Hardening Kubernetes and Cloud ...
The post Securing the DevOps Pipeline Part 2: Hardening Kubernetes and Cloud Security appeared first on SQLServerCentral.
How to Safely Remove a SQL Server Data File Without ...
Introduction Removing SQL Server Data File Without Downtime is one of important activities in enterprise production scenarios. Managing […]
SQL ASCII Function Use and Examples
The post SQL ASCII Function Use and Examples appeared first on SQLServerCentral.
Evaluating the Randomness of SQL Server Random Number Functions
The post Evaluating the Randomness of SQL Server Random Number Functions appeared first on SQLServerCentral.
Date and Time Calculations Made Easy with EOMONTH, DATEDIFF, and ...
Working with dates in SQL Server is something almost every developer runs into. You might need to figure […]
SQL Server Cursor Example
The post SQL Server Cursor Example appeared first on SQLServerCentral.
Understanding MERGE to Insert, Update, and Delete Data Simultaneously
Introduction In modern database management, data synchronization plays a critical role in processes like data warehousing and ETL […]
Return stored procedure parameter values to a calling stored procedure
The post Return stored procedure parameter values to a calling stored procedure appeared first on SQLServerCentral.
Modern Streaming Architecture Serverless Pool with Spark Streaming
Introduction Many high-volume data sources, including sensors, logs from mobile applications, and the Internet of Things, operate in […]
Meta AI by Facebook: A New Contender in the AI ...
Introduction Meta AI from Facebook is one of the last big technology giants’ contenders in the AI battle. […]
Using try catch in SQL Server stored procedures
The post Using try catch in SQL Server stored procedures appeared first on SQLServerCentral.
Retrieving Data Using the REST API in Data API Builder
I wrote a piece on getting started with the Data API Builder (DAB), which looked at how this […]
Using the CASE expression instead of dynamic SQL in SQL ...
The post Using the CASE expression instead of dynamic SQL in SQL Server appeared first on SQLServerCentral.
Understanding CROSS APPLY and OUTER APPLY in SQL Server
Introduction When working with table-valued functions (TVFs) or subqueries, the CROSS APPLY and OUTER APPLY operators provide flexible […]
Using the Default Trace in SQL Server
The post Using the Default Trace in SQL Server appeared first on SQLServerCentral.
The Subtle Differences Between COALESCE and ISNULL
If you’ve written SQL for a while, you’ve likely bumped into COALESCE and ISNULL. Both are handy for […]
The Fabric Modern Data Platform
This is a short series on the Modern Data Platform in Microsoft Fabric. The articles in this series […]
Securing the DevOps Pipeline Part 1: Tools and Strategies for ...
The post Securing the DevOps Pipeline Part 1: Tools and Strategies for Safer Deployments appeared first on SQLServerCentral.
Metadata Driven Pipelines (Full Load): The Fabric Modern Data Platform
To solve a complex business problem, one needs to break the process into smaller solvable steps. Today, we […]
How to Remove Constraints from a SQL Server Table
The post How to Remove Constraints from a SQL Server Table appeared first on SQLServerCentral.
Creating a Date Dimension (Calendar Table) in SQL Server
Introduction A calendar or date dimension table is essential for data analysis and reporting. It allows users to […]
The complexity of using Power BI in US Sovereign Clouds
The post The complexity of using Power BI in US Sovereign Clouds appeared first on SQLServerCentral.
Elements of the SQL Server Update Statement
Introduction This article explores a very common construct in standard SQL and Transact-SQL – the SQL Server Update […]
Killing a SPID and Checking Rollback progress in SQL Server
The post Killing a SPID and Checking Rollback progress in SQL Server appeared first on SQLServerCentral.
Navigating Your Test Data Challenges: Insights and Solutions
The post Navigating Your Test Data Challenges: Insights and Solutions appeared first on SQLServerCentral.
Introduction to GitHub Actions Part 1: Getting Started
The post Introduction to GitHub Actions Part 1: Getting Started appeared first on SQLServerCentral.
Understanding UNION and UNION ALL in SQL Server
Have you ever needed to combine data from two different tables or queries in SQL Server? Maybe you’ve […]
DAX CASE Statement Functionality using IF, SWITCH and SWITCH True
The post DAX CASE Statement Functionality using IF, SWITCH and SWITCH True appeared first on SQLServerCentral.
Windows Clustered MSDTC and SQL Server 2019 mishap
Introduction As you may know, in the early days of SQL Server Clustering, Microsoft advised to provide each […]
Scales & Measurements
The post Scales & Measurements appeared first on SQLServerCentral.
Create Raw Zone Tables using Generative AI: Data Engineering with ...
Microsoft has been talking about the Modern Data Platform for a long time. I first heard about this […]
DeepSeek: What is new with this AI technology?
Introduction I was happily resting in Samaipata, a pre-Inca temple admiring the ruins with our guide when a […]
Basic Regex Emulator for SQL Server
The post Basic Regex Emulator for SQL Server appeared first on SQLServerCentral.