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,426 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,034 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,607 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,038 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,851 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,075 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,465 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,081 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,703 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,697 reads
Blogs
Giving a Security Webinar this Wednesday
By Brian Kelley
If you haven’t already signed up, on November 29, 2023, at 11 AM Eastern...
Write to backup block blob device failed. Device has reached its limit of allowed blocks.
Picture this, you’re happily backing up your database to a Azure blob storage until...
Comparing Two Scripts with kdiff3
By Steve Jones
I had a customer recently ask if SQL Compare could show them the differences...
Forums
Error while opening a custom report(.rdl) in SSMS 2017, created in VS 2019
I'm experiencing difficulties opening a custom report created in Visual Studio 2019 using Microsoft...
activity monitor is showing two diffrent spid for one big stored procedure.
hi xyz.bat this is called from microsoft sheduler. the contenct of .bat is followng....
Commit transaction inside loops
Hello, our users are complaining about blocking during a delete loop so I'm thinking...
Ask SSC