Build Schedule

Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type

Sessions Found: 29
Starting with the 2005 release, SQL Server captures information about the workload on an instance, which you can use to monitor the system, gather performance metrics, and validate system settings.  This information is available via Dynamic Management View and functions and officially they "return internal, implementation-specific state data." This session gives an introduction to these concepts, how they make DBA life much sweeter and we discuss many of the different community queries available to help you get jump started in your environment.  We also open up the floor for ideas of how you are using these views/functions.
Speaker:

Session Type:
Regular Session

Track:
DBA 1 - Intro / Intermediate

Level: Beginner

Session Code:

Date: December 06

Time: 12:00 AM - 1:00 AM

Room: TBD

The difference between Analysis Services Multidimensional versus Analysis Service Tabular can be difficult to understand for both new and seasoned Microsoft business intelligence developers. However, this understanding helps you to pick the model type that will provide the best possible solution for your end users. This session will describe each model type, list the pros and cons of each model type, and show developer and end user functionality for both model types. After this session, you will be able to successfully pick the right Analysis Services model type for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI2 - Intermediate / Advanced

Level: Beginner

Session Code:

Date: December 06

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, we will discuss and demonstrate backup and recovery of your on-premises SQL Server databases to and from Windows Azure, a key Hybrid Cloud capability of SQL Server 2014.  We will discuss key feature concepts such as the enhanced Backup UI, Restore UI, encrypted backups, SQL Server backup to URL, and the SQL Server Backup to Windows Azure Tool. We will also discuss the scenarios for integration of this technology.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA 1 - Intro / Intermediate

Level: Intermedia

Session Code:

Date: December 06

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DEV

Level: Beginner

Session Code:

Date: December 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
Speaker:

Session Type:
Regular Session

Track:
Prof. Dev.

Level: Beginner

Session Code:

Date: December 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Will show you the chocolate of Fill Factor and how to win the Golden Ticket by easy Re-FillFactoring
  
Speaker:

Session Type:
Regular Session

Track:
DBA 2 - Intermediate / Advanced

Level: Intermedia

Session Code:

Date: December 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Columnstore indexes were introduced in SQL Server 2012 & have been wholly re-architected & optimized in SQL Server 2014.  Columnstore indexes are optimized for data warehouse workloads & are a hybrid technology leveraging the best of off-disk & in-memory capabilities. Transparent to the app, columnstore has been shown to render queries at subsecond response times which heretofore took many minutes or longer. This presentation includes an overview of SQL Server 2012 & a deep dive into SQL Server 2014 columnstore indexes, including a review of the architecture, as well as the challenges, workarounds, travails, & big wins at customer sites & inside MSIT. The presentation is rich in demos, including leveraging IaaS—Columnstore in The Cloud.  Learn whether columnstore can change your users' world & why columnstore may be a compelling reason to upgrade. Learn how columnstore indexes flip the DW faster bit & why columnstore manifests my motto, “Change the world or go home!”
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI2 - Intermediate / Advanced

Level: Intermedia

Session Code:

Date: December 06

Time: 12:00 AM - 1:00 AM

Room: TBD

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: December 06

Time: 12:00 AM - 1:00 AM

Room: TBD

For those of you that don’t have a full time DBA on staff, this session is built around you. I will give you the skills and tools necessary to successfully manage Microsoft SQL Server. Automation is the key to any monitoring effort and SQL Server is no different. I will show you publicly available tools and scripts to alert you when key areas of SQL Server are being stressed. Proactively monitoring SQL Server will make you more efficient and allow you to continue your success within your role.
Speaker:

Session Type:
Regular Session

Track:
Prof. Dev.

Level: Beginner

Session Code:

Date: December 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Power Query, a free add-in for Excel 2010 and 2013, will enhance the self-service business intelligence offering from Microsoft. With Power Query the business analysis along with the BI developer can combine and shape data from a wide variety of data sources in a quick and easy manner. This task can enable more time to be spent in analysis and discover and less time build ETL plumbing. 

This session will demo the ease of the data extraction process in Power Query. We will explore multiple data sources and even modify the language to create a foundation for further exploration into Power Query.
Speaker:

Session Type:
Regular Session

Track:
BI 1 - Intro / Intermediate

Level: Beginner

Session Code:

Date: December 06

Time: 12:00 AM - 1:00 AM

Room: TBD

As DBAs we are often stuck at the mercy of higher ups and Project Managers for completion of our assigned tasks/ projects.
In this session we wil actually take an arbitrary application and its affiliated databases and go throught the tasks/resources needed to accomplish the task. We will think and act like a Project Manager and DBA rolled into one. This will surely help you advance your career within organization and help you think ahead of time.
Speaker:

Session Type:
Regular Session

Track:
Prof. Dev.

Level: Intermedia

Session Code:

Date: December 06

Time: 12:00 AM - 1:00 AM

Room: TBD

John knows everything and goes out of his way to correct you at every turn.  Mary is agreeable to a fault and just placates everyone.  Mike is full of doom and gloom and whines constantly. Are these your co-workers? Relatives? Frenemies? You? Learn two golden rules to reduce the stress produced by the difficult people in your life.
Speaker:

Session Type:
Regular Session

Track:
Prof. Dev.

Level: Beginner

Session Code:

Date: December 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Errors can occur anywhere within an SSIS package and the cause and error message can be somewhat cryptic. This session focuses on identifying error causes and handling them dynamically and proactively. The means of dealing with errors is defined by where the error occurs and we will cover error handling in control flow, data flow, and script tasks in great detail. 

You will learn:
•To identify the different error handling methods in control flow, data flow, and script tasks 
•Be able to utilize event handlers to proactively handle errors 
•Be able to redirect data error and proactively handle data flow errors 
•Be able to identify error descriptions and log error details
Speaker:

Session Type:
Regular Session

Track:
BI 1 - Intro / Intermediate

Level: Intermedia

Session Code:

Date: December 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Data Analysis Expressions (DAX) is the language of PowerPivot and the Analysis Services Tabular engine. Review the basics of the DAX language and get introduced to evaluation context: including row and filter context. Learn why different cells return different results based on the same formula.  Understanding evaluation context is the driving force behind releasing the potential to create truly dynamic DAX formulas. The demo will walk through various examples the DAX query language and demonstrate row and filter context.
Speaker:

Session Type:
Regular Session

Track:
BI2 - Intermediate / Advanced

Level: Advanced

Session Code:

Date: December 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Most of the time you’ll see ETL being done with a tool such as SSIS, but what if you need near-realtime reporting? This session will walk through the basic transformations to build a Kimbal-style data warehouse from an OLTP database and demonstrate how to keep your data warehouse updated using Service Broker messages from your OLTP database.
Speaker:

Session Type:
Regular Session

Track:
BI2 - Intermediate / Advanced

Level: Intermedia

Session Code:

Date: December 06

Time: 12:00 AM - 1:00 AM

Room: TBD

The best way to understand why your query is running slow is to look at the execution plan. But, knowing how to get started in execution plans, what to look for, what's important, can all be terribly confusing. This session will provide you with a simple set of tasks to get you started reading execution plans. You'll learn where to start, what to look for first, and you'll be better prepared to tune your queries. We'll also look at some methods you can use to write queries against the plans themselves in order to more easily and quickly identify potential issues within your plans. The information presented will be immediately applicable on the queries you have running back in the office.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA 2 - Intermediate / Advanced

Level: Intermedia

Session Code:

Date: December 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this demo heavy session we will clear up the confusion.
Speaker:

Session Type:
Regular Session

Track:
DBA 2 - Intermediate / Advanced

Level: Intermedia

Session Code:

Date: December 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Join Microsoft Certified Master and SQL Server MVP, Jason Brimhall, as he examines numerous database design and coding implementations that they have seen over the years.  They will explore these implementations and show how they can be murder on SQL Server in terms of performance, security, storage and even accuracy. You will learn how you can identify these “killers” and how you can implement alternatives that will keep data professionals, management, and end-users happy.  All while keeping your databases happy, secure, turbo-charged and healthy. 

This is the Solo version of the Joint version normally done as an all-day precon
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
DBA 1 - Intro / Intermediate

Level: Intermedia

Session Code:

Date: December 06

Time: 12:00 AM - 1:00 AM

Room: TBD

You’re taking basic backups and you know how to restore them. Things have been running smoothly in your environment but you want to be confident that you’re equipped with the backup and restore tools, techniques, and options that you’ll need to adapt your strategies as business needs change. You’ve heard about piecemeal restores, filegroup backups, and backing up to multiple files, and now you’re ready to dig into learning more about these topics. In this demo-rich presentation, we’ll review scenarios using these options and you'll gain an understanding of some intermediate and advanced options related to backup performance, corruption detection, and the new SQL Server 2014 hybrid backup scenarios. You'll return to the office inspired to validate your backups and test your restore processes regularly, and you'll have references to great tools the SQL community has shared to help you get started.
Speaker:

Session Type:
Regular Session

Track:
DBA 1 - Intro / Intermediate

Level: Intermedia

Session Code:

Date: December 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Did you ever get woken up at night from a call from a user screaming about poor query performance, but didn’t really know how to begin attack the problem?  In this session, we will explore the basics of execution plan analysis and how to single out issues that pertain to base table operations.
In this presentation, we will identify what indexes are being used by the SQL Optimizer, the different type of index operations that are performed by SQL Server and which operations are generally considered the preferred method of data retrieval. We will discuss how to determine if the indexes used by the Optimizer are optimal, according to best practices, and the exceptions to those cases.   Finally, we will cover the relationships between different types of index operations and joins within SQL Server, including how the SQL Optimizer determines which join type it will use, along with the pros and cons of each join operation
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA 2 - Intermediate / Advanced

Level: Intermedia

Session Code:

Date: December 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Sessions Found: 29
Back to Top cage-aids
cage-aids
cage-aids
cage-aids