Sherry Li's BI Corner

What can be done in SAS must be possible in SQL
A friend of mine is a data professional in marketing data...

2015-01-22 (first published: 2015-01-17)

10,456 reads

Learning SQL #1–Start from buying a Copy of SQL Server Developer Edition

by Sherry-Lis-BI-Corner

Sherry Li's BI Corner

If learning SQL is in your New Year Resolution, then you will be happy to read this post.
We all make...

2015-01-09

1,050 reads

5th Blogging Year

by Sherry-Lis-BI-Corner

Sherry Li's BI Corner

It’s hard to believe that it’s been 5 years since my first ever post, in which I simply spelled Business Intelligence. Thanks...

2014-12-31

1,052 reads

SQL #56–Aggregation with ROLLUP operator is not fully supported

by Sherry-Lis-BI-Corner

Sherry Li's BI Corner

ROLLUP, CUBE, and GROUPING SETS Operators have been around since SQL Server 2005. These operators are extensions of the GROUP...

2015-01-05 (first published: 2014-12-31)

8,629 reads

SQL #55 – Data Types and Storage Reference

by Sherry-Lis-BI-Corner

Sherry Li's BI Corner

When we design a database, we usually need to do an estimate on the size of the database based on the...

2014-12-19

1,101 reads

SSIS #118–Is it an OLEDB or an SMO Server Connection?

by Sherry-Lis-BI-Corner

Sherry Li's BI Corner

OLEDB is the native client for SQL Server. Every SSIS developer is familiar with how to use it. Almost every...

2014-12-23 (first published: 2014-12-17)

7,873 reads

SSAS #39–Building Optimal and Well-Tuned Dimensions

by Sherry-Lis-BI-Corner

Sherry Li's BI Corner

The Analysis Services Performance Guide from bunch of Microsoft Analysis Services experts have been updated since 2005 edition for 2008 R2...

2014-12-14

1,492 reads

SSIS #117–What is the Location in the MSOLAP Connection String

by Sherry-Lis-BI-Corner

Sherry Li's BI Corner

MSOLAP is a native OLE DB provider for Analysis Services
A common task during ETL is to process the OLAP dimensions and the...

2014-12-13

3,101 reads

MDX #45–Find all the Calculated Sets and Their Calculation Scripts

by Sherry-Lis-BI-Corner

Sherry Li's BI Corner

Now we know how to find all the calculation scripts in a cube by querying the DMV $SYSTEM.MDSCHEMA_MEASURES.
MDX #43–Find a MDX...

2014-11-21 (first published: 2014-11-14)

5,730 reads

MDX #44–How to find all the calculated measures

by Sherry-Lis-BI-Corner

Sherry Li's BI Corner

Calculated measures are visually identifiable
If you have access to a cube, it’s quite easy to find all the calculated measures.
The...

2014-11-13

1,470 reads

Sherry Li's BI Corner

SQL #57–A one-liner query with PARTITION BY

Learning SQL #1–Start from buying a Copy of SQL Server Developer Edition

5th Blogging Year

SQL #56–Aggregation with ROLLUP operator is not fully supported

SQL #55 – Data Types and Storage Reference

SSIS #118–Is it an OLEDB or an SMO Server Connection?

SSAS #39–Building Optimal and Well-Tuned Dimensions

SSIS #117–What is the Location in the MSOLAP Connection String

MDX #45–Find all the Calculated Sets and Their Calculation Scripts

MDX #44–How to find all the calculated measures

Blogs

Audit – Security Compliance Frameworks (Part 1)

Restore SQL Server Database to an OrbStack Container

Day of Data Baton Rouge Slides and Code

Forums

ALAMAT BCA KCU SUDIRMAN Telp 08218200174

ALAMAT BCA KCU KUNINGAN Telp 08218200174

ALAMAT BCA KCU PURI INDAH Telp 08218200174

Question of the Day

SQL Server Certificates