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,123 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,081 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
791 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,426 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,046 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
747 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,479 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,536 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,178 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,158 reads
Blogs
Think Twice Before Enabling Fabric’s Inbound Network Protection
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python
Most apps that call an LLM send every request to the same model. That...
Advice I Like: Responsibility
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Forums
AI Observability Challenges in FinOps as a DBA
Comments posted to this topic are about the item AI Observability Challenges in FinOps...
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers