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,456 reads
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,050 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,629 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,052 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,873 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,101 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,492 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,101 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,730 reads
MDX #42–IsEmpty? or = 0 ? or IS NULL?
In SQL, NULL means undefined value
Any SQL programmer can tell you that zero is not NULL, NULL is not zero, and...
2014-11-18 (first published: 2014-11-12)
22,721 reads
Blogs
Restore SQL Server Database to an OrbStack Container
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
Day of Data Baton Rouge Slides and Code
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
Forums
ALAMAT KANTOR BCA KCU SEMARANG Telp:083831618008
WhatsApp:0838-3161-8008 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
SQL 2025 SSMS Nonsense
Yeah, I know this is a 2022 forum, but I don't see a 2025...
PowerBI Question - Data Sources
I don't see a PowerBI forum, so I'm posting here. I have a need...
Question of the Day
SQL Server Certificates
Which of these is not true for certificates used for SQL Server connections?
See possible answers