The MERGE statement in SQL Server
The SQL MERGE statement was introduced in SQL Server 2008 and allows you to modify data in a target table based...
2012-09-06 (first published: 2012-09-05)
4,802 reads
“It’s Alive” - SSIS Design Patterns
I’m happy to announce that the book I’ve been working on for the past two years is complete and has...
2012-09-05
1,000 reads
“It’s Alive” – SSIS Design Patterns
I’m happy to announce that the book I’ve been working on for the past two years is complete and has...
2012-09-05
572 reads
Error: ACCESS DENIED on installation
Error: ACCESS DENIED on installation Generally you would get error on: >> During installation >> when try to start the sql services....
2012-09-05
904 reads
SSMS Report Error – Index(zero based) must be greater than or equal to zero and less than the size of argument list !
SSMS reports are one of the best ways to pull some great deal of Server level or Database level information...
2012-09-04
4,717 reads
Our weekly webshow starts Friday! #DBAsAtMidnight
Let’s pretend we’ve never met. Depending on who you are, maybe we haven’t. It’s beside the point, really.
So hi, I’m...
2012-09-04
923 reads
September Events
Wow, I can’t believe it is already September of 2012. Labor day has come and gone, school is in session and the SQL Community is still busy. With that,...
2012-09-04
8 reads
September Events
Wow, I can’t believe it is already September of 2012. Labor day has come and gone, school is in session...
2012-09-04
891 reads
The Charles River – SQL in the City Boston
I once rowed in the Head of the Charles Regatta. I had the 3d seat, starboard, in a 4 man...
2012-09-07 (first published: 2012-09-04)
2,240 reads
Some Jargon from the SQL Server World
Not long ago I wrote about how to write well about SQL Server, and one major point was that jargon...
2012-09-04
1,131 reads
Blogs
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
An Eventual Consistency Scam
Comments posted to this topic are about the item An Eventual Consistency Scam
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers