Ship Safe...Ship Often
How can we ship safe, and ship often? Steve Jones has a few comments on the need for better engineering.
Using SQL Server's GROUP BY clause to Summarize your Data
SQL Server’s GROUP BY clause provides you a way to aggregate your SQL Server data and to group data on a single column, multiple columns, or even expressions. Greg Larsen discusses how to use the GROUP by clause to summarize your data.
SQL Bits and Community Superheroes
Chris Testa-O'Neil on the origins of SQL Bits and the joys of community events.
The Quickest Guide to Getting Started with PowerPivot
If you are still on the edge about PowerPivot and have not given it a shot, this article will get you started with ample of screen shots and a step-by-step guide.
Questions About T-SQL Control-of-Flow Language You Were Too Shy to Ask
Surely, we all know how T-SQL Control-of-flow language works? In fact it is surprisingly easy to get caught out. What, for example, do the BREAK, RETURN and CONTINUE keywords do in their various contexts? Robert Sheldon has the answers to this and other questions.
Data Mining Part 24: SQL Profiler and Data Mining
In this chapter we will detect the Data Mining activity using SQL Server Profiler.
Data Mining Part 24: SQL Profiler and Data Mining
In this chapter we will detect the Data Mining activity using SQL Server Profiler.
Programming Rules and 'Best Practices' Can't Replace Professional Judgement
In which Phil Factor casts doubts on 'programming policies'. For certain, any IT team development requires plenty of methods of working that maximise productivity, but coding standards and ‘best practices’ have to be treated with caution. Programming rules can’t replace professional judgement
Advice for Learning T-SQL SELECT Statement Step By Step
In this tip, Dallas Snider shares his experience with how someone can start learning T-SQL from the beginning with no prior knowledge.
Inception
Inspired by the movie with the same name, Steve Jones has a Friday poll about inspiration and ideas.
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