sqlsathistory

Nr: 301

Back to Main list

SQLSaturday #301 - Cape Town 2014

Start Time (24h) Speaker Track Title
00:00:00 Gail Shaw DBA Lies, Damned Lies And Statistics
00:00:00 Gail Shaw DBA On Transactions and Atomic Operations
00:00:00 Gary Hope Azure an Introduction to AzureML
00:00:00 Gordon Beeming BI Power BI in Office 365
00:00:00 Jody Roberts Azure Exploring CloudOS
00:00:00 Klaus Aschenbrenner Dev UNIQUEIDENTIFIERs as Primary Keys in SQL Server
00:00:00 Klaus Aschenbrenner DBA Inside the SQL Server Query Optimizer
00:00:00 Lyndon Johnson BI Custom Prompt Pages for Microsoft Reporting Services
00:00:00 Martin Phelps DBA Who's in Control? Use Sql Server Resource Governor
00:00:00 Matt Horn BI Introduction to Data Analysis Expressions (DAX)
00:00:00 Mine Tokus Azure Relational Data Management on Microsoft Azure
00:00:00 Niels Berglund Dev SQLCLR Real World Usage
00:00:00 Peter Willmot Dev Securing your SQL Database Applications
00:00:00 Serdar Altug Azure SQL 2014 Enhancements Overview
00:00:00 Stanley Roos Dev Indexing for performance
00:00:00 Stefan Cronje Dev SQL Source … controlled in the studio
00:00:00 Steve Simon BI SQL Server Reporting Services 2014 on Steroids!!
00:00:00 Steve Simon Dev Database design for mere developers

SessionID: 14366

Lies, Damned Lies And Statistics

Back to calendar

Event Date: 06-09-2014 - Session time: 00:00:00 - Track: DBA

Speaker: Gail Shaw

Title: Lies, Damned Lies And Statistics

Abstract:

Ever wondered what the things called statistics are, why they're important and what needs to be done to maintain them? If so, this session is for you! In this session well take a look at what statistics are and why SQL keeps them; at how SQL maintains them and under what circumstances that maintenance is insufficient; and well look at the problems that result when they are inaccurate. Finally well cover some suggestions and options around maintenance of statistics when the automatic maintenance is not sufficient.

SessionID: 14367

On Transactions and Atomic Operations

Back to calendar

Event Date: 06-09-2014 - Session time: 00:00:00 - Track: DBA

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

an Introduction to AzureML

Back to calendar

Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Azure

Speaker: Gary Hope

Title: an Introduction to AzureML

Abstract:

introducing Microsoft’s technology entry into the machine learning capability

SessionID: 14718

Power BI in Office 365

Back to calendar

Event Date: 06-09-2014 - Session time: 00:00:00 - Track: BI

Speaker: Gordon Beeming

Title: Power BI in Office 365

Abstract:

In this session we will explore the power of Power QA in Office 365. We'll look at getting data into O365 enabling it for QA and then using Power QA on that data. We'll then switch to Sample Data available in Office 365 to demo some capabilities with a larger data set.

SessionID: 17100

Exploring CloudOS

Back to calendar

Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Azure

Speaker: Jody Roberts

Title: Exploring CloudOS

Abstract:

In this session we will explore the way forward using the MS CloudOS platform and how it helps to simplifly our business.

SessionID: 18495

UNIQUEIDENTIFIERs as Primary Keys in SQL Server

Back to calendar

Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Dev

Speaker: Klaus Aschenbrenner

Title: UNIQUEIDENTIFIERs as Primary Keys in SQL Server

Abstract:

UNIQUEIDENTIFIERs as Primary Keys in SQL Server - a good or bad best practice? They have a lot of pros for DEVs, but DBAs just cry when they see them enforced by default as unique Clustered Indexes. In this session we will cover the basics about UNIQUEIDENTIFIERs, why they bad and sometimes even good, and how you can find out if they affect the performance of your performance critical database. If they are affecting your database negatively, you will also learn some best practices how you can resolve those performance limitations without changing your underlying application.

SessionID: 18502

Inside the SQL Server Query Optimizer

Back to calendar

Event Date: 06-09-2014 - Session time: 00:00:00 - Track: DBA

Speaker: Klaus Aschenbrenner

Title: Inside the SQL Server Query Optimizer

Abstract:

Things you don't want to know about SQL Server

SessionID: 19322

Custom Prompt Pages for Microsoft Reporting Services

Back to calendar

Event Date: 06-09-2014 - Session time: 00:00:00 - Track: BI

Speaker: Lyndon Johnson

Title: Custom Prompt Pages for Microsoft Reporting Services

Abstract:

When a client migrated from IBM Cognos to SQL Server Reporting Services as their reporting tool, we needed to provide the same functionality and user experience they were getting with the Cognos prompt pages. The standard Reporting Services prompt pages could not meet these requirements, so we developed and implemented a custom prompt page solution, using ASP, JavaScript and jQuery, from which to run the Reporting Services reports. This session will cover how we developed this solution and how it works.

SessionID: 19742

Who's in Control? Use Sql Server Resource Governor

Back to calendar

Event Date: 06-09-2014 - Session time: 00:00:00 - Track: DBA

Speaker: Martin Phelps

Title: Who's in Control? Use Sql Server Resource Governor

Abstract:

As a DBA do you control what is utilising the resources within Sql or do the the Applications? Learn how to setup and configure Sql Server Resource Governor, and how it can be used to determine what application or users are hogging the resources and how to limit those that are impacting on the overall system performance.

SessionID: 20153

Introduction to Data Analysis Expressions (DAX)

Back to calendar

Event Date: 06-09-2014 - Session time: 00:00:00 - Track: BI

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

Relational Data Management on Microsoft Azure

Back to calendar

Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Azure

Speaker: Mine Tokus

Title: Relational Data Management on Microsoft Azure

Abstract:

Start with data management features available on Microsoft Azure and learn about the various options for using SQL Server in Windows Azure. Explore the differences between Azure SQL Database (PaaS) and SQL Server in infrastructure as a service (IaaS), and see how to deploy and manage both approaches.

SessionID: 21439

SQLCLR Real World Usage

Back to calendar

Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Dev

Speaker: Niels Berglund

Title: SQLCLR Real World Usage

Abstract:

SQLCLR was introduced in SQL Server 2005 with much fanfare. Unfortunately the uptake of it was not as good as Microsoft would have wanted. This does not mean however that SQLCLR is not useful, it is very useful in the right circumstances. In this session we will see how to use SQLCLR and how it is being used in production to solve real-world hard problems. The session is high on code and low in slides!

SessionID: 22323

Securing your SQL Database Applications

Back to calendar

Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Dev

Speaker: Peter Willmot

Title: Securing your SQL Database Applications

Abstract:

- Understanding and mitigating Injection risks

SessionID: 23812

SQL 2014 Enhancements Overview

Back to calendar

Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Azure

Speaker: Serdar Altug

Title: SQL 2014 Enhancements Overview

Abstract:

SQL Server 2014’s mission is to deliver for mission critical performance for the most demanding database applications, hitting on all aspects of mission critical criteria from performance to security, scalability and high availability along with the mission critical support. For business intelligence our mission is to deliver faster insights into any data big data, small data, all data and most importantly deliver BI in a consumable manner for business users through familiar tools. Finally, SQL Server 2014 will enable new unique hybrid cloud solutions that can positively impact your bottom line and allow you to create new innovative hybrid cloud solutions for your database applications.

SessionID: 25241

Indexing for performance

Back to calendar

Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Dev

Speaker: Stanley Roos

Title: Indexing for performance

Abstract:

An effective indexing strategy is one of the most important responsibilities of a database professional. In this session we will briefly look at the internals of indexes and how the engine decides how to utilise them. We will explore the different options and choices available in the different versions from 2005, 2008,2012 and 2014.

SessionID: 25250

SQL Source … controlled in the studio

Back to calendar

Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Dev

Speaker: Stefan Cronje

Title: SQL Source … controlled in the studio

Abstract:

With the introduction of Database Projects in Visual Studio, SQL developers have finally had a way of controlling their source code. When used with TFS, you can take advantage of further enhancements such as automated builds, and workflows.

Tools being discussed, Visual Studio, TFS, Powershell, SQL Server, branching.“

SessionID: 25442

SQL Server Reporting Services 2014 on Steroids!!

Back to calendar

Event Date: 06-09-2014 - Session time: 00:00:00 - Track: BI

Speaker: Steve Simon

Title: SQL Server Reporting Services 2014 on Steroids!!

Abstract:

Reporting requests that are required ‘yesterday or sooner’, oft times necessitate working more efficiently and effectively. We have all been through this at one time or another.

In this hands on presentation we shall be looking some of the more challenging techniques of extracting our data from our Multidimensional and Tabular Models, in addition to our Data Mining Models. We shall be utilizing concepts of ‘Openquery()’ and ‘linked servers’ as a means to extract data, in addition to looking at the way that these two concepts can help us extract our data utilizing MDX, DMX and DAX expressions; AND YET maintain the flexibility and the ability to utilize all those wonderful techniques that may be done with T-SQL.

SessionID: 25463

Database design for mere developers

Back to calendar

Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Dev

Speaker: Steve Simon

Title: Database design for mere developers

Abstract: