Nr: 243
SQLSaturday #243 - Cape Town 2013
SessionID: 11617
The Secret Life of APPLY: Helping Developers Work Smarter, Not Harder
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: SQL Dev
Speaker: Christina Leo
Title: The Secret Life of APPLY: Helping Developers Work Smarter, Not Harder
Abstract:
SessionID: 11618
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: SQL Dev
Speaker: Christina Leo
Abstract:
Have you pulled a script to identify duplicates from a blog post, but couldn’t quite get it to work, because you weren’t sure what that ROW_NUMBER() function was doing. Maybe you heard talk about creating running totals without using sub-queries, but you got frustrated when the groups weren’t totaling correctly. Or maybe, you’ve never even heard of Window Functions. All are good reasons to attend this all-demo session which demystifies this versatile T-SQL tool. First, we’ll break apart the OVER clause, the key to understanding how window functions work. Then we’ll expand on each group of functions that can use the OVER clause: ranking, aggregate, and analytic functions. Finally, we’ll look at real scenarios where this tool works and talk about performance considerations. When you leave, you’ll have the fundamentals you need to fully develop your mastery of Window Functions.
SessionID: 13592
Closing the data loop with Master Data Services
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: BI
Speaker: Dudley Drummond-Hay
Title: Closing the data loop with Master Data Services
Abstract:
Master Data is not only a source in your organisation, but very often requires data feedback from various other IT systems. In addition to a high level introduction to Master Data Services(MDS) in SQL 2012, we will focus on closing the loop between MDS and your Data Warehouse. This will be a technical talk on the back-end integration points of MDS and how we can exploit these with SSIS.
SessionID: 14364
Dos and don’ts of database corruption
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Gail Shaw
Title: Dos and don’ts of database corruption
Abstract:
Database corruption is one of the worst things you can encounter as a DBA. It can result in downtime, data loss, and unhappy users. What’s scary about corruption is that it can strike out of the blue and with no warning, and without having some
In this session we’ll look at
• Easy maintenance operations you should be running right now to ensure the fastest possible identification and resolution of corruption
• Best practices for handling a database that you suspect may be corrupted
• Actions that can worsen the problem
• Appropriate steps to take and methods of recovery
SessionID: 15349
Clustered Columnstore - Introduction
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Niko Neugebauer
Title: Clustered Columnstore - Introduction
Abstract:
SQL Server 2014 receives a very new important feature - Clustered Columnstore Indexes. Using a xVelocity compression and a batch processing mode this type of indexes which was introduced in SQL Server 2012 is greatly enhanced by making it a Clustered and making it a default recommend solution for the DataWarehouse solutions. Join to discover the Clustered Columnstore Indexes by understanding on which principles they are built and what should you do get the best out of them.
This new feature is targeted at the OLAP installations and it is already available for the PDW (Parallel DataWarehouse) v2.
SessionID: 15350
Deep Dive into Clustered Columnstore
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Niko Neugebauer
Title: Deep Dive into Clustered Columnstore
Abstract:
So you already know and understand Row Groups, Delta Stores and Compression Methods, but let me show you how Clustered Columnstore Indexes work when locking blocking, when using different compression methods and technics. Let us dive deep into the Dictionaries creation and different methods for the ETL processes.
SessionID: 17770
Introduction to SQL Server 2012 PDW - The POC
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: BI
Speaker: Juan Thomas
Title: Introduction to SQL Server 2012 PDW - The POC
Abstract:
SessionID: 19741
Divide and Conquer - Scale out using Federated Database in Azure
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Martin Phelps
Title: Divide and Conquer - Scale out using Federated Database in Azure
Abstract:
Creating a Federated Sql Database in Azure can allow your data to scale out as it grows. Session will primarily be demos cover Setting up and configuring a Federated Sql Database in Azure as well as how to monitor growth of federations and how to split federations. Will also cover some limitations and disadvantages that need to be taken into consideration when deciding if using a Federated Sql Database is suitable for your business.
SessionID: 20080
Slowly changing dimensions- an integrated approach
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: BI
Speaker: Mark Stacey
Title: Slowly changing dimensions- an integrated approach
Abstract:
SessionID: 20150
Role based security from SharePoint through to the cube
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: BI
Speaker: Matt Horn
Title: Role based security from SharePoint through to the cube
Abstract:
In this session We will explore an easy way to leverage SharePoint to manage Role Based Security in the cube.
The benefits of this is to allow a non technical person to administer access permissions at the click of a button.
SessionID: 21435
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: SQL Dev
Speaker: Niels Berglund
Abstract:
SessionID: 21436
Real World Error Handling in SQL Server
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: SQL Dev
Speaker: Niels Berglund
Title: Real World Error Handling in SQL Server
Abstract:
Every SQL developers should by now be aware of the new error handling introduced in SQL Server 2005, i.e. BEGIN TRY ... END TRY BEGIN CATCH ... END CATCH, and all of us are most likely extremely happy that we finally have "proper" error handling.
However, in the "real world" it may not be so straight forward as just using this new error handling. As we at Derivco have seen there are quite a few "gotchas" when it comes to how to handle errors. In this session we will take a look and see what issues we have to be aware of, in order not to be bitten by our error handling.
SessionID: 25004
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Satya Jayanty
Abstract:
Why Upgrade?
This is the big question that every SQL Server user will be asking, from my experience I say not just for shiny new features but increase your productivity and do-more with-less practices.
Data Platform Upgrade topic has been a popular session that I've presented in major conferences like Microsoft Tech-Ed (North America, Europe India) and SQLbits since 2009.
In this session, we will overview end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading SQL Server 2000, 2005, SQL Server 2008 R2 (with a good overview on 2012 too) by using best practices and available resources. We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world examples from my Consulting experience expanding on why how such a solution is offered.
SessionID: 27121
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: SQL Dev
Speaker: Turgay Sahtiyan
Abstract:
SessionID: 34886
How to Model for Power View
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: BI
Speaker: Toufiq Abrahams
Title: How to Model for Power View
Abstract:
You can create professional, interactive and visually appealing Power View reports in Excel or SharePoint. The best part is that Power View is so easy to use. However, a report will always only be as good as the content (model) it is based on.
In this session we look at how to design a Power Pivot (or Tabular) model with the Power View author in mind. The session will include how to work with KPIs, images, hierarchies and geo-spatial mapping.