Excel BI Tip #18: Using CUBE Functions to Break Out of Pivot Tables
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-02-04 (first published: 2015-01-27)
8,091 reads
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-02-04 (first published: 2015-01-27)
8,091 reads
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-01-28 (first published: 2015-01-20)
6,924 reads
While this is not a regular Excel tip, but it is about Excel. In my Excel BI Tips series, I...
2015-01-22
1,103 reads
Steve:
This is James’ second post on creating SQL tools with PowerShell and Windows forms. James is a DBA responsible for...
2015-01-19 (first published: 2015-01-14)
6,787 reads
This is a follow up blog post based on the Intro to Data Factory session I gave on the Training...
2015-01-13
983 reads
A tribute is an expression of gratitude or praise. A couple of years ago, I started a series about individuals...
2015-01-12
755 reads
As is our want, we must look back over the past year to see what happened. While I normally focus...
2015-01-11
631 reads
Steve:
Check out a new blogger who is sharing secrets of the DBA world. In his first post, James shows us...
2014-12-09 (first published: 2014-12-03)
7,244 reads
This blog post digs into the details of shaping the data with Power Query and Power Pivot in order to...
2014-11-19 (first published: 2014-11-12)
8,121 reads
This is the second deep dive into Power Testing ETL with Power BI. At this point, we have created the...
2014-11-13
1,173 reads
I’m excited to announce the release of a new open-source project that fully automates...
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Hub CS 08218200233 Jl. Sultan Iskandar Muda No.Kav. 80/1-2, RT.2/RW.3, Kby. Lama Utara, Kec....
Telp/Wa 628218200203 Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec. Kby....
Hub CS 08218200174 1st Floor – Unit B EightyEight@kasablanka, Jl. Raya Casablanca No.Kav. 88,...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers