Day –2 (Sun) at the PASS Summit 2009
Flew out of Orlando direct to Seattle, leaving at 8:30 and arriving about 1130 am Seattle time. Nice flight, no...
2009-11-02
360 reads
Follow Up to Maintaining Security and Performance Using Stored Procedures Part I – Using Execute As
This is a follow up to Maintaining Security and Performance using Stored Procedures Part I – Using EXECUTE AS because of...
2009-11-02
475 reads
Fingers Crossed on a Short Flight
I'm heading to Seattle in a couple hours. Bags packed, I've completed my run for the day, and getting ready...
2009-11-02
369 reads
Free Books at Red Gate Booth at PASS Summit
Red Gate Software will be handing out a limited number of free paperback books at their booth at the 2009...
2009-11-02
593 reads
2009 PASS Community Summit Registration Starts Out Strong
Registration for the 2009 PASS Community Summit started out strong with many attendees registering early the Sunday evening before the...
2009-11-02
487 reads
Living with DTS on SQL Server 2005 and 2008
The DTS support in SQL Server 2005 and 2008 is excellent (almost). Typically the packages and jobs do not need...
2009-11-02
1,340 reads
SQL PASS Summit 2009 – Day Zero
For me, today was the start of a six-day SQL Server adventure at the PASS Summit in Seattle. The day...
2009-11-01
714 reads
Stored Procedure Call Tree
I was reading a post by Linchi Shea in which he demonstrates a Perl script to Find the complete call...
2009-11-01
1,808 reads
Two Very Important Configuration Settings For SQL Server 2005/2008
Two settings that I always enable when I install SQL Server 2005 or 2008 on an x64 production database server...
2009-11-01
5,916 reads
DB Audit Challenge #1
Take the DB Audit Challenge - Intermediate - DB Audit Challenge #1
For those of you who have been following my recent blogs,...
2009-11-01
1,199 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
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...
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers