SQL Server Patching within an Always On Environment
SQL Server Patching with the introduction and adoption of Always On has changed. The traditional method by waiting for Service...
2018-06-20
159 reads
Justin Figg
Removing a secondary replica database in Always On SQL Environment
Removing a database from an Always On availability group is pretty straight forward and can be accomplished by either ssms...
2018-06-19
117 reads
Blogs
Using SQLFluff
I thought I didn’t care about linting, and lately, I haven’t written a lot...
Marketing Analyst: The Data-Driven Superhero Your Company Needs
Want to blend your love of marketing with the power of data? Becoming a...
Can You See Table Valued Parameters in Extended Events?
I live for questions and this was an interesting one. Can you see Table...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
SQL Server Migration - Redirecting Old Instance Connections to New AG Listener
Hi everyone, I’ve been tasked with migrating a Standalone SQL Server instance to a...
How Can Programmatic Ads Benefit Insurance Businesses?
Programmatic advertising offers numerous advantages for insurance businesses advertising looking to enhance their marketing efforts efficiently....
Question of the Day
A Strange Choice
What is returned when I run this code in SQL Server 2022?
CREATE TABLE CatIndex
( indexval VARCHAR(20)
)
GO
INSERT dbo.CatIndex (indexval) VALUES ('1'), ('2'), ('3')
GO
SELECT CHOOSE(indexval, cast('2025-01-01' AS DATE), CAST('2025-02-01' AS DATE), CAST('2025-03-01' AS DATE))
FROM dbo.CatIndex AS ci See possible answers