Nr: 342
SQLSaturday #342 - Mobile 2014
SessionID: 10788
The Binary Language of Music
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
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
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
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Matthew Roberts
Title: SQL Server Internals
Abstract:
SessionID: 20707
Learn PowerShell or Die! for the DBA
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:
SessionID: 20708
What’s New in PowerShell Version 5?
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
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
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
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Ryan Duclos
Title: Microsoft Azure SQL Database
Abstract:
***It is assumed that you have familiarity with SQL Server.
SessionID: 22747
*** Reporting Services Support /Tips/Tricks ***
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
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Rohn Edwards
Title: Managing Access Control with PowerShell
Abstract:
SessionID: 25850
The Elephant in the Room; A DBA's Guide to Hadoop
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:
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
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Stuart Ainsworth
Title: Managing a Technical Team: Lessons Learned
Abstract:
SessionID: 25852
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Stuart Ainsworth
Abstract:
SessionID: 25924
Windows Server 2012 R2 High Availability for SQL Server
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!
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
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
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
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
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:
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.