Executing DBCC for SQL Server Analysis Services 2016
In the upcoming release of SQL Server Analysis Services 2016, one of the new features you’ll see is the ability...
2015-09-09 (first published: 2015-09-03)
2,127 reads
SQL with Dustin Ryan
10 DAX Calculations for your Tabular or Power Pivot Model (Part 1)
If you’ve read my blog for a while you may have seen the following posts:
Ten MDX Calculations For Your Cube...
2015-09-02
1,089 reads
Join Me for Free #PowerPivot Training w/ @ExcelBIPASS Sept 10 – 12p CDT
I’m excited to be able to say that coming up next week on Thursday September 10, I’ll be presenting my...
2015-09-01
795 reads
5 Tips for #PowerBI
After a couple months of fun with Power BI, I’ve picked up a few little tricks along the way that...
2015-09-04 (first published: 2015-08-29)
4,430 reads
Taking #PowerPivot to the Next Level
Power Pivot is an amazing, flexible and powerful business intelligence tool (among other things) and there is no doubt about...
2015-08-26
1,051 reads
Designing a Data Warehouse from the Ground Up Webinar Recording with Q & A
Thank you to everyone that registered and attended my webinar Designing your Data Warehouse from the Ground Up webinar this...
2015-08-21
751 reads
Importing Power Pivot & Power View into Power BI
The Power BI August update just rolled out today (8/20/2015) and in the latest update there’s a lot of cool,...
2015-08-20
2,485 reads
Power BI Tip: Use a Scatter Chart to Create a Calendar Report
The Scatter Chart in Power BI and Excel is very useful chart for visualizing three different metrics in tandem. But...
2015-08-28 (first published: 2015-08-19)
3,537 reads
Refreshing Excel Power Query & Pivot Tables with SSIS and Task Factory
With SSIS 2014 and earlier there is currently not native way to refresh an Excel workbook which include Power Query...
2015-08-15
1,182 reads
Here’s the New #Excel 2016 Chart Types!
The Office 2016 Public Preview is now available for download! Included in the preview of Excel 2016 are a handful...
2015-08-12
1,163 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
BCA KCU BLOK A CIPETE Telp:0821-8200-233
Telp/Wa 62 8218200233 PQHX+93W, Jl. RS. Fatmawati Raya No.6 A, RT.1/RW.5, Cipete Sel., Kec....
Alamat Kantor BCA KCP Tebet Telp:0821-8200-203
Telp/Wa 62 8218200203 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N &...
Alamat BCA KCP Tebet Barat Telp:0821-8200-174
Telp/Wa:62 8218200174 Jl. Tebet Barat IX No.40, RT.6/RW.4, Tebet Bar., Kec. Tebet, Kota Jakarta...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers