Pre-Conference

The pre-conference at SQL Server Days 2013 will have a BI, Dev, DBA and Big Data track all presented by top speakers.

Overview

BI track: Languages of BI by Stacia Misner
Dev track: From SQL Traces To Extended Events by Mladen Prajdic
DBA track: Real World Database Configuration and Tuning for SQL Server 2012 by Kevin Kline
Cloud track: How to become the DBA of the Future by Thomas Larock & Dandy Weyn
Big Data track: Big Data vs Many data, with a deep dive into the PDW by Mark Stacey

 

BI track: Languages of BI by Stacia Misner

To get the most of the presentation layer tools in the Microsoft BI stack when data sources include cubes, PowerPivot workbooks, and data mining models, you can’t rely solely on your T-SQL skills.
To produce high-performing reports and analytical tools, you’ll need to use other query languages like MDX, DAX, or DMX. In this workshop, you’ll learn which languages each presentation layer tool supports and the basic syntax used by each language.
You’ll also learn how take advantage of query builder tools to help you produce queries until you’ve developed the proficiency to create more complex queries on your own.
You’ll also learn how to work with expressions to add calculations to cubes and PowerPivot workbook, and how to use expressions to customize the appearance of reports, scorecards, and dashboards.

Dev track: From SQL Traces To Extended Events by Mladen Prajdic

This pre-con will give you deep insight into both of the current tracing technologies in SQL Server. The old SQL Trace which has served us well over the past 10 or so years is on its way out because the overhead and details it produces are no longer enough to deal with today’s loads.
The new Extended Events are a new lightweight tracing mechanism built directly into the SQLOS thus giving us information SQL Trace just couldn’t. They were designed and built with performance in mind and it shows.
Mastering Extended Events requires learning at least one new skill: XML querying. We will show you how to do that plus things you can do with them that you simply couldn’t do with SQL Trace. This demo and info heavy pre-con will get you ready for the new way to see what’s going on in your servers.

DBA track: Real World Database Configuration and Tuning for SQL Server 2012 by Kevin Kline

This full-day training event combines a thorough overview of key concepts followed by hands-on demos to reinforce each conceptual lesson. Since most technologists learn by doing, this training is designed to maximize the time attendees spend working with SQL Server. With ample demos, we’ll cover the spectrum of best practices as they relate to server and database design & configuration and performance tuning.

At the conclusion of the training, attendees will understand:

  • The internals and architecture of SQL Server and how they interact during read and, separately, during write operations, including an overview of SQL Server caches, memory buffering and clean-up processes, and user activity handling.
  • An introduction to bare-metal tuning of server hardware and storage configurations for database applications, including DASD, RAID, SSD, and SAN architectures.
  • Important Windows and SQL Server configuration settings and trace flags, including special considerations for SQL Server running on VMs.
  • Methods for benchmarking the performance of alternative configurations and settings.
  • Designing databases for performance through indexing, statistics and cardinality, data types, and recovery mode.
  • Monitoring and identifying performance bottlenecks and resolving performance issues, including PerfMon, traces and extended events, Dynamic Management Views (DMVs) and Wait Statistics.
  • Advanced database structures including “Hekaton” in-memory tables and Columnstore indexes.

Cloud track: How to become the DBA of the Future by Thomas Larock & Dandy Weyn

In the world of Hybrid IT, with data residing on premise and in the cloud, Database Administrators play an important role in application architecture and design. In this pre-conference we cover the changing DBA tasks to support on-premise and cloud-based performance tuning and monitoring, as well as how to implement High Availability and Disaster recovery scenarios. This pre-conference highlights the SQL Server Data Platform and the Windows Azure SQL Database as the data platform and architecture of choice for current and future database projects. Attendees are provided with scripting, demo recordings, and slide decks.

Big Data track: Big Data vs Many data, with a deep dive into the PDW by Mark Stacey

Big data is the marketing term du jour, but what is it really? As a broad umbrella term, it can be misleading, and many so-called “big data problems” are what I would call many data problems. In this session, I will take you through big data, many data, scale out in operational and reporting systems, and then dive into my personal favorite piece of the big data tools – Microsoft’s Parallel Data Warehouse, and talk about my experiences working on this technology.

  • Introduction
  • The field at large
    • Big data problems
    • 3 Vs
    • Big data vs many data
    • Sources of big data
  • Science
  • Machine/sensor data
  • Social media
  • Unstructured corporate data
    • Scaling operational systems
    • SMP and NUMA
    • CAP
    • Complex event processing
    • Messaging
    • Distributed systems
    • Hashes
    • Scaling reporting systems
      • OLAP
      • Map Reduce
      • NoSQL
      • Column store and in-memory
      • MPP
  • Intro to PDW
    • Shared nothing Architecture
    • Hardware – what is it?
    • Software – it’s SQL and yet it’s not
    • Data layout examples
  • Working on a PDW
    • Configuration manager
    • SSMS
    • Appliance Updates
  • Loading data
    • ELT vs ETL
    • DWLoader
    • SSIS
    • DSQL
    • Polybase as an ETL tool?
  • Database design and optimisation
    • Distribution vs replication
    • Heaps
    • Clustered Indexes
    • Non-clustered indexes – index lite
    • Clustered columnstore
    • Statistics, statistics, statistics
  • Differences from T-SQL
    • Datatypes
    • Distribution
    • Update/Delete
    • CTAS
    • Cursors and while loops
    • Functions
  • Anatomy of my first migration to a PDW
 

Confio Software


find_us_on_fb_badge
SQL Server Days 2013 is brought to you by the Belgian SQL Server User Group (SQLUG.be VZW) in collaboration with Microsoft Belux.


Get Adobe Flash player