SQL #57–A one-liner query with PARTITION BY
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,440 reads
Sherry Li's BI Corner
Learning SQL #1–Start from buying a Copy of SQL Server Developer Edition
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,038 reads
5th Blogging Year
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,040 reads
SQL #56–Aggregation with ROLLUP operator is not fully supported
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,619 reads
SQL #55 – Data Types and Storage Reference
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,084 reads
SSIS #118–Is it an OLEDB or an SMO Server Connection?
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,861 reads
SSAS #39–Building Optimal and Well-Tuned Dimensions
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,476 reads
SSIS #117–What is the Location in the MSOLAP Connection String
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,096 reads
MDX #45–Find all the Calculated Sets and Their Calculation Scripts
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,717 reads
MDX #44–How to find all the calculated measures
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,453 reads
Blogs
Demystifying Fabric Workspaces: The Nerve Center of Your Data Universe
By Chris Yates
It always starts the same way. You open your laptop on a Monday morning,...
Azure Networking: Designing for Change
By John
Failing to plan is planning to fail. When organizations first begin implementing Azure networking,...
The Case of the Forgotten Compatibility Mode – Scooby Dooing Episode 3
Like any good mystery, some SQL Server problems look spooky on the surface but...
Forums
SQL Server authentication vs. Trusted connection
I maintain an application written years ago, where the database is on a Windows...
The Duplicate Cursor
Comments posted to this topic are about the item The Duplicate Cursor
Concerns over AI Chat Privacy
Comments posted to this topic are about the item Concerns over AI Chat Privacy
Question of the Day
The Duplicate Cursor
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers