ThrowAway Scripts
Although I tend to write a lot of formal scripts, as part of the development process I'll explore an object...
2009-08-12
541 reads
Blog Posts
Which version of SSIS-DTS Package Search is right for you
The download page for SSIS-DTS Package search presents three choices:
SSIS-DTS Package Search for SQL Server 2000 on Windows x86SSIS-DTS Package...
2009-08-12
1,464 reads
Writing Technical Content for PASS
We’ve just posted our core guidelines for technical content on sqlpass.org. The short story is there are three main ways...
2009-08-12
869 reads
Data Theft
Is employee data theft on the rise? I saw this blog post on the subject, but I had to take...
2009-08-11
789 reads
Does File Exist Check in SSIS
A very common need in SSIS is to check to see if a file exist before you run what could be...
2009-08-11
15,176 reads
Passed The 70-251 Microsoft Exam
I took the final, non-BI Microsoft SQL Server 2008 Certification Exam on Friday, so now I have finished all of...
2009-08-11
542 reads
Review: Motorola H710 Headset
Last week I posted about getting a new bluetooth speakerphone, so I thought I’d follow up with some notes about...
2009-08-11
513 reads
Security is a Zero-Sum Game...
but I don't mean with respect to privacy. But I do mean with respect to the time it takes securing...
2009-08-11
707 reads
Some Statement Start Times!
I thought I had captured statement start times within the DMV sys.dm_exec_sessions. I was absolutely wrong. However, this has sparked...
2009-08-11
951 reads
The Joy of Data Modelling.
You may think that the task of teasing out the exact nature
of the data and processes within a company...
2009-08-11
2,489 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers