Nr: 327
SQLSaturday #327 - Johannesburg 2014
SessionID: 10409
Master data management - a simple approach to an improved data experience
Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Bhavesh Lala
Title: Master data management - a simple approach to an improved data experience
Abstract:
TBC
SessionID: 10749
Designing Modern Apps using New Capabilities in Microsoft Azure SQL Database
Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Brent Samodien
Title: Designing Modern Apps using New Capabilities in Microsoft Azure SQL Database
Abstract:
SessionID: 14369
On Transactions and Atomic Operations
Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Gail Shaw
Title: On Transactions and Atomic Operations
Abstract:
If there’s one thing that we, as SQL developers, don’t do, it’s use enough transactions.
Transactions are critical when multiple changes need to be made entirely or not at all, but even given that it’s rare to see transactions used at all in most production code.
In this session, we’ll look at what transactions are and why we should use them. We’ll explore the effects transactions have on locking and the transaction log. We’ll investigate methods of handling errors and undoing data modifications, and we’ll see why nested transactions are a lie.
SessionID: 14394
Introduction to AzureML
Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Gary Hope
Title: Introduction to AzureML
Abstract:
TBC
SessionID: 17105
Rocking with SQL 2012 Extended Events
Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Jody Roberts
Title: Rocking with SQL 2012 Extended Events
Abstract:
In this session we will cover getting started with SQL Server extended event. Scripting out events.
SessionID: 19301
Common ETL development mistakes (and their solutions)
Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Luis de Sousa
Title: Common ETL development mistakes (and their solutions)
Abstract:
We discuss a list of costly mistakes, and their solutions, made during the design and building of the ETL process. Recommendations to avoid these mistakes are covered as well as a checklist to use to create reliable ETL solutions.
SessionID: 19356
Columnstore Indexing: From SQL Server 2012 to SQL Server 2014
Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Sifiso Ndlovu
Title: Columnstore Indexing: From SQL Server 2012 to SQL Server 2014
Abstract:
Columnstore index is an enterprise feature that was introduced in SQL Server 2012 for the purposes of improving the query response on T-SQL queries against OLAP systems. In this session we will look at the initial (SQL Server 2012) implementation of columnstore indexing and how it has been improved in SQL Server 2014.
SessionID: 19419
DAX Ninja in 60 minutes
Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Mark White
Title: DAX Ninja in 60 minutes
Abstract:
In this session we will cover
• Internals of Tabular (and why you should care)
• Good and Bad Data Modelling Patterns.
• Identifying and fixing bad execution plans.
SessionID: 19513
How New Feature in SQL Server 2014 Could Benefit Business Intelligence Solutions
Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Marius Van Schalkwyk
Title: How New Feature in SQL Server 2014 Could Benefit Business Intelligence Solutions
Abstract:
This session will explore several of the new SQL Server 2014 features and how they could benefit existing and new BI solutions. This includes features that are typically considered as OLTP feature such as In-memory tables (Hekaton). The session will include a demo that will consider features and the impact they will have on data warehouse load performance, query performance, storage and maintenance. I will be using Windows Azure VMs to do the demo.
SessionID: 19743
Who's in Control? Use Sql Server Resource Governor
Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Martin Phelps
Title: Who's in Control? Use Sql Server Resource Governor
Abstract:
SessionID: 20154
Introduction to Data Analysis Expressions (DAX)
Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Matt Horn
Title: Introduction to Data Analysis Expressions (DAX)
Abstract:
In this session we will explore a number of basic data modelling and analytical problems and how to use DAX to solve them.
While this session will not make you a DAX Jedi It should provide you with a good understanding of the fundamentals of the language.
SessionID: 20369
Keynote address with Franco Rothner
Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Franco Rothner
Title: Keynote address with Franco Rothner
Abstract:
Keynote address
SessionID: 24294
Practical Query Tuning
Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Sean Pearce
Title: Practical Query Tuning
Abstract:
SessionID: 25527
SQL Server 2014 Data Access Layers
Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Steve Simon
Title: SQL Server 2014 Data Access Layers
Abstract:
SessionID: 25528
Creating efficient and effective SSRS BI Solutions
Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Steve Simon
Title: Creating efficient and effective SSRS BI Solutions
Abstract:
SQL Server 2014: With the vast amounts of data in today’s business warehouses, there has been increased demand on the Business Intelligence solution developer to produce more complex and all inclusive reporting facilities. More complexity, coupled with being all inclusive tends to yield more points of failure.In this hands on presentation we shall be examining new and innovative ways of rendering the required data in some unusual ways.
SessionID: 27368
In-Memory Optimized Tables - Hands-on demo and Real World applications
Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Frikkie Venter
Title: In-Memory Optimized Tables - Hands-on demo and Real World applications
Abstract:
The new SQL 2014 In-Memory Optimized Tables for OLTP is an exiting technology, but with a very specific and focused set of use-cases. This demo will outline their high level functioning and some real word examples.
SessionID: 35689
SQL Skills: Senior In Age / Pay OR Skills
Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Howard Diesel
Title: SQL Skills: Senior In Age / Pay OR Skills
Abstract:
This is not for those that are "Gettings Things Done" and already know the "End Game". It is also not for those that are not interested in Professional Development discussions and just want to listen to hard-core technical.
It is for those that appreciate being challenged in where they are currently in their professional career and where they are going.
It does try to address the decisions "ground rules" required to becoming a "Senior SQL Rockstar" without any regrets and blank spaces in your resume.
SessionID: 9231
SQL Best Practices including tips and Tricks for optimizing your SharePoint Farm
Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Alistair Pugin
Title: SQL Best Practices including tips and Tricks for optimizing your SharePoint Farm
Abstract:
• What architectural considerations there are for SQL from SharePoint
• Real-world SQL requirements for SharePoint
• Simple tips and tricks for SQL before deploying SharePoint
• Best practice scenario’s for SQL pertaining to SharePoint
Invariably, SharePoint Architects have to co-exist with SQL DBA’s without having to argue and or debate what is required. DBA’s armed with the items listed above will have a better understanding of SharePoint and will also be able to optimize the performance of SharePoint DB’s so as to ensure better overall performance.
SessionID: 9453
10 Things that you already knew about SSIS
Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Andreas Bergstedt
Title: 10 Things that you already knew about SSIS
Abstract:
We dive into the common knowledge subjects and principles that we already know about but forget to use or just blatantly ignore,
Delta management, Project recovery, Best and Worst practice and more.
Session is recommended for the intermediate to advanced but the beginner will also gain from this.