Adding PerformancePoint Dashboard Content to SharePoint
Microsoft SharePoint Server 2010 provides several options for creating Dashboards using PerformancePoint content.
The first option is to implement the...
2013-02-11
3,562 reads
SQL Server Analysis Services Tabular KPIs
A few weeks ago, I wrote a blog post that discusses implementing KPIs in SQL Server Analysis Services Multidimensional. For...
2013-02-04
2,590 reads
Currency Conversion in Tabular Model Using DAX
Roughly a year ago, I implemented currency conversion logic in multidimensional cubes using measure expressions (as well as using the...
2013-01-28
3,832 reads
Re-writing MDX calculated members as DAX measures
I have been working on re-creating some logic in a tabular cube that was originally implemented in multidimensional. This involved...
2013-01-21
1,345 reads
SQL Server Analysis Services KPIs
Key Performance Indicators (KPIs) are measurements used to gauge business performance against quantifiable goals. SQL Server Analysis Services provides functionality...
2013-01-15 (first published: 2013-01-14)
6,543 reads
Querying and Optimizing DAX
Over the past few weeks, I’ve been watching some videos from this year’s PASS Summit. One of the presentations I...
2013-01-02
3,935 reads
Optimizing Your BI Semantic Model for Performance and Scale
Here’s my notes from the ‘Optimizing Your BI Semantic Model for Performance and Scale (BIA-402-M)’ session at PASS Summit, presented...
2012-12-11
2,981 reads
SSIS: Character Replacement Using the Script Component
When cleansing data from source systems to store in a data mart or warehouse, we often need to remove or...
2012-12-08
1,752 reads
T-SQL Tuesday: What Does the SQL Community Mean to You?
Today is T-SQL Tuesday #36, hosted by Chris Yates (B | T). The topic this month is ‘What Does the SQL...
2012-11-13
783 reads
Book Review: SQL Server 2012 Analysis Services The BISM Tabular Model
I will start off by saying, whenever I see the names Marco Russo, Alberto Ferrari and Chris Webb on a...
2012-11-12
1,880 reads
Blogs
Using Cron in Postgres Flex
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...
Can I Change a Primary Key Value? #SQLNewBlogger
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
SQL Server Index Primer
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Forums
Multiple Collations
Comments posted to this topic are about the item Multiple Collations
How do you keep track of the purpose for SQL Logins?
Wondering how others keep track of the purpose for SQL Logins? I'm not talking...
Just a rant about the SQL Server 2022 upgrade
Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am...
Question of the Day
Multiple Collations
Can I have a collation expression like this in SQL Server 2022?
... WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS ...See possible answers