sqlsathistory

Nr: 342

Back to Main list

SQLSaturday #342 - Mobile 2014

Start Time (24h) Speaker Track Title
00:00:00 Brian Rigsby Track 2 The Binary Language of Music
00:00:00 Daniel Rosales Track 3 Aspect Oriented Programming
00:00:00 Glenda Gable Track 3 Data Warehouse Indexes
00:00:00 Matthew Roberts Track 2 SQL Server Internals
00:00:00 Mike Robbins Track 2 Learn PowerShell or Die! for the DBA
00:00:00 Mike Robbins Track 2 What’s New in PowerShell Version 5?
00:00:00 Michael Viron Track 1 Fundamentals of Disaster Planning Recovery
00:00:00 Michael Viron Track 4 Lessons Learned from Starting Software Development Projects
00:00:00 Ryan Duclos Track 1 Microsoft Azure SQL Database
00:00:00 Ryan Duclos Track 1 *** Reporting Services Support /Tips/Tricks ***
00:00:00 Rohn Edwards Track 4 Managing Access Control with PowerShell
00:00:00 Stuart Ainsworth Track 1 The Elephant in the Room; A DBA's Guide to Hadoop
00:00:00 Stuart Ainsworth Track 4 Managing a Technical Team: Lessons Learned
00:00:00 Stuart Ainsworth Track 1 What's in your toolbelt?
00:00:00 Sven Aelterman Track 2 Windows Server 2012 R2 High Availability for SQL Server
00:00:00 William E Pearson III Track 3 Design and Implement BI like Edison!
00:00:00 William E Pearson III Track 3 Getting Started with MDX
00:00:00 Robert Cain Track 4 Zero to Hero with PowerShell and SQL Server in 1 Session
00:00:00 Robert Cain Track 1 Introducing the SSAS 2012 BI Semantic Model, aka Tabular
00:00:00 Robert Cain Track 4 Everything You Ever Knew About SSIS Is Null and Void

SessionID: 10788

The Binary Language of Music

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Brian Rigsby

Title: The Binary Language of Music

Abstract:

Take a fascinating journey into how our minds work and discover how binary and mathematical patterns found in music can be used to learn the underlying language of music theory.

SessionID: 12183

Aspect Oriented Programming

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Daniel Rosales

Title: Aspect Oriented Programming

Abstract:

Have you heard of cross-cutting concerns? Do you fret about making the slightest change to your code-base? How does the sound of a new requirement make you feel? If you answered positively to any of the aforementioned questions, you will want to learn about AOP. AOP is a technique for localizing your cross-cutting concerns, such as transactions, security, logging and prevent them from littering what your code was originally intended to handle, namely, your business. Don't let cross-cutting concerns strangle your code base. Come learn about the PostSharp library, a library for the .NET framework that will aid you in keeping your code clear of cross-cutting concerns.

SessionID: 14577

Data Warehouse Indexes

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Glenda Gable

Title: Data Warehouse Indexes

Abstract:

A datawarehouse environment is used differently than a transactional environment, so architecture and indexing strategies should also be different. In this presentation, we review what the ultimate goal of an index really is, what the point of a data warehouse is, and how they relate to each other. You will also learn common practices for indexing the different types of warehouse tables, specifically dimension tables, fact tables, and staging tables. We will review cases when it is useful to have summary level fact tables, in addition to detail level fact tables. Then, lastly, we will look at the benefits, and gotchas, of using columnstore indexes.

SessionID: 19839

SQL Server Internals

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Matthew Roberts

Title: SQL Server Internals

Abstract:

A semi-deep dive into the internal parts of SQL Server that make it work including system tables, Information Schema views, and how table definitions, stored procedures, etc. are really stored and managed. Find out why everything you know about databases is an elaborate illusion.

SessionID: 20707

Learn PowerShell or Die! for the DBA

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Mike Robbins

Title: Learn PowerShell or Die! for the DBA

Abstract:

Learn PowerShell or Die! That is, learn PowerShell or your career in IT will die. PowerShell is one of those technologies that as a DBA you’ll either love or hate, but believe it or not DBA’s already have the mindset for scripting since you live and work with T-SQL day in and day out. During this session, scripting games winner Mike F Robbins will demonstrate the different methods of retrieving information from your SQL Servers to include a way to simply wrap your existing T-SQL code inside of a PowerShell one-liner, working with SQL Server in PowerShell as if it were a file system, and creating reusable tools via functions in PowerShell that use SMO to retrieve just about any information about your SQL Servers that you could imagine.

SessionID: 20708

What’s New in PowerShell Version 5?

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Mike Robbins

Title: What’s New in PowerShell Version 5?

Abstract:

With PowerShell version 4 being announced at TechEd last year and two preview versions of PowerShell version 5 already being released this year, it shows how committed Microsoft is to PowerShell and that it’s not going away any time soon which is why you can’t afford to ignore PowerShell or put off learning it any longer. During this session, scripting games winner Mike F Robbins will cover the new features that are in the preview version of PowerShell version 5 to include the cmdlets in the OneGet module, the NetworkSwitch module, the PowerShellGet module and much more that you’ll have to come to this session to find out about! This session is based off of a preview version of PowerShell version 5 so everything shown is subject to change.

SessionID: 21249

Fundamentals of Disaster Planning Recovery

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Michael Viron

Title: Fundamentals of Disaster Planning Recovery

Abstract:

In this session, we'll cover the basics of Disaster Planning and key operational items to consider when establishing software systems. We'll cover terms and their importance as well as commonly used software and hardware techniques for disaster planning purposes.

SessionID: 21250

Lessons Learned from Starting Software Development Projects

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Michael Viron

Title: Lessons Learned from Starting Software Development Projects

Abstract:

In this session we'll cover key lessons learned from both creating new divisions, product launches, and starting new organizations. These can help speed up the initial startup phases, decrease expenses, and build a successful team-based environment.

SessionID: 22745

Microsoft Azure SQL Database

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Ryan Duclos

Title: Microsoft Azure SQL Database

Abstract:

SQL Database is part of the Microsoft Azure platform. The SQL Database component provides the relational database functionality of SQL Server, but it also provides functionality as a cloud-computing service, hosted in Microsoft data-centers around the globe. We will go over how it works and what it has to offer, as well as some of the differences and limitations.

***It is assumed that you have familiarity with SQL Server.

SessionID: 22747

*** Reporting Services Support /Tips/Tricks ***

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Ryan Duclos

Title: *** Reporting Services Support /Tips/Tricks ***

Abstract:

I challenge you to bring your SSRS report issues to this session. Together we will try to find a way to solve your reporting issues. To help with solving your reporting issues, it would be great if you could bring the t-sql scripts to create the required schema and data. It would also be great to bring the report files that need to be updated.

If you don't have any reporting issues, I'll have a few reports to show you. These reports are a lot more complex then most of the reports you need to create. Though they will demonstrate some tips and tricks.

SessionID: 23424

Managing Access Control with PowerShell

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Rohn Edwards

Title: Managing Access Control with PowerShell

Abstract:

Access control in Windows, while very powerful, can be very complicated. Working with security descriptors one object at a time through the GUI is fairly straightforward, but that doesn’t help when you need to verify and/or configure settings for multiple objects at the same time. There are utilities available to handle this in an automated fashion, but most only work with certain types of objects, and they each have their own syntax. Fortunately, PowerShell has the ability to replace most, if not all, of those utility applications. In this session, we'll cover ways to use PowerShell to view and edit access control lists for almost any object in Windows that is secured with a security descriptor, including files, folders, registry keys, services, processes, WMI namespaces, Active Directory objects, and more. We'll cover using both native PowerShell commands, .NET methods, and the free PowerShell Access Control script module.

SessionID: 25850

The Elephant in the Room; A DBA's Guide to Hadoop

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Stuart Ainsworth

Title: The Elephant in the Room; A DBA's Guide to Hadoop

Abstract:

The term "Big Data" has risen to popularity in the last few years, and encompasses data platforms outside of the traditional RDBMS (like SQL Server). The purpose of this session is to introduce SQL Server DBA's to Hadoop, and to promote understanding of how schema-less data can be collected and accessed in coordination with the traditional SQL models. We'll cover the basic vocabulary of the Hadoop platform, Microsoft's integration efforts, and demonstrate how to get started with "big data".

You can download my slides at: http://codegumbo.com/index.php/code-etc/

Please follow me on twitter: https://twitter.com/codegumbo

SessionID: 25851

Managing a Technical Team: Lessons Learned

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Stuart Ainsworth

Title: Managing a Technical Team: Lessons Learned

Abstract:

I got promoted to management a couple of years ago, and despite what I previously believed, there were no fluffy pillows and bottles of champagne awaiting me. My team liked me, but they didn't exactly stoop and bow when I entered the room. I've spent the last year relearning everything I thought I knew about management, and what it means to be a manager of a technical team. This session is intended for new managers, especially if you've come from a database (or other technical) background.

SessionID: 25852

What's in your toolbelt?

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Stuart Ainsworth

Title: What's in your toolbelt?

Abstract:

This session is intended to cover some basic database administration tasks and some different approaches to monitoring, deployment, and scripting. We'll use the Red Gate Toolbelt to address some basic problems, but we'll also discuss these challenges from a more general layer. We'll also cover some basic performance tuning, and discuss how baseline analysis can help in quickly identifying problems.

SessionID: 25924

Windows Server 2012 R2 High Availability for SQL Server

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Sven Aelterman

Title: Windows Server 2012 R2 High Availability for SQL Server

Abstract:

With the increasing adoption rate of virtualization, creating SQL Server clusters is now within reach of many more DBAs. What do you need to know about Windows Server 2012 (R2) virtualization and high availability to set up your first cluster? What's needed for geo-clustering? Come learn from a Windows Server admin and (accidental) DBA who's been building SQL Server clusters since 2000 (the year and the version!). We'll discuss initial planning, the process and the maintenance best practices. There will be demos too, so if you want to see a multi-node SQL cluster run on a Lenovo X230 tablet, come see (it's pretty cool!).

SessionID: 28162

Design and Implement BI like Edison!

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: William E Pearson III

Title: Design and Implement BI like Edison!

Abstract:

As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence.

SessionID: 28164

Getting Started with MDX

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: William E Pearson III

Title: Getting Started with MDX

Abstract:

In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets. This session applies equally to Analysis Services 2008, 2008R2 and 2012.

SessionID: 9730

Zero to Hero with PowerShell and SQL Server in 1 Session

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Robert Cain

Title: Zero to Hero with PowerShell and SQL Server in 1 Session

Abstract:

There are two kinds of people in the SQL Server world. Those who are using PowerShell, and those that will be. In this session you'll learn how to become one of the "cool kids" using PowerShell.

We'll begin with a super fast paced introduction to PowerShell starting with a quick overview of the two environments you can use PowerShell in, command windows and the ISE (Integrated Scripting Environment). Next you'll learn about cmdlets, variables, functions, and logic flow. But wait, there's more! After that we'll learn how to interact with SQL Server using the SQL Provider. For the last dance we limbo, going low level with the the SQL Managment Object library, also known as SMO.

Don't be left behind, learn how to leverage the power of PowerShell in your SQL Server environment.

SessionID: 9732

Introducing the SSAS 2012 BI Semantic Model, aka Tabular

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Robert Cain

Title: Introducing the SSAS 2012 BI Semantic Model, aka Tabular

Abstract:

New to SQL Server Analysis Services 2012 is the BI Semantic Model, also known as the Tabular model. In this session you'll learn about the newest way to do analytics in SQL Server. We'll compare and contrast it with the traditional Multidimensional Model, then see how to create your first "cube" using the Tabular mode. Finally we'll look at some of the reporting options for using your new Tabular database, including SSRS, Excel, and PowerView.

SessionID: 9733

Everything You Ever Knew About SSIS Is Null and Void

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Robert Cain

Title: Everything You Ever Knew About SSIS Is Null and Void

Abstract:

With the release SQL Server Integration Services 2012, Microsoft did a massive overhaul to the deployment platform for SSIS. Gone is the old file based deployment system and MSDB. New to SSIS is the Integration Services Catalog.

Along with the catalog came many new improvements, such as package and project parameters. No longer do you have to mess around with ugly configuration files, or the mess of passing data between packages. Also included are new reports which you can use to examine your packages as they run, or see the status of past runs.

In this session we'll look at how the new project based deployment model simplifies your SSIS coding. We'll also take a dive into the catalog, uncovering the wealth of information it can provide.