Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 44
Learn 10 common T-SQL mistakes and how to avoid them.  Procedural coding, misuse of user-defined functions, and non-SARGable filters are just some of the topics we'll cover.
Speaker:

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: September 13

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you finally ready to unlock the power in your spatial data? In this session, we will explore some advanced spatial analysis techniques, including clustering, binning, and the basic use of spatial statistics. We will then discuss several options for visualizing the results in SQL Server Reporting Services and PowerPivot. Get ready to go beyond bars and bubble charts!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Advanced

Session Code:

Date: September 13

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server is often I/O bound - but why? Do you feel lost when talking to your storage administrator?  Are your storage subsystems like a mysterious black box where your databases live but you can’t go visit? This session will get you up to speed with the fundamentals of storage subsystems for SQL Server. You will learn about the different types of storage that are available, and how to decide what type of storage to use for different workload types. You will also learn useful tips and techniques for configuring your storage for the best performance and reliability. We’ll cover methods to effectively measure and monitor your storage performance so that you will have valuable information and evidence available the next time you have to discuss IO performance with your storage administrator. Come to this session to learn how to analyze I/Os as well as options to reduce the bottlenecks.
Speaker:

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: September 13

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will you chart the waters through the sea of Business Intelligence (BI) options.  IT departments need tools to turn data into useful information for users.  Instead of ROI, this session talks about Return on Data' for IT Managers.  

In this session we look at the roles of data warehousing, big data and business intelligence systems.  The Microsoft BI stack has evolved from traditional OLAP cubes to include tabular models, PowerBI, integration with HADOOP, reporting tools and full integration with SharePoint.  This session is non-technical.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: September 13

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn how to use integration services to create a fast reliable ETL structure that's designed to insert or update your destination from nearly any source.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: September 13

Time: 12:00 AM - 1:00 AM

Room: TBD

How many times have you heard the phrase, "Can you check on the database?". There's a problem, and they want YOU to validate it's not a problem with Sql Server. How do you quickly validate the health of Sql Server? Is there a problem you're not seeing? At what point is Sql Server not the problem? This session covers a step by step guide to validate that Sql Server is healthy and running its best. This also provides a framework to keep Sql Server healthy over time and prevent future problems. If you're not sure how to "check on the database", this session is for you!
Speaker:

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: September 13

Time: 12:00 AM - 1:00 AM

Room: TBD

Whether you are trying to setup a new data warehouse, keep it updated, audit changes to your databases or quickly load changes to another database Change Data Capture (CDC) is a solution for all of these and can now be setup and supported easily with SQL Server & SSIS 2012! Change Data Capture (CDC) has been around since SQL Server 2008, but has been underused because it was difficult to fully implement. SSIS 2012 now provides support for CDC with new components that make consuming the captured data very easy to apply. This session will define what CDC is and with live demos show how it is setup on your databases. Once it has been setup then you need to consume and apply those changes, this will be demonstrated with live demos using SSIS 2012 to create packages that apply the changes.
Speaker:

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: September 13

Time: 12:00 AM - 1:00 AM

Room: TBD

The fastest way to process large amounts of data in SQL Server is using set-based operations. That is if you can stand the blocking. This session walks through different ways to think about applications when transaction blocking becomes your biggest problem. It covers specific T-SQL suggestions to minimize the rows locked, application architectures to maximize concurrency and reporting solutions to reduce impact on the production database. And always lots of demos and spirited discussion.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: September 13

Time: 12:00 AM - 1:00 AM

Room: TBD

Building software is hard, and we often find that fixing bugs is expensive if they are not caught early. Continuous Integration has proven to be a valuable technique in improving software quality by finding problems quickly and letting developers know immediately they have introduced a bug.This session demonstrates how you can implement CI for SQL Server databases, execute automated tests against your code and inform developers that they have caused a problem immediately. 
Speaker:

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: September 13

Time: 12:00 AM - 1:00 AM

Room: TBD

Covering the basics for the beginner and those that have been thrown into a modeling role and have been cowboy’n it like the Wild West.  We’ll cover why you should bother with a conceptual model and invest some of your project time in the modeling task.  We will  go over some different modeling techniques around Normalized, Dimensional and Data Vault options.   And lastly, considerations for scalability, sustainability and empowering you with a Data Access Layer so you stay in control of your architecture as opposed to the application beast.  Yee-Haw!

Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: September 13

Time: 12:00 AM - 1:00 AM

Room: TBD

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

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: September 13

Time: 12:00 AM - 1:00 AM

Room: TBD

Database corruption is simply a fact of a DBA's life - if you haven't seen it yet, you will. Success or failure depends on having a solid plan to deal with different types of corruption.  In this session, we will discuss usage of related DBCC commands, monitoring for corruption with SQL Agent Alerts and Jobs, and when to restore versus repair. After attending this session, you will be able to check for corruption, identify different types of corruption, and take the appropriate measures for dealing with it. 
Speaker:

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: September 13

Time: 12:00 AM - 1:00 AM

Room: TBD

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

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: September 13

Time: 12:00 AM - 1:00 AM

Room: TBD

Follow along as we adventure through the vastness that is Availability Groups in SQL Server.  In this beginners guys we show you how to make an Availability Group from scratch, the new system tables that go along with Availability Groups, and how to troubleshoot your Availability Group using the system tables and SSMS.
Speaker:

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: September 13

Time: 12:00 AM - 1:00 AM

Room: TBD

Extended Events are used to gather a wide range of performance information to help troubleshoot performance problems in SQL Server. The system_health session is an Extended Events session that is included by default with SQL Server. This session starts automatically when the SQL Server database engine starts, and runs without any noticeable performance effects. This presentations will take you on an in-depth tour of the data provided in the system_health event session and how to use it to troubleshoot performance issues. Cases studies from real-life examples will be used to demonstrate tips and tricks.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: September 13

Time: 12:00 AM - 1:00 AM

Room: TBD

Business Intelligence Markup Language (Biml) is an XML language for Microsoft Business Intelligence that can take your Integration Services package development to the next level. Creating template packages added productivity to your Integration Services development effort. If the template design changes after development begins, a fair amount of rework to packages could be needed. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive design or redesign. 

This session will be a demo based session that will inspire you to make Biml your number one integration services development tool. Learn how to use Biml scripts to create staging tables and integration services packages. Add metadata to your Biml scripts and really watch the possibilities expand. 
Speaker:

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: September 13

Time: 12:00 AM - 1:00 AM

Room: TBD

Ever wonder what happens when a query is processed? Got a process that is running slow at the office and your boss in looking at you for answers? Want to look like a hero to your boss for fixing something that no one else could figure out? Then you might want to consider this session. Execution plans tell you what steps were taken to generate the results sets you did. In analyzing these plans, you can figure out what you are doing that is not efficient, so you can fix it. This session will give you the foundation you will need to do analysis so you can write better code and help your company with their performance issues.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: September 13

Time: 12:00 AM - 1:00 AM

Room: TBD

You’ve been hearing about this newfangled craze, and it’s time to learn exactly why it’s called POWERshell. You’ll want to take notes, or better yet, bring your laptop and start using Powershell immediately. We will get Posh running and then I’ll introduce you to the basic concepts, with examples to make things happen right away. We’ll work on SQL Server with Powershell, and learn some cool techniques. Come see this all-demo, hands-on session!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: September 13

Time: 12:00 AM - 1:00 AM

Room: TBD

It is easy to schedule full backups to run each night, but is that the right decision for your organization?  You say you have a backup strategy, but what is your recovery strategy?  Do you have a well-executed recovery plan?  In this session I will cover several methods for performing much needed backups and how to recover those backups.  Full, Differential, File Group, Transaction logs and recovery the tail end of a the log.  He will discuss industry best practices and hopefully cause you to validate and test your current strategy.
Speaker:

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: September 13

Time: 12:00 AM - 1:00 AM

Room: TBD

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

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: September 13

Time: 12:00 AM - 1:00 AM

Room: TBD

Sessions Found: 44
Back to Top