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
611 reads
Jason Brimhall
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
475 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
441 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,650 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
519 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,561 reads
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,822 reads
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
789 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
428 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
578 reads
Blogs
T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
Keeping MS Docs Up to Date
By Steve Jones
One of the things that I like about the SQL Server docs (MS Learn...
Patch Tuesday – Where to get more information
By Brian Kelley
For a number of years I have subscribed to Randy Franklin Smith's Patch Tuesday...
Forums
Change Tracking – Troubleshooting
I have change tracking configured in several databases, in QA and production environments, and...
is there a no code way to limit an ssis extract from excel to the 1st 21 rows?
is there a no code way to limit an ssis extract from excel to...
Pivot but preserve all rows on Aggregate column
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers