Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 24
With the introduction of SQL CLR DBAs are being thrust into the world of .NET. This session wil look at the basics of .NET and relate them to equivalent concepts in T-SQL. This session will help you to decipher the code that you are being asked to review so you can decide if it meets your quality bar before you apply it to your database.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Room 308

Level: Beginner

Session Code:

Date: September 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Attribute discretization is an oft-overlooked feature in Analysis Services that allows us to automatically create a manageable number of groups of attribute values that are clearly separated by boundaries. Discretization can help us to make it easier for information consumers to work with large numbers of possible attribute member values. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson discusses the varied options, the design (and other) considerations involved, and best practices surrounding the use of this capability.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 302

Level: Intermedia

Session Code:

Date: September 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Whether we inherit our Analysis Services environments from predecessors or create them - learning as we go - ourselves, we often conclude that performance (processing and / or querying) and functionality can be enhanced. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson overviews ways to launch new capabilities, and to propel performance beyond its current plateau, using design best practices to better meet consumer performance and functional needs. This is the initial session of a set of detailed Best Practices presentations.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 308

Level: Intermedia

Session Code:

Date: September 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn how easy it is to utilize the free download from Microsoft that allows users to create charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 308

Level: Beginner

Session Code:

Date: September 10

Time: 12:00 AM - 1:00 AM

Room: TBD

If you've ever found yourself stating the above, this session is for you.  For many developers, writing T-SQL that works is not the challenge.  But too  often, functional T-SQL is not the same as good T-SQL.  In this session, we  will examine why "SQL that works" is not good enough.  Understanding  indexes, exectuion plans, sargability, and more are all critical to writing  good T-SQL.  We will also examine several real-world examples of T-SQL that  "worked great in dev" but caused major issues when it hit production. 
Speaker:

Session Type:
Regular Session

Track:
Room 300

Level: Beginner

Session Code:

Date: September 10

Time: 12:00 AM - 1:00 AM

Room: TBD

We often run a fine line between how much space we need, and how much space we have for our databases.  Having too much drive space can be a waste of resources; however, running out of space is an obvious issue.  Let’s find a way to straddle the line and determine just how much space we really need, give ourselves a bit more than that, and make it a regular process to baseline, then continue to monitor, make adjustments along the way if needed, and ultimately plan for just enough space to get us through the year on budget.  
We’ll talk about a stand-alone tool that I used to determine space use for baseline, continued monitoring of the space used, and ensuring we have enough but not too much space.
Speaker:

Session Type:
Regular Session

Track:
Room 302

Level: Beginner

Session Code:

Date: September 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you remember what it was like to fall in love? Wasn't it wonderful? Lately it just hasn't been the same. You've been stuck in the same old routine, doing the same old charts and tables. Maybe Reporting Services doesn’t tell you what’s wrong. Maybe you're even thinking about seeing other reporting products (!) In this session made for report developers, Doug will re-ignite your passion for RS by showing you how to design for better performance, explaining what RS has been trying to tell you through logs (but you haven't been listening), and demonstrating some new -- and easy -- tricks you may not have known RS can do. After this session, you'll want to spend some time alone with your new old flame.
Speaker:

Session Type:
Regular Session

Track:
Room 308

Level: Beginner

Session Code:

Date: September 10

Time: 12:00 AM - 1:00 AM

Room: TBD

We will discuss some of the most important things that you as a Data Professional can document to make your job much easier, ensure information consistency between groups, and better prepare your organizations for raising the bar on your day to day business.  Think of this as a sort of Database Library that allows you to finally detail the processes you follow currently to perform repetitive tasks.  This Library will also allow you to simply document your systems for your and others knowledge.  Some of the documents and processes we will review are:
Speaker:

Session Type:
Regular Session

Track:
Room 300

Level: Beginner

Session Code:

Date: September 10

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, you will learn how to setup and implement Central Management Server (CMS) to run queries against multiple SQL servers in your environment. We will also cover Policy Based Management (PBM) and how to use out of the box best practices and create custom policies to maintain your environment. We will then look at using both CMS and PBM in conjunction with each other to monitor your environment.
Speaker:

Session Type:
Regular Session

Track:
Room 302

Level: Beginner

Session Code:

Date: September 10

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will explore some practical scripts to help create database documentation. We will be looking at how to make some of those documentation tasks easier, while giving you greater insight into your database(s). Attendees will be able to leave with some additional tools for their toolbox and through the use of these scripts the attendee will be able to perform these tasks faster.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 309

Level: Beginner

Session Code:

Date: September 10

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will look at the basics of indexes in SQL Server, and will discuss strategies and techniques for managing indexes in large databases with high uptime requirements, including how to automate online and offline index maintenance operations, and how to collect and analyze index usage statistics to see which ones are helping your database's performance, and which ones are hurting it.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Room 308

Level: Intermedia

Session Code:

Date: September 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Just getting started with SQL Server Integration Services (SSIS)?  Not sure where to start? Or have you been using SSIS for a little while now and are still trying to figure out the basics.  The biggest barrier to learning something new is figuring out the first few steps.  We will discuss what SSIS is, some lessons learned and some new features that are around the corner with the release of Denali.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 309

Level: Beginner

Session Code:

Date: September 10

Time: 12:00 AM - 1:00 AM

Room: TBD

When your boss asks you who has access to your databases, do you break out into a cold sweat? Or, instead, are you worried about those other people who might have 'sa' access to your server and might be causing trouble on your server? Either way, as DBAs we need to be able to audit our SQL Server security. This presentation will give you a general overview of the different types of roles that you can use to manage access, what they mean, and how we look at the security gremlins hiding under the covers of our databases. 
Speaker:

Session Type:
Regular Session

Track:
Room 309

Level: Beginner

Session Code:

Date: September 10

Time: 12:00 AM - 1:00 AM

Room: TBD

I hear all the time that someone should upgrade from MySQL to SQL Server.  Is it really an upgrade or just the same animal with a different face, we will discuss the differences between the engines, tools, administration and  indexes.  If you’d like to really find out how similar these two animals are you won’t want to miss this.  
Speaker:

Session Type:
Regular Session

Track:
Room 300

Level: Beginner

Session Code:

Date: September 10

Time: 12:00 AM - 1:00 AM

Room: TBD

If you want to architect a parallel processing system, Data Vault should be your preferred architecture.  In this session I will introduce you to the Data Vault design pattern and demonstrate the major performance advantages of this architecture.  Data Vault hub, link and satellite tables allow for vertical and horizontal partitioning of data.  When properly implemented, your database tables will provide the most index coverage of any indexing system and provide the fastest possible disk scan access.  I will provide a real world example of a parallel manufacturing execution system that we developed at Abound Solar which implements the Data Vault architecture. 
Speaker:

Session Type:
Regular Session

Track:
Room 309

Level: Beginner

Session Code:

Date: September 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Expand the value of your Business Intelligence infrastructure by delivering powerful forecasts and predictions using SQL Server Reporting Services visual capabilities. Using proven predictive models that forecast future buying patterns, foster care placement success, or customer income and net worth, you will see how to create appealing charts, graphs and maps that allow business users to include predictive analytics in their decision making process. In this session, Carlos Bossy will show you how to combine the visual features of SQL Server Reporting Services with the power of Data Mining and Analysis Services to take your organization’s BI competency to the next level.
Speaker:

Session Type:
Regular Session

Track:
Room 309

Level: Intermedia

Session Code:

Date: September 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Everyone wants to be in the on the PowerShell sweetness, right?  This session will cover in depth the options that you have for using PowerShell with a set of modules that already exist in a very robust package.  SQLPSX is the name and it is diverse but powerful.  From Database backup, to database maintenance and index maintenance, SQLPSX is there for you.  Join me for a power packed session and get up to speed really fast in SQL PowerShell.
Speaker:

Session Type:
Regular Session

Track:
Room 300

Level: Beginner

Session Code:

Date: September 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Is your data secured? Are you a victim of SQL Injection? You'll discover some commonly overlooked practices in securing your SQL Server databases. Learn about physical security, passwords, privileges and roles, and preventative best practices. I'll demonstrate auditing and we will take a quick look at some .Net code samples to use on your applications. Get up to speed on the new security features in "Denali", the next version of SQL Server. Takeaway the 20/20 vision to identify SQL Injection and other database vulnerabilities and how to prevent them.
Speaker:

Session Type:
Regular Session

Track:
Room 308

Level: Beginner

Session Code:

Date: September 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Partitioning technology distributes data in a single table among several individual filegroups.  When implemented carefully, this allows DBAs to instantaneously move large amounts of data from one table to another.  After this session, attendees will understand how partitioning works, when it is beneficial, and how to implement a basic setup.  We will also illustrate partitioning in a practical "sliding window" demonstration.  This will be a broad, high-level introduction to the technology.
Speaker:

Session Type:
Regular Session

Track:
Room 300

Level: Beginner

Session Code:

Date: September 10

Time: 12:00 AM - 1:00 AM

Room: TBD

This session provides an overview of the new tabular modeling features introduced in SQL Server CTP 3 code name "Denali". We will look at some of the key concepts in tabular model design including: relationships, calculated columns, measures, KPIs, and hierarchies. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 302

Level: Beginner

Session Code:

Date: September 10

Time: 12:00 AM - 1:00 AM

Room: TBD

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