Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 25
The 2012 release of SQL Server promise a variety of delicious new language features to solve problems. After this session, you'll have a taste for all the sweets they've packed into the language including conversions, date & time functions, windowing functions, analytic functions and sequences.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Track 5

Level: Intermedia

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

An informative, entry level session regarding SQL Server statistics and the importance of their accuracy. The presentation will cover, in detail, the statistics object - how they are generated and how the optimizer utilizes them, along with some foundation SQL Server internals principles. Examples will be provided that construct situations where the optimizer chooses poor execution plans due to issues with statistics. Finally, a free stored proc will be provided that allows for comprehensive statistics management by the DBA.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance.  I have given this talk over a dozen times now and it is always very highly rated!
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

This is an expanded and updated version of the session I presented at the SQL Rally in Orlando. We will cover Tactical Data Governance and in detail specific code examples, using Stock and Custom SSIS Transforms ,Data Models, SSAS Cubes used to create and populate a Metadata Mart as defined by Michael Belcher(Gartner). We  will demonstrate incorporating complete custom Data Profiling capabilities (SSIS Transform Scripting, TSQL) capable of Profiling any Source and Targeting any destination. In addition we will implement Data Quality(Address Correction, Fuzzy Matching) and Visualization via PowerPivot , Excel and QlikView. Last will will demonstrate code generation.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5

Level: Intermedia

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

What you do for a living may say a lot about who you are. No where is this as true as in IT. How you learn, how you grow, your passions, and your goals can all be reflected in your job. There are many ways your skills can be delivered and you need to choose the best fit for who you are. This session aims to take an unbiased look at the difference between working in a solid, stable IT environment or trekking out and offering your skills as an IT consultant. The differences are staggering and each has their risks and rewards. Each role has its own myths and, like most myths, some are true and some are not. This session will draw on real-world experience and won't hesitate to point out the successes as well as the failures.

Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

From beginning to end application development is upside down.  So much emphasis is placed on the front end and so little on the analysis of database structure that many application development projects fail to achieve the goals set by the business.  This presentation uses an interwoven analogy to illustrate the process currently used by most enterprises, the results, and the short comings.  Yet with a change of focus, the same projects can not only be successful; they can be done under budget, with greater flexibility and extensibility.  Future projects can benefit from this change of focus with additional savings in timelines and fewer bug fixes downstream.  Any business person or data professional who works directly with business people c
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

Sure, your SQL Server is up and running. Is it healthy? Is it performing the best that it can? Where are your performance bottlenecks? This dynamic dialog session will present a solid process for checking your environment's overall health and performance levels as well as solutions for common problems. Some of the items focused on include dynamic management views (DMVs), Windows Perfmon, and disk performance tools such as IOMeter and SQLIO.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment. 
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

With the next release of SQL Server, BI developers and database professionals need to know what's available and how to take advantage of new features and capabilities. During this session, we'll drilldown on the next release of SSIS and discuss development improvements, the new deployment model, and better managability options. Along the way, we'll look at new SSIS features including project parameters, shared connection managers, team-based development improvements, and a brand new deployment model with significantly improved management features. Come see some of the exciting changes now available in your favorite data integration tool!
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

Slow running packages? SSIS consuming all your resources? No idea what it's doing?
After attending this session, you will come out with an understanding of how Configuration, Logging, Package settings and deployment work in SQL Server Integration Services. You will also be armed with a list of transformations and perfmon counters to watch out for.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

One of the most widely respected and recommended free tools for SQL Server is Ola Hallengren's MaintenanceSolution.sql.  It is a one-stop package to backup your databases, maintain your indexes and statistics, and validate the integrity of databases.  Come learn about the solution and how it can help you escape the world of canned maintenance plans as well as the importance of performing the various maintenance tasks.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

This session describes how to maximize throughput for high-volume insert applications using both programming and database server techniques.  Performance of bulk insert and table-valued-parameter methods will be contrasted with traditional insert methods.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

A look at different options for monitoring and debugging your SQL Server environment.  We'll start from low level and work our way to enterprise level options.  We'll look at traces flags, logs, data collectors, utility control points, and up to system center.  
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you ever been wrought with end user complaints of database performance issues only to open your tools that show only live performance or limited historical performance and find no answers?  After being bit by this many times, I developed my own eye in the sky to monitor CPU & Physical IO at the database, user and application levels.  This solution logs data continuously and parses it into an Analysis Services cube which can be queried by Excel.  No need to requisition funds for 3rd party tools.  You can do this with the tools you have and I’ll give you the scripts to get started.  Using these tools I have been able to find needles in haystacks and effectively communicate the nature of the problems to people at all levels.
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Advanced

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

With an ever increasing workload, security is often hoisted upon the DBA. So where do you start? Sometimes it's better to start off by understanding what an attacker could do to you in order to get a clearer picture of what you need to do to prevent it. In this session, we will delve into the key features of the SQL Server and explain what the various attack vectors are, what an attack can do with them, and what you can do about them. We'll also look at important features such as SQL Audit that, while not helping to prevent, can definitely help in figuring out what is going on. It'll be AWESOME!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

Issue a "SELECT {data} FROM {myTable}" statement and users need to trust the data returned is accurate. What happens when multiple processes access the same data? What happens further if one of those process is an UPDATE or even a DELETE statement? How about if both processes will be updating that data? Understanding Isolation in SQL Server is paramount in ensuring data integrity in your system. We will cover the different levels of isolation and how they impact what a user views when accessing the data at a given point-in-time.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will showcase what is new in the BI arena in SQL 2012, focusing on BI in SharePoint.  Discussion will be centered around Power View, SSRS, PowerPivot 2.0 and the new Tabular Model.  Learn what each tool can do and when to use them.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you heard about all the great new T-SQL features? Attend this session to learn about new functions, OVER clause enhancements, the Sequence Object and more!
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

'Change 'is the only constant. It is the undoubted truth for data in our world of OLTP databases. Most of us are required to implement an array of solutions to track data changes, for reasons ranging from simple logging to complex regulatory compliance. So the important question is, how best can tracking be done? To help you make the right choice, this session will list and demonstrate some Change Tracking mechanisms. Some of the highlights will be SQL Server Change Tracking and Change Data Capture (CDC) features.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

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