Raw Materials - The Low Bid
When a job is too simple to be done in-house, how far down the phylogenetic tree should you go?
10 Good Things About Reporting Services 2008 R2
The 10 things Microsoft got right about SQL Server Reporting Services 2008 R2 (a sister article shows 10 things which aren't quite so good)
Labor Day 2011
It's a holiday in the US today and Steve Jones provides a little entertainment for those people still at work.
Piracy and Agile
Do Agile IT projects have anything to learn from the organizational structures and laws used by pirates? Phil Factor is not convinced.
TSQL Challenge 64 - A Payroll calculation Challenge
This challenge invites you to solve a payroll challenge which requires special calculation of holidays and absences that are adjacent to holidays
Using a SQL Server Alias for SSIS Package Configuration Database Connection String
In this tip we will walk through setting up the SQL Server Alias and using it with SQL Server package configuration in an SSIS package.
The Growth of Data Types
This week Steve Jones asks you what you think will make up the majority of your future databases? Will it be numerical data or will some other type come to dominate?
Configure SQL Server Database Mirroring Using SSMS
This tip outlines a test environment and then walks through the process of setting up Database Mirroring. This includes the configurations, backups, restores and verification process.
Recovery Models
Learn the basics of recovery models in this short article from SQL Server guru and MVP, Gail Shaw.
Blogs
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...
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
Forums
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:...
Spring Connections and Learning at PASS On Tour
Comments posted to this topic are about the item Spring Connections and Learning at...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers