Identity Columns
When Nigel Rivett takes us on a tour of the apparently innocuous subject of Identity Columns in TSQL, even the seasoned programmer is due for one or two surprises.
Software Comparison - Part 2
The second editorial from Steve Jones comparing software to other types of jobs continues with a look at the legal profession.
Sync All Logins on a Server in a single click using SP_MSForEachDB
Reduce your recovery time and minimize the chance for error by resolving all logins in one script.
Intelligence on the Go: Mobile Delivery of BI
Many BI vendors now offer modules that let you deliver just about any report to smart phones, but as a major retailer, a health care provider and a major government agency have discovered, practical, tactical wins are the key to mobile success.
The Software Comparison - Part 3
Steve Jones takes another attempt at comparing software development to another profession. Today's target: doctors.
The Software Comparison - Part 3
Steve Jones takes another attempt at comparing software development to another profession. Today's target: doctors.
The Software Comparison - Part 3
Steve Jones takes another attempt at comparing software development to another profession. Today's target: doctors.
Tips for moving from local disk storage to SANs
Move SQL Server storage to storage area networks (SANs) with network redundancy and storage multipathing tips. Learn about iSCSI databases and SQL failover.
Database Weekly - June 2, 2008
A look back at the news from the week including Windows 7 and taking an unwired vacation.
Job Specialization - Boon or Bane?
As the number of different software/technologies increases exponentially, does specializing limit an IT professional's ability to move around? This editorial is being republished due to technical issues from last week.
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
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