Why Do I Need All These Servers?
Introduction
I am frequently getting requests for a new server to do this or that. Running through the usual questions to...
2010-02-23
473 reads
Why All The Fuzz?
I really must thank Steve for his editorial on FizzBuzz. It seemed like a really good topic to do some...
2010-02-23
793 reads
Power Plans and Windows Server 2008 R2
After seeing an interesting blog post on AnandTech IT last week that showed slower query response time in x64 SQL...
2010-02-22
3,455 reads
SQL Server 2008 - Adding Row Totals
During a recent client engagement I was asked if there was a quick way to add a row containing totals...
2010-02-22
739 reads
Free Webinar Series This Week
If you haven’t heard already this week there is a great free webinar series going on that’s meant for beginners. ...
2010-02-22
630 reads
It will happen on a spring day in May...
"The world's favorite season is the spring. All things seem possible in May." - Edwin Way Teale This spring, the Portland,...
2010-02-22
463 reads
IgnoreUnrelatedDimensions in Analysis Services 2008
Once of the more common issues with working with data in a cube is that it does not always line...
2010-02-22
467 reads
Basic SQL Querying From PowerShell
I promise to make this worth your time. (Oops, I better make this quick.)
Alright so with PowerShell if you open...
2010-02-22
1,284 reads
Christmas Holiday
We booked a vacation over the weekend, so I’m marking off the week before Christmas as vacation this year. Hoping...
2010-02-22
933 reads
Introduction to Using Profiler with SSAS 2008
There are many ways to optimize your analysis services cubes, but the real trouble is how do you know where...
2010-02-22
611 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