Defensive Db Programming Chapter 02
This is the review of the second chapter of the book Defensive Database Programming. The title of this chapter is...
2010-07-15
1,818 reads
SQL RNNR
Gettin’ Skewled
Observe and Report
This month we get to frolic in our memories of school days. Thanks to HeadMaster Robert Davis (Blog...
2010-07-13
784 reads
TSQL 2sday Coming Up
TSQL Tuesday is fast upon us once again. In fact, in my time zone, it is just a day away.
This...
2010-07-12
574 reads
S3OLV July Recap
This month we had our first adventure in LiveMeeting presentations. We had the pleasure of listening to Jack Corbett give...
2010-07-12
426 reads
July SSSOLV UG Meeting
This is really late notice – apologies in advance.
We will be holding the LV UG meeting July 8th at the same...
2010-07-07
560 reads
SQL 2008 DTS
It’s a Bird…
No, not really. It’s just Windows 7. I have recently upgraded to Windows 7. I took the roundabout...
2010-07-07
3,412 reads
Q2 Goal Review
As we close out the Second Quarter of 2010 it is time to review progress made on the Goals I...
2010-07-06
517 reads
Who2 Article Published
I just had my second article published on June 14, 2010 at SQLServerCentral. I will be posting a follow-up to...
2010-06-22
986 reads
Declare Scalar Variable
Lately I have been going through a bunch of maintenance style scripts and fixing them. Along with fixing them, I...
2010-06-22
774 reads
24 HOP Available
Just a quick note. PASS has made the 24 Hours of PASS available via streaming video. You can check it...
2010-06-16
464 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...
Lower Your Attack Surface Area
Comments posted to this topic are about the item Lower Your Attack Surface Area
Understanding SQL Server LEFT_SHIFT and RIGHT_SHIFT Functions
Comments posted to this topic are about the item Understanding SQL Server LEFT_SHIFT and...
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 ciSee possible answers