Development Lifecycle Deployment SSAS, SSRS, SSIS
Many companies have a very rigid development lifecycle for all products or solutions they develop. Deploying to each of these...
2010-02-17
3,932 reads
Reporting Services - Disable Loop Back Check
I have been installing and configuring SSRS since the initial release. I have always encountered several different caveats when upgrading...
2010-02-17
735 reads
Keyboard Clash
The SQLServerCentral servers are in the UK, and installed by UK personnel at Rackspace. We recently switched servers to Rackspace,...
2010-02-17
962 reads
The Perfect is the Enemy of the Good (Again)
I wrote an editorial for SSC back on January 19th about the perfect being the enemy of the good. It’s...
2010-02-17
509 reads
DBA.Sleep(8hrs)
I have been pondering recently what helps me to sleep at night. Or, conversely, what prevents me from sleeping at...
2010-02-17
1,333 reads
The Power Grid (No, Not THAT Power)
Yesterday I had the Adversity Index, today it’s the Power Grid from MediaIte. It attempts to score the power of...
2010-02-17
751 reads
MVP Summit Impressions From Day 1
Well, today was the opening day of the 2010 MVP Global Summit in Bellevue, WA. There were a few “side...
2010-02-17
642 reads
SSIS 2008 Script Component variable gotcha..
In a previous post I showed you how to access variables from within an SSIS script component. More specifically I...
2010-02-17
782 reads
2010 MVP Summit Held This Week
If you can’t tell what is happening in the above photo, you won’t be alone. Today, at the opening keynote...
2010-02-17
607 reads
SQL Saturday returns to Redmond, WA
SQL Saturday returns to Redmond, WA, Saturday, June 12, 2010, in the Microsoft Commons.
I have submitted 2 proposals for presentations,...
2010-02-17
751 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