Build Schedule

Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type

Sessions Found: 48
If the words "regulatory compliance", "data governance',  or "merger and acquisition" are voiced at your company you know the importance of keeping accurate master data.  We have been given a new feature to help manage this in SQL Server 2008 R2, Master Data Services.

Come join Whitney Weaver as we explore the business application of this feature.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
1 Centennial Park

Level: Beginner

Session Code:

Date: April 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Using MS SQL in conjunction with a visual analysis tool like Tableau can leverage can expand the use of your data.  This session will demonstrate how rapid-fire visual analysis can enhance the value of your data stores and provide information consumers with ad hoc query capability along with easy interactive dashboard building.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
2 Highlands

Level: Beginner

Session Code:

Date: April 24

Time: 12:00 AM - 1:00 AM

Room: TBD

The range of real-world queries that can be performed using set-based TSQL solutions is astounding, but many of these are not well known and if you haven't been shown the light you might never realize what is possible.  Come and join me as we delve into the inner recesses and corners of the TSQL envelope using a wide variety of expressions, clauses and techniques.  
Speaker:

Session Type:
Regular Session

Track:
1 Piedmont Park

Level: Advanced

Session Code:

Date: April 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Auditing user activity in SQL Server has become a hot topic lately. From SOX and PCI to HIPPA, the security of personal data, and the ability to track who accessed the data and how has become extremely important. In this session, SQL Server MVP Jonathan Kehayias covers the various methods available in SQL Server 2000, 2005, and 2008 to accomplish this task including SQL Trace in SQL Server 2000 and 2005, and the new Server Audits in SQL Server 2008. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
2 Buckhead

Level: Intermedia

Session Code:

Date: April 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Having trouble or trying to figure out how you can navigate to your reports through your application, without creating a complete dashboard? This session will show you how to navigate and control your reports through your application using links.
Speaker:

Session Type:
Regular Session

Track:
1 Grant

Level: Intermedia

Session Code:

Date: April 24

Time: 12:00 AM - 1:00 AM

Room: TBD

failover Clustering is the fundamental technology for High Availability in the Microsoft SQL world.  Windows 2008 and SQL 2008 make Clustering easier than ever.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
2 Buckhead

Level: Intermedia

Session Code:

Date: April 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you need recursive queries, do you want your T-SQL to be easier to read and maintain? 
Speaker:

Session Type:
Regular Session

Track:
2 Chastain Park

Level: Beginner

Session Code:

Date: April 24

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

Session Type:
Regular Session

Track:
1 Piedmont Park

Level: Intermedia

Session Code:

Date: April 24

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will demonstrate the ways that ASP & ASP.NET applications can be configured to make connections to SQL Server from different versions of IIS so that we can keep our servers secure and our DBAs happy. 
Session Goals: 
- Learn when to use SQL logins and when to use Windows Authentication 
- Understand the concept of impersonation 
- Learn how ASP and ASP.NET applications can be configured to use impersonation to make secure connections to SQL Server 
- Learn how to configure IIS 5, 6, & 7 and Windows XP, 2003, and 2008 to support impersonation 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
2 Buckhead

Level: Intermedia

Session Code:

Date: April 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you been asked to deliver a data warehouse project? Do you need to provide access to Production data to end users? Do you see a need (or opportunity) to position data warehousing as a core technology?

If you answered yes to any of these questions, a data warehouse assessment will help you increase your chances of success.  This session will discuss what factors typically make up a data warehouse assessment, as well as the opportunities and challenges that are presented.
Speaker:

Session Type:
Regular Session

Track:
1 Grant

Level: Beginner

Session Code:

Date: April 24

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session I will give an overview of how to design a database, including the common normal forms and why they should matter to you if you are creating or modifying SQL Server databases. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have proven for many years. Many common T-SQL programming "difficulties" are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can't use an index efficiently). 
Speaker:

Session Type:
Regular Session

Track:
1 Piedmont Park

Level: Intermedia

Session Code:

Date: April 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Beyond database design fundamentals (for example, Normalization) lies the area where you have to create "real" solutions. In this session, I will cover a good number of patterns that we commonly find useful to try to apply to the problem of building a database solution. Ideas like generalization, subclassing, single table domain tables, optional data, and more will be discussed, some of them good, some not so good (don't assume which will be which), but all that are common and/or useful for your database implementations.
Speaker:

Session Type:
Regular Session

Track:
1 Piedmont Park

Level: Intermedia

Session Code:

Date: April 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Too often the query plan, or how the SQL Server engine actually implements the logical query, is ignored by developers and DBAs.  The reason for not trying to dive into the meaning behind the hyro-glyphic plan is simple: It's not easy to understand what all those icons mean in isolation, never mind as a collection.

This session will bridge the gap between the theory of internals, where the details are mentioned but not demonstrated, and the logical query.  A series of actual query examples will show how queries are treated by the optimizer and why; what to do to identify slow performing queries, and how to make simple adjustments to allow the query to perform significantly better.
Speaker:

Session Type:
Regular Session

Track:
1 Centennial Park

Level: Intermedia

Session Code:

Date: April 24

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:
2 Midtown

Level: Intermedia

Session Code:

Date: April 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Users have become familiar with the simple search capabilities of tools like Microsoft Live Search and Google. Did you know you can give your users the same ability to search their data with SQL Server? And it's as easy as 1-2-3! Come and learn the how to setup and use full text searching with SQL Server.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
1 Grant

Level: Beginner

Session Code:

Date: April 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you thinking of starting a blog? Or are you interested in presenting at events like SQL Saturday but not sure what to do to get started? This panel style session with established SQL bloggers will give you tips on blogging platforms, choosing topics, techniques for giving presentations, and sage advice from years of experience. 
Speaker:

Session Type:
Regular Session

Track:
2 Midtown

Level: Beginner

Session Code:

Date: April 24

Time: 12:00 AM - 1:00 AM

Room: TBD

This sessions provides a walk through of Microsoft's newest SQL Replication feature called Change Data Capture (CDC). Sessions covers overview of CDC, setting up CDC and using various CDC functions to retrieve list of data changes.  CDC is often used by data warehouse applications to retrieve list of SQL insert and updates for a given time window.  
Speaker:

Session Type:
Regular Session

Track:
2 Buckhead

Level: Beginner

Session Code:

Date: April 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Session is intended to exhibit beginners, how to use data mining capabilities of  SQL server.
Speaker:

Session Type:
Regular Session

Track:
1 Grant

Level: Beginner

Session Code:

Date: April 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Business Intelligence is one of the hot job skills for 2010. In this talk you will learn the concepts behind building and designing data warehouses, and cut through the buzz words so you will walk away with a clear understanding of what words like dimensions, facts, and measures mean. You'll also get a peak at the tools available in SQL Server 2008. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
1 Grant

Level: Beginner

Session Code:

Date: April 24

Time: 12:00 AM - 1:00 AM

Room: TBD

This sessions provides an overview of Merge Replication.   Areas covered include setting up Merge Replication, configuring  dynamic filtered subscribers, performing sychronization over the Internet.
Speaker:

Session Type:
Regular Session

Track:
2 Buckhead

Level: Beginner

Session Code:

Date: April 24

Time: 12:00 AM - 1:00 AM

Room: TBD

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