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,717 reads
Blog Posts
Career Warfare - Book Review
I picked up Career Warfare on the recommendation of a friend that had seen the Modern Resume presentation. I grabbed...
2010-10-08
672 reads
Free SQL Server Training for the Week of October 11, 2010
Monday
SQL Lunch - SSIS Design Patterns 1c: Variables, Events, and Automated Custom Logging Patterns - Andy Leonard
Tuesday
Idera - Accelerating Answers with Analysis Services...
2010-10-08
626 reads
New Hotness: sys.objects and sys.schemas
Last month we talked about the old and busted syscomments- and the new hotness that is sys.sql_modules – for pulling code out of...
2010-10-08
691 reads
Planning to Fail
Great title for a post, isn’t it? Seems foolish, lazy, or worse to plan for failure, right? Yet, in the...
2010-10-08
315 reads
SQL Lunch #32: SSIS Design Patterns, with Andy Leonard
Don't miss SQL Server MVP Andy Leonard on the SQL Lunch, Monday, October 11th.
#32-SSIS Design Patterns 1c: Variables, Events, and...
2010-10-08
796 reads
SQL Server Memory Related Queries
What is using all of my memory in SQL Server? If you ever believe that you are seeing signs of...
2010-10-08
2,749 reads
SSRS - Join Function
Often when designing a Reporting Services with parameters you
may be required to display those parameter values on your report.This is...
2010-10-08
4,196 reads
A little planning would have gone a long way
I was doing a database server migration for a client this week that involved a local database server with Access...
2010-10-07
902 reads
At The End of the IO Road With C#? Pave New Road!
Not being one for letting a problem get the best of me, I took another look at the asynchronous overlapped...
2010-10-07
2,791 reads
Blogs
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
GenAI vs Dashboards: Not the Same (And Never Will Be)
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Forums
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...
Multiple Sequence Values
Comments posted to this topic are about the item Multiple Sequence Values
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers