Why I dislike Third Party Database Monitoring Tools
I have to admit I am not a fan of the various 3rd party monitoring tools (after using a few...
2012-09-17
1,906 reads
Logon Triggers: SQL Server
As the name implies, logon triggers fire in response to the logon event that is raised when a user sessions...
2012-09-17
24,357 reads
SQLSaturday #171, Pittsburgh
Date: October 6, 2012
Title: Searching for the Holy Grail of DDL Auditing
Abstract:
Who altered this view and how? When was that...
2012-09-16
692 reads
SQL Server 2012 Diagnostic Information Queries (September 2012)
Here is the September 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-09-16
1,221 reads
Going to the PASS Summit? Join Us at a Networking Dinner
For the third year Steve Jones and I are coordinating a very informal networking dinner on Monday night the week...
2012-09-21 (first published: 2012-09-15)
1,821 reads
Attendant’s checklist to a SQL Saturday event
Weeks Before The Event
Check for conflict in Schedule
Family Activities (Y/N)Business Appointment (Y/N)Other Commitments (Y/N)Plan the Trip
Distance (calculate travel time)Budget $ (Gasoline,...
2012-09-15
711 reads
Certificates of Completion for SQL Seminars
Most managers and employers distinguish between attending a conference and training. We (the royal SQL community we) offer quite a...
2012-09-14
1,120 reads
Update on My Lenovo Laptop
Order status on the web site still shows an estimated ship date of the 4th (of September) for my X1...
2012-09-14
814 reads
Conference in Florida: SQL Server Live
This conference is new to me. In case it’s new to you, I thought I’d take a moment to point...
2012-09-14
982 reads
The DevConnections Schedule is out
It’s preliminary, but the fall 2012 SQL Server Connections schedule at DevConnections is out. I’ll be speaking Tuesday, Oct 30,...
2012-09-14
1,340 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