Teaching SQL Server 2008 Class at University of Denver – University College
I will be teaching ICT 4461 SQL Server with Lab starting Tuesday, January 5, 2010. This will be an on-campus...
2009-11-30
1,569 reads
Blog Posts
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
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
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
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
Featured Blogger: Rob Garrison
I met Rob via email early this year as a volunteer helping with content for PASS, and I’ve been following...
2009-11-29
1,419 reads
Kevin Kline on PASS
Brian Moran (incoming Board member) did a nice interview with Kevin, worth reading, and some good stuff about areas where...
2009-11-29
1,387 reads
Link: Top 200 Developer Blogs
Ran across this list a while back, Jurgen posted his Top 200 Developer Blogs list and an OPML file of...
2009-11-29
1,402 reads
weekly update
Well I said that I would try to post regularly and seeing as its Sunday and I haven’t posted for...
2009-11-29
597 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