I’ve blogged about the Properties() function before.
MDX #11 – How to get number of cars each customer owned using Properties() function?
MDX...
2013-02-28 (first published: 2013-02-21)
1,965 reads
Slicer, Axes and Calculations Can All Filter Data in MDX
Every developer with SQL background knows how the WHERE clause works....
2013-02-08
4,015 reads
Functions such as NonEmpty(), Filter() and Exists() must use a numeric expression
Many of the MDX functions, such as NonEmpty(),...
2013-01-17
17,103 reads
Calculated Field has existed in Reporting Services since version 2005. SSRS 2005 did not have the most attractive user interface...
2013-01-04
11,492 reads
I often think that I am lucky to work in a profession that I enjoy very much. It makes everything...
2012-12-03
693 reads
Almost every tool we learned has some sort of “Hello World!” tutorial lesson.
So here comes the “Hello World!” lesson in...
2012-12-03
1,081 reads
Need to check the last time when our ETL processes ran successfully
Data warehouse developers routinely query the last data date...
2012-11-22
670 reads
ParallelPeriod() function is very useful when we need to present data side-by-side for two parallel periods
ParallelPeriod() function is often used...
2012-11-22
1,370 reads
A reader asked me to share a C Sharp script I used in this post, SSIS #114 – How many ways...
2012-11-03
1,173 reads
Continuing from MDX #18 – Easy to concatenate row values into column in MDX.
I have not accomplished the goal of concatenating...
2012-10-19
1,456 reads
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
How I used AI for this postChatGPT to generate images based on info specifically...
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Comments posted to this topic are about the item How Can SQL Server Detect...
Comments posted to this topic are about the item Getting Database MaiL Profiles
Comments posted to this topic are about the item Preserving Data
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers