Build Schedule

Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type

Sessions Found: 42
The 2012 release of SQL Server introduces 14 new functions for developers. This list includes functions for conversion, date/time calculation, enhanced logic, and string manipulation. In this session we’ll cover the ins and outs of these new functions, making you a better T-SQL developer.
Speaker:

Session Type:
Regular Session

Track:
Training 4

Level: Intermedia

Session Code:

Date: February 08

Time: 12:00 AM - 1:00 AM

Room: TBD

Does this sound like you? You were just given access to SSRS and you want to make a report. Or, you're a DBA and could use a daily report. Either way, I've got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed. We’ll even look at the differences between building a report in BIDS (Business Intelligence Development Studio) and Report Builder 3.0. We’ll use SSRS (SQL Server Reporting Services) 2012. The query makes no difference, this time it's all about the output. 
Speaker:

Session Type:
Regular Session

Track:
Training 5

Level: Beginner

Session Code:

Date: February 08

Time: 12:00 AM - 1:00 AM

Room: TBD

The term "big data" dominates the headlines in technology news these days, but what is the fuss really all about? What are the implications for traditional data warehousing and reporting? What kind of technology and skill sets do you need to successfully implement to a big data strategy? Come to this session for a gentle, business-focused introduction to big data and leave with some inspiration and practical steps for tackling your first big data project.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Training 1

Level: Beginner

Session Code:

Date: February 08

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, we’ll show you how you can expose your reportable data in the cloud and use Microsoft’s Power BI in different ways to empower your business users to Self-Service BI.  Equal demo time will be given to all 4 of Power BI’s pillars:  Power Pivot, Power View, Power Query, and Power Map.
Speaker:

Session Type:
Regular Session

Track:
Training 5

Level: Beginner

Session Code:

Date: February 08

Time: 12:00 AM - 1:00 AM

Room: TBD

Much of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single destination.  Creating the individual packages can be tedious and it's easy to miss something in the process of generating the same basic package over and again.  BI Markup Language makes it easy to build new packages, and PowerShell makes creating the BIML scripts easy.  In this session we'll show you how to use PowerShell to generate dozens of SSIS packages doing similar tasks from a defined set of ETL sources.
Speaker:

Session Type:
Regular Session

Track:
Auditorium

Level: Intermedia

Session Code:

Date: February 08

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:
Auditorium

Level: Beginner

Session Code:

Date: February 08

Time: 12:00 AM - 1:00 AM

Room: TBD

 BIML--Business Intelligence Markup Language is your key to faster development of SSIS Packages. This session will guide you through an introduction to BIML. We'll explore the capabilities of BIML and BIMLScript, available through the free Codeplex BIDSHelper download. We'll move through basic syntax of plain BIML, and progress to BIMLScript, using LINQ, and Lambda expressions to access enterprise metadata, speeding SSIS development exponentially.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Training 1

Level: Intermedia

Session Code:

Date: February 08

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

Level: Beginner

Session Code:

Date: February 08

Time: 12:00 AM - 1:00 AM

Room: TBD

As the number of SQL Server versions and features grow over time so does the the difficulty in maintaining a set of tools for working with all of them on your local machine. Add in that some features require multiple physical instances and suddenly a single installation isn't enough. Need to quickly switch between versions and editions of SQL Server? Want to learn how to set up a cluster? Or maybe you want to try out the latest features in SQL 2012...virtualization offers a convenient way to do any or all of these. In this session we'll show you how by covering the fundamentals of desktop virtualization and demonstrating how to set up a virtual playground on your own machine.
Speaker:

Session Type:
Regular Session

Track:
Training 5

Level: Intermedia

Session Code:

Date: February 08

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, I will introduce you to SQL Server Data Tools.  With SSDT, you can create database projects to act as the system of record for your database schema.  You can also utilize SSDT to automate SQL code deployments into multiple environments.  And did I mention the tool is free? Your SQL code can finally be treated as a first class code citizen.
Speaker:

Session Type:
Regular Session

Track:
Training 4

Level: Beginner

Session Code:

Date: February 08

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn from a Microsoft Certified Master how to secure your SQL Server infrastructure and your Windows installations to enhance resiliency and minimize exposure to attacks—all without touching any of your code!
Speaker:

Session Type:
Regular Session

Track:
Training 1

Level: Intermedia

Session Code:

Date: February 08

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:
Training 5

Level: Beginner

Session Code:

Date: February 08

Time: 12:00 AM - 1:00 AM

Room: TBD

Great database performance starts with great database design. During the database design process it is important to select your datatypes wisely. The wrong choices will often lead to wasted space, increased response times, and less stability. Additionally you run the risk of having your design not scale as well as it should. Leave this session armed with the knowledge you need to help your databases perform at their peak efficiency. 
Speaker:

Session Type:
Regular Session

Track:
Training 1

Level: Intermedia

Session Code:

Date: February 08

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:
Training 4

Level: Beginner

Session Code:

Date: February 08

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 on a coffee break. 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:
Auditorium

Level: Beginner

Session Code:

Date: February 08

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:

Session Type:
Regular Session

Track:
Training 2

Level: Beginner

Session Code:

Date: February 08

Time: 12:00 AM - 1:00 AM

Room: TBD

Hierarchical data sets are everywhere. If you haven't worked with one yet, you will. If you're already working with them, you know they can be horribly complex, slow performing, difficult to maintain resource hogs that can really take the steam out of any GUI or batch process. This simple but code intensive "black arts" session shows you how to quickly and easily get around all of that using all 3 common hierarchical structures and includes a very high performance method (100,000 nodes in  less than 4 seconds and 1 Million nodes in less than a minute) for converting Adjacency Lists to Nested Sets that even a beginner can understand.  As a finale`, we'll cover a new "pre-aggregated" Hierarchical table structure that answers most of the questions you'd ask of a Hierarchy. You just have to know that a Tally Table is involved somewhere in this. ;-)
Speaker:

Session Type:
Regular Session

Track:
Training 6

Level: Intermedia

Session Code:

Date: February 08

Time: 12:00 AM - 1:00 AM

Room: TBD

Columnstore indexes were introduced in SQL Server 2012, along with a new type of query processing "batch mode". In SQL 2014 they get even better--we can use a Columnstore index as a clustered index and update it. In this session we will explore the basics and beyond of Columnstore indexes and how they can help your warehouse performance. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Training 3

Level: Intermedia

Session Code:

Date: February 08

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:
Training 2

Level: Intermedia

Session Code:

Date: February 08

Time: 12:00 AM - 1:00 AM

Room: TBD

If you’re like me, you’ve been using SQL Trace and Profiler since you started using SQL Server.  They’re like old friends, tried and true.  You know how they work, you know what you can capture, you know how to find the data you need.  But now you’ve been told that your good friends have been deprecated in SQL Server 2012, and you need to become best friends with Extended Events.  What is THAT all about?  It’s ok.  Really.  In this session we’ll look at Profiler and Extended Events side by side to see how easy it is to transition to Extended Events.  We’ll step through real world examples using Extended Events to do what you’re used to doing with Trace, and even more.  You can find the time learn Extended Events…today.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Training 3

Level: Beginner

Session Code:

Date: February 08

Time: 12:00 AM - 1:00 AM

Room: TBD

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