Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type

Sessions Found: 40
Conversations about SQL Server administration tends to be all about administering OLTP systems. If you administer BI systems, you can't apply everything you know about administering OLTP systems to BI systems. BI systems usually end up being administered by OLTP DBAs or by BI developers and architects. Where does one even find a BI Administrator? Fortunately, I've been administering BI systems for several years, and I have learned the hard way the difference between administering OLTP and BI systems. This session will cover the top 10 things that I think an administrator of BI systems need to know.
Speaker:

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: October 08

Time: 12:00 AM - 1:00 AM

Room: TBD

So you know all about heaps, clustered indexes, and nonclustered indexes, but are still not satisfied? Then this is just the session for you!I will explore advanced features such as included columns, indexed views, and filtered indexes. You will find out how they are stored on disk, and how SQL Server uses them to satisfy queries, But I will also show the dangers of using too many indexes, and the tools SQL Server itself hands you to help identify just the right subset of indexes.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:

Level: Advanced

Session Code:

Date: October 08

Time: 12:00 AM - 1:00 AM

Room: TBD

With the widespread availability of location and spatial data to both consumers and corporations
(such as smartphone GPS data), there is a need to manage and analyze all this data as well.
SQL Server 2008 introduces new standards-based spatial data types and associated functionality
to the relational engine. Spatial data can be stored in the cloud using SQL Azure.
And SQL Server 2008 R2 Reporting Services allows spatial data to be visualized as Maps.

In this session, we'll explore both the SQL spatial data types and SSRS maps,
using demos to show this functionality in action. We'll also cover enhancements to 
spatial functionality in the forthcoming "Denali" version of SQL Server.
Speaker:

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: October 08

Time: 12:00 AM - 1:00 AM

Room: TBD

I'm sure you've been told seeks are better than scans. I'm sure you've been told that a covering index is ideal. I'm sure you've been told small arrows are better than thick ones. Get the whole story.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: October 08

Time: 12:00 AM - 1:00 AM

Room: TBD

Forget Profiler for a second, I have seen one poorly placed index bring an enterprise database to its knees. We will cover the basic tips of performance which always work and the ones which always fail. What can you do – and what should you do –when it comes to the most common types of indexes so you always make the right move. The Author will use lessons from SQL Architecture Joes 2 Pros Vol3.
Speaker:

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: October 08

Time: 12:00 AM - 1:00 AM

Room: TBD

The focus of this session is on describing best practices every SQL Server DBA needs to know. These are foundational best practices that, if not followed, could have a significant negative effect on the performance and availability of their SQL Servers. This session focuses on key fundamentals, such as: Installing & Upgrading SQL Server; SQL Server Configuration; User Data and Log File Management; Database Configuration Settings; Configuring Critical Maintenance Jobs; Setting Up Alerts for Critical Errors; Security Basics; Implementing a Backup and Restore Strategy; Creating a Disaster Recovery Plan; Testing; Monitoring; and Documentation.
Speaker:

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: October 08

Time: 12:00 AM - 1:00 AM

Room: TBD

One of the new features of SQL Server 11 (Code Name Denali) is columnstore indexes, where the storage of index data is “turned on its head”. We will look into how this feature is implemented internally, how it can greatly improve query performance in the right environment, and its current limitations.
Speaker:

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: October 08

Time: 12:00 AM - 1:00 AM

Room: TBD

The session is mainly a review of Cube Health Monitoring and Load Balancing in adCenter Enterprise Cube Environment.  It is a detailed discussion and review of our process on achieving the following goals:
1.	Create a load balancer across the OLAP cubes
2.	Achieve better monitoring and alerting of our enterprise OLAP systems
3.	Increase our Up-time and monitor our SLA
4.	Increase our ROI of the HW
Currently AdCenter has two major services that are integrated / connected to each other: first one does the monitoring and alerting of the OLAP cubes and the second one does load balancing across the OLAP servers. The monitoring service notifies the load balancer when a server is not available so the cube balancer does not route traffic to it
Speaker:

Session Type:
Regular Session

Track:

Level: Advanced

Session Code:

Date: October 08

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will describe the best practises for designing a data warehouse to get the most out of SQL Server.  Doug has worked in data warehousing for 12 years and will blend experience, with best practises and recommendations from Microsoft's Fast Track program.  Each version of SQL Server introduces new features specifically for data warehousing - by applying the correct technique, feature, hint, modelling approach and layout the data warehouse will be faster and more scalable.
Speaker:

Session Type:
Regular Session

Track:

Level: Advanced

Session Code:

Date: October 08

Time: 12:00 AM - 1:00 AM

Room: TBD

A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *Identity Crisis * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.
Speaker:

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: October 08

Time: 12:00 AM - 1:00 AM

Room: TBD

Does your company use agile development? It can deliver more value to customers with lower project risk.  However, it can also make the system design change rapidly, and require frequent software rollouts. This session will  focus on best practices for DBAs and developers to make design, testing and deployments easier. Keep your systems agile, not fragile!
Speaker:

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: October 08

Time: 12:00 AM - 1:00 AM

Room: TBD

There's so much more to know about joins than INNER, OUTER, CROSS. Understanding other kinds of joins, and the impact of decisions about how you write them can seriously impact your T-SQL effectiveness. A bunch of myths to dispel here too! No slides here - just demos. We'll create slides as we go.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: October 08

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you remember what it was like to fall in love? Wasn't it wonderful? Lately it just hasn't been the same. You've been stuck in the same old routine, doing the same old charts and tables. Maybe Reporting Services doesn’t tell you what’s wrong. Maybe you're even thinking about seeing other reporting products (!) In this session made for report developers with less than 2 years' experience, Doug will re-ignite your passion for RS by showing you how to design for better performance, explaining what RS has been trying to tell you through logs (but you haven't been listening), and demonstrating some new -- and easy -- tricks you may not have known RS can do. After this session, you'll want to spend some time alone with your new old flame.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: October 08

Time: 12:00 AM - 1:00 AM

Room: TBD

MERGE is a new capability in SQL Server 2008. This session will start with the basics of what MERGE is and then dig into how it works and how it compares to using traditional INSERT/UPDATE semantics. You should come away from this session with a good understanding of MERGE, ready to implement it in your environment.
Speaker:

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: October 08

Time: 12:00 AM - 1:00 AM

Room: TBD

Extended Events is the replacement for profiler in many respects, and will be the choice of capturing data from within SQL Server now and in future editions, so we need to understand the differences it has to profiler "old guard" and why we should be using this new feature for this purposeI'll take you on a Guided tour of the key aspects, and show you simply how in just minutes you can up and running and capturing data using this new method and how to analyze it effectivelyFollow me to the "new age" of understanding your systems activity
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: October 08

Time: 12:00 AM - 1:00 AM

Room: TBD

We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem.  We don't always know how to do this easily and consistently.  This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.
Speaker:

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: October 08

Time: 12:00 AM - 1:00 AM

Room: TBD

With so much interest in Cloud technology, where does it really fit in, and what is the role of the DBA and Database Developer? What is available in SQL Azure, as it compares to SQL Server? Can you leave some data on-premise, and put other data in the cloud? Buck shows you the ins and outs of SQL Azure, how to connect to it, manage it, what the limitations are, and real-world examples of architectures that work. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: October 08

Time: 12:00 AM - 1:00 AM

Room: TBD

In this introductory session, we will go through an overview of SQL Server Mirroring and Log Shipping. We will do a brief overview of the parts and modes of database Mirroring. You will also be introduce to Log Shipping and how it works. We will have a demo part of the session where we will go through step-by-step on how to set up Mirroring and Log Shipping. By the end of this session, you should have a general understanding and ability to deploy database Mirroring and Log Shipping.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: October 08

Time: 12:00 AM - 1:00 AM

Room: TBD

By now you have probably already heard about Analysis Services. Maybe you've even said to yourself that you were going to learn more about it but just haven't found the time. The biggest barrier to learning something new is figuring out the first few steps. But where do you begin? Come learn those first few steps by attending this presentation. We will discuss what Analysis Services is, where it shines and more importantly, how to get started.
Speaker:

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: October 08

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: October 08

Time: 12:00 AM - 1:00 AM

Room: TBD

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