sqlsathistory

Nr: 324

Back to Main list

SQLSaturday #324 - Baton Rouge 2014

Start Time (24h) Speaker Track Title
00:00:00 Brandon Cornett .NET 2 / ALM Continuous Integration and Delivery
00:00:00 Brian Rigsby Career Development The Binary Language of Music
00:00:00 Robert Canzonire Blue Cross Recursive Queries using Common Table Expression (CTE)
00:00:00 Corey Baham IT Pro Using Agile Project Management in IT Disaster Recovery
00:00:00 Carlos Bossy Business Intelligence Getting started with Big Data and BI
00:00:00 Christine Assaf CIO / IT Manager Interview Tips for Managers
00:00:00 Cherie Sheriff Business Intelligence The Value of Visualizations in BI
00:00:00 Cherie Sheriff Business Intelligence Data Vault Data Warehouse Architecture
00:00:00 Cody Gros SharePoint Introduction to the SharePoint 2013 REST API
00:00:00 Cody Gros SharePoint PowerShell Fundamentals for SharePoint 2010/2013
00:00:00 Dale Kirby Business Intelligence Business Analytics with Microsoft Power BI 101
00:00:00 David Reid CIO / IT Manager Power of Employee Engagement
00:00:00 WIlliam Barnes SQL DBA Foundations Fill Factor: Performance or Nuisance?
00:00:00 Eric Trivette SharePoint Single Page Applications (SPAs) in SharePoint with Angular
00:00:00 Glenda Gable SQL DBA Foundations Data Warehouse Indexes
00:00:00 HL Arledge CIO / IT Manager Scrum But Better: Real World Team Management
00:00:00 James Alt Blue Cross Cross-Platform Mobile App Development using Xamarin
00:00:00 Jameson Bozeman SharePoint Introduction to JSLink in SharePoint 2013
00:00:00 Jeremy Beckham Blue Cross Waste Management
00:00:00 Jeremy Cronan Web / Mobile Dev Making your website more responsive with Bootstrap
00:00:00 Jennifer McCown Career Development DBA Career Roadmap
00:00:00 Jennifer McCown SQL Dev Designing Stored Procedure Solutions
00:00:00 Jeremy Knight .NET 2 / ALM Testable WebForms with MVP
00:00:00 Jim Murphy SQL DBA Foundations AlwaysOn - Finally, A usable 'mirror'!
00:00:00 Jonathan Nogueira .NET 2 / ALM Release Management with TFS and Visual Studio 2013
00:00:00 J Sawyer SQL Dev Introducing StreamInsight 2.3
00:00:00 John Sterrett PowerShell Introduction to Powershell for DBA's
00:00:00 Justin Obney .NET 2 / ALM JavaScript Unit Testing - It's Not That Scary
00:00:00 Latham Brunson Blue Cross Kanban and WIP Limits, Inside and Out of TFS
00:00:00 Matthew Brimer DBA Advanced SQL Security Best Practices Shrinking Your Attack Surface
00:00:00 Mike Byrd DBA Advanced SQL Server Foreign Keys – De-mystifying the Rest of the Story
00:00:00 Mike Robbins PowerShell Learn PowerShell or Die! for the DBA
00:00:00 Mike Robbins PowerShell What’s New in PowerShell Version 5?
00:00:00 Matthew Vidacovich .NET 1 Long running task processing with Azure
00:00:00 Michael Viron IT Pro Fundamentals of Disaster Planning Recovery
00:00:00 Nancy Hidy Wilson DBA Advanced SQL Server Deprecated and Discontinued Features
00:00:00 Paul Johnson Web / Mobile Dev Converge with 8.1 Universal Apps
00:00:00 Raghu Dodda Web / Mobile Dev What I learned about functional programming in C# while using JavaScript
00:00:00 Rohn Edwards PowerShell Managing Access Control with PowerShell
00:00:00 Ryan Adams SQL DBA Foundations Mirroring Start to Finish
00:00:00 Ryan Adams DBA Advanced Manage your shop with CMS and Policy Based Mgmt
00:00:00 Sean McCown DBA Advanced Monster Text Manipulation: Regular Expressions for the DBA
00:00:00 Stephen Fulcher .NET 2 / ALM Lessons Learned from Building Big Apps
00:00:00 Stacey Hopkins Business Intelligence Back to Basics - What is BI?
00:00:00 Stacy Vicknair Career Development Improving your communication and leadership through Toastmasters
00:00:00 Steven Rachui IT Pro SQL for the ConfigMgr admin - Understanding Settings, the database and troubleshooting tools
00:00:00 Steven Rachui IT Pro Strategies for Software Update Deployment in Configuration Manager 2012
00:00:00 Kevin Boles SQL Dev Common TSQL Mistakes
00:00:00 Kevin Boles SQL Dev Windowing Functions: THE Reason to Upgrade to 2012
00:00:00 Tim Costello SQL Dev Source Code Control: Revision management for the data dude.
00:00:00 Trent Mera .NET 2 / ALM SQL Server Waits - Dell Software
00:00:00 Seth Valdetero Web / Mobile Dev Cross-Platform Mobile Development with PCLs
00:00:00 George Mauer Web / Mobile Dev Be the Javascriptiest
00:00:00 Rusty Frioux .NET 1 An introduction to Ninject Interception
00:00:00 Rusty Frioux .NET 1 Let's Talk Parallelism in .NET 4.5
00:00:00 Rusty Frioux .NET 1 Introduction to MVC for ASP.NET Web Forms Developers
00:00:00 Rusty Frioux CIO / IT Manager The Supportable Data Warehouse
00:00:00 Adrian Aucoin Jr SQL DBA Foundations Wait Stats: What are they and why you should care.
00:00:00 Wesley Brown IT Pro Fundamentals of SAN, NAS and IP Storage
00:00:00 Anthony Ma .NET 1 Crash Course in Dependency Injection
00:00:00 Amy Herold Career Development Making the Leap from Developer to DBA
00:00:00 Amy Herold PowerShell Beginning Automation with Powershell
00:00:00 Andy Tabisz SharePoint Creating Access 2013 Web Apps based on SQL Azure using SharePoint

SessionID: 10176

Continuous Integration and Delivery

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: .NET 2 / ALM

Speaker: Brandon Cornett

Title: Continuous Integration and Delivery

Abstract:

Continuous integration and deployment are two practices that can drastically reduce any software company's testing and deployment time. In this talk, we will be discussing several tools that you can use to streamline these tasks, as well as how you can go from zero to a baseline project on a development environment in less that 5 minutes. The days of copying and pasting files to deploy your code are over.

SessionID: 10787

The Binary Language of Music

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: Career Development

Speaker: Brian Rigsby

Title: The Binary Language of Music

Abstract:

Discover how binary patterns found in music can be used to learn the underlying language of music theory.

SessionID: 11160

Recursive Queries using Common Table Expression (CTE)

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: Blue Cross

Speaker: Robert Canzonire

Title: Recursive Queries using Common Table Expression (CTE)

Abstract:

In this session we will look at real world experiences using recursive CTEs. Starting with the basics of putting together CTEs, adding recursion, using more complex queries.

SessionID: 11246

Using Agile Project Management in IT Disaster Recovery

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: IT Pro

Speaker: Corey Baham

Title: Using Agile Project Management in IT Disaster Recovery

Abstract:

In this session, a novel framework for disaster recovery will be introduced. This framework is suited for a generic large enterprise, but can be tailored to fit specific needs of virtually any company. Using academic and industry research along with lessons learned, we developed an agile-based project management framework for the orchestration function of IT disaster recovery. This framework is intended to serve as a quick response plan that will improve the rate of response and flow of communication in the wake of a natural disaster like the notorious South Louisiana hurricanes.

SessionID: 11367

Getting started with Big Data and BI

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Carlos Bossy

Title: Getting started with Big Data and BI

Abstract:

HDInsight is the latest evolution of Hadoop on the Windows platform. It allows you to manage big and unstructured data while using the rich Business Intelligence tools provided by SQL Server. This session will cover big data architecture and demonstrate map/reduce, the nucleus of big data technology. You will also see how you to get maximum value out of big data by incorporating it into your BI architecture with tools such as Hive, Excel, PowerQuery, and Tabular models.

SessionID: 11644

Interview Tips for Managers

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: CIO / 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: 11718

The Value of Visualizations in BI

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Cherie Sheriff

Title: The Value of Visualizations in BI

Abstract:

A demonstration of Business Intelligence visualizations and an interactive session on how these add value to your BI solutions. This session will demonstrate practical examples and metrics on how this increased productivity, reduced liability and helped support revenue streams. I will walk through the planning process on where to determine visualizations are of the greatest benefit.

SessionID: 11719

Data Vault Data Warehouse Architecture

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Cherie Sheriff

Title: Data Vault Data Warehouse Architecture

Abstract:

Data vault is a compelling architecture for an enterprise data warehouse using SQL Server 2014. A well designed data vault data warehouse facilitates fast, efficient and maintainable data integration across business systems. In this session I will review the basics about enterprise data warehouse design, introduce you to the data vault architecture and discuss how you can leverage new features of SQL Server 2014 help make your data warehouse solution provide maximum value to your users.

SessionID: 11741

Introduction to the SharePoint 2013 REST API

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: SharePoint

Speaker: Cody Gros

Title: Introduction to the SharePoint 2013 REST API

Abstract:

SharePoint 2013 has extended the REST interface to provide easy access to data within your SharePoint farm. The REST interface opens the SharePoint 2013 development platform to standard Web technologies and languages. This session will cover the basics of getting started with the REST service and provide beneficial examples of using REST.

SessionID: 11742

PowerShell Fundamentals for SharePoint 2010/2013

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: SharePoint

Speaker: Cody Gros

Title: PowerShell Fundamentals for SharePoint 2010/2013

Abstract:

This session will go through the fundamental PowerShell cmdlets you need to know. The session will then dive into common SharePoint scenarios where you can use PowerShell for automation.

SessionID: 12144

Business Analytics with Microsoft Power BI 101

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Dale Kirby

Title: Business Analytics with Microsoft Power BI 101

Abstract:

This session will provide a high-level overview of Business Intelligence and Big Data, discuss industry trends and use cases, and provide a live demonstration of a Business Analytics scenario using Microsoft Power BI and other tools.

SessionID: 12322

Power of Employee Engagement

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: CIO / IT Manager

Speaker: David Reid

Title: Power of Employee Engagement

Abstract:

This will show the power of Employee Engagement. Also, it will show how disengaged employees impact the Organization.

SessionID: 12865

Fill Factor: Performance or Nuisance?

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: SQL DBA Foundations

Speaker: WIlliam Barnes

Title: Fill Factor: Performance or Nuisance?

Abstract:

We expand on a little known but widely modified feature of SQL Server. Fill Factor is something to address in performance tuning after all the low hanging fruit has been addressed. This is not a deep dive into the underlying mechanics of how SQL Server works, but a softer more useful approach to this subject. We will be looking into why changing this could be either good or bad for your environments. This presentation is useful for DBA’s as well as developers trying to get a little more out of their servers.

SessionID: 13891

Single Page Applications (SPAs) in SharePoint with Angular

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: SharePoint

Speaker: Eric Trivette

Title: Single Page Applications (SPAs) in SharePoint with Angular

Abstract:

The Angular framework allows developers to create lightweight single page web applications with ease. By leveraging the Angular framework and the SharePoint 2013 REST API, we can create lightweight applications within SharePoint as alternatives to InfoPath forms and OOTB SharePoint web parts. This presentation will cover the basics of single page applications with Angular as well as targeting the SharePoint platform with SPA applications.

SessionID: 14580

Data Warehouse Indexes

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: SQL DBA Foundations

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: 14994

Scrum But Better: Real World Team Management

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: CIO / IT Manager

Speaker: HL Arledge

Title: Scrum But Better: Real World Team Management

Abstract:

Learn to manage cross-functional teams, their workloads, and project stakeholders in a real world environment, using Scrum, Kanban, Mind-maps, and a few industry secrets you may have never heard of.

SessionID: 15534

Cross-Platform Mobile App Development using Xamarin

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: Blue Cross

Speaker: James Alt

Title: Cross-Platform Mobile App Development using Xamarin

Abstract:

This session will be an introduction to cross-platform mobile app development using C# on the Xamarin Platform. We will build a shared UI using Xamarin.Forms for Windows Phone, iOS and Android apps from within Visual Studio.

SessionID: 15561

Introduction to JSLink in SharePoint 2013

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: SharePoint

Speaker: Jameson Bozeman

Abstract:

SessionID: 16036

Waste Management

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: Blue Cross

Speaker: Jeremy Beckham

Title: Waste Management

Abstract:

This session is an introduction to Garbage Collection in .Net. We will cover what the garbage collector does, the generations of garbage collection, what causes items to be placed in different generations, and some common gotchas that cause issues with Garbage Collection.

SessionID: 16143

Making your website more responsive with Bootstrap

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: Web / Mobile Dev

Speaker: Jeremy Cronan

Title: Making your website more responsive with Bootstrap

Abstract:

How to use Bootstrap to make your website more responsive between desktop, tablets and smartphones.

SessionID: 16495

DBA Career Roadmap

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: Career Development

Speaker: Jennifer McCown

Title: DBA Career Roadmap

Abstract:

Let’s talk about your career. You’ve been a DBA for a week, a month, a year, or ten, but do you know all you need to about keeping up to date? Job hunting and recruiters? Are you an interview ace? We’ll talk about all of this, and much more. To answer your specific questions, we’ll wrap up with a question and answer session.

SessionID: 16497

Designing Stored Procedure Solutions

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: SQL Dev

Speaker: Jennifer McCown

Title: Designing Stored Procedure Solutions

Abstract:

In this session, you’ll learn about SQL Server stored procedures (SPs): what they are, when and why you'd use them, and how you'd go about developing a solution with one. We will address common SP myths and learn about planning for performance. Most of all, we’ll walk through examples to explore the process of solution building in SQL Server.

SessionID: 16597

Testable WebForms with MVP

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: .NET 2 / ALM

Speaker: Jeremy Knight

Title: Testable WebForms with MVP

Abstract:

MVC is all the rage but what about all the code you already have written in ASP.NET WebForms? How can you make it maintainable and testable? In this session, I'll show how you can make WebForms applications testable using Model-View-Presenter.

SessionID: 16820

AlwaysOn - Finally, A usable 'mirror'!

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: SQL DBA Foundations

Speaker: Jim Murphy

Title: AlwaysOn - Finally, A usable 'mirror'!

Abstract:

In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot! Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We'll also test automatic fail-over using a real web app to see how well this feature works.

SessionID: 17350

Release Management with TFS and Visual Studio 2013

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: .NET 2 / ALM

Speaker: Jonathan Nogueira

Title: Release Management with TFS and Visual Studio 2013

Abstract:

y using Release Management for Visual Studio 2013, your development and operations teams can enable additional capabilities in Team Foundation Server 2013 so that they can more easily and more confidently configure and automate complex deployments to a variety of target environments. We will cover the basics of the client usage within Visual Studio and the Server components.

SessionID: 17639

Introducing StreamInsight 2.3

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: SQL Dev

Speaker: J Sawyer

Title: Introducing StreamInsight 2.3

Abstract:

StreamInsight provides real-time analytics on large volumes of data with a response time measured in milliseconds, bringing a new level of capabilities to the Sql Server platform. This session will provide an overview of StreamInsight, its capabilities and use cases. We'll also look at some queries leveraging StreamInsight in real-world scenarios.

SessionID: 17737

Introduction to Powershell for DBA's

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: PowerShell

Speaker: John Sterrett

Title: Introduction to Powershell for DBA's

Abstract:

Is the list of servers you manage growing and growing? Are you starting to wonder if there is a more efficient way to manage your SQL Server instances than T-SQL and SSMS? In this session we will give you an introduction to PowerShell with a focus on SQL Server. In this session, we will cover the basics towards configuring and using PowerShell. We will also cover the basic syntax of PowerShell that will help you get started in the right direction. Finally, we will conclude the session with some examples that could make your SQL Admin life a lot easier.

SessionID: 17783

JavaScript Unit Testing - It's Not That Scary

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: .NET 2 / ALM

Speaker: Justin Obney

Title: JavaScript Unit Testing - It's Not That Scary

Abstract:

The web is becoming the new "native". The front-end is landscape is rapidly increasing with more and more logic moving into the client. It seems like a new framework/library is released every day. And with clients expecting a polished, responsive, and reliable application, unit testing your JavaScript is no longer just a "nice thing to have." The tooling is here. What are you waiting for.

SessionID: 18978

Kanban and WIP Limits, Inside and Out of TFS

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: Blue Cross

Speaker: Latham Brunson

Title: Kanban and WIP Limits, Inside and Out of TFS

Abstract:

The session will serve as an introduction to Kanban and WIP limits. The discussion will include setting up a physical Kanban board, setting up a virtual Kanban board in Visual Studio Online, along with the advantages/disadvantages of physical versus virtual.

SessionID: 19869

SQL Security Best Practices Shrinking Your Attack Surface

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: DBA Advanced

Speaker: Matthew Brimer

Title: SQL Security Best Practices Shrinking Your Attack Surface

Abstract:

Every industry has a governing body or standard that requires some layer of security to your data. In my travels I have come to realize that when someone mentions security, DBA's tend to get frightened. This could be due to a lack of understanding of the requirements or not knowing what SQL Server offers to meet those requirements. In this session we will go over what SQL Server has to offer, Security Best Practices and how you can shrink your attack surface to meet Confidentiality, Integrity and Availability of your Servers and Data.

In addition, attending this talk is worth 1.5 Continuing Education credits.

SessionID: 19959

SQL Server Foreign Keys – De-mystifying the Rest of the Story

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: DBA Advanced

Speaker: Mike Byrd

Title: SQL Server Foreign Keys – De-mystifying the Rest of the Story

Abstract:

Foreign Keys have a bad rap – they cause performance issues, they inhibit some inserts, deletes and updates, etc. This may be true, but let’s further explore why we even have them and how they can benefit and maybe even improve performance. This session will concentrate on many demos including the attributes associated with foreign keys. The attendee will walk away from this session with a better understanding of Foreign Key utility and their maintenance.

SessionID: 20703

Learn PowerShell or Die! for the DBA

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: PowerShell

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: 20704

What’s New in PowerShell Version 5?

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: PowerShell

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: 21246

Long running task processing with Azure

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: .NET 1

Speaker: Matthew Vidacovich

Title: Long running task processing with Azure

Abstract:

Azure offers amazing capacities for computation for a low cost, but it can be a challenge to create a seamless user experience when there are so many moving parts. This talk will go over a methodology of getting potentially gigabytes of data to azure and back to the user seamlessly using ASP.NET MVC, SignalR, and Azure CORS. I also plan to go over some important limitations of various azure services and tools that I've discovered (the hard way) working on my projects with Azure.

SessionID: 21248

Fundamentals of Disaster Planning Recovery

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: IT Pro

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: 21302

SQL Server Deprecated and Discontinued Features

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: DBA Advanced

Speaker: Nancy Hidy Wilson

Title: SQL Server Deprecated and Discontinued Features

Abstract:

Each version of SQL Server provides a list of features which are deprecated – meaning they will be removed in a future version – and a list of features previously deprecated which are discontinued in that version. This session will discuss the deprecated\discontinued features starting with SQL 2008 and will show you how to identify deprecated features so that you can upgrade with ease when those features are finally discontinued.

SessionID: 22169

Converge with 8.1 Universal Apps

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: Web / Mobile Dev

Speaker: Paul Johnson

Title: Converge with 8.1 Universal Apps

Abstract:

This session will discuss the new Universal Apps for the Windows and Windows Phone 8.1 platforms. We will look at developing apps using the same runtime as well as explore some of the new tooling that will help you out.

SessionID: 22435

What I learned about functional programming in C# while using JavaScript

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: Web / Mobile Dev

Speaker: Raghu Dodda

Title: What I learned about functional programming in C# while using JavaScript

Abstract:

Programming in C# is about decomposing code into classes, but is it possible to achieve encapsulation and modularity using only lambdas? Apart from being an interesting excursion into functional features of the C#, this talk will illustrate how modularity can be achieved in languages such as JavaScript that emphasize functions over classes.

A basic understanding of Func and dynamic is necessary. Most of the talk will be coding in C#, with a few snippets of JavaScript.

SessionID: 23425

Managing Access Control with PowerShell

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: PowerShell

Speaker: Rohn Edwards

Title: Managing Access Control with PowerShell

Abstract:

Access control in Windows, while very powerful, can be very complicated. Working with securitydescriptors 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 “PowerShellAccessControl” script module.

SessionID: 23758

Mirroring Start to Finish

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: SQL DBA Foundations

Speaker: Ryan Adams

Title: Mirroring Start to Finish

Abstract:

Mirroring is not dead! If you don't have Enterprise Edition, then this is still your tried and true solution. We’ll cover what mirroring is from start to finish, how it can fit into an HA/DR plan, the rules surrounding its use, configuration via the GUI and T-SQL, as well as how to monitor mirroring. This presentation is designed to walk you through a basic implementation. At the end you will have learned what mirroring is, how it can fit into your environment, what business requirements it solves, and how to configure it.

SessionID: 23759

Manage your shop with CMS and Policy Based Mgmt

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: DBA Advanced

Speaker: Ryan Adams

Title: Manage your shop with CMS and Policy Based Mgmt

Abstract:

In this session I will talk about Central Management Server and how it can help you manage a disperse environment. I will also cover what Policy Based Management is and how you can leverage its power to better manage your environment. With PBM we'll see what it can and cannot do to help you enforce standards in your enterprise. I will demonstrate PBM from creating and evaluating policies to receiving alerts on policy violations.

SessionID: 24286

Monster Text Manipulation: Regular Expressions for the DBA

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: DBA Advanced

Speaker: Sean McCown

Title: Monster Text Manipulation: Regular Expressions for the DBA

Abstract:

As DBAs there are many tasks we’re asked to do every day that we just accept as taking a long time because of some manual component we can’t get around. Many of these tasks can be brought into line with regex. You can use it to format your own T-SQL and create code that writes code with relative ease. I’m going to teach you the basics of regex and show you how to perform many tasks that’ll make your life much easier like deploying code, formatting T-SQL, and much more.

SessionID: 24386

Lessons Learned from Building Big Apps

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: .NET 2 / ALM

Speaker: Stephen Fulcher

Title: Lessons Learned from Building Big Apps

Abstract:

Lessons Learned from Building Big Apps

SessionID: 25233

Back to Basics - What is BI?

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Stacey Hopkins

Title: Back to Basics - What is BI?

Abstract:

An overview of the various niches within the Business Intelligence area along with a brief look at some of the tools used

SessionID: 25239

Improving your communication and leadership through Toastmasters

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: Career Development

Speaker: Stacy Vicknair

Title: Improving your communication and leadership through Toastmasters

Abstract:

Since 1924, Toastmasters International has been recognized as the leading organization dedicated to communication and

leadership skill development. Through its worldwide network of clubs, each week Toastmasters helps more than a quarter million men and women of every ethnicity, education level and profession build their competence in communication so they can gain the confidence to lead others.

By regularly giving speeches, gaining feedback, leading teams and guiding others to achieve their goals in a supportive atmosphere, leaders emerge. They learn to tell their stories. They listen and answer. They plan and lead. They give feedback — and accept it. They find their path to leadership.

In this session we will demonstrate how a Toastmasters meeting operates, answer your questions about how toastmasters can improve your career and tell you where you can find a club that fits your schedule. Join us and find your path!

SessionID: 25818

SQL for the ConfigMgr admin - Understanding Settings, the database and troubleshooting tools

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: IT Pro

Speaker: Steven Rachui

Title: SQL for the ConfigMgr admin - Understanding Settings, the database and troubleshooting tools

Abstract:

This session will pull back the covers on the ConfigMgr SQL database. We will specifically focus on the views, the data they hold and how they can be leveraged for robust reporting. We will also discuss the various settings that are critical for ConfigMgr including autogrow settings, the use of triggers, memory settings and more. We will wrap discussion with a review of the troubleshooting tools available in ConfigMgr and SQL that help in understanding database issues.

SessionID: 25819

Strategies for Software Update Deployment in Configuration Manager 2012

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: IT Pro

Speaker: Steven Rachui

Title: Strategies for Software Update Deployment in Configuration Manager 2012

Abstract:

Deploying software updates has become a critical function for enterprises of all sizes. Making sure the process is efficient and strategic is important for best results. This session will review the software update process, discuss common pitfalls and suggest a strategy for software update deployment that is both effective and easy. Time permitting this session will also discuss potential ways to automate routine software update maintenance.

SessionID: 26487

Common TSQL Mistakes

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: SQL Dev

Speaker: Kevin Boles

Title: Common TSQL Mistakes

Abstract:

We are going to examine a variety of oopsies MANY developers fall prey to - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance and concurrency. I have given this talk over FIFTY times now and it is always very highly rated!

SessionID: 26488

Windowing Functions: THE Reason to Upgrade to 2012

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: SQL Dev

Speaker: Kevin Boles

Title: Windowing Functions: THE Reason to Upgrade to 2012

Abstract:

For the first time since SQL 7 there is a compelling reason for EVERY SQL Server user to upgrade to the next version and this time around the reason is Windowing Functions. And these are NOT limited to Enterprise Edition, like so many other really useful and important features! The range of data processing needs that can be very efficiently and cleanly solved with these tools is stunning. In this demo-packed session we will cover as many features as we can pack into an hour's time, and you can take the demo code back home with you to review at your leisure!

SessionID: 26570

Source Code Control: Revision management for the data dude.

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: SQL Dev

Speaker: Tim Costello

Title: Source Code Control: Revision management for the data dude.

Abstract:

Ever wanted to see what has changed since the last time you looked, or work with someone else and realize you've both changed the same stored procedure? Do you really enjoy searching through folder after folder of obscure .sql files to find the query you might or might not have saved last week? There is a better way, and it doesn't have to be a hassle. In this session we'll look at why you would want a revision management system and options (build or buy, free or fee) to implement one for yourself or your team.

SessionID: 27106

SQL Server Waits - Dell Software

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: .NET 2 / ALM

Speaker: Trent Mera

Title: SQL Server Waits - Dell Software

Abstract:

Trent will show how SQL Server Waits reveal which of your statements most need tuning. SQL Waits show the specific workload generated by each statement running against your SQL Server, and this information can be captured and viewed over various time ranges. Methods for accomplishing this using the natively available utilities will be shown, followed by a look at Dell tools that use this approach.

SessionID: 27323

Cross-Platform Mobile Development with PCLs

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: Web / Mobile Dev

Speaker: Seth Valdetero

Title: Cross-Platform Mobile Development with PCLs

Abstract:

Portable class libraries are a great way to maximize code sharing across platforms. With Xamarin having full support for it, there is no reason not to use them. In this session we will be creating a cross-platform application using PCLs and MVVM to maximize our code sharing. We will also be utilizing HttpClient, async/await, and SQLite. If you've never created a mobile application and would like to know where to start or maybe you have but just haven't used any of these new technologies, come to this session and see how to do it all in C#.

SessionID: 34640

Be the Javascriptiest

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: Web / Mobile Dev

Speaker: George Mauer

Title: Be the Javascriptiest

Abstract:

Angular! Knockout! Ember! Node! Batmanbacond3lodashpolymerexpressreact. The javascript landscape has suddenly become a dense jungle. So dense in fact that it is easy to become distracted by the patterns of the shiny-new-thing and forget the fundamentals of the language. This session will reaffirm how the language actually works to and how these features enable such a great ecosystem. What is the event loop? hoisting? What is this? What on earth does the new keyword actually do in a classless language? Machete a path through the fauna back to the basics.

SessionID: 34872

An introduction to Ninject Interception

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: .NET 1

Speaker: Rusty Frioux

Title: An introduction to Ninject Interception

Abstract:

In this session, I will present the fundamental concepts of AOP, and create a program that can show you how to inject aspects dynamically with the Ninject Interception extension.

SessionID: 34873

Let's Talk Parallelism in .NET 4.5

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: .NET 1

Speaker: Rusty Frioux

Title: Let's Talk Parallelism in .NET 4.5

Abstract:

TPL? PLINQ? Data Structures for Coordination? Threads? In this session we will go over the major components and design considerations when choosing which parallel construct to use in .NET 4.5. When leaving, you should have a good grasp of the options available. Let's get ready to push your CPU.

SessionID: 34874

Introduction to MVC for ASP.NET Web Forms Developers

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: .NET 1

Speaker: Rusty Frioux

Title: Introduction to MVC for ASP.NET Web Forms Developers

Abstract:

Separate your concerns! Learn what ASP .NET MVC has to offer. This session is specifically tailored for Web Forms developers who want to learn how to create modern web UIs. We will discuss what MVC really means -- what it IS and what it is NOT. Web API and Javascript MVC alternatives, such as AngularJS, will also be introduced.

SessionID: 34876

The Supportable Data Warehouse

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: CIO / IT Manager

Speaker: Rusty Frioux

Title: The Supportable Data Warehouse

Abstract:

Rusty will walk you through real strategies for designing, building and unit testing data warehouses, ETL’s, and reports that will result in a lower cost of implementation and support – and result in fewer angry calls from the CFO.

SessionID: 8905

Wait Stats: What are they and why you should care.

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: SQL DBA Foundations

Speaker: Adrian Aucoin Jr

Title: Wait Stats: What are they and why you should care.

Abstract:

Many Application Support personnel, IT support, and even some DBA's are occasionally bombarded with "My application is slow", "the database keeps timing out", and many other end user complaints when supporting applications in any industry. Instead of simply blaming it on the developers or simply brushing it off as a "vendor problem", wouldn't it be nice to understand the issues and notify the correct party? This presentation is intended as a primer for wait stats. Introducing the concepts, discussing why it's useful, then discussing a few ways that you can take this knowledge and apply it using a number of different approaches. At the end I've also provided some examples of various LIVE environments I help manage so we can discuss what issues may or may not be prevalent.

SessionID: 9042

Fundamentals of SAN, NAS and IP Storage

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: IT Pro

Speaker: Wesley Brown

Title: Fundamentals of SAN, NAS and IP Storage

Abstract:

SAN’s and NAS’s have their own challenges but also open up a whole new set of tools for disaster recovery and high availability. We will touch on the basics that can be applied to most SAN’s and talk about strategies for setting up your storage. We will also cover what makes up a Storage Area Network and what seperates Network Attached Storage from SAN's and how iSCSI fits into this picture.

SessionID: 9362

Crash Course in Dependency Injection

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: .NET 1

Speaker: Anthony Ma

Title: Crash Course in Dependency Injection

Abstract:

SessionID: 9415

Making the Leap from Developer to DBA

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: Career Development

Speaker: Amy Herold

Title: Making the Leap from Developer to DBA

Abstract:

You are a Developer (.NET, SQL or otherwise) but you have been doing some DBA work and have now decided that is all you want to do - how do you make the transition? What do you need to know? This session will cover this topic from first-hand experience.

SessionID: 9416

Beginning Automation with Powershell

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: PowerShell

Speaker: Amy Herold

Title: Beginning Automation with Powershell

Abstract:

This session will cover concepts of automating SQL processes with Powershell - the one tool no DBA should shy away from. If you haven't gotten on the bandwagon yet now is the time. With some simple demos that you can take and expand upon, you wil learn how you can leverage Powershell to not only efficiently meet the needs of your busines, but also free up your time for other things.

SessionID: 9603

Creating Access 2013 Web Apps based on SQL Azure using SharePoint

Back to calendar

Event Date: 02-08-2014 - Session time: 00:00:00 - Track: SharePoint

Speaker: Andy Tabisz

Title: Creating Access 2013 Web Apps based on SQL Azure using SharePoint

Abstract:

Access 2013 web apps feature a new, full integration with SQL Azure. When you create a web app on SharePoint, Access Services will create SQL Azure database that houses all of your Access objects. This opens up new opportunities for SQL developers to extend and work with the data in Access apps. In this session you will learn to easily create an Access Web Apps with automatic views, view the online development environment and see a real-world, production web app in action. We’ll discuss different the use of hybrid applications and integrating office web apps as well as learn about app distribution, deployment and upgrades. And lastly, see the pros/cons of Access Web Apps in a corporate environment.