A Script A Day - Day 28 - String Manipulation
Today’s script is one that I used earlier this week. On Thursday I migrated a server from SQL Server 200...
2012-03-02
532 reads
Blog Posts
A Script A Day - Day 29 - The Importance of Being Idle
Today’s script is also one I used in my migration on Wednesday. It again uses string manipulation to generate a...
2012-03-02
524 reads
Clearing Job Notifications - HELP!
I have inherited a SQL 2005 server with SQL Agent job notifications in place, and a request to clear the...
2012-03-02
909 reads
Extract CLR Assemblies from SQL Server
I’ve run into a few situations that required examining the existing CLR assemblies on a server. Whether I needed to do a comparison between two versions to make sure...
2012-03-02
426 reads
Extract CLR Assemblies from SQL Server
I’ve run into a few situations that required examining the existing CLR assemblies on a server. Whether I needed to...
2012-03-02
3,219 reads
Introducing SQL Roundup
Following in the foot steps of John Sansom (b|t), I’m going to post a roundup of links from other blogs every Friday. I’ll...
2012-03-02
987 reads
MDX SSRS Parameter Values
<rant> One of the most frustrating things about working with the Microsoft BI Stack is after you go through all...
2012-03-02
9,338 reads
PepsiCo Women’s Inspiration Award Winner – If I can do it, so can you…
An inspiring story. A hard one, and one that comes from someone with talent.
I like seeing stories like this, and...
2012-03-02
1,015 reads
Re-blog – February 24 – March 1
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-03-02
469 reads
Running a script on multiple servers
One of my favorite features of SQL Server Management Studio (SSMS) is the ability to run a script on multiple...
2012-03-02
2,678 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