SQL Server Security Model
Greg Larsen discusses the different options available within SQL Server 2005 for managing security.
Becoming A DBA, Part 2
Buck Woody discusses the hard-earned knowledge and experience that you'll need to gain in order to stand out as a and professional and exceptional DBA.
Building a Better Career
It's important that you manage your career and not just leave it to chance. Steve Jones talks about what you might do to ensure that you'll be successful in the IT world.
The Dynamic Process of Loading Data
When loading a data warehouse, handling the ETL process of working with files can be problematic. Longtime DBA Janet Wong brings us an interesting solution that is flexible and efficient for quickly loading a number of files into a warehouse using DTS.
The Weekly Update for Dec 31, 2007
Interviewing, Google as a monopoly, Cumulative Update 5 and more.
Add Custom Data Mining Algorithms to SQL Server 2005
Get a high-level overview of the benefits of the extensibility framework in SQL Server 2005 Analysis Services that allows independent software developers to easily integrate new data mining algorithms into the product.
A Christmas Time Saving Contest for DBAs
We've got a new contest running for the next week just for your production DBAs. Win a prize just for telling us a story.
Row-By-Row Processing Without Cursor
If you are a SQL Server DBA, you realize that the performance of cursors is not great and they should be avoided where possible. One place it is difficult to avoid cursors is individual row processing within a trigger. Amin Sobati brings us a new article that shows just how you can avoid this.
Table Defaults
In working on an existing database, DBAs often look to normalize tables and correct obvious flaws in design. Recently Andy Warren was working on a consulting project and realized that defaults would prevent many issues.
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