Physical Servers What are They?
Today I'm in the process of installing some physical servers. To put this into perspective due to the companies I...
2011-11-09
507 reads
SQL Server 365
CONVERT Dates and Confusion
Right I've been itching to post another Blog and actually contribute something this time. This isn't something I've learned but something I've taught many...
2011-11-08
786 reads
My First Blog Post!
So here it is then, my first ever Blog post!
I'm not cheating here as I am not officially starting to...
2011-11-07
572 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