PASS Cloud Virtual Group – Call for Speakers
The cloud is calling to you. Or more specifically, Jody Roberts (b | @) and I (b | @) are looking to the community...
2017-04-07
933 reads
StrateSQL
PASS Cloud Virtual Group – Call for Speakers
The cloud is calling to you. Or more specifically, Jody Roberts (b | @) and I (b | @) are looking to the community to find some presenters interested in...
2017-04-07
2 reads
Not Quite Monday Morning SQL Break – February 7, 2017
It’s Tuesday and time to get Monday’s weekly blog and twitter round-up for last week out the door. It’s late...
2017-02-07
970 reads
Not Quite Monday Morning SQL Break – February 7, 2017
It’s Tuesday and time to get Monday’s weekly blog and twitter round-up for last week out the door. It’s late and I need to find a better way to...
2017-02-07
11 reads
Monday Morning SQL Break – January 16, 2017
It’s Monday and time, finally, for a weekly blog and twitter round-up for last week. It’s been a while since...
2017-01-16
756 reads
Monday Morning SQL Break – January 16, 2017
It’s Monday and time, finally, for a weekly blog and twitter round-up for last week. It’s been a while since I’ve published this summary post, but hey that’s what life...
2017-01-16
3 reads
Monday Morning SQL Break – November 7, 2016
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on...
2016-11-07
782 reads
Monday Morning SQL Break – November 7, 2016
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch...
2016-11-07
8 reads
Yup, @StrateSQL’s Running for the PASS Board of Directors
Why I’m Running
Over the past few years, I’ve been considering running for the PASS Board of Directors and this year appears...
2016-10-05
879 reads
Yup, @StrateSQL’s Running for the PASS Board of Directors
Why I’m Running Over the past few years, I’ve been considering running for the PASS Board of Directors and this year appears to be the right year to do this....
2016-10-05
5 reads
Blogs
DATEADD Truncates the Number Parameter: #SQLNewBlogger
By Steve Jones
This was an interesting thing I saw in a Question of the Day submission....
Our SQL Server is Slow! What Do I Do First?
By Kevin3NF
Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before...
Using SQLFluff
I thought I didn’t care about linting, and lately, I haven’t written a lot...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Eliminate a function by writing out the code is now throwing an error
/* I'm trying to eliminate (write out) this function 'largest_date', but SQL Server 2016...
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...
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