Please check out SQLShack.com for three articles on SSIS. I wrote them based on using the SSIS Catalog and Project Parameters created in SQL Server 2012 and improved on in the next 2 releases. Project parameters are a big deal in SSIS for changing values when executing a package… Read more
Please join the PASS Excel Business Intelligence Virtual Group onn March 22nd 11AM Eastern for Microsoft’s Program manager Alexander Lahuerta. The presentation will be shorted than typical meetings, lasting 20-30 minutes.
But, the session will provide great insights into changes in Excel Pivot tables. You can register for the session… Read more
There is a new website from PASS. Go to Pass.org instead of SQLPass.org. The change does not really concern me but marketing is something I am not into…yet!!!
The one thing I do like is the formatting when viewing on a mobile device. That is very nice. Here is what… Read more
Here is a list of the upcoming PASS Virtual Groups and SQLSautrday Events.
There are many ways to reap benefits from being a member of the PASS Global Community. Today, as I write this blog, I glance over at twitter for hash tag #SQLSatNash and see all the speakers, volunteers and attendees express their love of this free event. You really never see… Read more
SQL Server’s new Query Data Store is a brilliant option for databases if you are a DBA or have to do performance tuning on T-SQL queries. This new feature of SQL Server 2016 is contained within a database with configuration options for storage of history and query plans. The option… Read more
WOW!!! The next great update to Execution Plans is a way to watch the processing of rows through iterators while the query runs. Never saw that coming. And even a bonus, you can use SQL Server 2016 Management Studio (SSMS) to watch queries run on versions 2014, 2012 and 2008… Read more
There have been different announcements for new and upcoming features in the Microsoft Data Technology ecosystem. The one today I am hearing about is Data Migration Assistant (DMA) tool v2.0 GA and Tech Preview of DEA – Data Experimentation Assistant. James Serra blogged about it here - http://www.jamesserra.com/archive/2016/10/pass-summit-announcements-dmadea/. The… Read more
The second half of the day was spent talking with various speakers and attendees. I got into a great conversation about trying to mentor developers at work places about how to write good T-SQL. It was interesting to here how some developers (or DBAs) are not open to new ways… Read more
Today’s keynote was by David Dewitt. He did an excellent job explaining the architecture behind various Cloud Data Warehouse offerings. It was nice to get an explanation of the behind the scenes node and disk usage.
One announcement that caught me off guard was next year’s Summit is Oct… Read more
As all Summits, the first Regular Session day in Seattle started with the Keynote. Well, really it starts with a great breakfast at the Seattle Convention Center, but I digressed. Microsoft released information about new features for its Microsoft Data Platforms. The Keynote provided Customer specific examples of some… Read more
For the first day at the Summit this year, I spent half my time in a Pre-Conference session with Idera as an outgoing Idera Ace. The session include a 45 minute presentation for me on a Customer Use-Case. The second half of the day was spent in #SQLPASS Community… Read more
It is voting season again, and there is a great group of individuals running for the Board of Directors of PASS. You can go to the Elections Page of the SQLPass.org site and review all the information about the elections. Logging into the site will enable you to vote.
As… Read more
If you are looking for a great conference to attend, please look at Live! 360. This event combines 6 different areas of IT (including SQL Server) with some of the great experts presenting sessions for 5 days. The sessions are on December 5th thru the 9th in Orlando, FL… Read more
Please join me and about 4000+ other technology professionals for the annual PASS Summit in Seattle, WA October 24th – 28th. But before I talk about this year’s event, join me in a trip down memory lane about my path to the PASS Summit. If not, skip to the…
In the Data Mart, or the Data Warehouse world, there is a date dimension table in all schemas if you are using the Kimball Dimensional Modeling method. In the beginning of Dimensional Modeling, it was called a Time dimension. Since then, the Time dimension has actually been separate from the…
SQLSaturday events are a pleasure to be a part of whether it involves speaking or volunteering. Volunteering definitely takes more work and time, but to see someone who is interested in SQL Server as a career take time to learn on a Saturday, makes it all worth the effort. When… Read more
Thu, Mar 24 2016 12:00 Central Daylight Time
Dustin Ryan presents What's New in Power BI
WHAT'S NEW IN POWERBI
Between the weekly and monthly updates to Power BI, its tough to stay caught up with the latest updates and improvements with Microsoft's newest business intelligence…
Multidimensional Cubes provide speed when it comes to retrieving aggregations that are important to business decisions. Being able to slice or group the measures by dimension attributes helps with a quick analysis and flexible/interactive reporting. Configuring these attributes as hierarchies has some details that are not at first obvious. The…