Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 33
Are you interested in designing, building, and deploying an Analysis Services database that follows best practices and best delivers value to your organization? This session goes through the process of optimizing cube creation through the proper design of dimensions, measure groups, aggregations, calculations, perspectives, security, and more. The areas of source code control, deployment, promotion from test to production, processing efficiency, and other areas will be discussed. Craig Utley has experience designing, implementing, and troubleshooting Analysis Services databases at dozens of companies worldwide through his more than 11 years of experience with the Microsoft BI stack.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: August 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Everyone has their own best practices that they try to follow.  But often times we aren’t sure how well we are following our own or industry best practices.  In this session we’ll go into monitoring and managing best practices throughout your environment.  The session will look at how to create a solution using policy based management and other tools to report on your compliance to best practices. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Database Administration

Level: Beginner

Session Code:

Date: August 21

Time: 12:00 AM - 1:00 AM

Room: TBD

A good professional development plan has to go far beyond ‘learning more technology’, it has to encompass the wide variety of skills you need to build the next step in your career, and it has to include a variety of learning methods. We’ll discuss how much time and money you should budget when building your plan, and how the distribution of time and money changes as your career evolves. We’ll look at the growth phases you’ll encounter, learning how you learn best, how to keep up with new technology without burning out, and even how things like blogging and Twitter can be an interesting part of your plan.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Professional Development

Level: Beginner

Session Code:

Date: August 21

Time: 12:00 AM - 1:00 AM

Room: TBD

As a long-term relational engine consultant, I have seen just about everything.  Here is a colleciton of many of the most commonly found problems.  We are going to examine a variety of oopsies MANY developers fall prey to - some obvious, some fairly subtle and some down right sneaky!  Lots of code examples with the bad AND good code presented.
Speaker:

Session Type:
Regular Session

Track:
Database Development

Level: Intermedia

Session Code:

Date: August 21

Time: 12:00 AM - 1:00 AM

Room: TBD

SSIS data flows are great tools for moving data. But what if you need to go beyond the out-of-the-box components provided with SSIS? Custom components are a great way to encapsulate and reuse functionality for the data flow in SSIS. We will discuss what it takes to create and deploy custom components in SSIS, review the pros and cons of using custom components instead of scripts, and discuss some of the common challenges and issues with creating them.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Professional Development

Level: Intermedia

Session Code:

Date: August 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Whether you are a dedicated database developer, or a DBA/.Net Developer for whom database development is a secondary job, Visual Studio Database Developer edition, aka "Data Dude" can be a boon to you. In this session we'll start by reverse engineering an existing database into complete scripts to create the tables, indexes, stored procedures, and more. Deployment strategies will be covered, as well as refactoring and unit testing. Finally we'll look at the powerful data generation capabilities built into "Data Dude". 
Speaker:

Session Type:
Regular Session

Track:
Database Development

Level: Intermedia

Session Code:

Date: August 21

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will focus on using real world data ( no Adventureworks) taken through the life cycle of a data mining application. Topics will include the details of data mining methodology  fine tuyning mining models and validating discoveries
Speaker:

Session Type:
Regular Session

Track:
Professional Development

Level: Advanced

Session Code:

Date: August 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Excel provides a compelling and ubiquitous interface for Microsoft Data Mining. With new features available through PowerPivot, business users can apply the technology through a well-designed infrastructure of Microsoft technologies. This presentation will welcome any newcomers to data mining, and provide interactive demos which highlight data mining through these technologies. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Professional Development

Level: Intermedia

Session Code:

Date: August 21

Time: 12:00 AM - 1:00 AM

Room: TBD

This session is for software developers tasked with database development. Attend and learn about patterns and anti-patterns of database development, one method for building re-executable Transact-SQL deployment scripts, a method for using SqlCmd to deploy re-executable Transact-SQL deployment scripts, and fodder for a lively discussion about NULLs.
Speaker:

Session Type:
Regular Session

Track:
Session Mix

Level: Beginner

Session Code:

Date: August 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Congratulations! You have accepted a position as a Database Administrator. What's that? Oh, you were told that you were going to be the new DBA? No worries, I am certain you were carefully selected to be the best…of the best…of the best. Now that you have the job, what's next? What is your action plan? What do you take care of first? And how much more will you get paid?
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Cafeteria

Level: Beginner

Session Code:

Date: August 21

Time: 12:00 AM - 1:00 AM

Room: TBD

As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor.  In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence solutions. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Database Development

Level: Beginner

Session Code:

Date: August 21

Time: 12:00 AM - 1:00 AM

Room: TBD

If you have ever been responsible for a mission critical database, you have probably been faced with a high stress, emergency situation where a database issue is causing unacceptable application performance, resulting in angry users and hovering managers and executives. This session will show you how to use DMV queries to quickly detect and diagnose the problem, starting at the server and instance level, and then progessing down to the database and object level.  This session will show you how to assemble and use an emergency DMV toolkit that you can use to save the day the next time a sick database shows up on your watch in the Database ER!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Session Mix

Level: Intermedia

Session Code:

Date: August 21

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we'll look at how to lock down SQL Server installation starting from the operating system and diving in to SQL Server itself. We'll take on the mindset of someone in the business of breaking into systems for pay and how they would attack SQL Server. This will lead us to consider the appropriate defenses we need to have in place. Finally, we'll look at how to take this information and come up with reasonable costs for breaches as well as the defenses we want to put in place to it in order to present to the business side for additional funding/time to secure our systems properly.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Session Mix

Level: Intermedia

Session Code:

Date: August 21

Time: 12:00 AM - 1:00 AM

Room: TBD

This session is designed to assist the user in migrating from an Access database to SQL Server.  A primer is included that describes the differences between databases, relational databases and relational database management systems (RDBMS).  Additional background is included to acquaint attendees with various aspects of SQL Server that are often missing from formal training classes.  Various reasons are examined for either migrating or not migrating.  Required FrontEnd modifications are discussed as well as some pitfalls that a user may experience.
Speaker:

Session Type:
Regular Session

Track:
Database Development

Level: Beginner

Session Code:

Date: August 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Want to know what makes SQL Server tick? Ever wonder what SQL Server is doing when you run a query? Ever wonder which parts of SQL Server are responsible for specific functionality? Want to know what a HOBT is? I can’t promise answers to every question, but I can set you on the path to knowledge about the inner workings of SQL Server.
Speaker:

Session Type:
Regular Session

Track:
Session Mix

Level: Beginner

Session Code:

Date: August 21

Time: 12:00 AM - 1:00 AM

Room: TBD

We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem.  We don't always know how to do this easily and consistently.  This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.
Speaker:

Session Type:
Regular Session

Track:
Database Administration

Level: Advanced

Session Code:

Date: August 21

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will provide you with some surprising and interesting insights into how dashboards should be designed. Called Information Visualization, there is a whole line of thinking which maps how the brain interprets what the eyes see. We will translate this into best (and worst) practices related to visualization in dashboard, scorecard, table, and report design. Both funny and informative, you will probably learn, as I did, that you have been designing your dashboards/scorecards and reports badly. We are going to take a visualization test, and learn how to convey information in a clearer, better way. You will be surprised.  Join me - this session is going to be hoot!
Speaker:

Session Type:
Regular Session

Track:
Business Intelligence

Level: Advanced

Session Code:

Date: August 21

Time: 12:00 AM - 1:00 AM

Room: TBD

This 100-level session will provide SQL programmers with the tools to begin querying SQL Server Analysis Services (SSAS) databases. Through examples, including the creation of an SSAS database from the AdventureWorks example database, students will have a primer of knowledge to begin using SSAS to the fullest.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: August 21

Time: 12:00 AM - 1:00 AM

Room: TBD

This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more! Statistics are a key part of getting solid and repeatable performance and is easily just as important as having indexes. Whether you're a DBA or trying to get by without one, this session will give you the information you need to know. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Session Mix

Level: Beginner

Session Code:

Date: August 21

Time: 12:00 AM - 1:00 AM

Room: TBD

TBA
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Cafeteria

Level: Beginner

Session Code:

Date: August 21

Time: 12:00 AM - 1:00 AM

Room: TBD

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