Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 36
We will implement several code samples based on a series of articles amd posts identifying similar records between two different sources or grouping of records from a single source, based on existing column string of values. We will define an approach, review actual implementations with various SQL tools(TSQL, VB,SSIS and MDS). There are many facets to review. I would like to start by drawing concepts from several articles from experienced practitioners, either from academia or the commercial market. They will be footnoted at the end of the session. Although we are discussing matching, we need to address several steps prior to getting to the actual use of matching algorithms
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: November 05

Time: 12:00 AM - 1:00 AM

Room: TBD

An overview of basic database architecture and operations such as startup, shutdown, backup, redo log, alert log, tablespaces, etc. for SQL Server database professionals. This will provide a broad look at Oracle 11g from a DBA perspective. This session will give you a basic understanding of the terminology and command structure used in daily operations. It is not that complicated, come and see for yourself.
Speaker:

Session Type:
Regular Session

Track:
Prof. Dev.

Level: Beginner

Session Code:

Date: November 05

Time: 12:00 AM - 1:00 AM

Room: TBD

In this presentation, Microsoft BI Architect and SQL Server MVP Bill Pearson explores “self-service BI” as a concept. We then provide a walkthrough of the primary features of PowerPivot, focusing on how we can exploit its capabilities to offer the benefits of BI to decision makers and analysts throughout our organizations. “There’s no service like self-service …”
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: November 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Track source code changes and manage the synchronization between the source control system and your database. Using SQL Source Control and your favorite source control system, this task can be automated, and you can catch those sneaky developers making changes they forgot to tell you to source.
Speaker:

Session Type:
Regular Session

Track:
DBA/Dev

Level: Beginner

Session Code:

Date: November 05

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server is primarily designed for set-based operations, so code that performs Row-By-Agonizing-Row (RBAR) operations is going against the design, rather than working with it. Come to this code filled session, where we will examine several recent additions to SQL Server, and learn how the vast majority of RBAR code can be replaced with efficient, set-based code. Learn how the APPLY operator works; iterate through incoming data just once with the MERGE statement; “slice and dice” your data with the Windowing (ranking) functions; re-write your multi-statement table-valued functions to inline functions to help the optimizer and speed up your queries; learn how to create a grouped delimited list – without loops!
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Dev

Level: Intermedia

Session Code:

Date: November 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you have the needed skills for your SQL Server career?  Whether you are looking to land your first job or advance into a managerial position, this session will offer recommendations to you.  From interview tips to skills all employers are looking for in SQL Server professionals, this session will benefit you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Prof. Dev.

Level: Intermedia

Session Code:

Date: November 05

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, I'll  talk about Change Data Capture (CDC) terminology and configuring a database for Change Data Capture.  I'll show how to read CDC log tables, and show CDC code samples. I'll  discuss CDC and SQL Server Agent jobs, and the use of CDC versus database triggers (and where triggers are still needed). Also, the impact of CDC on the transaction log and system performance will be explored. Finally, I'll talk about how to deal with schema changes, performance tuning, and using CDC in an ETL (Extract-Transform-Load) environment with SQL Server Integration Services.

Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA/Dev

Level: Intermedia

Session Code:

Date: November 05

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 files be auto-shrunk? Why keep that free space in the files?  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:

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: November 05

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

Level: Advanced

Session Code:

Date: November 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Let's go from Cradle to Grave with the one dimension in 99.99999% of cubes, the dreaded Date dimension.  Without this dimension users wouldn't know if it is worth staying open on a holiday or which day of the week the most fresh produce ships or even what their bonus will be.  What should be included in the dimension? Should you use the wizard to generate? In this session, we will explore a generic date dimension load script and configuring SSAS to use the table as the time  dimension.  We will explore performance considerations of attribute hierarchies compared with usability benefits of user hierarchies. Finally, we will address the advantages of role-playing dimensions to make Order Date, Ship Date and Received Date dimensions.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: November 05

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:
Prof. Dev.

Level: Beginner

Session Code:

Date: November 05

Time: 12:00 AM - 1:00 AM

Room: TBD

One of the great features of SQL Server 2008 is its native support for spatial data types. Spatial data represents information about the physical location and shape of geometric objects. These objects can be point locations or more complex objects such as countries, roads, or lakes. This session looks at how you can take advantage of this support for spatial data to enhance your location based applications in new and interesting ways. You will learn how to load and query spatial data in SQL Server as well as how to present the data in a Bing map.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA/Dev

Level: Beginner

Session Code:

Date: November 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you looking for a career change?  Good News!  Technology is back on the move and companies are again hiring.  We’ll cover key strategies you can use during the interviews first 10 minutes to increase chances for a new job and new adventure.
Speaker:

Session Type:
Regular Session

Track:
Prof. Dev.

Level: Beginner

Session Code:

Date: November 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Using SQL Server 2008 R2 Reporting Services and Report Builder 3.0, report writers can store, re-use, and modify pieces of reports using "report parts". Report parts are stored on the report server and are provided to others for collaboration in a report part library to increase initial development productivity and decrease maintenance turn-around time. This presentation will describe how to set up a user-friendly and easily maintained report part library by discussing how to create report parts, how to store them on the report server, and how to import them into a new report.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: November 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Common Table Expressions (CTEs) serve two main functions: first they remove the clutter of subqueries out of the FROM clause while simultaneously making them easy to reference multiple times by alias if need be, and second they make it possible to do recursive queries. Learn the basics of using CTEs to streamline T-SQL code and to query self-referential tables.
Speaker:

Session Type:
Regular Session

Track:
Dev

Level: Beginner

Session Code:

Date: November 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Window functions greatly simplify the syntax and efficiency of queries that mix scalar with aggregate values. Learn how to add aggregate values to a query result without a GROUP BY clause, how to add row numbers and ranking values to query results, and how to subdivide a set of results evenly into a given number of parts.
Speaker:

Session Type:
Regular Session

Track:
Dev

Level: Beginner

Session Code:

Date: November 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Microsoft’s SQL Server Analysis Services is best known for its ability to build and manage OLAP data cubes.  In addition to that core functionality, SSAS enables users to define key performance indicators (KPIs), profile data, mine data and predict future activities using the results of that mining.  Perhaps best of all, SSAS is included as part of SQL Server 2008 Standard and Enterprise Editions.  This session introduces the audience to the capabilities of SSAS, businesses uses for those tools and ways to integrate SSAS with Integration Services and Reporting Services.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: November 05

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we’ll  look in depth at the three main types of join operations (Nested Loops, Hash and Merge)  in order to understand how query plans are computed. We will look at the performance of Hash and Merge joins in different scenarios and explain why they are sometimes associated with poor performing queries.
Speaker:

Session Type:
Regular Session

Track:
Dev

Level: Intermedia

Session Code:

Date: November 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Leadership coaching is the practice of using relational influence, the people kind, not the database kind, to develop and empower adult leaders. Coaching embraces a set of structured techniques designed to help you make other people more effective in reaching their goals and developing as leaders and can be a powerful tool for developing and managing teams in a technical environment. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Prof. Dev.

Level: Beginner

Session Code:

Date: November 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Whether predicting customers, All Stars or concert set lists, the process and the tools remain the same.  Microsoft’s Analysis Services Data Mining tools enable you to quickly profile your data, identify hidden relationships and predict future outcomes based on those relationships.   Join me to see what data mining is, what data mining is not and how Microsoft's data mining tools can help you analyze your business.  During this session, I will walk us through a start-to-finish data mining prediction project.  It's easier than you might have thought.
Speaker:

Session Type:
Regular Session

Track:
Dev

Level: Intermedia

Session Code:

Date: November 05

Time: 12:00 AM - 1:00 AM

Room: TBD

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