Advanced Filters:
  • Track

    clear all












  • Speaker


  • Level


  • Session Type


Sessions Found: 83
GREAT SCOTT!  You never know when or where a bolt of lightning will strike! But we do now! Come to this session and hear some local and SQL Server community speakers give brief, intense flashes of insight to the audience! And if you have a topic you can present in 5 minutes or less, COME PREPARED! You never know when it might be your chance to get up there!  If you put your mind to it, you can accomplish anything!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Ask Doc & Einstein!

Level: Beginner

Session Code:

Date: May 16

Time: 11:45 AM - 12:45 PM

Room: 205: Doc's Lab

The Tabular model is still the new kid on the block in the world of SQL Server Analysis Services, and its importance in the Microsoft BI roadmap continues to grow. Based on xVelocity, a highly compressed in-memory technology, Tabular models promise considerable performance improvements over Multidimensional models in many scenarios. But, as is the case with any new technology, there are certain limitations of which to be aware. Join me in this session and learn what a Tabular model is, how it fits into the Microsoft BI stack, the major factors to consider when choosing between Tabular and Multidimensional technologies, and finally a live step-by-step demo where we'll build and deploy a basic Tabular model. 
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: May 16

Time: 10:45 AM - 11:45 AM

Room: 113: Lorraine's House

Are you an independent consultant focused on Microsoft data or aspire to become one? Maybe you have a few partners or are considering joining forces with friends? This session is for you. 

My 25 years of consulting experience include 15 years working for myself or with partners. This session explores the top lessons I’ve learned over that time. 

This session doesn’t cover marketing or SME topics.  We explore top tips related to most everything else you must know to achieve success as an IC including:

•	Common reasons IC’s fail. 
•	Customer satisfaction and happiness.
•	Formal and informal partnerships.
•	Legal stuff 101.
•	Bookkeeping, finance and cash flow.
•	Taxes and entity structures. 
•	Building equity in your business.
•	Work life balance. 

We often learn the most from our mistakes. 25 years of mistakes has made me an IC expert. Attending this session will shave years from your learning curve.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Professional Development

Level: Intermedia

Session Code:

Date: May 16

Time: 2:30 PM - 3:30 PM

Room: 206: Clock Tower

As an ETL developer using SQL Server Integration Services have you ever wondered how to:
1.	Import all .csv files from a folder
2.	Replace dynamic SQL using variables in SSIS
3.	How to configure the data flow buffer
4.	Create custom logging solutions
5.	Use a script component as a data flow transformation
This session focuses on advanced techniques that are used in SSIS and is meant for the experienced SSIS developer.  We will focus on tasks and techniques that are native to SSIS 2005-2014 as well as some of the more advanced and vague  properties.  
Attendees must have a good working knowledge of SSIS as well as familiarity with VB.NET or C# as some time will be taken looking at extending SSIS with script tasks and components.
Upon completion of this workshop attendees will be able to:
1.	Import/export multiple sources/destinations
2.	Use an execute SQL task with variables to replace dynamic SQL within a package
3.	Dynamically handle errors within any part of a package
4.	
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
ETL/SSIS

Level: Advanced

Session Code:

Date: May 16

Time: 3:45 PM - 4:45 PM

Room: 107: Lou's Cafe

As new technology cycles emerge, we find ourselves immersed in a growing diversity of tools and infrastructures. Success in Business Intelligence, however, depends often on our capacity to increase adoption and is not always tied to the degree of engineering sophistication. 

Too often we experience adoption issues that account for partial or complete failures for BI delivery.  Are users satisfied with BI assets?  Do they continue to build information 'silos'?  Are they reluctant to change and utilize governed data sets?

In this presentation, attendees will learn about a perspective that can help increase ROI on BI delivery by actively targeting human factors critical to achieving success.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: May 16

Time: 9:30 AM - 10:30 AM

Room: 113: Lorraine's House

Do you have a pressing question about SQL Server? Or Time Travel?  We have a number of experts that can answer your questions! Stop by Room 205 throughout the day and get your tough SQL Server questions answered by experts in the community! You can also ask about career advice and professional development if you're looking to get into or get better at your SQL Server skills.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Ask Doc & Einstein!

Level: Beginner

Session Code:

Date: May 16

Time: 10:45 AM - 11:45 AM

Room: 205: Doc's Lab

Need to import millions of rows from a CSV in under a minute?  No problem.  Need to copy all the Users, Databases, and Agent Jobs from one server to another?  Done.  Need to update all of your development databases to have the same schema, but want to skip the update and only spit out a report if data loss might occur?  Piece of CAKE!!  These are some of the scenarios that we will cover in this session on how to leverage PowerShell with SQL Server 2014.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
PowerShell

Level: Intermedia

Session Code:

Date: May 16

Time: 1:15 PM - 2:15 PM

Room: 220: Twin Pines Mall

Being a DBA is tough job--there are on call situations to deal with, and managing a large amount of servers with less resources is a constant challenge in corporate environments. In this session you will learn techniques to reduce the amount of manual effort in your job, and keep you three steps ahead of your users. Learn techniques such as:
	• Fully Automating SQL Server Installations
	• Dynamically Adding Databases to an Availability Group
	• Syncing jobs and logins between Availability Group members
	• Patching SQL Servers automatically
	• Other techniques for process automation
This session will benefit both new and Senior DBAs, as well as anyone who wants to automate themselves into a promotion.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: May 16

Time: 2:30 PM - 3:30 PM

Room: 210: Lyon Estates

Security is not for the faint of heart and this session is just the tip of the iceberg. Those new to the DBA role and of course the Accidental DBA's can take away a few nuggets to get them started securing their SQL Servers and raising awareness to the importance of securing the data we have been sworn to protect. Let this session jump start your journey to learning why DBA's are called the gatekeepers and increase your value in the office while getting noticed for caring enough to stop intrusions to your SQL Servers.  
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: May 16

Time: 9:30 AM - 10:30 AM

Room: 210: Lyon Estates

These days, I've stopped counting how many times I've been approached to help implement feature X because a customer thinks/was told it provides 24x7 for a DB/instance. These decisions often lead to more downtime and less uptme if the technology choice was not right or cannot be administered by the current staff. The secret sauce is not what gets implemented but understanding everything behind the scenes that influences the final architecture based on your actual requirements. It’s less about technology and more about understanding what it will take to keep your business going even when things seems like they are crumbling down around you. This session will cover how to approach achieving business continuity with the right amount of uptime.
Speaker:

Session Type:
Regular Session

Track:
Availability & Replication

Level: Beginner

Session Code:

Date: May 16

Time: 1:15 PM - 2:15 PM

Room: 206: Clock Tower

Databases are growing.  The way we use data is changing and growing.  When you have a lot of change, it has to be managed, or bad things happen to your data and your job!  A common problem with database change management is... database change management.  This session walks the user through the concepts of database change management, why it's important, and how SQL Server Data Tools (SSDT) makes this process easy.  There are a lot of great features in this frequently overlooked product, and if you are not using it, your job is a lot harder than it needs to be.  Some things we will discuss: schema compare, database versions in source control, renaming objects, and how your job is pushing the button to deliver it the EASY way with SSDT.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DEV

Level: Intermedia

Session Code:

Date: May 16

Time: 3:45 PM - 4:45 PM

Room: 222: Essex Theater

The choice of clustering key can make a huge impact on performance and storage.  In this session, we will explore the factors that influence the decision and how to measure the differences that the decision made.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DEV

Level: Intermedia

Session Code:

Date: May 16

Time: 10:45 AM - 11:45 AM

Room: 218: Lone Pine Mall

Learn about Cisco Unified Computing System (UCS) and why it is an optimal platform for Microsoft SQL Server. During this session we’ll discuss key differentiators that place Cisco well ahead of the competition. Learn about UCS’ management model, Service Profiles, Virtual Interface Adapters, and how they help to simplify and standardize SQL Server deployments. We will also discuss how these differentiators drastically reduce deployment and recovery times, and how UCS provides the best of class hardware platform that can help to achieve the highest levels of consolidation and performance for both virtual and bare metal SQL Server implementations.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Lunch Session (75 minutes)

Track:
Sponsor/Lunch

Level: Beginner

Session Code:

Date: May 16

Time: 11:45 AM - 1:00 PM

Room: 107: Lou's Cafe

Existing SSIS automation solutions are focused on forward-motion activities: creating packages and pushing them to the server.  Little or no thought is given to the management of the packages once they are in production - existing tooling offers nothing to help you understand and manage a live, money-printing ETL workflow based on SSIS packages.

BIPS is an open source project that allows you to manage a live SSIS package tree from PowerShell.  It closes the automation loop, providing the ability to learn and discover the features of an existing package deployment tree as well as manipulate it.  In short, the goal of BIPS brings a devops perspective to managing your SSIS packages.

In this session, you will learn how to leverage BIPS in your own environment.  Specific attention will be given to searching and filtering tasks and data flows on arbitrary criteria and manipulating specific parts of the ETL workflow from the shell. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
PowerShell

Level: Beginner

Session Code:

Date: May 16

Time: 8:15 AM - 9:15 AM

Room: 107: Lou's Cafe

SQL Server 2012 introduced columnstore indexing but with one major drawback -- columnstore indexes were not updateable.  Thus, adopting them to improve data warehousing (or other) query patterns took careful planning and quite a bit of management.  SQL Server 2014 introduces clustered columnstore indexes that are now fully updateable!  During this session, we'll take a look at how clustered columnstore indexes work, what implications exist for using them, and how the update process is handled.  We'll also take a look at what management and maintenance operations are required to keep clustered columnstore indexes performing optimally.  Anyone with a large data warehouse environment (or even an OLTP or ODS database with very large tables) will definitely want to attend!  
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Advanced

Session Code:

Date: May 16

Time: 8:15 AM - 9:15 AM

Room: 220: Twin Pines Mall

Abstract: SQL Server MVP Geoff Hiten will discuss how to create #SANLess clusters in environments where traditional shared storage clusters are impractical or impossible: specifically local high performance clusters leveraging SSD/Flash-based storage and clustering in the cloud - no SAN (or SAN Admin required). He will also touch upon cost-effective disaster recovery options without the need for SAN replication. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Lunch Session (75 minutes)

Track:
Availability & Replication

Level: Beginner

Session Code:

Date: May 16

Time: 11:45 AM - 1:00 PM

Room: 220: Twin Pines Mall

There are several programming design patterns that work great in object orientated code that doesn’t scale well inside of SQL Server. In this session we will focus some of these patterns and show you how to make them scale in the database engine. We will touch on Scalar-Value functions, Union, CTE, RBAR and more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DEV

Level: Beginner

Session Code:

Date: May 16

Time: 10:45 AM - 11:45 AM

Room: 222: Essex Theater

Continuous delivery is an approach that enables new functionality to be delivered as needed. This session will cover how this approach can be applied to data warehouses to enable faster time to value for the consumers of the data.
Most data warehouses are in a constant state of flux. There are new requirements coming in from the business, updates and improvements to be made to existing data and structures, and new initiatives that drive new data requirements. How do you manage the complexity of keeping up with the changes and delivering new features to your business users in a timely manner, while maintaining high quality? Continuous delivery is an approach for managing this. It focuses on automation of many steps in the process, so that time is spent on adding new functionality, rather than repetitive steps. Attend this session and learn how Continuous Delivery can be applied to your data projects.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
BI

Level: Advanced

Session Code:

Date: May 16

Time: 3:45 PM - 4:45 PM

Room: 113: Lorraine's House

After a long maturation process, SQL Server Data Tools is emerging as a huge step forward in database development.  It won't be long before Visual Studio replaces SSMS as the primary IDE for SQL Server developers.  One of the greatest benefits of making the switch is the continuous integration capabilities that are now streamlined by the tool set.  In this session we will discuss how SSDT works, the goal of continuous integration, and how you can put them together to dramatically improve your productivity as a database developer.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DEV

Level: Intermedia

Session Code:

Date: May 16

Time: 1:15 PM - 2:15 PM

Room: 216: Brown Mansion

Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years, but are often thought of as old-fashioned. Many common T-SQL programming "difficulties" are the result of struggling against these standards and can be avoided by understanding the requirements, applying normalization, as well as a healthy dose of simple common sense. In this session I will give an overview of how to design a relational database, allowing you to work with the data structures instead of against them. This will let you use SQL naturally, enabling the query engine internals to optimize your output needs without you needing to spend a lot of time thinking about it. This will mean less time trying to figure out why SUBSTRING(column,3,1) = 'A' is killing your performance, and more time for solving the next customer problem.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DEV

Level: Beginner

Session Code:

Date: May 16

Time: 8:15 AM - 9:15 AM

Room: 216: Brown Mansion

Sessions Found: 83
SQLSaturday