sqlsathistory

Nr: 234

Back to Main list

SQLSaturday #234 - Baton Rouge 2013

Start Time (24h) Speaker Track Title
00:00:00 Cade Roux SQL Dev Get a Lever and Pick Any Turtle: Lifting with Metadata
00:00:00 Christine Assaf CIO/CTO/IT Manager Interview Tips for Managers
00:00:00 Christine Assaf Career Development Mastering your Resume Interview: Tips to Get Hired
00:00:00 Cody Gros SharePoint Building an Intranet SharePoint 2013 Style
00:00:00 Corey Roth SharePoint Configuring SharePoint Search for an optimal document management experience
00:00:00 Cory Hutchinson Business Intelligence Foundations SQL 2012 OLAP vs Tabular Modeling
00:00:00 Chris Wolfley SQL DBA Foundations Improving Performance, Backups, and the Development Lifecycle with Centralized Storage
00:00:00 Daniel Hillis SQL Dev Get your feet wet with Hadoop on Azure
00:00:00 David Reid Career Development How to Prepare Conduct Technical Presentations
00:00:00 Devlin Liles Dev .NET Foundations Data Access 0-120 : Because 60 just won't do
00:00:00 Glenda Gable Business Intelligence Foundations The ABCs of SSIS
00:00:00 Jaisson Mailloux SQL DBA Foundations SQL Licensing White Board Session
00:00:00 James Sampson Dev Web/Mobile Who Could Ask for More with LESS CSS?
00:00:00 James Sampson Dev .NET Foundations Visual Studio Productivity Tips and Tricks
00:00:00 Jameson Bozeman SharePoint Building Resilient Workflows in SharePoint 2013
00:00:00 Jason Tate Dev Web/Mobile Multiplatform Development with Unity 3D and C#
00:00:00 Jeremy Beckham Dev .NET Foundations Moving to XAML
00:00:00 Jeremy Cronan Dev .NET/ALM Using Team Foundation 2012 for Agile Project Management
00:00:00 Jennifer McCown SQL Dev Beginning T-SQL
00:00:00 J Sawyer Dev App Support StreamInsight in action: Monitoring website performance in real time
00:00:00 J Sawyer Dev .NET Foundations Back to Basics: .NET Essentials You May have Forgotten
00:00:00 Keith Elder Dev .NET/ALM Building an English-Based Rules Engine using the Dynamic Language Runtime and IronRuby
00:00:00 Mark Verret Business Intelligence Advanced Introduction to SQL Spatial Analysis and Reporting
00:00:00 Mark Verret Business Intelligence Foundations Data cleaning with SSIS - SQL 2012
00:00:00 Mike Byrd Business Intelligence Advanced Change Tracking: A Near Bullet-Proof ETL Synchronization Control
00:00:00 Matt Hester PowerShell PowerShell Not Your Father's Command Line 10 things you need to know
00:00:00 Matt Hester Windows Server Infrastructure Windows Azure IaaS and You
00:00:00 Mike Huguet Dev .NET Foundations Getting Started with C#
00:00:00 Mike Huguet Dev App Support When Things Go Wrong in My Code
00:00:00 Mike Clement Dev .NET/ALM Power of Patterns: Refactoring to (or away from) Patterns
00:00:00 Mike Clement Dev .NET/ALM Agile Games: Games with Cards and Dice
00:00:00 Mike Robbins PowerShell PowerShell Fundamentals for Beginners
00:00:00 Mike Huguet Dev App Support What's it like to Work for Microsoft?
00:00:00 Neil Hambly Dev Web/Mobile Advanced Performance Tuning Tips with Ignite
00:00:00 Nicholas Jones Windows Server Infrastructure SCCM 2012 High Availability
00:00:00 Ryan Duclos Dev Web/Mobile Web Sites on Windows Azure
00:00:00 Rusty Frioux Business Intelligence Foundations Analytics 101 : Big data, business intelligence, and predictive analytics for decision makers
00:00:00 Ryan Adams SQL DBA Foundations SQL 2012 AlwaysOn Quickstart
00:00:00 Ryan Adams SQL DBA Foundations AlwaysOn Live Deployment
00:00:00 Sean McCown PowerShell Beginning Powershell for DBAs 1.0
00:00:00 Sean McCown PowerShell Beginning Powershell for DBAs 1.5
00:00:00 Stephen Fulcher Dev App Support High Traffic Web Services
00:00:00 Stephen Fulcher Dev App Support Application Instrumentation
00:00:00 Steve Schaneville Dev App Support Unit Tests in Action – an exercise in updating legacy code, and how unit tests play a critical role
00:00:00 Steven Rachui Windows Server Infrastructure ConfigMgr 2012 - Whats the big deal?
00:00:00 Steven Rachui Windows Server Infrastructure Troubleshoot ConfigMgr 2012 like a pro
00:00:00 Sven Aelterman Business Intelligence Advanced Managing the SQL Server 2012 SSIS catalog (SSISDB)
00:00:00 Sven Aelterman SQL Dev Configuring and Managing FILESTREAM and FileTable
00:00:00 Stacy Vicknair Career Development Toastmasters Demo Meeting
00:00:00 Theresa Eller SharePoint Who Moved My SharePoint (to 2013)?
00:00:00 Thomas LeBlanc SQL Dev Execution Plan Basics - Beginners
00:00:00 Thomas LeBlanc Business Intelligence Advanced Attributes Hierarchies in Analysis Services 2012
00:00:00 Tim Rayburn Dev .NET/ALM Install-Package Your.Architecture
00:00:00 Tim Rayburn PowerShell Intro PowerShell for Technologists
00:00:00 Seth Valdetero Dev Web/Mobile iPhone Apps in C#
00:00:00 Bill Watters SharePoint Bringing Business Intelligence to SharePoint Users
00:00:00 William E Pearson III Business Intelligence Advanced Getting Started with Analysis Services 2012 Tabular
00:00:00 William E Pearson III Business Intelligence Foundations Practical Self-Service BI with Excel 2013
00:00:00 George Mauer Dev Web/Mobile Let's Learn Knockout
00:00:00 Wesley Brown SQL DBA Foundations Understanding Storage Systems and SQL Server

SessionID: 11151

Get a Lever and Pick Any Turtle: Lifting with Metadata

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: SQL Dev

Speaker: Cade Roux

Title: Get a Lever and Pick Any Turtle: Lifting with Metadata

Abstract:

Get a Lever and Pick Any Turtle: Lifting with Metadata

Ever wondered how to do operations on a list of tables? Get a list of all the columns over a certain length? Automate tedious writing of repetitive code if only there was a way to tell the query to just do this for all VARCHAR columns?

Integrated metadata is a required element of all RDBMSs. In addition to ANSI INFORMATION_SCHEMA and metadata on implementation-specific features like indexes, SQL Server also offers a very powerful extended properties feature. In this talk, I cover using the basic metadata combined with extended properties and demonstrate some practical usages to organize and document a system's design and monitor the health of a system's compliance with design rules, but there are many uses of the system metadata for code generation and automating maintenance.

Basic knowledge of T-SQL and relational database principles is assumed.

SessionID: 11628

Interview Tips for Managers

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: CIO/CTO/IT Manager

Speaker: Christine Assaf

Title: Interview Tips for Managers

Abstract:

If you are a Manager needing some interviewing education - this is your course! This session focuses on basic interviewing guidelines, including: preliminary interviews, types of testing, secondary or follow-up interviews, while keeping in mind EEO guidelines and best practices. Learn tips and tricks of the trade from an HR guru who is "in the trenches."

SessionID: 11630

Mastering your Resume Interview: Tips to Get Hired

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Career Development

Speaker: Christine Assaf

Title: Mastering your Resume Interview: Tips to Get Hired

Abstract:

Looking for a job? Learn trade secrets from a Recruiter! Resume blunders and interview tips, this session will focus on ten most important things you can do to get hired.

SessionID: 11738

Building an Intranet SharePoint 2013 Style

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: SharePoint

Speaker: Cody Gros

Title: Building an Intranet SharePoint 2013 Style

Abstract:

SessionID: 11868

Configuring SharePoint Search for an optimal document management experience

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: SharePoint

Speaker: Corey Roth

Title: Configuring SharePoint Search for an optimal document management experience

Abstract:

Search in SharePoint 2013 has many new features to deliver an excellent document management experience. In this talk, we'll learn how to take advantage of the hard work you have invested in classifying your documents with rich metadata. Administrators will learn step-by-step how to map crawled properties to managed properties allowing you to query and refine on the data in your site columns. We'll look in depth at managed property options such as queryable, retrievable, and refinable. Once we demonstrate the intricacies of property mapping, attendees will learn how to take advantage of them in the Search Center. We'll create custom result types to display custom data from site columns and we'll configure the refinement panel to allow users to drill down results in ways never before possible. Finally, we'll show you how to use entity extraction to infer values of metadata allowing you to do refinement.

SessionID: 11872

SQL 2012 OLAP vs Tabular Modeling

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Business Intelligence Foundations

Speaker: Cory Hutchinson

Title: SQL 2012 OLAP vs Tabular Modeling

Abstract:

The Highway Safety Research Group at Louisiana State University, funded by the Louisiana Department of Transportation and Development (LA DOTD), collects and analyzes traffic crash data for the state of Louisiana. Over the past few years, a major focus was placed on decreasing the time it takes to report crash data to the state. With the success of data collection efforts, the HSRG is now focusing on providing tools and resources to help agencies at all levels throughout the state better understand and utilize their crash data.

In 2011, the HSRG developed an OLAP cube for 'slicing and dicing' crash, DWI, and Roadway data to improve traffic safety. In 2013, the HSRG, utilizing the same data warehouse, built a very similar tool utilizing the new BISM Tabular Model in SQL 2012. This session will show the two models, discuss advantages disadvantages of each model, and present data reporting options (Reporting Services, Tableau, and Power View).

SessionID: 12122

Improving Performance, Backups, and the Development Lifecycle with Centralized Storage

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: SQL DBA Foundations

Speaker: Chris Wolfley

Title: Improving Performance, Backups, and the Development Lifecycle with Centralized Storage

Abstract:

Nimble Storage arrays provide I/O optimization and protection features that greatly benefit SQL Server implementations. It is important to first understand some of the internal I/O processes that SQL Server uses to store data on disk. Then you can use this fundamental understanding to implement best practices for provisioning a database storage design that will optimize performance and eliminate database backup windows. Using these best practices can also dramatically reduce recovery time objectives for full databases as well as individual database objects and data after user error and system failures.

SessionID: 12180

Get your feet wet with Hadoop on Azure

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: SQL Dev

Speaker: Daniel Hillis

Title: Get your feet wet with Hadoop on Azure

Abstract:

Using Hadoop to process large amounts of data doesn't get easier than using Hive and Pig in Azure. In this session I will demonstrate just how easy it can be to unleash distributed processing on your data.

SessionID: 12320

How to Prepare Conduct Technical Presentations

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Career Development

Speaker: David Reid

Title: How to Prepare Conduct Technical Presentations

Abstract:

Iiiustrating how/what to do to in preparing information for and conducting/presenting an Technical Presentation..

SessionID: 13233

Data Access 0-120 : Because 60 just won't do

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Dev .NET Foundations

Speaker: Devlin Liles

Title: Data Access 0-120 : Because 60 just won't do

Abstract:

In this session we will be diving into the data access architecture of modern applications and how we can make these more reusable and testable. We will leverage several open source frameworks to make this much quicker to build and deploy.

SessionID: 14571

The ABCs of SSIS

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Business Intelligence Foundations

Speaker: Glenda Gable

Title: The ABCs of SSIS

Abstract:

This presentation shows the basics of SSIS to help with automating database tasks, such as maintenance, importing and exporting data, or ETL transactions. The discussion will start with an understanding of when SSIS should be used vs. when a database object, such as a view or stored procedure, should be used. You will also see how to create a basic package, and how to use the built-in logging and configurations. Lastly, we will talk about the different ways SSIS is used, based on the role of the person using it and the importance of organizing the overall SSIS structure.

SessionID: 15526

SQL Licensing White Board Session

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: SQL DBA Foundations

Speaker: Jaisson Mailloux

Title: SQL Licensing White Board Session

Abstract:

SQL Licensing? How boring. What if we told you that one of the most significant changes in SQL Server 2012 is around licensing. Yes, software licensing can be dreadful, but one misstep could cost your company thousands of dollars! During this presentation we will NOT show a single PowerPoint slide ... instead we will whiteboard the SQL 2012 licensing changes, illustrate ways you can save money by understanding how to take advantage of virtualization rights, and we will also make sure you do NOT over license. Yes, that is correct, we will show you how to ensure you do NOT over license.

SessionID: 15537

Who Could Ask for More with LESS CSS?

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Dev Web/Mobile

Speaker: James Sampson

Title: Who Could Ask for More with LESS CSS?

Abstract:

In this session, I will cover getting started with an ASP.NET MVC4 site, and using the LESS CSS engine instead of plain-old-CSS. Using LESS CSS, you can turbo charge your design, layout, and branding of a site, increasing the amount of time that you have to work on other requirements.

SessionID: 15538

Visual Studio Productivity Tips and Tricks

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Dev .NET Foundations

Speaker: James Sampson

Title: Visual Studio Productivity Tips and Tricks

Abstract:

Development in Visual Studio can either be slow as a rock, or fast as a cheetah. In this speech, I hope to be able to give some efficiency tips that have come to help me. I will touch base on some Visual Studio Extensions that are useful, Keyword usage, web.config transforms, deployment techniques – with a side step into a Windows Azure deployment concern. This speech will be geared more towards introductory to intermediate developers, but I hope to be able to give everyone a couple of helpful tips they might not have known before.

SessionID: 15560

Building Resilient Workflows in SharePoint 2013

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: SharePoint

Speaker: Jameson Bozeman

Title: Building Resilient Workflows in SharePoint 2013

Abstract:

SharePoint Designer workflows have made a huge leap forward in the newest version of SharePoint. After discussing some of the key improvements with SharePoint 2013 Workflows, we will take a look at ways to create workflows that are scalable, resilient to errors and flexible to changes.

SessionID: 15778

Multiplatform Development with Unity 3D and C#

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Dev Web/Mobile

Speaker: Jason Tate

Title: Multiplatform Development with Unity 3D and C#

Abstract:

An introduction to the Unity 3D video game engine, a state of the art tool for game and application development. I will demonstrate the ease at which you can develop games across PC, web, and mobile platforms, all for free.

SessionID: 16033

Moving to XAML

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Dev .NET Foundations

Speaker: Jeremy Beckham

Title: Moving to XAML

Abstract:

XAML has been around for several years now, but most developers haven't had to use it yet. As Microsoft pushes Windows Store applications and Windows Phone, that is going to change.

We'll cover: Differences between Windows Forms and XAML Basic layout of a XAML UI Binding in XAML Very basics of MVVM

This presentation will introduce intermediate+ C# developers to XAML.

SessionID: 16142

Using Team Foundation 2012 for Agile Project Management

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Dev .NET/ALM

Speaker: Jeremy Cronan

Title: Using Team Foundation 2012 for Agile Project Management

Abstract:

Using Team Foundation 2012 and Visual Studio 2012 for Agile or regular Project Management. Focuses on the tools offered by Team Foundation 2012 including the web interface and tools in Visual Studio 2012 to manage tasks and bugs. Will also look at Microsoft Test Manager and how it connects with TFS. Knowledge of Agile Developer is a plus to understand some terminology for this session but is not necessary.

SessionID: 16474

Beginning T-SQL

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: SQL Dev

Speaker: Jennifer McCown

Title: Beginning T-SQL

Abstract:

If you'd like to become a database professional - or if you already work with SQL Server at all - you need to know Transact-SQL, the SQL Server programming language. During this session, we’ll design and create our own table to demonstrate key concepts, query syntax, and more. If you’ve been meaning to learn T-SQL, here’s your chance!

SessionID: 17633

StreamInsight in action: Monitoring website performance in real time

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Dev App Support

Speaker: J Sawyer

Title: StreamInsight in action: Monitoring website performance in real time

Abstract:

You may have heard of StreamInsight but what can it be used for? While there are a wide variety of use cases, we will look at one in particular ... how to monitor your website in real time with StreamInsight. In this session, we'll hook into the ASP.NET pipeline to send information to StreamInsight and integrate diagnostic information from Windows into a single dashboard of your website's performance as it is running. We'll see how StreamInsight can provide valuable analytics that allow you to gain valuable information ... not from web or event logs after the fact ... but while your site is running and you can respond to potential issues before they become visible to your users.

SessionID: 17635

Back to Basics: .NET Essentials You May have Forgotten

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Dev .NET Foundations

Speaker: J Sawyer

Title: Back to Basics: .NET Essentials You May have Forgotten

Abstract:

Now that the .NET Framework has been out for 10 years and so many tools are available to make things easier, many developers seem to have forgotten some of the core principles of .NET. In this presentation, I'll review the fundamentals of the .NET Framework and what makes all of that magic happen. From the CLR to IL to memory management and garbage collection, we'll touch on these core concepts that every developer should know.

SessionID: 18040

Building an English-Based Rules Engine using the Dynamic Language Runtime and IronRuby

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Dev .NET/ALM

Speaker: Keith Elder

Title: Building an English-Based Rules Engine using the Dynamic Language Runtime and IronRuby

Abstract:

In this session we will explore writing an English-based rules engine that allows developers to create domain-specific rules for an application that can be easily understood by anyone. We will use a combination of C# and the DLR (dynamic language runtime) with IronRuby on the .NET platform to create a way to write, manage, and process rules for an application.

SessionID: 19626

Introduction to SQL Spatial Analysis and Reporting

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Business Intelligence Advanced

Speaker: Mark Verret

Title: Introduction to SQL Spatial Analysis and Reporting

Abstract:

Most all data captured today is tied in some way to spatial elements. SQL Server has powerful functionality that will allow you to leverage this information to get deeper insights and make better decisions. We will walk through demonstrations of basic reporting and analysis involving place data. We will use "in house" analytical/spatial data along with openly available spatial data. Demos will show the various spatial functions for data analysis along with reporting using reporting services, powerview, and geoflow.

SessionID: 19627

Data cleaning with SSIS - SQL 2012

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Business Intelligence Foundations

Speaker: Mark Verret

Title: Data cleaning with SSIS - SQL 2012

Abstract:

Having clean data is a critical component in data warehousing and business intelligence systems. With the release of SQL Server 2012 Microsoft has provided a powerful tool to help organizations in tackling their data quality issues. We will look at this new Data Quality Services tool, its strengths and weaknesses. We will also looks at some customizations that can be built to handle some tasks better, such as pattern matching. The focus will be on how SSIS can help clean the data that will eventually end up in your warehouse.

SessionID: 19938

Change Tracking: A Near Bullet-Proof ETL Synchronization Control

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Business Intelligence Advanced

Speaker: Mike Byrd

Title: Change Tracking: A Near Bullet-Proof ETL Synchronization Control

Abstract:

Change Tracking came out with SQL Server 2008, but SS2012 almost eclipsed it with Change Data Capture. Change Tracking is now the red-headed step child, but in many cases may be a better solution for data ETL movement from an OLTP database to a data warehouse database. This session will provide a review of change tracking syntax and implementation with detailed demos. It will then dive into an actual ETL subset implementation from the AdventureWorks database to a data warehouse solution (modified AdventureWorksDW) with detailed code discussion and demos.

SessionID: 20143

PowerShell Not Your Father's Command Line 10 things you need to know

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: PowerShell

Speaker: Matt Hester

Title: PowerShell Not Your Father's Command Line 10 things you need to know

Abstract:

Are you scared of PowerShell or do you think PowerShell is just another command line prompt? Have you used PowerShell? Do you even know how to start with PowerShell? You will learn the basics of PowerShell and what it can do for you!. You will learn how PowerShell combined with your applications can help save you time and money.

SessionID: 20144

Windows Azure IaaS and You

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Windows Server Infrastructure

Speaker: Matt Hester

Title: Windows Azure IaaS and You

Abstract:

Cloud computing is emerging as a promising IT service delivery vehicle. But is the question “To cloud or not to cloud”? For IT professionals and your IT organizations, it is crucial to recognize the opportunities and play a key role in the transformation from existing infrastructure-focused IT into a service-oriented, user-centric, and IT-as-a-Service (IaaS) environment. Are you ready for the challenge to lead and transform your IT organization?

This session will clarify the myths and provide pertinent information on cloud computing from a business and IT professional’s viewpoint. We will review the architectures and examine the service delivery models of cloud computing while stepping through business scenarios and operations of employing public cloud and private cloud.

SessionID: 20434

Getting Started with C#

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Dev .NET Foundations

Speaker: Mike Huguet

Title: Getting Started with C#

Abstract:

In this session we will cover some of the basics of the .NET framework, C#, and Visual Studio. This session is just right for those learning .NET or those who need a refresher. We will cover constructs and concepts including types, operators, flow control, configuration, comments, application types, and others.

SessionID: 20435

When Things Go Wrong in My Code

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Dev App Support

Speaker: Mike Huguet

Title: When Things Go Wrong in My Code

Abstract:

Over the past year I have spent a lot of time reviewing source code for .NET applications written by medium and large sized Enterprise customers. Most of these applications could use some help when it comes to handling situations in code where a problem could or does happen. In this session we’ll cover some strategies for avoiding exceptions and provide guidance for improving exception handling code.

SessionID: 20592

Power of Patterns: Refactoring to (or away from) Patterns

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Dev .NET/ALM

Speaker: Mike Clement

Title: Power of Patterns: Refactoring to (or away from) Patterns

Abstract:

What is a design pattern? Why should you care? What it the power of design patterns? How do design patterns tie into object oriented programming? If I'm using objects in my code, isn't that object oriented programming? (The answer is not necessarily!) When should I use them?

Design Patterns are great but the temptation is to use Design Patterns as a golden hammer. This can lead to unnecessarily complicated, over-engineered code in an effort to be flexible and ready for the future. That sounds reasonable - if you happen to be a psychic. More commonly, you will refactor to a pattern when the code (that you’ve written simply and minimally) demands it.

We'll talk about why you should know common design patterns, why they are powerful, how they relate to object oriented principles, different composite refactorings that will move you to (and sometimes away) from patterns and the smells that help you know when to apply them.

SessionID: 20594

Agile Games: Games with Cards and Dice

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Dev .NET/ALM

Speaker: Mike Clement

Title: Agile Games: Games with Cards and Dice

Abstract:

Play is a powerful method to learn! Come and play some simple agile games to explore the different values that are at the foundation of Agile and Lean development practices.

SessionID: 20700

PowerShell Fundamentals for Beginners

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: PowerShell

Speaker: Mike Robbins

Title: PowerShell Fundamentals for Beginners

Abstract:

SessionID: 20725

What's it like to Work for Microsoft?

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Dev App Support

Speaker: Mike Huguet

Title: What's it like to Work for Microsoft?

Abstract:

The number of Microsoft employees in Louisiana has increased quite a bit over the past couple of years. In this lunch session several Microsoft employees will discuss some of their experiences as a Microsoft "blue" badge (employee).

SessionID: 21410

Advanced Performance Tuning Tips with Ignite

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Dev Web/Mobile

Speaker: Neil Hambly

Title: Advanced Performance Tuning Tips with Ignite

Abstract:

Are you struggling with performance issues and your current tools are not providing answers? Confio’s flagship product, Ignite, may be your answer. This presentation outlines a method for determining the best approach for tuning SQL statements by utilizing response time analysis. The speaker will use real-life case studies to demonstrate the techniques.

SessionID: 21426

SCCM 2012 High Availability

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Windows Server Infrastructure

Speaker: Nicholas Jones

Title: SCCM 2012 High Availability

Abstract:

Information on making your System Center Configuration Manager environment highly available

SessionID: 22734

Web Sites on Windows Azure

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Dev Web/Mobile

Speaker: Ryan Duclos

Title: Web Sites on Windows Azure

Abstract:

Windows Azure Web Sites is a simple and powerful hosting platform that allows developers to easily build and rapidly deploy web applications on Windows Azure using their favorite languages, frameworks, and tools.

SessionID: 23701

Analytics 101 : Big data, business intelligence, and predictive analytics for decision makers

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Business Intelligence Foundations

Speaker: Rusty Frioux

Title: Analytics 101 : Big data, business intelligence, and predictive analytics for decision makers

Abstract:

Business analytics is the hottest ticket in the IT world these days. The trouble is, the industry doesn’t seem to agree on what “it” might be. Is analytics jazzed up reporting and slick dashboards? Is it statistical modeling? Is it Hadoop? Is it SAS? Is it PowerView? What’s a poor technical manager to do when the C-Suite demands it?

Business analytics is the art and science of data driven decision making. Analytics projects span corporate performance management, reporting, dashboarding, statistical analysis, predictive modeling, a/b experimentation, and a host of other techniques all designed to help organizations make fact based decisions using business data.
Rusty Frioux from DataClear will sort out truth from hype and give some practical guidance for anyone tasked with starting an analytics initiative.

SessionID: 23727

SQL 2012 AlwaysOn Quickstart

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: SQL DBA Foundations

Speaker: Ryan Adams

Title: SQL 2012 AlwaysOn Quickstart

Abstract:

In this presentation I'll explain what the new SQL 2012 AlwaysOn high availability

and disaster recovery solution is all about. I'll talk about the different levels of protection it provides through Windows Clustering, SQL Clustering, and Availability Groups. We'll discuss how these three things come together to protect your databases. We'll finish with a dive into availability group configuration and the new capabilities it gives us.

SessionID: 23728

AlwaysOn Live Deployment

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: SQL DBA Foundations

Speaker: Ryan Adams

Title: AlwaysOn Live Deployment

Abstract:

This session is 90% live demonstrations. I'll walk you through a complete AlwaysOn deployment. You will see firsthand how to install and configure an AlwaysOn Failover Cluster. I'll also show you how to bring AlwaysOn Availability Groups into the picture. I'll finish up by showing how you can use a readable secondary for read-only routing.

SessionID: 24270

Beginning Powershell for DBAs 1.0

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: PowerShell

Speaker: Sean McCown

Title: Beginning Powershell for DBAs 1.0

Abstract:

The time has come where DBAs can no longer afford to ignore powershell. Not only has it become an integral part of SQL Server, but we’re being asked to do things on a much grander scale than ever before; things that can only be done with powershell. This session will take you from nothing and explain what powershell is all about. I’m going to show you how the more things change the more they stay the same and if you master the basics of powershell in this session, you’ll be able to work with powershell not only in SQL Server, but also at the file system level, in Exchange, IIS, Windows, and anything else. So in this session I’m going to show you the basics you need to get your powershell career started.

SessionID: 24271

Beginning Powershell for DBAs 1.5

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: PowerShell

Speaker: Sean McCown

Title: Beginning Powershell for DBAs 1.5

Abstract:

If you were in the 1.0 session you’ll love this one. In this session we’re going to pick up where we left off and really get into some real SQL Server admin tasks. We’ll start with some more advanced basics to enhance your knowledge of powershell, and then apply them directly to SQL Server. By the end of this session you won’t be an expert, but my goal is to make you competent enough to be able to understand blogs and articles about powershell.

SessionID: 24384

High Traffic Web Services

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Dev App Support

Speaker: Stephen Fulcher

Title: High Traffic Web Services

Abstract:

In the enterprise context today, applications require a variety of services to create a seamless and optimized customer experience. Among others, they need integrated user tracking, state management and instrumentation that enable request tracing all the way through into asynchronous processes. Implementation demands are compounded by the high volume and distributed processing. In this session, we'll detail the different kinds of application components required to implement a solid, next generation high traffic web application on the Microsoft stack.

SessionID: 24385

Application Instrumentation

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Dev App Support

Speaker: Stephen Fulcher

Title: Application Instrumentation

Abstract:

In this session, we'll explore the key issues involved in instrumenting .NET applications to proactively drive production excellence using runtime information and supporting artifacts. We will cover development through post-deployment challenges and discuss requirement and implementation differences for both high and low volume application scenarios. As part of the process, we will work through a small framework with some of the concepts as a take away.

SessionID: 25305

Unit Tests in Action – an exercise in updating legacy code, and how unit tests play a critical role

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Dev App Support

Speaker: Steve Schaneville

Title: Unit Tests in Action – an exercise in updating legacy code, and how unit tests play a critical role

Abstract:

This session will attempt to show how to use unit tests to confidently make changes to existing production code, reducing the risk of introducing bugs. It will do so in a “hands on presentation” sort of manner, as most of the time will be spent in code rather than in slides. The intent is to demonstrate (by using a real-world example, not slides and theory) the importance of having/creating well written unit tests before updating production code, and will be targeted to persuade the developer who is not yet sold on writing a solid suite of unit tests. During the session, we will take an production existing framework and make changes to it using the following techniques:

  1.  Use unit tests to ensure existing functionality does not break
    
  2.  Use Code Digger to ensure that we test all possible code paths
    
  3.  Use Fakes (including both Stubs and Shims) to isolate code paths and create targeted unit tests
    

SessionID: 25813

ConfigMgr 2012 - Whats the big deal?

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Windows Server Infrastructure

Speaker: Steven Rachui

Title: ConfigMgr 2012 - Whats the big deal?

Abstract:

This session will provide an overview discussion of key features and components of ConfigMgr 2012. This session is suitable for those new to product and those migrating from a previous version of ConfigMgr. Discussion will focus on hierarchy considerations and application deployment and, as time permits, discuss other interesting changes.

SessionID: 25814

Troubleshoot ConfigMgr 2012 like a pro

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Windows Server Infrastructure

Speaker: Steven Rachui

Title: Troubleshoot ConfigMgr 2012 like a pro

Abstract:

When those issues arise having the right tools available to troubleshoot and knowing how to use them is key to successful resolution. This session will review key logs, tools, approaches to using them and specific troubleshooting scenarios.

SessionID: 25905

Managing the SQL Server 2012 SSIS catalog (SSISDB)

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Business Intelligence Advanced

Speaker: Sven Aelterman

Title: Managing the SQL Server 2012 SSIS catalog (SSISDB)

Abstract:

In SQL Server 2012, the new package deployment model also provides benefits for managing and monitoring your SSIS solutions. This session delves into the SSISDB, the database where your packages and their execution details and results are stored. You’ll learn about the schema of the SSISDB and how to use the provided stored procedures and views to manage your SSIS catalog.

SessionID: 25908

Configuring and Managing FILESTREAM and FileTable

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: SQL Dev

Speaker: Sven Aelterman

Title: Configuring and Managing FILESTREAM and FileTable

Abstract:

FILESTREAM and FileTable offer attractive solutions for applications that need to store large binary data (BLOBs) alongside relational data. With the benefit of the SQL Server storage engine managing the BLOB data but without the downsides of VARBINARY(MAX), FILESTREAM and FileTable have advantages that no other solution offers. This session will demonstrate how to design and create databases with these features. Because the paradigm is different than relational storage, the management aspect of FILESTREAM will also be examined, including transactional integrity, the garbage collector and backup and restore.

SessionID: 25932

Toastmasters Demo Meeting

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Career Development

Speaker: Stacy Vicknair

Title: Toastmasters Demo Meeting

Abstract:

A demonstration of the tools, techniques, and benefits of Toastmasters International program. We will present a Toastmaster meeting that will allow the participants to see, hear, and experience the effects of communication and leadership development.

SessionID: 26146

Who Moved My SharePoint (to 2013)?

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: SharePoint

Speaker: Theresa Eller

Title: Who Moved My SharePoint (to 2013)?

Abstract:

Change can be a difficult obstacle in any organization. As an IT pro, how do you promote executive and/or business user adoption of SharePoint 2013? As an executive, power or business user, what should you expect? In this interactive session, we will build a SharePoint 2013 training and transition plan that promotes collaboration between the organization’s SharePoint users and IT professionals for a successful migration. Topics include improved efficiencies, enhanced search functionality, making social features useful for business purposes, what's new for site administrators, and changes to the world of workflows.

SessionID: 26523

Execution Plan Basics - Beginners

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: SQL Dev

Speaker: Thomas LeBlanc

Title: Execution Plan Basics - Beginners

Abstract:

This will be a Beginners session highlighting the starting point for using the execution plans from SQL Server to assist in query tuning. Briefly, we will look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan with the properties window?

SessionID: 26524

Attributes Hierarchies in Analysis Services 2012

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Business Intelligence Advanced

Speaker: Thomas LeBlanc

Title: Attributes Hierarchies in Analysis Services 2012

Abstract:

The session explains Attributes and Hierarchies in Analysis Services 2012 Semantic Model. They are used to slice (filter) and dice (group) measures and dimensions used to view analytical data. The slicing and dicing of data involves fields, columns, or whatever you want to labeled them. But, in SQL Server Semantic model these are called Attributes and Hierarchies. The configuration of these slicers and dicers are important in SQL Server Analysis Services. This session will demonstrate the difference between an attribute and columns in a hierarchy in the dimension as well as the configuration of these for best performance and viewing.

SessionID: 26738

Install-Package Your.Architecture

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Dev .NET/ALM

Speaker: Tim Rayburn

Title: Install-Package Your.Architecture

Abstract:

Come and learn how to use NuGet, Highway.OnRamper, and your own good sense to quickly create templated projects in Visual Studio 2012 that can codify your company’s architecture. It's File ... New Project on Steroids.

SessionID: 26739

Intro PowerShell for Technologists

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: PowerShell

Speaker: Tim Rayburn

Title: Intro PowerShell for Technologists

Abstract:

There is nothing which will empower technologists more than truly understanding and using a powerful command line. On the Windows platform, this is PowerShell, and it can do some AMAZING things if you spend just a little bit of time learning it. Come to this hands-on session where we'll walk you from Zero to Competent in just 1 hour.

SessionID: 27322

iPhone Apps in C#

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Dev Web/Mobile

Speaker: Seth Valdetero

Title: iPhone Apps in C#

Abstract:

Mobile development has traditionally been having to learn a new language for that platform and new ways of doing the same ‘ole thing. Cross-platform development has been especially burdensome since that means multiple code-bases in different languages that have to be kept in sync. Mono aims to make cross-platform mobile development easier by leveraging your existing .NET skills. You no longer need to spend your time re-learning the wheel and hopefully you can save even more time by sharing the majority of your code across all of the platforms. In this session, we will be looking specifically into the iOS platform and how to get started writing iPhone apps in C# and hopefully Visual Studio.

SessionID: 27670

Bringing Business Intelligence to SharePoint Users

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: SharePoint

Speaker: Bill Watters

Title: Bringing Business Intelligence to SharePoint Users

Abstract:

In this session we will have a high level discussion of some of the different Business Intelligence Integration Points available to SharePoint 2010 Enabled Organizations.

SessionID: 28097

Getting Started with Analysis Services 2012 Tabular

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Business Intelligence Advanced

Speaker: William E Pearson III

Title: Getting Started with Analysis Services 2012 Tabular

Abstract:

The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI. In this session, BI Architect, SQL Server MVP and Analysis Services Maestro Bill Pearson introduces Microsoft Business Intelligence 2012 and the Business Intelligence Semantic Model ("BISM"). He then overviews the Tabular model, beginning with the creation of a project with SQL Server Data Tools (“SSDT”), and continuing from the data import steps to the creation and management of calculations, measures and Key Performance Indicators (“KPIs”). Finally, he provides insight to the creation and maintenance of perspectives and hierarchies, as well as other considerations involved in working with Tabular.

SessionID: 28099

Practical Self-Service BI with Excel 2013

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Business Intelligence Foundations

Speaker: William E Pearson III

Title: Practical Self-Service BI with Excel 2013

Abstract:

SessionID: 34638

Let's Learn Knockout

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: Dev Web/Mobile

Speaker: George Mauer

Title: Let's Learn Knockout

Abstract:

KnockoutJs is a simple tool for a simple yet pervasive task - modelbinding. Yet it, like anything on the web, comes with its own set of traps and gotchas. Come learn about making incredibly dynamic applications with knockout from someone that’s been using, extending, and cursing it for the better part of a year.

SessionID: 9032

Understanding Storage Systems and SQL Server

Back to calendar

Event Date: 03-08-2013 - Session time: 00:00:00 - Track: SQL DBA Foundations

Speaker: Wesley Brown

Title: Understanding Storage Systems and SQL Server

Abstract:

The most important part of your SQL Server is also the slowest, Storage. This talk will take you through the fundamentals of your server's Disk I/O System. From how hard drives work, through RAID configurations, and how to configure the file system. This session should give you a solid foundation over storage systems and help you understand why they are slow and how to overcome some of their limitations.