PASS Update #44 (Budget)
I had a question recently about how budgets work at PASS, and I think that’s something worth sharing, so I’m...
2010-10-11
527 reads
Listing members of a group in SQL Server.
In SQL we are used to the GROUP BY and the type of result it produces. In real life, we...
2010-10-11
1,592 reads
SSMS Tip – Tab Groups
A few months ago as I came across tab groups in SSMS and once I found them I was very...
2010-10-11
1,104 reads
Return Values from XP_CMDSHELL
Let’s be clear: I don’t recommend the use of xp_cmdshell as a general tool. It ought to be used when...
2010-10-11
17,431 reads
Getting ready for the third “Industrial Revolution”: Database 2010-2015
I searched the internet for “connect and forget”. Wonderbox.net offer is described as a...
2010-10-10
91 reads
Getting ready for the third “Industrial Revolution”: Database 2010-2015
I searched the internet for “connect and forget”. Wonderbox.net offer is described as a “revolutionary computer server”… I think of wonderbox as a “computing appliance”, but Wikipedia limits the...
2010-10-10
42 reads
Time Saver – Presentation Preparation
Presenting is a huge fear for many and it is no different for me. I have been presenting at SQL...
2010-10-10
593 reads
Project Phoenix
Project PhoenixSometime people need a hand up – an opportunity to rise from the ashes. Over the last couple of years...
2010-10-09
904 reads
What are Physical Sockets, Physical Cores, and Logical Cores and Why Does it matter?
I witnessed a confused conversation on Twitter today where someone was talking about how he uses the terms sockets and...
2010-10-09
12,732 reads
Issues With Calculating Current Age Using DateDiff (Rounding?)
Recently I inherited a set of SSIS packages that did a pretty simple calculation for age.It used the following expression,...
2010-10-09
1,393 reads
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