Build Schedule

Advanced Filters:
  • Track

    clear all












  • Speaker


  • Level


  • Session Type

Sessions Found: 63
In this session we will discuss how to perform upgrades while maintaining high availability of your SQL server infrastructure by leveraging rolling upgrades. We will review how to use database mirroring or AlwaysOn Availability Groups for this, along with a simpler version using Log Shipping. This is a demo-intensive session that you won't want to miss. 
Speaker:

Session Type:
Regular Session

Track:
DBA Bonus Track

Level: Intermedia

Session Code:

Date: September 27

Time: 12:00 AM - 1:00 AM

Room: TBD

If you work with SQL Server, either as a developer, Dev/DBA, or accidental DBA, we are all DiBA's! but in order to keep that status and not run into "fire drill" mode, you need to make sure you set the ground to keep on looking good. This session will focus on how to set your Database Server environment in a way that will switch you from reactive to proactive mode. And I will demo its implementation via Policy Based Management. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA Admin 2 Track

Level: Intermedia

Session Code:

Date: September 27

Time: 12:00 AM - 1:00 AM

Room: TBD

What is "Windows Azure SQL Database" all about ? What does this mean for me as a DBA ? What is the process for setting up a Windows Azure database ? How would I go about migrating one of my databases to "The Cloud" ? How do I possibly leverage this new technology in my production environment ? 
If you are a production DBA and have contemplated one or more of these questions, this session is for you! Maybe, you have been tasked with finding out about "The Cloud". Join me in exploring the cloud where I will show you how SQL Server works in the Windows Azure SQL Database world. We will run through the simple process of configuring a Windows Azure SQL database. We will investigate the similarities and differences between on premises SQL Server and Windows Azure SQL Databases. We will even look into the DR, HA, monitoring and performance tuning options available with Windows Azure. 
Speaker:

Session Type:
Regular Session

Track:
DBA Admin Track

Level: Beginner

Session Code:

Date: September 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Microsoft Access makes an unparalleled front-end for any version of SQL-Server. This session will explain the how and why.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI/Big Data/Misc

Level: Intermedia

Session Code:

Date: September 27

Time: 12:00 AM - 1:00 AM

Room: TBD

With the release of SQL Server 2012 Microsoft introduced FileTables, a better way to store large objects inside a database. With FileTables you get the advantage of the security and transactional consistency of a database AND improved file streaming from the OS. In this session I'll show you how easy it is to set up and use FileTables, as well as improved methods of searching document keywords with FullText and Semantic searches.
Speaker:

Session Type:
Regular Session

Track:
DBA Admin Track

Level: Intermedia

Session Code:

Date: September 27

Time: 12:00 AM - 1:00 AM

Room: TBD

If you would like to see how real businesses build real-world Big Data Analytics solutions, then come to this session. I will dive right into a number of reference architectures and demos of Big Data Analytics using SQL Server, Hadoop and MongoDB.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI/Big Data/Misc

Level: Intermedia

Session Code:

Date: September 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn how to build an MDM Center of Excellence with Best Practices using extensive demo. The session will including building a complete sample customer domain including data quality, merge, match and deduplication, and business workflow.
Speaker:

Session Type:
Regular Session

Track:
BI Track

Level: Beginner

Session Code:

Date: September 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Cloud, Cloud, Cloud.  Microsoft is "all in". CxOs love the idea of renting compute resources.  You know this is where our profession is headed, but when and how fast.  When should you jump on board?  The good news is cloud will not eliminate or even reduce the need for IT and Data professionals.  The bad news is our world and our profession is changing.  Adapt or be left behind.  Come see what Microsoft Azure has to offer Data Professionals.
Speaker:

Session Type:
Regular Session

Track:
Cloud/Security

Level: Intermedia

Session Code:

Date: September 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Not every system has a database architect available to design it. But what happens when a database is created and the proper care wasn't taken into designing it? This session will take a real-world look into my experiences with some database design choices. We'll take a deep look into these design choices including a detailed discussion on why they didn't work and what could have been done better. We may even take a peek into SQL Server internals. This session is primarily for data professionals that are new to database design.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA Performance Track

Level: Intermedia

Session Code:

Date: September 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Database development has traditionally been done using SQL Server Management Studio query window as the primary tool, when far more powerful tools are available in your toolset. This is the equivalent of writing a document using Notepad, when MS Word is available on your desktop. This session will take you through some of the basics of using SSDT, show you how to use VS2012 database projects effectively, how to utilize TFS build, test and deploy your code. I've had my share of bumps on the road to deploying these toolsets. At the end of this session you will have a good introduction into how to use the tools and how to avoid some common issues with legacy code you are already have in your environments.
Speaker:

Session Type:
Regular Session

Track:
DBA Admin 2 Track

Level: Intermedia

Session Code:

Date: September 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn about database projects.  Relieve yourself of deployment script nightmares.  Integrate the database with your application's nightly builds.  Link all of your database object changes to TFS tickets.  Deploy your database using DACPACs and guarantee that the database created in dev and tested in QA, is *the* database that ends up in production and other client facing environments.  You can even create unit tests!!!  Database projects are a powerful tool.  Attend this session and find out how they can help you!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA Admin Track

Level: Beginner

Session Code:

Date: September 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Despite SQL Server Reporting Services (SSRS) being a very flexible and adaptable tool when it comes to visualization techniques, very few venture beyond its ready-made charts. Most of the time, all it takes to build a chart considered “outside the scope” of SSRS is a bit of lateral thinking. Sometimes, we need to go a little further and use custom code. Join this session as we bust popular myths around "impossible in SSRS" visualizations and construct them live in SSRS!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI Track

Level: Advanced

Session Code:

Date: September 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Documentation is the bane of every DBA's existence. We all know we should do it but it's time consuming; by the time you're finally done it's probably out of date. Throw in the new servers you just found out about last week and keeping documentation up to date can turn into a full time job. And with everything we have to do in our day, who has time for that?

You need a way to work smarter, not harder, and automate your documentation. It can be done, and in this session you'll learn how to discover all the SQL Servers on your network, document their configuration from top to bottom (including OS details), and diagnose common problems before they turn into big headaches - all while you're out at lunch. You'll look like a rock star without writing a line of code on your own or having to ask management to sign a check.


Attend this session and walk away with everything you need to generate documentation for your entire SQL Server environment on your first day back at the office
Speaker:

Session Type:
Regular Session

Track:
DBA Bonus Track

Level: Beginner

Session Code:

Date: September 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Every organization has to deal with the constant loading of text,csv,excel,pipe, fixed width, and ragged right files in this session we are going to build metadata driving ETL framework that will dynamically create an standard SSIS template that will encompass the file format, enforce standards, and keep track of data lineage across an organization. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SSIS/Virtualization Track

Level: Advanced

Session Code:

Date: September 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you have a new piece of hardware going into service and want to see how well it performs? Or do you have a few systems and want to see how they compare against each other? Multiple free and easy ways to stress test your SQL Servers exist by simulating an OLTP workload against a real SQL Server and the infrastructure underneath. In this session we will demonstrate how to test your storage and SQL Server instances to get raw performance numbers that you can use to compare performance of machines across your enterprise. The utilities DVDStore, HammerDB, and SQLIO will be demonstrated in depth. 
Speaker:

Session Type:
Regular Session

Track:
DBA Admin 2 Track

Level: Beginner

Session Code:

Date: September 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Are your backups like a stack of cash free for the taking, or a hardened ATM?  Are your database connections scrambled and safe or are you sending data over the party line?  In this session we will walk through the many ways SQL Server allows us to protect our data using encryption. We will evaluate the various methods for protecting data at rest, in the database, and while in transport.  Since nothing comes for free, we will look at how much all of this is going to cost us, in time, money, and failure to implement. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Prof Dev/Security

Level: Beginner

Session Code:

Date: September 27

Time: 12:00 AM - 1:00 AM

Room: TBD

New to BI?  Loading data warehouses got you down?  Do Connection Managers, Control Flows, and Data Flows make your head swirl?  Well, don't fret.  In this session, we will peel back the onion that is SQL Server Integration Services and identify the elements necessary to develop efficient, high performance ETL packages that will shock and amaze your friends and coworkers. Expect to cover several real-world scenarios including implementing best practices around disparate data sources, package design and development, logging, troubleshooting, and deployment.  This will be an interactive session based on your input; come with questions!
Speaker:

Session Type:
Regular Session

Track:
SSIS/Virtualization Track

Level: Beginner

Session Code:

Date: September 27

Time: 12:00 AM - 1:00 AM

Room: TBD


In this session we will step through the very basics of SQL Server for the new DBA. Since we can not delve into the SQL Server without a SQL Server, we will install one from scratch. Next we will add a database, write a couple of simple queries and export and import some data. All of this will be in preparation for our final look at running a report using data that we just loaded. At the end you will be familiar with many of the tools and techniques that DBAs use every day.
Speaker:

Session Type:
Regular Session

Track:
Beginner

Level: Beginner

Session Code:

Date: September 27

Time: 12:00 AM - 1:00 AM

Room: TBD

More CPU/more Memory/More Spindles’  has been the mantra for increasing performance for SQL Server environments that are resource bound.  This often leads to complicated file placements,  complicated lun/disk striping, complex partitioning schemes and creative resource handling.  Storage has been the last area of hardware technology that has improved performance for enterprise systems,  but now the next generation of storage is here… Flash, and its available and practical for database systems.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
T-SQL/SQL 2014 Track

Level: Beginner

Session Code:

Date: September 27

Time: 12:00 AM - 1:00 AM

Room: TBD

In the first half hour attendees will learn about the various roles related to databases including the Database Administrator, Database Developer, Report Writer, and ETL Developer. In the second half hour attendees will learn how to install SQL Server on a laptop/PC and apply a service pack.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Beginner

Level: Beginner

Session Code:

Date: September 27

Time: 12:00 AM - 1:00 AM

Room: TBD

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