Improve Productivity with Collaboration Tools
In order for your team to be productive, communication and collaboration are essential. Collaboration tools allow you to get the most out of your team members.
Understanding Your Value
Fill out the 2017 salary survey to help us all understand where our compensation might lie relative to others.
Summarizing Data Using the GROUPING SETS Operator
Writing aggregate queries is one of the most important tasks for anyone working with T-SQL. Determining the expressions required in the GROUP BY clause is not that difficult, but what do you do if you need to include different combinations of group by expressions in the same result set? Alfonso demonstrates how to use the GROUPING SETS operator to accomplish this task.
Holidays and Calendar Generation
Create the definition of your holidays and have them available for any year. Create a Calendar including holidays and business/work dates.
How to use Azure SQL Database features and settings
Vitor Montalvao explains how to work with the basic configuration settings for a SQL Azure database from the Microsoft Azure portal itself.
Questions About the GDPR That You Were Too Shy to Ask
The General Data Protection Regulation (GDPR) will affect organisations in countries around the world, not just those in Europe. The GDPR regulates how personal data is stored, moved, handled, and destroyed. Not following the regulation will lead to dire consequences for your organisation. As a data professional or developer, you may have many questions and might be wondering how it will affect the way you will do your job. William Brewer answers common questions about the GDPR that you were too shy to ask.
Partition Level Locking: Explanations From Outer Space
Erik Darling partitions the Stack Overflow database, then uses sp_WhoIsActive's @get_locks = 1 parameter to demo locking.
Advice for Newcomers
If you could look back on your career, is there some advice you wish you had? Is there something you'd tell people considering your job as a career? Let us know this Friday.
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