Lock configuration setting and preventing locking contention
The locks configuration option for SQL Server controls the number of locks available in SQL Server. You can view this...
2010-01-11
740 reads
Horror… sort of
You must read this post from Tim Ford to understand why I might do this on my technical blog. But...
2010-01-11
885 reads
New England Data Camp v2/SQL Saturdy #34 Update
The second annual New England Data Camp is shaping up to one excellent event. We’ve put together a great set...
2010-01-11
560 reads
Permon Counters Missing Windows 64 Bit SQL Server 32 Bit
For reasons beyond the scope of this post I have an environment where I have Windows 2003 R2 64 bit...
2010-01-11
754 reads
More Laptop Issues
My laptop died on Dec 1, 2009. I was on vacation, but on Dec 2 I called Toshiba (I have...
2010-01-11
1,075 reads
That DARN TOMCAT
Here is a challenge that had me stumped for several days. Besides for working with Reporting Services on a day...
2010-01-11
1,255 reads
PASS Update #22 (Speaker Bureau – Call for Comments)
One of my big projects this year is to build a speaker bureau, so in this post I’m going to...
2010-01-11
756 reads
Kevin Cox from SQLCAT Presenting at the Denver SQL Server User’s Group On January 21, 2010
Kevin Cox, who is part of the SQLCAT Team at Microsoft, will be giving the presentation at this month’s Denver...
2010-01-11
822 reads
House of Commons Justice Committee Related to The European Union's Data Protection-Retention Directives
Just this past week on Tuesday afternoon (a link to video of Parliament online, please forward to about half way through),...
2010-01-10
2,219 reads
Professional Communications
This past week I had the opportunity to have lunch with a vendor at his clients’ site. As a part...
2010-01-10
523 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