Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 39
Head starting to explode from all the technical information you’re absorbing?  Come spend a session with us while we play games with Reporting Services…literally!  Come watch as Stacia Misner and a special guest introduce you to some  word play, all wrapped up in SQL Server Reporting Services.  She'll push the limits with what can be built in SSRS and show you how to have fun while doing it.  Board games and SQL…who could ask for more?
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI2

Level: Beginner

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

I spend a large portion of each day looking through performance reports and dashboards from various organizations around the world. I've identified some very common performance problems and/or misunderstandings that tend to have easy, though not always obvious, solutions.

I intend to share the whys and hows of these issues with anyone who would like to attend during a SQL Saturday session.
Speaker:

Session Type:
Regular Session

Track:
Dev

Level: Intermedia

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

In this hour long session We'll delve into the Health Insurance Portability and Accountability Act (HIPAA) and what implications it has for us as data professionals.  We'll discuss SQL Server best practices that can help protect ourselves, our company, and the people whom we serve.
We'll also dive into several features in SQL Server that can help in this endeavor. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: March 09

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

Level: Beginner

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

If you don't have the chance to work on different kinds of projects, it can be tough to grow all the necessary skills to further your career. Take control of the situation by building a virtual lab at home.

We'll begin the session by talking about why you might want to build a lab, and what you'll need to complete the task - nothing more than your home computer and free software. We'll review the basics of virtualization as it relates to VirtualBox. Finally, we'll dive into an example of building a Windows Server 2012 cluster, and talk about how you can use these networking and server skills to advance your SQL Server education.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Professional Development / Misc

Level: Intermedia

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Life is all about choices, and when it comes to SQL Server it is no different. If you don't have a methodology for researching questions and resolving issues then you need to get one, and soon. Join SQL Server MCM and MVP Thomas LaRock from Confio Software as he helps guide you while YOU make the choices in this interactive performance tuning adventure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Mixed

Level: Advanced

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance.  I have given this talk over FORTY times now and it is always very highly rated!
Speaker:

Session Type:
Regular Session

Track:
Dev

Level: Intermedia

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Data Quality (DQ) tools are typically expensive and difficult to integrate into your ETL and governance plans but it doesn't have to be that way. During this fun, highly-interactive session, Kevin Hazzard (Microsoft Windows Azure MVP and author of the book Metaprogramming in .NET), will show you how to implement a modular, highly resilient DQ foundation from the tools you already own, no matter which version of SQL Server you're using today. At the end of this discussion, Kevin will give you a copy of his schema and his standard DQ function library that you can use in your own databases.
Speaker:

Session Type:
Regular Session

Track:
BI2

Level: Intermedia

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Compare and contrast how each Microsoft BI tool satisfies requirements for visualization, interactivity, data sources, formatting, printing, and exporting.  We'll explore the strengths and limitations of each tool for creating dashboards & scorecards with PerformancePoint, Reporting Services, Excel, and Power View.  This session will help you with things to consider when selecting one tool in the Microsoft BI stack versus another.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

You've fallen into a job that requires you to manage a SQL Server Database Management System. Now you have to keep these databases on their feet. You've heard of this concept called a backup, and it sounds great, but you sure don't know what it is. This session is for you. We're going to go over backups, right from the beginning, so that when you come out of this session you can go back to your systems and set up backups, log backups, differentials, and anything else you might need. Further, you'll know how to recover your database in the event of an actual failure. The fundamentals you need to get a good backup in place and then be able to restore it will be covered in this session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *Identity Crisis * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.
Speaker:

Session Type:
Regular Session

Track:
Mixed

Level: Intermedia

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Too often reports sent on a daily basis end up in a mail filter. Only a small percentage of the reports are actually necessary for someone to take action. How happy would your users be if you could only provide the report when they actually needed to look at it? You can, by using subscriptions and alerts in Reporting Services 2012. This session will provide a comparison of regular subscriptions, data-driven subscriptions, and data-driven alerts in Reporting Services 2012 in SharePoint Integrated mode. Attend this session to learn how to provide reports that will be read rather than filtered.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

This presentation will explore the evolution of storage architectures, reviewing the technology inflection points and core business drivers that have propelled the transitions from direct attached to monolithic to modular storage solutions.  We are at the beginning of the next major technology inflection driving enterprise storage. Solid state drives (SSDs) promise to solve the performance challenges inherent in spinning disks, rendering traditional storage architectures obsolete.  But SSDs by themselves are not the solution. The next decade will be dominated by storage architectures designed from the ground up to leverage the best characteristics of flash and disk. Will these new solutions be able to simultaneously deliver high performance and high capacity primary storage? And can they improve data protection, improving recovery point and recovery time objectives with far less cost and complexity? Learn the answer and examine real-world case studies in this informative session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Professional Development / Misc

Level: Beginner

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Mike Hillwig is known as the Cranky DBA. You probably have pain points in your environment that make you cranky, too. Mike has lots of horror stories to tell about bad SQL Server implementations and practices. More importantly, he has developed a list of 12 key tips for managing your SQL Server environment. By following these tips, you’ll make your DBAs, developers, and system administrators a little less cranky.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

It can quickly become overwhelming to track all of your SQL Server Integration Services (SSIS) packages for loading data.  Trying to figure out ‘what ran when’ and ‘who did what’ are tasks we've all had to face.  CapTech Consulting has successfully solved these common data management problems by implementing a data management framework for multiple organizations.  Come to this lunchtime session to learn how to implement your own SSIS framework and to never worry about your SSIS packages again!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Dev

Level: Beginner

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Common Table Expressions (CTEs) serve two main functions: first they remove the clutter of subqueries out of the FROM clause while simultaneously making them easy to reference multiple times by alias if need be, and second they make it possible to do recursive queries. Learn the basics of using CTEs to streamline T-SQL code and to query self-referential tables.
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Wondering how all that big data is going to be moved around? Or how you are going to move any of it into your SQL Server environment? Come to this session, and learn about some of the familiar and not so similar tools you can use for moving big data. We’ll compare the options, discuss how they can work with your existing Microsoft technologies, and provide some guidance on when to use each of the tools.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI2

Level: Beginner

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

During this talk I'll walk you through the process actually used to migrate a client's systems from hosted in a company closet to multiple Microsoft Azure data centers.  Along the way we'll discuss the planning that went into the migration, the testing we went through, the pain points we hit,  all the way to up and running in the cloud. This session covers the roadmap, we won't go through the actual migration itself...that took almost a year to complete.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Professional Development / Misc

Level: Intermedia

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Just because you're using an Azure SQL database does not mean you can avoid tuning queries. Microsoft has throttling in place that could seriously impact your systems if your queries are using up lots of resources. This session will introduce you to the tools you have available to identify poor performing queries, such as dynamic management objects and others. You'll learn how to understand why a query is running slow using the Azure Portal execution plans. This understanding will enable you to fix your poorly performing queries.  All in the cloud.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Professional Development / Misc

Level: Intermedia

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

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