Linear Gauge Control: A Practical Use
SQL Server Reporting Services 2008 introduced several new features.One key feature was the inclusion of the Gauge Controls.I was recently...
2009-11-30
1,738 reads
SQL Saturday #34/New England Data Camp v2.0
It’s official sports fans. Well, it’s been official since last week since Adam Machanic set up the web site. The...
2009-11-30
1,381 reads
Are You a Giver or a Taker?
I have been involved in the SQL Server community since 2000, and during the past nine years I have seen...
2009-11-30
1,461 reads
What’s Using Space in Tempdb?
It happens, not often, but I do regularly see people talking about their tempdb growing too large. Often that means...
2009-11-30
14,993 reads
When it rains…
It pours.
I come back from 4 days unwired, a bunch of writing done, to a laptop that’s head, a site...
2009-11-30
1,424 reads
SQL Server XQuery For Idiots
I’m still struggling with learning XQuery. My latest little revelation was small, but vital.
The difference between:
@inXML.nodes('/rss/channel/item')and
@inXML.nodes('/rss[1]/channel[1]/item')Is the difference between a...
2009-11-30
1,548 reads
XQuery For Idiots
I’m still struggling with learning XQuery. My latest little revelation was small, but vital.
The difference between:
@inXML.nodes('/rss/channel/item')and
@inXML.nodes('/rss[1]/channel[1]/item')Is the difference between a...
2009-11-30
1,749 reads
TechNet WebCast: SQL Server Locking & Blocking
Next Monday, I’m presenting a TechNet WebCast for Microsoft Thrive Live! The subject: SQL Server Locking & Blocking Made Simple. Here...
2009-11-30
1,505 reads
My first useful powershell script – capturing performance counters
After playing around with powershell a bit, I managed to do something quite useful. There are a multitude of ways...
2009-11-30
1,774 reads
Unwired
I didn’t have Internet access for 4 days while we were in the mountains. Actually I could have purchased it,...
2009-11-30
1,467 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
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....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers