Using PerformancePoint against tabular data
PerformancePoint (PPS) is typically used against multidimensional data sources (i.e. Analysis Services), but it does have the ability, albeit limited, to work against...
2012-10-25
2,894 reads
PASS 2012 Countdown – 2 Weeks To Go
I’m not sure how we got to 2-weeks until this year’s PASS Summit. If you haven’t registered yet it’s really...
2012-10-25
792 reads
The SQL PASS Summit countdown has already started!
As a SQL Server professional, I consider it an absolute must to attend the SQL PASS Summit each year. Last...
2012-10-25
954 reads
You don’t like SQLTreeo price
Today is the first day when we turned SQLTreeo into a commercial product and your emails continue to flood into...
2012-10-25
1,492 reads
SQL won't start because there's not enough space to create TEMPDB
SQL Server will not start.
You open up the ERRORLOG (...which I would only do with a text editor like gVim...
2012-10-25
1,443 reads
Denali –Memory : Memory Error Recovery in SQL Server 2012
Continue on What’s new in Denali and Memory enhancement, come across another great article by SQLCAT and Glenn Berry a...
2012-10-25
878 reads
PASS DBA Virtual Chapter Deck and Demo's Live
Hello Dear Reader, I wanted to say a quick Thank You to the PASS DBA Virtual Chapter for having me...
2012-10-25
544 reads
Windows 8 First Impressions
I haven’t worked with Window 8 at all. I’m not a big beta tester, and it’s been a busy few...
2012-10-25
1,368 reads
SQL Server Service Broker error database cannot be enabled
Problem
The SQL Server Database Engine returns the following error message after a service broker enabled database is restored to the...
2012-10-24
3,833 reads
Getting Started with Partially Contained Databases
Before SQL Server 2012, when we move or restore databases to a different SQL Server instance, then any logins associated...
2012-10-24
890 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