Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 24
There are a plethora of regulatory compliance mandates that affect business today with names like Sarbanes-Oxley, PCI-DSS, and HIPAA. How does a database professional implement these controls in your SQL Server infrastructure? We will review the basics of the GRC (Governance, Risk Management, and Compliance) methodology. You will learn about the tools that you can use to achieve compliance such as TDE, Auditing, and Identity Management. Come to this session and learn how to build a compliant infrastructure that keeps the DBA team, the auditors and the business leaders happy.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Wildcard 2

Level: Beginner

Session Code:

Date: May 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Wow, deployment of SSIS packages in SQL Server 2012 is radically different, when the new SSIS catalog is used (“Who Moved My Cheese?”). This session examines the “new” SSISDB, its architecture and functionality and compares that to the “old” method of Package Configurations in previous versions of SSIS. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Advanced

Session Code:

Date: May 17

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

Level: Intermedia

Session Code:

Date: May 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Big Data is a hot topic in the news today. Many organizations are trying to develop their big data strategy but there is much confusion over the definition of the term and how it aligns to technology. Microsoft’s SQL Server Parallel Data Warehouse (PDW) provides a platform upon which to build your big data solution. This session will peel back the covers and discuss what big data means and provide a deep dive into the architecture of PDW. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: May 17

Time: 12:00 AM - 1:00 AM

Room: TBD

The pace of business accelerates fairly continuously and application development moves right with it. But we’re still trying to deploy databases the same way we did 10 years ago. This session addresses the need for changes in organizational structure, process and technology necessary to arrive at a nimble, fast, automatable and continuous database deployment process. We’ll use actual customer case studies to illustrate both the common methods and the unique context that led to a continuous delivery process that is best described as a pipeline. You will learn how to customize common practices and tool sets to build a database deployment pipeline unique to your environment in order to speed your own database delivery while still protecting your organization’s most valuable asset, it’s data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Dev

Level: Intermedia

Session Code:

Date: May 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Do It Yourself Geocoding -- Step-by-step instructions on how to build a CLR assembly that will allow you to directly query various web services for geospatial data. We will also learn how to ensure a high level of confidence in the accuracy of your geospatial data.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Wildcard 2

Level: Intermedia

Session Code:

Date: May 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you ever had to import a ton of CSV or DBF files into a database?  Did you create a separate connection object for each file in SSIS?  I will show you how to create one connection object and dynamically change that as you navigate through the file system, greatly reducing your development time.  Yes, we will be typing in this demo!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Dev

Level: Intermedia

Session Code:

Date: May 17

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

Level: Beginner

Session Code:

Date: May 17

Time: 12:00 AM - 1:00 AM

Room: TBD

The best way to understand why your query is running slow is to look at the execution plan. But, knowing how to get started in execution plans, what to look for, what's important, can all be terribly confusing. This session will provide you with a simple set of tasks to get you started reading execution plans. You'll learn where to start, what to look for first, and you'll be better prepared to tune your queries. We'll also look at some methods you can use to write queries against the plans themselves in order to more easily and quickly identify potential issues within your plans. The information presented will be immediately applicable on the queries you have running back in the office.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Dev

Level: Intermedia

Session Code:

Date: May 17

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

Level: Beginner

Session Code:

Date: May 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn how to practice hacking without going to jail or getting fired. In this presentation we'll be demonstrating how to exploit weak SQL servers with actual tools of the penetration testing trade. You will learn why the SQL Service is a popular target on your network and how to defend against basic attacks. We will focus mostly on detailed tactical defenses but also cover some higher level strategic defenses.
Speaker:

Session Type:
Regular Session

Track:
Dev

Level: Advanced

Session Code:

Date: May 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you feel like you spend hours going round-and-round with your system, storage, and virtualization administrators over SQL Server best practices? Are their application-agnostic requirements hurting your SQL Server’s performance, or worse, their reliability? David Klee (@kleegeek) will discuss valuable insight into how to start and work through the common conversations with them on the SQL Server infrastructure practices that matter to you the most, and how to succeed in getting what you need while keeping everyone happy.
Speaker:

Session Type:
Regular Session

Track:
Wildcard 1

Level: Intermedia

Session Code:

Date: May 17

Time: 12:00 AM - 1:00 AM

Room: TBD

This isn't your typical talk on "partitioning".  This is a deep dive into all the problems that you'll run into when partitioning new or existing "Write Once, Read Many" tables, such as large Audit Tables, and how to code around them.  You'll also learn the methods to support three of the best reasons for partitioning such monster tables... MUCH shorter nightly index maintenance, MUCH shorter and smaller backups, and MUCH shorter "Get back in business" piecemeal restores.  We'll also learn how to do the "impossible"... compact a File Group (one per partition) so that there's virtually no unused space in the underlying file.  After all, we don't want to set any "free" disk-space to "Read Only".  Don't let the "Advanced" rating of this session scare you away.  Anyone with a decent handle on T-SQL (or wants one) will be able to understand this session because "all will be explained" and there will be oodles of well-documented code to back up the explanations.
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Advanced

Session Code:

Date: May 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Reporting has moved to the cloud with the introduction of Power BI.  Get the Power with Power Query, Power Map, Power Pivot and Power View which you will learn about while finding out how they all work together with Microsoft Excel and Office 365 to create a Self-Service Business Intelligence application in the cloud.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Wildcard 2

Level: Beginner

Session Code:

Date: May 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Let's face it, auditing isn't fun.  But if you're a DBA, you need to know what's going on in your SQL Server instance.  Fortunately, SQL Audit makes it easy.  In this session, we'll cover what you can and can't audit using SQL Audit, enhancements in 2012, configuring database and server audits, ways to process output, and ideas for how to implement SQL Audit on a larger scale.  Auditing doesn't have to be hard.  And with the help of a little custom coding, it can even be fun.  
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: May 17

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2014 has added In-Memory OLTP capabilities that provide new high-end performance for mission critical applications.  This session will describe the new in-memory features and the table and stored procedure changes to support in-memory.  We will review the new in-memory architecture that has been added to the SQL Server database engine and show a few demos that illustrate the tremendous performance gains SQL Server 2014 delivers.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: May 17

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session you will learn how to configure, run, and monitor the new SQL Server 2014 feature SQL Server Managed Backup to Windows Azure.   Also, SQL Server database recovery from Windows Azure will be covered.  This session will also discuss interfacing with the Windows Azure Storage Service.  Experiences from using SQL Server Managed Backup and practical guidance will be provided.

Speaker:

Session Type:
Regular Session

Track:
Wildcard 1

Level: Intermedia

Session Code:

Date: May 17

Time: 12:00 AM - 1:00 AM

Room: TBD

How many times have you started a new SSIS project and added the same components that you’ve added to almost every other package you’ve created?  Components to handle logging and errors or even a standard workflow for loading data files.  In this session I’ll show you how you can create standard templates that already contain any and all of the common components you desire.  We’ll also look at how to implement and use these templates so that the next time you create a SSIS package you can spend your time on the work you actually need to do instead of implementing common components over and over again.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: May 17

Time: 12:00 AM - 1:00 AM

Room: TBD

The Dynamic Management Objects are a very powerful set of tools available to SQL Data Professionals.  There are so many though that it's easy to get overwhelmed.  Join Tim Ford, Creator of The Periodic Table of Dynamic Management Objects (http://thesqlagentman.com/go/periodic2012/) as he presents the most important DMOs for DBAs to start using immediately.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Wildcard 1

Level: Beginner

Session Code:

Date: May 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Everywhere you turn in the technological literature people are talking and writing about Big Data. In this presentation you will learn about the origins of Hadoop, and how it is implemented today. In addition to the most infamous way of retrieving data from Hadoop, Map Reduce, there another way to manipulate the Hadoop data.  It is possible to query the data from Hadoop in SQL Server through the use of Sqoop. In order to better understand the logic behind Sqoop, I will present information on the Hadoop components.  Having this information will help you determine how the tools all fit together so that you will know which tools are the best choice for getting the desired answers from your data sources.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: May 17

Time: 12:00 AM - 1:00 AM

Room: TBD

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