Securing Data
It's important that you do more than just implement perimeter security with firewalls. Steve Jones talks about how we can better secure our systems.
TSQL String Array Workbench
Robyn Page and Phil Factor show how to use XML-based arrays to make string handling easier in SQL Server 2005/2007, and illustrate the techniques with some useful functions
The Cost of Support
Microsoft is not planning on releasing Service Pack 3, but what is the best model for supporting software? Steve Jones gives a few thoughts.
The Cost of Support
Microsoft is not planning on releasing Service Pack 3, but what is the best model for supporting software? Steve Jones gives a few thoughts.
The Cost of Support
Microsoft is not planning on releasing Service Pack 3, but what is the best model for supporting software? Steve Jones gives a few thoughts.
No XP, but Look Forward To 7
A look back at the news of the past week including Windows 7, SSD performance, April Fools, and consistency in SQL Server.
Windows 7 and More
A look back at the news of the past week including Windows 7, SSD performance, April Fools, and consistency in SQL Server.
Windows 7 and More
A look back at the news of the past week including Windows 7, SSD performance, April Fools, and consistency in SQL Server.
Gotcha! SQL Aggregate Functions and NULL
Working with NULL functions can be tricky in T-SQL and SQL Server 2000. If you add in aggregates, you need to be sure you understand what the behavior will be or you might report incorrect values to a user. Michael Coles has written a new article that talks about how NULL affects your results.
Blogs
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Forums
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions
Comments posted to this topic are about the item Stairway to DAX and Power...
AI Is Improving Security
Comments posted to this topic are about the item AI Is Improving Security
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers