Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type

Sessions Found: 43
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:
Track 4

Level: Beginner

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 6

Level: Beginner

Session Code:

Date: March 29

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:
Track 3

Level: Beginner

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will take a look at things that you should regularly know and use when coding TSQL. How can you be really friendly to SQL? The items covered will show you things that will help ensure that your code is readable, efficient and maintainable. We will look at query semantics, datatypes, things to avoid as well as how to be super friendly to the SQL Engine and allow things to work well.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Big data and the cloud offer unparalleled opportunities for compute elasticity and deployment model flexibility. Learn about your options with the Windows Azure platform for deploying and managing Hadoop in the cloud. We'll demonstrate cluster deployment and integration with the various options.  
Speaker:

Session Type:
Regular Session

Track:
Track 8

Level: Intermedia

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

In SQL Server 2012, Microsoft added the new feature "contained databases".

Database movement with out the orphans! Developers working independent of an instance! Delegate some database administration
with out granting SA!  Sound to good to be true?

Come learn how these and other elements of a "contained database", can impact your database life.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 6

Level: Beginner

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Is there a great difference in the brain chemistry of someone fleeing a hungry mountain lion and someone presenting to a group of colleagues in a corporate board room? The answer is: NO. Over the past decade, a lot has been learned about the chemistry of the brain and why humans react the way we do to events in our environment. The concept of EQ (Emotional Intelligence) is a compelling and growing concept that applies this knowledge in a set of learnable, improvable skills for leading human beings. While EQ is often applied to corporate leadership, the parallels to presenting are fantastic. This session will explain the basics of EQ and demonstrate how you can apply it to make your presentations better in the following areas: * Crafting better slide decks * Preparing yourself for presenting * Delivering your content * Dealing with the unexpected Understanding and practicing the concepts of EQ can make your presentations a better experience for everyone in the room--including you.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Want to off load some of that reporting workload, make an emergency rollback during a production upgrade faster, or make managing your test databases easier?  If any of these appeal to you, then you should be familiar with database snapshots within SQL Server.  Available since SQL Server 2005, use of this feature can make your life a lot easier.We'll spend the first part of this session taking an in depth look at how database snapshots work. We’ll look at what exactly is happening behind the scenes when you create a snapshot and when you query a snapshot.  Once we've covered the basics, we'll spend the rest of our time analyzing and discussing a number of real world use cases where snapshots can be very beneficial and save you a great deal of time.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn about Database Unit Testing, how it can add value to your projects, and how to do It with Microsoft Visual Studio. Brian will be speaking about the fundamentals of what database unit testing is and the Microsoft Visual Studio Tools for implementing database unit test projects. This talk is intended for audiences who are new to database unit testing and want to learn the basics behind using Visual Studio to perform automated database unit tests.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 6

Level: Beginner

Session Code:

Date: March 29

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:
Track 6

Level: Beginner

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, we will discuss the enhancements and new features that are provided with Excel 2013 as Microsoft continues its roadmap with self-service BI. First we will go over the changes that have been made in Excel 2013, covering the new features. From there we will show how PowerPivot models can be used to integrate and load data to be used for analysis. Lastly, we will look at using Power View inside Excel to provide self-service reporting capabilities that are highly interactive. 
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Intermedia

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Ever encounter a table consisting only of BIGINT, CHAR(255), and NVARCHAR(MAX) columns?  Did your gut tell you that this is bad, but you had difficulty explaining why?  Did you know that these Datatype Choices can be a real performance killer?  Attend this session, learn how database records are stored within SQL Server, and why all data types are not created equal.  Armed with that knowledge, we will then explore several performance scenarios that may be impacting your systems right now!  When you leave, you should be able to explain why datatype choices matter to your colleagues, assess your own systems, and implement some best practices to mitigate these performance killers.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

The Microsoft SQL Server stack provides an excellent set of tools for storing, visualizing, and analyzing data, but sometimes we want to do more. In this session, we’ll take a look at the open-source statistical software R and how we can use it to connect to SQL Server, analyze data, and put the results of our analysis back into SQL Server for later use. We’ll look at examples of analyses performed by a fictional company as they segment their customers, forecast their sales, and examine interesting relationships among their product offerings. Along the way, we’ll see what some of these analyses would take if done in SQL Server itself and why R is so effective when paired with SQL Server.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you a jack of all trades?  Have you been writing application code AND designing databases?  Are you a DBA who can’t get that expensive database design training approved?  Are you spending lots of time altering your tables knowing there has just got to be a better way?  This session will take a dive into common pitfalls in database designs, prove out consistency issues and help you keep your applications fast and flexible.  A properly designed database should perform at the highest levels and not require a gargantuan effort to adapt to routine application growth.
Speaker:

Session Type:
Regular Session

Track:
Track 7

Level: Beginner

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

If you are working with Windows Azure SQL Database (WASD) then you know that the way to scale large data sets is to use federations. If you were using SSIS to move data into a federated database you know how challenging this can be. This year Microsoft released a new SSIS component that handles a lot of the federated headache. I'll give the steps you need to set up federations in your WASD database and how to use SSIS to fill the tables with data. 
Speaker:

Session Type:
Regular Session

Track:
Track 6

Level: Intermedia

Session Code:

Date: March 29

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:
Track 1

Level: Intermedia

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

So you've heard of Hekaton (In-Memory OLTP) but you aren't sure where to start or if it's for you or not. Maybe you've heard or read some information and not sure what's true or not. There's a number of misconceptions out there about Hekaton. By the end of this session you'll have a better understanding of what Hekaton is and how it may be able to help you. We'll discuss the basics of Hekaton and more as well as walking through some demos to show you how to use Hekaton and what it can do as well as help you get started diving into Hekaton on your own.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2014's In-Memory OLTP stores your data and indexes in a whole new way. In this session we'll take a look at way SQL Server 2014 In-Memory Database keeps track of your data with two new kinds of indexes, and why your data storage is so much more efficient.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 8

Level: Advanced

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

There are many automated test frameworks available for different types of applications, but Extract, Transform, and Load (ETL) data movement applications seem to lack an efficient and easy to use automated test suite. 

We will review how the automated test suite is a data driven approach by showing how the tests self-generate based upon the data in the Information-Model schema in SQL Server and 4 slender custom tables that define the field data mapping between the source and target.

The last half of the session will be a demonstration of the tests to illustrate how they execute. To do this we will quickly review the stored procedure code that generates the tests. 
Speaker:

Session Type:
Regular Session

Track:
Track 6

Level: Intermedia

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Skyline Technologies will share their experience in using Agile project methodology and "Dev Camp" events to promote innovation and build technical skills - all while having fun!  In particular, Skyline will highlight  their recent project to demonstrate the mobile BI capabilities of Datazen and PowerBI using data around the recent NCAA March Madness.
Speaker:

Session Type:
Regular Session

Track:
Track 7

Level: Intermedia

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

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