S3OLV August Recap
The SQL Server Society of Las Vegas meeting has come and gone once again. This meeting is held typically on...
2010-08-16
425 reads
SQL RNNR
TSQL Tuesday 009 Roundup
T-SQL Tuesday #009: Beach Time
I hope you enjoyed your time in the sun with your toes in the sand. We...
2010-08-13
789 reads
Defensive Db Programming Chapter 04
This week we will be checking out the fourth chapter of this book by Alex. This is a continuous effort...
2010-08-11
740 reads
R & R
It is once again time for the blog party known as TSQL Tuesday. I am hosting this month and wanted...
2010-08-10
604 reads
August SSSOLV Reminder
Just another reminder about the Las Vegas User Group meeting coming up on August 12th.
Here is the info:
The S3OLV UG...
2010-08-10
461 reads
August S3OLV UG Meeting
It is nearly UG meeting time once again. The S3OLV UG will be meeting Thursday August 12 at 6:00. Come...
2010-08-04
467 reads
TSQL Tuesday Coming Up
The next TSQL Tuesday is only 1 week away. This month the topic covers getting a little R&R. We would...
2010-08-03
437 reads
Defensive Db Programming Chapter 03
Chapter 3 of the Defensive Database Programming Book by Alex Kuznetsov teaches us about how to “survive” changes to database...
2010-07-26
1,641 reads
5 down 4 to go
Not much ado about SQL Server here. Good things come with the number 9. For instance SQL Server got substantially...
2010-07-23
515 reads
A little Dance with SSIS and Informix
Not too many moons ago I embarked on porting some servers over from SQL 2000 to SQL 2008. On some...
2010-07-23
1,535 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