Database Design: Solving Problems Before they Start!
Every Byte Counts: Why Your Data Type Choices Matter
Introduction to Microsoft Azure DocumentDB
Offline Database Development and Unit Testing with SSDT
Protecting Your Data with Encryption
BI Information Delivery
Introduction to the Power BI Designer
Understanding and Visualizing Data Using R in SQL Server
BI Platform Architecture, Development & Administration
Don’t Repeat Yourself – An Introduction to Agile SSIS Development
Improving Data Analytics with Azure Machine Learning
Optimizing your data warehouse for OLAP Processing
Rethink your ETL with BIML
SSAS Design and Performance Best Practices
Cloud Application Development & Deployment
Azure IOT: A Practical Introduction to Stream Analytics
Enterprise Database Administration & Deployment
Common SQL Server Mistakes and How to Avoid Them
Curious Cases of Availability Groups
Data Pages, Allocation Units, IAM chains… Oh My!
Overlord – tracking changes, real-time, in your environment
SQL Server Agent: The life preserver for the drowning DBA
The Art and the Science of Designing a Mission Critical SQL Server Solution
The Data Loading Performance Presentation
Trend Analysis of SQL Error Logs: Seeing Beyond the Error
Turbo-Charged Transaction Logs
Making the Leap from Developer to DBA
SQLSaturday #407 in Vancouver, BC
SQLSaturday #407 in Vancouver, BC is happening on June 27, 2015 at UBC Robson Square, 800 Robson Street, Vancouver. SQLSaturdays are one day free training events for SQL Server professionals. SQL Server professionals have developed a pretty tight knit community over the years, and this is one way of sharing information, learnings, experiences and best practices on the product. This event is also volunteer-driven – the organizers and presenters volunteer their time and effort to help foster the #SQLCommunity.
Sessions delivered range from SQL Server Administration, Development, Business Intelligence Application, Business Intelligence Delivery, and Professional Development.
The landscape of Business Intelligence changes with SQL Server 2012. Microsoft has introduced a new “model” – the BI Semantic Model.
Don’t get too hung up on this word though, the BI Semantic Model is really just an umbrella terminology that says as long as a source follows the BI Semantic Model, it will be supported in the tools. This is the eventual goal anyway; for now there is still a discrepancy which tools support what.
The multidimensional model is the traditional OLAP model. Data source is a cube, that is processed from a data warehouse that usually follows a star schema. Complex calculations and queries using MDX can be done against it. It also allows write-backs.
The new tabular model is not really a “new model” because it is a relational model. Yes the same model we’ve grown accustomed to using when we query our transactional OLTP databases. The difference is, SSAS Tabular is an in-memory database. This is fueled by the xVelocity engine (previously known as Vertipaq), and it also leverages columnstore indexes. All calculations are in memory, and this makes tabular models really fast.
So if you are thinking of exploring the new SQL Server 2012 capabilities, including the new BI capabilities (PowerView! xVelocity!), head on to his site. It’s going to be a long process, but at least Richard has given us a comprehensive list of to-do’s.