Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type

Sessions Found: 48
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, we will discuss 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:
Misc

Level: Intermedia

Session Code:

Date: October 02

Time: 12:00 AM - 1:00 AM

Room: TBD

How do you tell good code from bad?  Bad SQL code makes the system work harder for the same results.  Bad SQL does not scale well with larger data sizes, nor does it scale with increased server activity.  Extreme Bad SQL can bring a server to a grinding halt.   This presentation shows you how and why certain commonly used SQL constructions are Bad SQL.  Bad SQL is not very useful by itself so each example includes its Good SQL counterpart.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Large Session

Level: Intermedia

Session Code:

Date: October 02

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:

Session Type:
Regular Session

Track:
Misc

Level: Beginner

Session Code:

Date: October 02

Time: 12:00 AM - 1:00 AM

Room: TBD

For many Database Administrators, Data Analysts and other IT and Business Professionals, Business Intelligence (BI) and Data Warehousing (DW) may be a new and uncharted territory with no clear path towards the destination. Others, who have already jumped head-on into the Business Intelligence journey, may be facing challenges that can potentially put their efforts at risk of failure. In this session I will go over some of the basic concepts that are key in understanding BI and DW. I will also go over the natural roadmap towards BI success, its maturity stages and some of the factors that influence a successful BI project. I will exemplify all these concepts by showcasing a successful real-world BI and DW solution.
Speaker:

Session Type:
Regular Session

Track:
BI 2

Level: Beginner

Session Code:

Date: October 02

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will bring you up to speed on simple CLR SQL Server objects implementations.
We will show you how to organize your environment to work with VS2010 Express and up.
We will also show you how to organize your SQL Server Express and up, for hosting deployed CLR objects.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
DB Dev 2

Level: Beginner

Session Code:

Date: October 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn about the major changes in clustering in recent SQL and Windows releases and how clustering is something you can implement that will actually make your work life easier.

Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DB Admin 2

Level: Intermedia

Session Code:

Date: October 02

Time: 12:00 AM - 1:00 AM

Room: TBD

As database systems become more prevalent, the need to integrate disparate data sources becomes more pressing. DBA’s and developers are often forced to support code they can’t control, and must find ways to support poorly designed relational systems. The purpose of this presentation is to explore some of those challenges and discuss possible solutions using certain "taboo" tools including string parsing, looping, and dynamic SQL. Recommended for experienced T-SQL programmers only. 
Speaker:

Session Type:
Regular Session

Track:
BI 2

Level: Intermedia

Session Code:

Date: October 02

Time: 12:00 AM - 1:00 AM

Room: TBD

There is more than one way to approach a consolidation effort, and you must understand the pros and cons of each. Consolidate on physical hardware? Use virtualization? Multiple instance per server or VM? How will availability be achieved for a consolidated environment? These topics and more will be addressed in this session.
Speaker:

Session Type:
Regular Session

Track:
DB Admin 1

Level: Intermedia

Session Code:

Date: October 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Cool Tricks to Pull from your SSIS Hat:  Variables, For Each Loops, and the SSIS Expression Language. This presentation will cover some useful SSIS features commonly used to add flexibility and elegance to more advanced ETL solutions.  The presentation demonstrates short case studies of real world business scenarios and solutions.  
Speaker:

Session Type:
Regular Session

Track:
BI 1

Level: Intermedia

Session Code:

Date: October 02

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:

Session Type:
Regular Session

Track:
BI 2

Level: Intermedia

Session Code:

Date: October 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Performance of SQL Server poor? One cause may have been that starting file size that you didn't think was important because it will auto-grow. Why is auto-grow bad? Why shouldn't logs be auto-shrunk? Explore the physical structure of a database, how table structure effects use of memory and key mistakes to avoid. Additionally, dive into the transaction log process - VLFs, auto-recovery and lock escalation. Solid foundation for Programmers and Administrators!  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DB Admin 1

Level: Beginner

Session Code:

Date: October 02

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:

Session Type:
Regular Session

Track:
BI 2

Level: Intermedia

Session Code:

Date: October 02

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:
Large Session

Level: Intermedia

Session Code:

Date: October 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you an "accidental" or "unintentional" DBA? Or are you a manager or developer who wants to see more into the DBA world? If you're someone who has to wear a DBA hat or someone considering it, this presentation is for you. This presentation is a beginner session intending to show the basics every DBA needs to know to do the job. 
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
DB Admin 1

Level: Beginner

Session Code:

Date: October 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Evan will show you how to diagnose and solve common connectivity issues.  This will include covering GNEs, Kerberos, and completely inaccessible SQL Servers.  He will demonstrate how to use UDLs and network traces to easily identify the problem, plus provide tips that often solve the problem in seconds.
Speaker:

Session Type:
Regular Session

Track:
DB Admin 2

Level: Advanced

Session Code:

Date: October 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Obtaining a certification may be a dreaded and stressing process for some people. Most people fail because of their failure to plan a realistic roadmap towards their goals and not necessarily because they lack the skills. 

This session will focus on establishing a roadmap towards certification success for the MCTS and MCITP programs of SQL Server and Business Intelligence. I will do a quick overview of my recent success obtaining 4 certifications in 30 days and how you can achieve similar goals. 

But why certify? Join me to find out the opportunities you may be missing on! 
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Misc

Level: Beginner

Session Code:

Date: October 02

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI 2

Level: Beginner

Session Code:

Date: October 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Thinking of adding spatial functionality to your application?  You'll need to learn how to start using SQL Server Spatial data types.  This session will cover the basics of spatial support in SQL Server 2008 as well some freely available tools that will help you go spatial with your data.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
DB Dev 1

Level: Beginner

Session Code:

Date: October 02

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will be an in-depth session of the reasons for and against using dynamic SQL in database applications. We'll look at different ways to write dynamic SQL statements, performance and security considerations that accompany using dynamic SQL, and how and when to take advantage of this powerful tool. 
Speaker:

Session Type:
Regular Session

Track:
DB Dev 1

Level: Intermedia

Session Code:

Date: October 02

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will provide you with some surprising and interesting insights into how dashboards and charts 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. I will prove that you are blind! You will be surprised.  Join me - this session is going to be hoot!
Speaker:

Session Type:
Regular Session

Track:
BI 1

Level: Intermedia

Session Code:

Date: October 02

Time: 12:00 AM - 1:00 AM

Room: TBD

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