The Standing Desk – In the Light
It’s been almost a month since I started the Standing Desk experiment. My first setup was down in the basement,...
2012-07-05
1,130 reads
Blog Posts
Using Excel Macro (.xlsm) Enabled Files in SSIS
Recently while working for a client that was running SQL Server 2008 R2 I was tasked with loading an Excel...
2012-07-05 (first published: 2012-06-29)
6,279 reads
Fourth of July Bloopers
Here you go. The raw ones.
It’s a holiday, and usually I’m spending time with the family and enjoying the...
2012-07-04
1,113 reads
Lost in Translation – Deprecated System Tables – syscomments
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-07-04
1,016 reads
MDX ‘Is’ Operator
I recently encountered a business scenario involving calculated members in a cube that I thought is worth sharing.
We have a...
2012-07-04
827 reads
Powershell, SMO, and Add-Member - Not Always BFF
Over the past few weeks, I’ve been working with SMO to implement some maintenance routines across my clients. Because of...
2012-07-04 (first published: 2012-06-28)
3,957 reads
Does Encryption Affect Seeing Statements in Deadlock Graphs?
Good question. I don’t have a clue. So let’s set up a test. I’ll create this stored procedure:
CREATE PROCEDURE DL2e
...
2012-07-03 (first published: 2012-06-25)
2,271 reads
July 2012 – Monthly SQL Server Checklist
The year is half over and for many of us, specifically those in the United States, it’s a tricky week...
2012-07-03
894 reads
Lunch is for Wimps
A real life DBA tale from the trenches with some awesome advice. That’s what one reader chose to share with...
2012-07-03
1,268 reads
Speaker Selection for SQLSaturday Orlando-Group #4
Ten speakers selected, and as we go into the July 4th holiday we’re going to add two more to that...
2012-07-03
320 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