Scales & Measurements
The post Scales & Measurements appeared first on SQLServerCentral.
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.
Overview Searching for relevant information in vast repositories of unstructured text can be a challenge. This article demonstrates […]
The post Fun with PowerShell Asynchronous appeared first on SQLServerCentral.
The post Using Group Managed Service Accounts with SQL Server appeared first on SQLServerCentral.
The SQL endpoint of the Fabric Data Warehouse allows programs to read from and write to tables. The […]
Introduction This article teaches how to use the Azure Data Studio extension to handle SQL Database projects. It […]
Introduction SQL Server provides robust tools for data type conversion, such as PARSE, TRY_PARSE, and TRY_CONVERT. These functions […]
The post How to use @@ROWCOUNT in SQL Server appeared first on SQLServerCentral.
Introduction Azure Synapse Analytics, previously known as Azure SQL Data Warehouse, is a widely utilized platform for storing […]
The post SSMS Export to Excel appeared first on SQLServerCentral.
Introduction JSON (JavaScript Object Notation) has become a popular data format for storing and exchanging information. Microsoft SQL […]
The post How to rename a SQL Server database appeared first on SQLServerCentral.
A common requirement for database professionals working with SQL Server is the capability to connect seamlessly to other […]
The post A Practical Guide to Using Azure Key Vault in Enterprise Deployments appeared first on SQLServerCentral.
The post Add and Subtract Dates using DATEADD in SQL Server appeared first on SQLServerCentral.
Introduction Attaching databases in SQL Server can be a routine yet sometimes time-consuming task for Database Administrators (DBAs). […]
Project Context and Data Presentation Challenges In our projects we have seen, data quality issues manifest in various […]
The post Navigating the Database Landscape in 2025 Livestream on Feb 12 appeared first on SQLServerCentral.