Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 29
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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room A

Level: Beginner

Session Code:

Date: November 02

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:

No material found.

Session Type:
Regular Session

Track:
Wile Auditorium

Level: Beginner

Session Code:

Date: November 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you ever started work on a project only to find that one of your key reference datasets is only available in a spreadsheet on somebody's desktop?  Even worse, you've probably run into situations where key data elements are 'common knowledge' amongst the business users, but don't even exist in a spreadsheet.  

Take heart.   Using Master Data Services (MDS) we now have an effective solution to this problem that has plagued IT for years, without having to create a custom solution.  In this session you will learn the basics of MDS, and how it can be used to easily create a home for the homeless data on your latest project.  Also, learn how Data Quality Services integration can be used to detect duplicate records, and perform cleansing operations.

Don't get hung up trying to build a custom solution to house homeless reference data during your next project.  Join this session and learn how to use MDS so you can deliver your project on time and on budget.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room C

Level: Beginner

Session Code:

Date: November 02

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Wile Auditorium

Level: Intermedia

Session Code:

Date: November 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Are your databases being backed up? Are you sure? Are you sure they're being backed up correctly? Maybe you're an "accidental DBA" or a developer who's not quite sure of the answers to those questions. In this session, you'll learn what the different types of basic backups are, how to execute them, and (perhaps most importantly) how to restore from them if and when necessary.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Room D

Level: Beginner

Session Code:

Date: November 02

Time: 12:00 AM - 1:00 AM

Room: TBD

This is an expanded and updated version of the session I presented at the SQL Rally in Orlando. We will cover Tactical Data Governance and in detail specific code examples, using Stock and Custom SSIS Transforms ,Data Models, SSAS Cubes used to create and populate a Metadata Mart as defined by Michael Belcher(Gartner). We  will demonstrate incorporating complete custom Data Profiling capabilities (SSIS Transform Scripting, TSQL) capable of Profiling any Source and Targeting any destination. In addition we will implement Data Quality(Address Correction, Fuzzy Matching) and Visualization via PowerPivot , Excel and QlikView. Last will will demonstrate code generation.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room D

Level: Intermedia

Session Code:

Date: November 02

Time: 12:00 AM - 1:00 AM

Room: TBD

The presenter will consider different architectures to move data across environments during the software development life-cycle. Whether you start from scratch working with XP, or you have to establish processes in already existing organization working in waterfall, whether the data to move is 1 MB or terabytes, the presenter will present ways to handle the tasks and outline the cons and pros of each approach.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room B

Level: Beginner

Session Code:

Date: November 02

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:
Room B

Level: Beginner

Session Code:

Date: November 02

Time: 12:00 AM - 1:00 AM

Room: TBD

You spent 45 minutes making your first report, but now you want more. Of course you do; everyone wants to make things pretty. Using SSRS 2012 we will look into rendering types & considerations, conditional formatting, properties you can’t live without, and why standards are good. Full of samples and demos, you can’t miss this one.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room A

Level: Beginner

Session Code:

Date: November 02

Time: 12:00 AM - 1:00 AM

Room: TBD

One of the most recommended "best practices" there is is to disable xp_CmdShell.  Whether you're pro, con, or just a casual user of xp_CmdShell, the first part of this "Black Arts" session will show you why disabling xp_CmdShell might actually be a bad idea depending on what else you do or don't do.  Then, for those folks that have made the extremely grave security mistake of giving users or apps the privs to run xp_CmdShell directly, you'll learn how to use a very simple method to allow the users/apps to use stored procedures that run xp_CmdShell without them having the privs to run xp_CmdShell directly themselves in a much more secure manner and all without certificates!.  If time allows, we'll also learn a method to greatly simplify PowerShell inputs to a table from T-SQL using only a single extra connection instead of two.

Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Wile Auditorium

Level: Intermedia

Session Code:

Date: November 02

Time: 12:00 AM - 1:00 AM

Room: TBD

It's story time. I explore 5 unrelated recent production episodes I tackled. For each issue, I explain the troubleshooting methods I used, the data I collected, the plan I made and the actions I took. DBAs or DB Developers in attendance will learn about data gathering methods and quick troubleshooting tricks. You'll learn the easy way some lessons I learned the hard way.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room A

Level: Intermedia

Session Code:

Date: November 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Introduction to the spatial features in SQL Server: how to create, procure and leverage spatial data. Learn how to add a spatial dimension to your existing data so you can perform spatial analysis and create engaging maps. You will also be introduced to the tools necessary to integrate spatial data from a variety of sources, such as the Census Bureau, National Weather Service, etc.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room D

Level: Beginner

Session Code:

Date: November 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Tired of clicking through all those setup screens and entering the same information over and over again? I know I am, so I'm doing something about it...I'm automating my installs!  From base SQL Server installs to Service Packs, Cumulative Updates and even Client Tools for DBA's and Developers, I'll show you ways to automate your installs using SQL Server FineBuild (CodePlex Project).  We'll cover many of the scenarios you may encounter and you'll walk away with some pre-built install scripts to help get you started.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room D

Level: Intermedia

Session Code:

Date: November 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Without the transaction log, SQL Server would have no way of maintaining a consistent and durable view of its data.  It would be pandaemonium!!!  Think of the Stay-Puft Marshmallow Man!  

Thankfully the transaction log is there and we can all breathe easier.
In this session, you will learn how SQL Server uses the transaction log to maintain the durability and consistency of its data, along with methods for reading the transaction log and identifying active transactions.
Speaker:

Session Type:
Regular Session

Track:
Room C

Level: Intermedia

Session Code:

Date: November 02

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, we'll cover the basics of setting up SQL Server Service Broker from the ground up with lots of demos. We'll discuss some pros and cons to using Service Broker, some common problems encountered when using it, and some example use cases. If you've ever been curious about Service Broker, need to send data between databases or instances, or are wondering if Service Broker is right for your organization, then you won't want to miss this session.
Speaker:

Session Type:
Regular Session

Track:
Room C

Level: Beginner

Session Code:

Date: November 02

Time: 12:00 AM - 1:00 AM

Room: TBD

When it comes to making changes to your production Analysis Services databases, do you simply open the SSAS DB in SQL Server Data Tools (or BIDS) and click through creating the changes? Does this method lead to problems keeping everything in sync and the right changes deployed to the right environment at the right time? Have you, the BI developer, had to fight to get Production access to do your own deployments?

If you've answered "yes" to any of these questions, and are in search of a better way, I have the solution! In this demo-heavy session, will look at five steps to more robust, controllable, and flexible Tabular and Multidimensional SSAS deployments.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room C

Level: Beginner

Session Code:

Date: November 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Would business users in your organization love to get their hands on an interactive, visually-oriented, data exploration tool? If so, Power View may be a useful addition to your BI environment to handle certain types of self-service reporting requirements. In this session we will demonstrate the features and functionality of Power View including highlighting, cross-filtering, play axis, small multiples, tiles, cards, maps, filtering, and exporting.

We will identify which situations Power View is most suited for, as well as its strengths and limitations. Capabilities in SharePoint 2010/2013 vs. Excel 2013 will be reviewed, as well as restrictions on types of data sources allowed. We will also discuss how to prepare a dataset in order to maximize the usability and functionality of Power View. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room B

Level: Beginner

Session Code:

Date: November 02

Time: 12:00 AM - 1:00 AM

Room: TBD

You got the "It's Slow" call, yeah you know the one.  There are many places to dig in and determine how true that is but we'll focus on what the server thinks utilizing Performance Monitor.  We'll go a bit deep into those facts in the poster on the wall and tell you the what/where/whys of it all.  We'll make sure you understand those items selected and what they mean.  We will also go through ways to quickly analyze that mountain of data collected.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room A

Level: Beginner

Session Code:

Date: November 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Managing data in ever-growing transaction and history tables can be challenging. Activities with large chunks of data such as moving data to archive tables, batch-importing many rows, or defragging an entire table when only the active portion changes introduces heavy I/O and blocking. Table partitioning solves a host of headaches with minimal effort. Ever wanted to truncate or defrag part of a table, or insert an entire staging table of data into another table in milliseconds instead of hours?  Come see what partitioning can provide for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room B

Level: Intermedia

Session Code:

Date: November 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Taking the periodic table of elements into consideration I've created The Periodic Table of Dynamic Management Objects as a reference tool for these functions and views that have become so critical for today's SQL Server DBA to performance tune and gain metadata insights into their various SQL instances. In the first version of this presentation we discussed organization of the DMOs - this time around we're going to get our hands dirty and see how we can use them to collect baselines and plan for consolidations or migrations.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Wile Auditorium

Level: Intermedia

Session Code:

Date: November 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Sessions Found: 29
Back to Top