未加星标

What’s new in SSRS 2016 Session Contents

字体大小 | |
[数据库(mssql) 所属分类 数据库(mssql) | 发布者 店小二04 | 时间 2016 | 作者 红领巾 ] 0人收藏点击收藏

The 2016 edition of the Belgian SQL Server Days is over. It was a blast as usual and it was very nice meeting up with the #sqlfamily again. I had a session about the new features in SSRS 2016. I was so excited that I could do a full hour session on Reporting Services’ new features. I had to wait onlylike 7 years to be able to do so. Anyway, the session went okay and there weren’t that many questions. I always assume that’s because I did a kickass job at explaining stuff, if there are no questions :wink:

You can find the slides from my presentation on Docs.com:

All of the demos are turned into mssqlTips.com articles, so you can find more information about them over there.

I also attended some other sessions:

The SSIS design patterns precon by Matt Masson. It was really great meeting up with Matt. He has been in a lot of Microsoft teams: SSIS, MDS, DQS and Power Query. He did a solid precon, but at the end I kind of lost my interest (I already read the book by Matt and Andy Leonard about SSIS Design Patterns , so I already knew most of the stuff). Once Matt mentioned XML patterns, it was time to pack it up I did learn some interesting nuggets, like for example how the SSIS data flow treats LOB columns (badly). The Advanced MDX Tips and Tricks session by Chris Webb. Chris is an utmost authority on MDX, so I couldn’t miss this one. He also stated that this would be his very last MDX session ever (session, not training!). Unless he comes back like an aged rockstar, that is. It was a very interesting session and I learned a lot. Chris did a great piece on subselects (damn you SSRS and Excel), partitioning and the unknown UNORDER() function. Too bad there wasn’t more time. Deep Dive into Data Modeling using Power BI Desktop and SQL Server Analysis by Kasper De Jonge. Kasper has worked both on the SSAS team and on the Power BI team, so I was very excited to attend his session. He did a very thorough explanation of row level security (RLS) andbi-directional cross filtering (BI-DI). He had some warnings about over-filtering your model using BI-DI, so you shouldn’t blindly enable it on every relationship, especially in more complex models. He finished off with a part on DAX variables, which are a great addition to the language. The Power BI happy hour. Chris did a great demo about using Power BI and your brainwaves to do predictions and you could tell he really put some work in it. Joey D’Antoni talked about beer and cycling, Nico Jacobs about Power BI running for president and Wesley Backelant ended the day with a nice Power BI dashboard about his music influences. Great stuff.

I had a great time and can’t wait till next years’ edition.

本文数据库(mssql)相关术语:熊片数据库 mssql数据库 oracle数据库 pubmed数据库 access数据库 万方数据库

主题: SQLXMLSQL ServerExcelSAS
分页:12
转载请注明
本文标题:What’s new in SSRS 2016 Session Contents
本站链接:http://www.codesec.net/view/483956.html
分享请点击:


1.凡CodeSecTeam转载的文章,均出自其它媒体或其他官网介绍,目的在于传递更多的信息,并不代表本站赞同其观点和其真实性负责;
2.转载的文章仅代表原创作者观点,与本站无关。其原创性以及文中陈述文字和内容未经本站证实,本站对该文以及其中全部或者部分内容、文字的真实性、完整性、及时性,不作出任何保证或承若;
3.如本站转载稿涉及版权等问题,请作者及时联系本站,我们会及时处理。
登录后可拥有收藏文章、关注作者等权限...
技术大类 技术大类 | 数据库(mssql) | 评论(0) | 阅读(28)