Speaking at the Houston Techfest
I am heading down to Houston, TX to speak at the Houston Techfest this weekend. Being a Houston native makes...
2010-10-07
402 reads
Blog Posts
SQLSaturday Advice - Scheduling
One of the things that I’ve seen cause a few headaches at SQL Saturday events is the scheduling. First, before...
2010-10-07
496 reads
SSRS axe work: How to use fields from different Datasets in the same field Expression and Grouping in Report Builder 2.0?
Last week I was puzzled by one of my colleagues - he needed help in creating a Report Builder 2.0 SSRS...
2010-10-07
6,770 reads
Today I Blog About Certifications (Instead of Studying)
I'm not in it for the money...exclusively...
I was talking to the older kids about homework yesterday, and I mentioned that...
2010-10-07
709 reads
5-Weeks to PASS Summit 2010 Countdown
With 5-weeks until the PASS Summit it’s time to start getting ready for the event. As I’ve discussed a couple...
2010-10-06
731 reads
A Surprising Result from Ident_Current
If you haven’t used it (and I rarely do myself), Ident_Current (‘tablename’) returns the last identity value generated across all...
2010-10-06
964 reads
An Organizer's Recap of SQL Saturday #48 - Columbia, SC
This past Saturday, October 2nd, we hosted Columbia, SC's first ever SQL Saturday. By the feedback we've received, both during...
2010-10-06
814 reads
Closing Fast – SQLSaturday #49 – Orlando
Well, the event is closing in fast, less than 2 weeks away! We have over 300 registered, a great schedule,...
2010-10-06
545 reads
Connection Strings: Database Mirroring Failover Partner Setup & Sample Backup/Restore Preparation Script
After having setup my first SQL 2008 R2 Enterprise (build level 10.50.1702) database mirror as High Safety with automatic failover,...
2010-10-06
6,245 reads
Determine if Directory Exists using xp_cmdshell
Recently, I came across a forum post from a user trying to determine if a directory existed in the file...
2010-10-06
14,312 reads
Blogs
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Questions and Answers from Running a Local LLM
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
Overview of Claude AI Models: Which One to Choose?
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
Forums
A question about how to store the address in the database
I have an app that has an address field on the customer and the...
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers