Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type

Sessions Found: 48
Are all your databases backed up?  Has SQL reported any errors? Are there critical Windows or SQL patches you need to apply?  Are all of your SQL Servers configured to Microsoft "Best Practices"?  This sessions shows how Microsoft Atlanta Tool can be used to provide the CIO or DBA an "extra set of eyes" to check the health of your SQL Severs.
Speaker:

Session Type:
Regular Session

Track:
DB Admin 2

Level: Beginner

Session Code:

Date: March 19

Time: 12:00 AM - 1:00 AM

Room: TBD

This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI 1

Level: Beginner

Session Code:

Date: March 19

Time: 12:00 AM - 1:00 AM

Room: TBD

This talk will go over some of the best practices of software engineering as they apply to 
SQL Server CLR projects. We will also show how to build a small library of utilities,
stored procedures, functions, etc., that should help you remove some of SQL Server built-in
functional barriers.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DB Development

Level: Intermedia

Session Code:

Date: March 19

Time: 12:00 AM - 1:00 AM

Room: TBD

Producing a good looking report will wow your business users even if your data isn't all that impressive. If you've ever had trouble finding the best way to display that data or how to show trends appropriately, this is the session for you. We will review grouping logic, graphs, gauges, and more in Reporting Services 2008 R2. With the knowledge in this session, you won't ever need to show a plain, boring report again!
Speaker:

Session Type:
Regular Session

Track:
BI 2

Level: Intermedia

Session Code:

Date: March 19

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will cover everything a good SQL Developer needs to know about indexing.  Will cover how to identify when needed indexes are missing, how to find bad indexes and remove them, understanding exactly what data is stored within indexes and much more.  Understand why having indexes can be both bad and good by understanding your own data and how it is structured and accessed.  Will cover various design patterns, SQL Server DMVs, as well as real world examples of good and bad indexes.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DB Admin 3

Level: Intermedia

Session Code:

Date: March 19

Time: 12:00 AM - 1:00 AM

Room: TBD

The Policy-Based Management feature in SQL Server 2008 provides a great way to ensure your systems are configured consistently and correctly, but it can be tedious to implement on each server in your environment.  PowerShell scripts allow you to automate the implementation of your policies so you can focus on more important problems.  This session will walk you through how PBM works, how to define your policies in PowerShell, and how to set up Agent jobs to evaluate those policies regularly to let you know when you need to take action.
Speaker:

Session Type:
Regular Session

Track:
DB Admin 1

Level: Intermedia

Session Code:

Date: March 19

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:
DB Admin 2

Level: Intermedia

Session Code:

Date: March 19

Time: 12:00 AM - 1:00 AM

Room: TBD

Become a better SQL developer by learning the most common pitfalls in the SQL language. Both inexperienced and experienced SQL developers and DBAs can get caught by many of these. Practical examples and internal logical processing explanation will help you understand why mistakes happen and how to develop good SQL coding practices to avoid them.
Speaker:

Session Type:
Regular Session

Track:
DB Development

Level: Intermedia

Session Code:

Date: March 19

Time: 12:00 AM - 1:00 AM

Room: TBD

Tempdb is used by all kinds of operations in all sorts of ways. In SQL 2005 & 2008 it has become even more critical to the internal operation of the engine and performance can be affected by a misconfigured or mistuned instance. We will cover the areas that cause the most issues in terms of performance along with demos that illustrate the symptoms. This session will help you ensure your tempdb is up to the task.
Speaker:

Session Type:
Regular Session

Track:
DB Admin 3

Level: Intermedia

Session Code:

Date: March 19

Time: 12:00 AM - 1:00 AM

Room: TBD

A review of Database Mirroring in the context of operations at Baker Hostetler, where mirroring has been a cornerstone high availability tool for over 5 years. A high level look at the key modes of mirroring; specific analysis of setup and configuration problems; various real time monitoring techniques of the mirrored databases; pros and cons of WAN hardware acceleration devices to improve performance; using mirroring to perform a rolling upgrades or to move large databases to a different location.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DB Admin 3

Level: Intermedia

Session Code:

Date: March 19

Time: 12:00 AM - 1:00 AM

Room: TBD

Data Analysis Expressions (DAX) is an expression language used to develop calculations based on PowerPivot data. A lot of its capabilities are very intuitive to Excel power users as it emulates current functionality but over a much larger set of data.  However, Its real power emerges with the ability to create aggregations that are evaluated at different contexts on the data stored in-memory. This session will explore DAX formula context, which is of great benefit when developing business calculations like ratios or weighted averages.  A brief comparison with MDX will be established in order to contrast the process followed by each language when establishing the context of a calculation.
Speaker:

Session Type:
Regular Session

Track:
BI 2

Level: Beginner

Session Code:

Date: March 19

Time: 12:00 AM - 1:00 AM

Room: TBD

Declarative database development has made great strides forward with the Visual Studio 2010 data tools allowing developers to focus on the model instead of the implementation.  But once you have the model, what are the options for deployment and what if your solution doesn’t match the Books Online example?  The session will demonstrate multiple ways to deploy database projects using TFS Build, MSBuild, VSDBCMD, Powershell and more.  For each deployment method, automation and customization techniques will be examined and demonstrated (including the common requirement of deploying one model to multiple targets.)  Attendees will leave with a better understanding of database deployment options when using Visual Studio 2010   
Speaker:

Session Type:
Regular Session

Track:
DB Admin 2

Level: Intermedia

Session Code:

Date: March 19

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI 2

Level: Beginner

Session Code:

Date: March 19

Time: 12:00 AM - 1:00 AM

Room: TBD

In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging. Key takeaways: 1) Developers can migrate packages from Development, through their lifecycle, to Production without editing SSIS Connection Managers properties. 2) A metadata-driven approach to SSIS package execution. 3) Demonstration of a centralized logging reporting application.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI 3

Level: Advanced

Session Code:

Date: March 19

Time: 12:00 AM - 1:00 AM

Room: TBD

Relational databases have become storage engines for more than just the traditional datatypes; the inclusion of XML in SQL Server 2005 and SQL Server 2008 opens up a host of new avenues for application development.  XQuery is a powerful language for querying XML fragments in conjunction with the relational engine; this session is designed to cover the basic FLWOR syntax of XQuery in an interactive fashion.  Participants are encouraged to discuss their own challenges with XML as well as seek out solutions from each other.
Speaker:

Session Type:
Regular Session

Track:
DB Development

Level: Intermedia

Session Code:

Date: March 19

Time: 12:00 AM - 1:00 AM

Room: TBD

SSIS is a great tool for transferring data from one data source to another, and for implementing complex ETL processes. However, for simple, straightforward data transfer tasks, creating SSIS packages by hand can be time-consuming and repetitious. By attending this session, you'll learn how to automate package creation in SSIS, including the dynamic generation of data flows. We’ll cover some of the free and open source tools available for this, and discuss “roll your own” options.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI 2

Level: Intermedia

Session Code:

Date: March 19

Time: 12:00 AM - 1:00 AM

Room: TBD

Ugly data is the scourge of developers and DBA’s alike.  Do your part to rid the world of ugly data models!  Beautiful data starts with a beautiful design.  In this session we’ll begin with requirements and end with a physical model, discussing how to make sure that your database design equals data integrity, scalability, and good looks.  

Topics include:  
--Requirements Analysis
--Conceptual Modeling
--Logical & Physical Modeling
--Best Practices
Speaker:

Session Type:
Regular Session

Track:
Professional Dev

Level: Beginner

Session Code:

Date: March 19

Time: 12:00 AM - 1:00 AM

Room: TBD

With data being the focal point of a data warehouse, its data integration component becomes a critical point of failure of the whole system, and to make matters worse, we, as developers, face increasingly complex scenarios and requirements such as larger number of systems and volumes of data, data quality problems and complex business logic.
 
In this session Rafael will share a compilation of pitfalls and mistakes he has seen –and made!– across many implementations, and offers recommendations to avoid them. We will look at problems related to metadata, data quality, monitoring, system reliability and some SSIS specific issues among other common problems. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI 1

Level: Beginner

Session Code:

Date: March 19

Time: 12:00 AM - 1:00 AM

Room: TBD

This presentation presents SQL Server Data Mining (SSDM) for SQL Server Professionals based on the speaker's past presentations for SQL Saturday. Starting with SQL Server Management Studio (SSMS), the demo includes the interfaces important for professional development, including Business Intelligence Development Studio (BIDS), highlighting Integration Services, and PowerShell.  The interactive demos are based on Microsoft's Contoso Retail sample data.  Finally we will evaluate where Microsoft data mining can help you in a practical business environment, which may include Oracle and SAS.
Speaker:

Session Type:
Regular Session

Track:
BI 1

Level: Intermedia

Session Code:

Date: March 19

Time: 12:00 AM - 1:00 AM

Room: TBD

Independent BI consultant, MSSQL Server MVP, and practicing CPA Bill Pearson examines the various options available for organizing and protecting your consulting business. In this section, he covers C Corp, S Corp, LLC, Partnership, and Sole Proprietorship (“Schedule C”) options, as well as other practical advice (trademarks, etc.) useful in forming your business entity.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Professional Dev

Level: Beginner

Session Code:

Date: March 19

Time: 12:00 AM - 1:00 AM

Room: TBD

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