sqlsathistory

Nr: 479

Back to Main list

SQLSaturday #479 - South Island NZ 2016

Start Time (24h) Speaker Track Title
10:00:00 Dave Dustin Enterprise Database Administration Deployment Managing and Monitoring SQL Server for $0 without sacrificing functionality, performance or data…
10:00:00 Simon Peck BI Platform Architecture, Development Administration Benefits of SSIS ETL automation with BIML
10:00:00 Martin Catherall Enterprise Database Administration Deployment Moving from Profiler to Extended Events.
10:00:00 Chris Campbell Application Database Development Embracing Database Theft
11:15:00 Dave Dustin Application Database Development SQL Server Window functions – reducing the need for cursors and other horrible stuff
11:15:00 John Martin Enterprise Database Administration Deployment High Availability for SQL Server Standard Edition
11:15:00 Martin Catherall Enterprise Database Administration Deployment A Lap Around Columnstore.
13:15:00 Warwick Rudd Enterprise Database Administration Deployment How Available is SQL Server 2016
13:15:00 Hamish Watson Application Database Development Implementing DevOps methodologies to improve application deployment
13:15:00 Leila Etaati BI Platform Architecture, Development Administration A Journey into Azure Machine Learning
14:30:00 Vijayakumar Thurupathan Application Database Development Protecting your data in the Cloud
14:30:00 Reza Rad BI Platform Architecture, Development Administration Incremental Load using CDC and Integration Service
14:30:00 Rob Douglas Enterprise Database Administration Deployment Hitting the SQL Server "Go Faster" Button
15:35:00 Manohar Punna Enterprise Database Administration Deployment DBA life made easier with SQL Server 2016 - Query Store and LQS
15:35:00 Manjot Kaur Application Database Development Performance Based Indexing
15:35:00 Steve Knutson BI Platform Architecture, Development Administration Business Intelligence for all with Power BI

SessionID: 40559

Managing and Monitoring SQL Server for $0 without sacrificing functionality, performance or data…

Back to calendar

Event Date: 16-04-2016 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Dave Dustin

Title: Managing and Monitoring SQL Server for $0 without sacrificing functionality, performance or data…

Abstract:

One of the most important aspects of DBAs role is making sure your servers and the databases housed on them are up and performing as expected. Not only does this mean reacting if (when) something goes wrong. You need to be proactive and work towards identifying potential issues before they occur. In addition, with proper monitoring you can often identify ways to improve performance for "free"

This session covers using features built into Windows, SQL Server as well as extending with free 3rd-party components and solutions.

SessionID: 45229

Benefits of SSIS ETL automation with BIML

Back to calendar

Event Date: 16-04-2016 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Simon Peck

Title: Benefits of SSIS ETL automation with BIML

Abstract:

Redefining business intelligence ROI is one of Varigences' (The creators of BIML) key headlines. During this "from the field" session we will step through some real life scenarios where BIML was not only cheaper and faster but better than traditional methods of SSIS development.

We'll also explore some less obvious time savers I've discovered while using BIML for BI implementations.

SessionID: 46844

Moving from Profiler to Extended Events.

Back to calendar

Event Date: 16-04-2016 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Martin Catherall

Title: Moving from Profiler to Extended Events.

Abstract:

Profiler has been with us for a long time and it's pretty much the goto tool for a lot of performance related issues but there's been a new tool around for a few years now - actually since SQL SERVER 2008 - but there doesn't seem to have been a big uptake of it. Well, after this session hopefully that will all change for you...

SessionID: 48188

Embracing Database Theft

Back to calendar

Event Date: 16-04-2016 - Session time: 10:00:00 - Track: Application Database Development

Speaker: Chris Campbell

Title: Embracing Database Theft

Abstract:

In a day and age where database theft is becoming increasingly more frequent, why do we continue to be negligent of our duty to protect user data? Why is it that we have a raft of security features made available to us within SQL Server, and strong cryptographic libraries and solid object-relational mapping frameworks at our disposal, but still opt for insecure alternatives? In this session we'll explore the consequences of directing application development down the better known and more convenient path, and why approaching it from the perspective that your data will inevitably be stolen is what will give you the best chance of surviving a breach.

SessionID: 40558

SQL Server Window functions – reducing the need for cursors and other horrible stuff

Back to calendar

Event Date: 16-04-2016 - Session time: 11:15:00 - Track: Application Database Development

Speaker: Dave Dustin

Title: SQL Server Window functions – reducing the need for cursors and other horrible stuff

Abstract:

Window functions have been part of SQL Server since 2005. In 2012, we got some new additions that make performing aggregations, running counts, n-1 / n+1, and much more that could previously only be done with RBAR loops.

This developer focused session describes and details usage of these features, covering theoretical and real world scenarios.

SessionID: 44767

High Availability for SQL Server Standard Edition

Back to calendar

Event Date: 16-04-2016 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment

Speaker: John Martin

Title: High Availability for SQL Server Standard Edition

Abstract:

SQL Server High Availability is normally spoken about with Enterprise Edition features, however not all of us use Enterprise Edition, so what do we have in Standard Edition? In this session we will look at what options we have for building Highly Available systems in Standard Edition.

Looking at how to combine the different features such as clustering, mirroring and the new basic Availability Groups so that you can have much of the capability that you see in Enterprise Edition but without the high cost. I will demonstrate some of the ways that we can build solutions that are accessible to all with design patterns that you can upgrade to Enterprise at a later date if you upgrade your systems.

SessionID: 46843

A Lap Around Columnstore.

Back to calendar

Event Date: 16-04-2016 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Martin Catherall

Title: A Lap Around Columnstore.

Abstract:

Columnstore indexing was first introduced in SQL Server 2012.

The technology was designed to give significant performance gains for datawarehouse queries. This initial version required some creative thinking to get all of the promised performance gains. This meant that adoption rates were not that high. However, SQL Server 2014 added significant functionality, which SQL Server 2016 builds upon. Come along and get a lap around this feature and find out how its adoption could help your organisation. Attendees should leave this session will enough knowledge about the storage, architecture and query enhancements to implement a successful columnstore feature and administer it.

SessionID: 42224

How Available is SQL Server 2016

Back to calendar

Event Date: 16-04-2016 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Warwick Rudd

Title: How Available is SQL Server 2016

Abstract:

Having your SQL Server databases not available for business to be making money is not a good way to stay employed. Do you understand what features and options can assist you with keeping SQL Server Databases Available?

In this session we will look at the options available to you currently to meet your Availability requirements using features being released in SQL Server 2016 to better provide high availability

SessionID: 42486

Implementing DevOps methodologies to improve application deployment

Back to calendar

Event Date: 16-04-2016 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Hamish Watson

Title: Implementing DevOps methodologies to improve application deployment

Abstract:

DevOps is a about aligning SQL Server DBAs and Development teams to utilise agile methodologies and continuous integration to optimise application rollouts.

Hamish will discuss the importance of DevOps in industry and how it is a method to leverage people, processes, and tools to remove barriers and improve service delivery.

DevOps methodologies and culture can help teams to respond faster to competitive pressures by replacing error prone (human) processes with automation so that the experience of production deployments are more repeatable, more reliable and more robust.

In this session, we will look at continuous integration/delivery methods for both applications and databases. Hamish will use a live demo to illustrate the concepts of continuous integration delivery and show the rewards of reliable production deployment.

SessionID: 42823

A Journey into Azure Machine Learning

Back to calendar

Event Date: 16-04-2016 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Leila Etaati

Title: A Journey into Azure Machine Learning

Abstract:

Machine learning provides a facility for companies and governments and not-for-profits companies to replace guesses with a valuable data driven predictive analysis. Azure Machin Learning is valuable tools that can be employed by all data scientist with different skill levels. In this session, a brief description about the azure machine learning, algorithms selection, importing data from different resources, creating web service, using the created web service in a .net project, calling the web service from Excel files, and comparison of the azure Machin Learning with SSAS mining structure approach will be presented. This session will be accompany with demos and provide a full process of data analytics using Azure Machine Learning.

SessionID: 42333

Protecting your data in the Cloud

Back to calendar

Event Date: 16-04-2016 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Vijayakumar Thurupathan

Title: Protecting your data in the Cloud

Abstract:

Are you concerned about moving to cloud, because of the safety of your data ? Organizations choose to go with the platform services of Azure using SQL Databases or they go with the Infrastructure services of Azure using virtual machines, in both cases security of your data is vital. This demo driven session will give you all the information you need to know about the security implementations available in SQL Databases in Azure and SQL Server. The session will cover the following topics with demos. Introduction to cloud adaptation of the organizations, - how enterprises adopt to the cloud and how startups are moving to the cloud. SQL relational store options in Azure. Security features of SQL Databases Cloud demanded security features of SQL Servers Using Azure Key Vault to secure data in SQL Server

SessionID: 46471

Incremental Load using CDC and Integration Service

Back to calendar

Event Date: 16-04-2016 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Reza Rad

Title: Incremental Load using CDC and Integration Service

Abstract:

Incremental Load is one of the main challenges in loading data warehouse. SQL Server Integration Services 2012 comes with Change Data Capture (CDC) components that helps to improve incremental load. CDC can be used with Oracle or SQL Server database.

In this session a brief architecture design for solving incremental load will be discussed and then a real world sample of Incremental will be implemented through a demo with CDC components of SSIS 2012.

SessionID: 48163

Hitting the SQL Server "Go Faster" Button

Back to calendar

Event Date: 16-04-2016 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Rob Douglas

Title: Hitting the SQL Server "Go Faster" Button

Abstract:

Tuning individual queries is incredibly resource intensive. Everyone wants a "Go Faster" button that will improve performance across the entire SQL instance. While there is no sp_gofaster command to run, there are a bunch of magic knobs and switches that can quite often achieve the desired results.

In this session we'll look at some of the things you can do to get the best performance out of your SQL Server workload. You'll leave with a shopping list of things to check and options to try in your environments to get the performance you are after.

SessionID: 42357

DBA life made easier with SQL Server 2016 - Query Store and LQS

Back to calendar

Event Date: 16-04-2016 - Session time: 15:35:00 - Track: Enterprise Database Administration Deployment

Speaker: Manohar Punna

Title: DBA life made easier with SQL Server 2016 - Query Store and LQS

Abstract:

SessionID: 48152

Performance Based Indexing

Back to calendar

Event Date: 16-04-2016 - Session time: 15:35:00 - Track: Application Database Development

Speaker: Manjot Kaur

Title: Performance Based Indexing

Abstract:

SQL server indexes need to be effective so that data could be manipulated with minimum resource consumption. Having too few indexes will result in scanning full tables and having too many indexes will result in incurring un-necessary costs in keeping the index up-to-date. Even if the number of indexes "seem" sufficient, de-fragmenting is only one side of the story. In this session, we will cover index creation best practices and demo sql cache based index tuning, duplicate indexes, and more.

SessionID: 48224

Business Intelligence for all with Power BI

Back to calendar

Event Date: 16-04-2016 - Session time: 15:35:00 - Track: BI Platform Architecture, Development Administration

Speaker: Steve Knutson

Title: Business Intelligence for all with Power BI

Abstract:

It’s a fact, we are now recording and storing more business data than ever before. Whether you are the CFO, Marketing Manager, HR Manager, customer services representative or business owner, you are probably swamped with data that is meaningless unless you spend hours building the mother of all spreadsheets. Power BI allows you to visualise and analyse data from a wide variety of sources, both in-house and off the cloud quickly, easily and at a price everyone can afford.

Learn how Power BI improves your Business Intelligence. In this session Steve demonstrates Power BI dashboards, reports and natural language queries to answer real-world business questions.

This site is open source. Improve this page.