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.
The post Using the CASE expression instead of dynamic SQL in SQL Server appeared first on SQLServerCentral.
Introduction When working with table-valued functions (TVFs) or subqueries, the CROSS APPLY and OUTER APPLY operators provide flexible […]
The post Using the Default Trace in SQL Server appeared first on SQLServerCentral.
If you’ve written SQL for a while, you’ve likely bumped into COALESCE and ISNULL. Both are handy for […]
This is a short series on the Modern Data Platform in Microsoft Fabric. The articles in this series […]
The post Securing the DevOps Pipeline Part 1: Tools and Strategies for Safer Deployments appeared first on SQLServerCentral.
To solve a complex business problem, one needs to break the process into smaller solvable steps. Today, we […]
The post How to Remove Constraints from a SQL Server Table appeared first on SQLServerCentral.
Introduction A calendar or date dimension table is essential for data analysis and reporting. It allows users to […]
The post The complexity of using Power BI in US Sovereign Clouds appeared first on SQLServerCentral.
Introduction This article explores a very common construct in standard SQL and Transact-SQL – the SQL Server Update […]
The post Killing a SPID and Checking Rollback progress in SQL Server appeared first on SQLServerCentral.
The post Navigating Your Test Data Challenges: Insights and Solutions appeared first on SQLServerCentral.
The post Introduction to GitHub Actions Part 1: Getting Started appeared first on SQLServerCentral.
Have you ever needed to combine data from two different tables or queries in SQL Server? Maybe you’ve […]
The post DAX CASE Statement Functionality using IF, SWITCH and SWITCH True appeared first on SQLServerCentral.
Introduction As you may know, in the early days of SQL Server Clustering, Microsoft advised to provide each […]
The post Scales & Measurements appeared first on SQLServerCentral.
Microsoft has been talking about the Modern Data Platform for a long time. I first heard about this […]
Introduction I was happily resting in Samaipata, a pre-Inca temple admiring the ruins with our guide when a […]
The post Basic Regex Emulator for SQL Server appeared first on SQLServerCentral.
In February 2025, Microsoft introduced new T-SQL functions in Azure SQL Database and SQL Database in Microsoft Fabric […]
Introduction Performing bulk updates in SQL Server can be a resource-intensive operation, particularly when dealing with large datasets. […]
The post SQL Server JSON Functions JSON_OBJECTAGG and JSON_ARRAYAGG appeared first on SQLServerCentral.
When working with SQL Server, there are times when you need to build SQL scripts dynamically. In many […]
Summary In a landscape abundant with AI innovations and promises, a crucial question arises: « Is leveraging SQL and […]
Introduction SQL Server 2022 introduced the LEFT_SHIFT and RIGHT_SHIFT functions, which allow you to manipulate numbers by shifting […]
The post AI Tools for Job Seekers – Salary appeared first on SQLServerCentral.
Because it’s important to know when adversaries are scanning the network searching for vulnerabilities, misconfigurations, unpatched systems or […]
There comes a time when the built-in ORM just isn’t enough. You might have complex queries or performance-critical […]
The post Data Streaming Databricks in Azure appeared first on SQLServerCentral.
Overview Amazon RDS allows users to create multiple databases within a single database instance. And connections to each […]
Deploying a DACPAC to an Azure SQL Database is a critical step in ensuring your database changes are […]
The post INFO.VIEW DAX Functions Usage and Examples appeared first on SQLServerCentral.
The post The State of the Database Landscape in 2025: Insights and trends appeared first on SQLServerCentral.
Introduction AdventureWorks is a sample database from Microsoft that simulates a company called Adventure Works Cycles. It is […]
Introduction In SQL Server 2022, developers often need to implement conditional logic within their queries. Whether it’s selecting […]
The post The Power of Generate_series appeared first on SQLServerCentral.
Geographic information systems (GIS) play a critical role in emergency response planning and risk assessment. One of the […]
Introduction AdventureWorks is a sample database from Microsoft that simulates a company called Adventure Works Cycles. It is […]
The post SQL Server Backup or Restore using Network Share with SSMS appeared first on SQLServerCentral.
Did you know that Edgar F. Codd is considered the father of the relational model that is used […]
The post Engineering a Lakehouse with Azure Databricks with Spark Dataframes appeared first on SQLServerCentral.
Introduction Sometimes, we need to test our apps in Azure and we do not have time to connect […]
The post Upgrade and Migrate SSIS Catalog and SSISDB to a New Server appeared first on SQLServerCentral.
In this article, we are going to configure a maintenance place on the SQL Server 2017 instance installed […]
The post Index Rebuilds Make Even Less Sense with ADR & RCSI appeared first on SQLServerCentral.
Introduction In this article, we will learn how to restore a database which is stuck in the Recovery […]
Introduction SQL Server 2022 introduces powerful bit manipulation functions that allow for efficient handling of binary data. These […]
The post Find Text in Stored Procedure, Function, View, or Trigger appeared first on SQLServerCentral.