sqlsathistory

Nr: 244

Back to Main list

SQLSaturday #244 - Johannesburg 2013

Start Time (24h) Speaker Track Title
00:00:00 Christina Leo Breakout room T-SQL Fundamentals: Logical Processing Order
00:00:00 Jacques Mostert Auditorium 1 Off with his head!!!! - 10 SQL coding mistakes that can lead to death.
00:00:00 Gary Hope Laura Kotlinski Auditorium 1 Introduction to the PDW: Gary Hope and Laura Kotlinksi
00:00:00 Gail Shaw Auditorium 3 Dos and don’ts of database corruption
00:00:00 Gary Hope Auditorium 1 The Microsoft "Big Data" and "In Memory" Data Management Story.
00:00:00 Greg Fibiger Auditorium 2 Microsoft BI - Smart Analytics for a Smarter Future
00:00:00 Geoffrey Smith Auditorium 2 Introduction to PowerBI
00:00:00 Michael Johnson Auditorium 1 Getting started with your first tabular cube
00:00:00 Martin Phelps Auditorium 2 Divide and Conquer - Scale out using Federated Database in Azure
00:00:00 Matt Horn Breakout room I wish I knew that yesterday!
00:00:00 Niels Berglund Auditorium 3 Enhance SQL Performance by Messaging and Queuing Applications
00:00:00 Sandesh Nagaraj Auditorium 2 Master Data Services Role as Dimension Manager
00:00:00 Scott Klein Auditorium 3 Windows Azure SQL Database Troubleshooting and Query Tuning
00:00:00 Sean Pearce Auditorium 3 An Introduction to Indexes and How to Use Them for Maximum Performance

SessionID: 11615

T-SQL Fundamentals: Logical Processing Order

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Breakout room

Speaker: Christina Leo

Title: T-SQL Fundamentals: Logical Processing Order

Abstract:

“Column dbo.xyz' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.” Seen it; fixed it, but can we explain why we’re getting a syntax in the first place? The optimizer must follow a very specific hierarchy in order to generate a plan. When you understand the hierarchy, then you better understand the behavior of the optimizer.

This all-demo session will explain the logical processing hierarchy, giving you the foundation knowledge you need to build well-structured queries that keep the optimizer happy. Learn how the FROM clause is processed, why a calculated column’s alias can’t be addressed in the JOIN, why WHERE isn’t the only filter, and why NULL confuses everything. When you leave, you will think very differently about how you build your queries, and the query optimizer will love you for learning to speak its language.

SessionID: 13254

Off with his head!!!! - 10 SQL coding mistakes that can lead to death.

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Auditorium 1

Speaker: Jacques Mostert

Title: Off with his head!!!! - 10 SQL coding mistakes that can lead to death.

Abstract:

in this session I will cover 10 mistakes I see developers make on a regular basis. sometimes simple to fix other times just plain stupid.

SessionID: 14003

Introduction to the PDW: Gary Hope and Laura Kotlinksi

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Auditorium 1

Speaker: Gary Hope Laura Kotlinski

Title: Introduction to the PDW: Gary Hope and Laura Kotlinksi

Abstract:

Introduction to the PDW: Gary Hope and Laura Kotlinksi

SessionID: 14363

Dos and don’ts of database corruption

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Auditorium 3

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: 14392

The Microsoft "Big Data" and "In Memory" Data Management Story.

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Auditorium 1

Speaker: Gary Hope

Title: The Microsoft "Big Data" and "In Memory" Data Management Story.

Abstract:

The Microsoft "Big Data" and "In Memory" Data Management Story.

A 360' view of Microsoft's latest investments in scale out, unstructured and high speed transaction processing technologies that form the new Microsoft Data Platform (including PDW, Polybase, HDInsight and Hekaton)

SessionID: 14816

Microsoft BI - Smart Analytics for a Smarter Future

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Auditorium 2

Speaker: Greg Fibiger

Title: Microsoft BI - Smart Analytics for a Smarter Future

Abstract:

With a wide variety of products services, Microsoft has really changed the game with their new BI capabilities. In this session Greg will take you through Microsoft Business Intelligence (SQL 2012/2014, SharePoint 2013 and Office 2013) providing useful insights into the present and the future of Microsoft Business Intelligence

SessionID: 14840

Introduction to PowerBI

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Auditorium 2

Speaker: Geoffrey Smith

Title: Introduction to PowerBI

Abstract:

Overview and introduction to Microsoft's latest self-service BI offering - PowerBI

SessionID: 19343

Getting started with your first tabular cube

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Auditorium 1

Speaker: Michael Johnson

Title: Getting started with your first tabular cube

Abstract:

In this session we will look at how you can easily get started with your first tabular cube. We will importing multiple data sources and creating relationships between them. This data will then be enriched through the use of calculated columns, and custom calculations.

SessionID: 19740

Divide and Conquer - Scale out using Federated Database in Azure

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Auditorium 2

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: 20149

I wish I knew that yesterday!

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Breakout room

Speaker: Matt Horn

Title: I wish I knew that yesterday!

Abstract:

SQL server 2012 functions and techniques you wish you knew about before writing that 1000 line UDF.

In this session we will explore some interesting and useful tips,tricks, functions and DMVs.

SessionID: 21432

Enhance SQL Performance by Messaging and Queuing Applications

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Auditorium 3

Speaker: Niels Berglund

Title: Enhance SQL Performance by Messaging and Queuing Applications

Abstract:

When you think of SQL Server, the first thing you think about is probably not SQL as host for messaging / queuing applications. However, in certain scenarios it definitely makes sense to implement messaging inside the SQL engine. In this session we will see the benefits of messaging applications inside SQL as well as what options you have when implementing it and their respective performance implications.

SessionID: 23929

Master Data Services Role as Dimension Manager

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Auditorium 2

Speaker: Sandesh Nagaraj

Title: Master Data Services Role as Dimension Manager

Abstract:

This Session is an introduction to Master Data Services and the role it can play in Data Management and Data Warehouse.

Session Highlights:

SessionID: 24090

Windows Azure SQL Database Troubleshooting and Query Tuning

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Auditorium 3

Speaker: Scott Klein

Title: Windows Azure SQL Database Troubleshooting and Query Tuning

Abstract:

Windows Azure SQL Database is a fully-managed, scalable service based on SQL Server technology. It is also a shared-environment service which means that you can’t and shouldn’t avoid best practices when it comes to query tuning. Microsoft has put mechanisms in place to ensure that your queries and processes don’t use up too many resources which could seriously impact performance of not only your database, but the database of other organizations as well. This demo-filled session will look at tools and options available to help identify poor performing queries, such as dynamic management views. This session will help identify problem queries and help you understand why a query is running slow through execution plans and other tools in the SQL Database Portal. Ultimately, you will be enabled to find and fix your poorly performing queries and do it all in the cloud.

SessionID: 24295

An Introduction to Indexes and How to Use Them for Maximum Performance

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Auditorium 3

Speaker: Sean Pearce

Title: An Introduction to Indexes and How to Use Them for Maximum Performance

Abstract:

Do you find yourself battling to describe the difference between a clustered and a non-clustered index. Do you struggle with unhappy users and bad performance. Do you want to know how to identify missing indexes or duplicate indexes? Indexes are a vital cog in the SQL Server engine and getting them right is one of the best performance tuning techniques available. A simple index can make the difference between a sub-second result or waiting 30 minutes for data. A simple index can also make the difference between happy and unhappy users. So what are indexes exactly and why do they make my life so much easier? Find out here.