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,731 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
677 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
633 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
701 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
322 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
804 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,769 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,206 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
905 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,801 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers