Build Schedule

Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type

Sessions Found: 34
It depends, every situation is different. The question is often asked of DBA's to provide a solution to very open ended requirements.  However, the best solution can only be provided if the database professional is getting all the answers.  This session is a case study into many of Disaster Recovery options that we as database professionals have.  Understand the answers to the important questions that  we should be asking to provide the best solution not only for the database but for the business as well.  As an attendee you will learn how to change an answer from it depends into a solid solution that can be built upon. We will take examples from experiences and as a group determine what the best solution is. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DB Developer/DBA

Level: Beginner

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you just starting out in the DB world? Are you unsure of things that you should know? Are you a developer wanting to gain further insight on how to improve your SQL Skills? If you answered 'Yes' to any of those question, then this is the session for you!  John will be talk about things that he's seen in the trenches that every DBA should know and understand.  
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

We will explore data quality issues that face today’s business and how Data Quality Services 2012 can help IT Pros and Data Stewards meet those challenges. We will start from zero, build a knowledge base, profile data to train our knowledge base and then use that knowledge to highlight both the cleansing and matching capabilities of DQS. This session will also cover the DQS SSIS component that’s available in SQL Server 2012.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SQL Server 2012 Roundup

Level: Intermedia

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

There are many white papers and articles about table partitioning, but when it comes down to implementing partitioning there is little "real world" documentation.  This presentation will cover definitions (so you will know what I am talking about), tips on what tables to partition and how to pick a partition key, and finally a real world example with scripts on implementation and ongoing maintenance of the partitioned tables.  
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

If you’re like most Database Administrators then you already work with data that is big, so what is this big data thing all about?  This session will cover the significance of big data by comparing and contrasting it to the SQL Server relational database environment.  It will also demonstrate the value a big data ecosystem can provide to your technology infrastructure organization by using it to complement your existing data architecture, and by having it co-exist in effective ways with your SQL Server databases. Live demonstrations will show how you to get maximum value out of big data with tools such as Sqoop, Hive and Pig so that you can perform bulk data transfers, queries, and ETL using SQL Server and HDFS, the Hadoop file system. 
Speaker:

Session Type:
Regular Session

Track:
Big Data/Cloud

Level: Beginner

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

If you’re like most Database Administrators then you already work with data that is big, so what is this big data thing all about?  This session will cover the significance of big data by comparing and contrasting it to the SQL Server relational database environment.  It will also demonstrate the value a big data ecosystem can provide to your technology infrastructure organization by using it to complement your existing data architecture, and by having it co-exist in effective ways with your SQL Server databases. Live demonstrations will show how you to get maximum value out of big data with tools such as Sqoop, Hive and Pig so that you can perform bulk data transfers, queries, and ETL using SQL Server and HDFS, the Hadoop file system.
Speaker:

Session Type:
Regular Session

Track:
Big Data/Cloud

Level: Intermedia

Session Code:

Date: September 22

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:
Professional Development

Level: Beginner

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

PowerPivot is a powerful new tool able to slice and dice data in memory very fast. But how do you acheive complex situations like, parent child hierarchies, Many to Many, and using inactive Relationships. Come see these complex DAX functions and leave with some great DAX knowledge.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Advanced

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will describe the best practices for designing a data warehouse to get the most out of SQL Server.  Raphael has worked in data warehousing for 12 years and will blend experience, with best practices and recommendations from Microsoft's Fast Track program.  Each version of SQL Server introduces new features specifically for data warehousing - by applying the correct technique, feature, hint, modelling approach and layout the data warehouse will be faster and more scalable.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Advanced

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Develop a Quick and Dirty Web interface to your database: for the DBA and other non-developers. So you want to develop to your database? Do you have your own tools to check performance? Does Chris Shaw's Utility Database sound like a tool you have and want a web interface, but don’t want to write a lot of code? I will demonstrate how a simple ASP.Net MVC site can be developed and deployed against your database. See firsthand how easy we can use Shaw's utility database and access across the web over a mobile device so you may manage performance online whilst zipping your drink of choice.
Speaker:

Session Type:
Regular Session

Track:
DB Developer/DBA

Level: Beginner

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will provide a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. This session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

If you have ever been responsible for a mission critical database, you have probably been faced with a high stress, emergency situation where a database issue is causing unacceptable application performance, resulting in angry users and hovering managers and executives. If this hasn't happened to you yet, thank your lucky stars, but start getting prepared for your time in the hot seat. This session will show you how to use DMV queries to quickly detect and diagnose the problem, starting at the server and instance level, and then progressing down to the database and object level. Based on the initial assessment of the problem, different types of DMV queries will help you narrow down and identify the problem.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Exploring your data has never been easier with Power View included in SQL Server 2012. Learn how to quickly analyze and discover new trends in your information by using the intuitive, easy to use, and business-friendly tool. This session will not walk through installation of the tool, but will instead describe the different visualizations provided and when you would use each one.
Speaker:

Session Type:
Regular Session

Track:
SQL Server 2012 Roundup

Level: Beginner

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Everything that's old is new again, as Windows Server moves back to the terminal interface.  With SQL 2012, we can now run our SQL Servers on Server Core, a version of the Windows OS that is smaller and more secure.  This presentation will introduce you to Server Core, how to prepare it for a SQL installation(including using Powershell for management), and how to actually install SQL 2012 on to it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DB Developer/DBA

Level: Beginner

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

See the architecture of the largest Azure projects in the world.  Find out why most use a combination of SQL Azure and NoSQL. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Big Data/Cloud

Level: Intermedia

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

"Interviews are so easy," says absolutely nobody.  In fact, interviewing for your next DBA or SQL developer job is a very tricky process, with many common pitfalls.  In this fun and interactive session, we'll give you all the best advice you've never heard about pre-interview preparation, typical traps, and the new professionalism. You will start to refine the way you present yourself, tailor your answers appropriately, and learn about our revolutionary negotiating tactics.  Most importantly, we'll quantify the most difficult aspect of interviews: knowing when to keep silent.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Professional Development

Level: Beginner

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you wanted to speak, but weren't sure how or where to start? Maybe you've done some presentations, but still aren't comfortable with building your deck or working in front of an audiance? This session will show you how you how to create great presentations by using many of the same techniques musicians use to create songs and perform on stage. Participants won't need to have any musical training or previous speaking experience to benefit from this session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Professional Development

Level: Beginner

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2012 has many new T-SQL features and enhancements that will simplify your code and life.  We’ll roll up our sleeves and dive in head first to take a look at some of the new features.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SQL Server 2012 Roundup

Level: Beginner

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Well known RDBMS’ have similar physical designs to meet ACID requirements and production standards.  As most DBA’s are required to support more than one platform these days, this presentation will introduce the SQL Server DBA to the fundamental concepts of Oracle database administration.

The attendee will leave this session with a solid understanding of the similarities and differences in comparison to common Oracle features, design basics and how they correspond to SQL Server architecture. 

 
Prerequisites:  An open mind to different database platforms and a solid understanding of SQL Server.  No exposure to Oracle database administration is required to attend this presentation.
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Ever gotten stuck with a vendor application?  Ever wanted to gleam some information from that database?  It's happened to many of us.  Whether it be a ticketing or a call system, sometimes you just want to get more information out of it.  In this talk, we'll discuss what methods are available to you to try and discover where the data resides and how it flows through the database.
Speaker:

Session Type:
Regular Session

Track:
DB Developer/DBA

Level: Intermedia

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

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