The SQL Language is Just a Hurdle You Gotta Overcome.
I’m not talking just about Microsoft SQL Server specifically here, nor T-SQL. Let’s zoom out a little and […]
I’m not talking just about Microsoft SQL Server specifically here, nor T-SQL. Let’s zoom out a little and […]
Microsoft Azure offers the Azure Elastic Job agent as a managed service, enabling efficient scheduling of T-SQL workloads […]
The post Finding Sister Locations to Help Each Other: Answers & Discussion appeared first on SQLServerCentral.
For this month’s T-SQL Tuesday, Pinal Dave asked us if AI has helped us with our SQL Server […]
A couple of days ago I was doing some cleaning on some Azure SQL DBs and shrinking some […]
A common question that arises in SQL Server collation discussions is whether a binary collation (BIN2) is functionally […]
I didn’t say that – Guy Glantser did. Guy Glantser is an Israeli SQL Server guru with a […]
For this month’s T-SQL Tuesday, I asked y’all to write about the most recent ticket or issue that […]
Introduction In this article, we will see how to work with GitHub Copilot. GitHub copilot is an interesting […]
Introduction Table variables are special types of local variables that can be used to store data temporarily, similar […]
Provisioning infrastructure in a timely and reliable manner is essential for agile development. One well-liked method that lets […]
The post Gracefully Handle Errors using TRY CATCH Logic in SQL Server Stored Procedures appeared first on SQLServerCentral.
Introduction This article celebrates a classic algorithm [1] of Dijkstra (1930 – 2002) which finds a path of […]
When encrypting a database column, equality searching can be preserved by using a deterministic encryption algorithm. A deterministic […]
The post SQL GROUP BY Alias – An Oracle feature that would be great in SQL Server appeared […]
In the realm of data analysis, being able to understand the relationships between sequential data points is paramount. […]
One of the things that I’ve done over the last year to improve my T-SQL skills is learn […]
The post Time Series Data Mining Example with T-SQL when Adding New Data appeared first on SQLServerCentral.
Single row tables in data modeling Single row tables are a fact of our life as as a […]
The post Unpivoting Multiple Sets of Columns in SQL Server using CROSS APPLY appeared first on SQLServerCentral.
Recently someone posted a question where they couldn’t quite figure out how to construct a predicate based […]
Introduction Efficiently migrating tables to a new schema in T-SQL is a common task for database administrators and […]
I’ve quietly resolved performance issues by re-writing slow queries to avoid DISTINCT. Often, the DISTINCT is there […]
The post Alternatives To SQL Server 2022 Built-in function GREATEST appeared first on SQLServerCentral.
First, SQL Server 2022 has many interesting new features for both DBAs and database developers. GENERATE_SERIES is one […]
tl;dr The title says it all. Prologue One of the keys to my personal learning is that, very […]
The post Different Ways to Format Currency Output in SQL appeared first on SQLServerCentral.
At Stack Overflow, our environment has multiple implementations of a largely – but not 100% – identical […]
The post Sample Use Case for Using SQLCMD Utility Batch Files appeared first on SQLServerCentral.
The first time I saw FOR XML PATH being used to generate a comma-delimited list, I think I […]
Task: Update a table with the most current value of a detail table. In this article I’m using […]
The post Starter Metadata T-SQL Query Examples for Databases and Tables appeared first on SQLServerCentral.
Introduction The sp_HorizontalTree procedure introduced here may be used to audit tables with dependent columns. A column is dependent […]
Introduction Firstly, we need to understand what is a common table expression. Common table expressions, also abbreviated as […]
The post REPLACE versus TRANSLATE for SQL Server Text Data Manipulation appeared first on SQLServerCentral.
The need for performance tuning your SQL Server workloads has never been more critical. As workloads are moved […]
The post DAX CASE Statement Functionality with IF, SWITCH and SWITCH True appeared first on SQLServerCentral.
Problem Statement You have a need to extract data from a table or view with 1 or more […]
Introduction ChatGPT in SQL Server In this article, we will learn some basic examples of ChatGPT in SQL […]
To find out, let’s set up a simple status log table: DROP TABLE IF EXISTS dbo.StatusLog; CREATE TABLE […]
Aaron Bertrand posted a challenge: We’re going to use the AdventureWorks sample database (get your copy here), where […]
Writing new code = bugging. That part’s easy. Taking those bugs back out, that’s the hard part. Developers […]
When someone says, “Find all the rows that have been deleted,” it’s a lot easier when the table […]
SQL Server 2022 improved the STRING_SPLIT function so that it can now return lists that are guaranteed to […]
SQL Server 2022 introduced a new T-SQL element, DATETRUNC, that truncates parts of dates. For example: SELECT DATETRUNC(year, […]
In this article, I will explore one of the SQL Server mathematical functions, ROUND. The T-SQL ROUND() function […]
I was helping a client with a query, and I’m going to rework the example to use the […]
SQL Server is a resource-intensive database system that requires adequate CPU and memory capacity to run transactions with […]
The post SQL Cheat Sheet for Basic T-SQL Commands appeared first on SQLServerCentral.
You can master engineering for your SQL Server databases, on premises or in the cloud, with a FREE […]