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,104 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,066 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
783 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,398 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,037 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
740 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,462 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,520 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,148 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,150 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers