Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 22
It's Friday, 05:00pm. You are just receiving an email that informs you that your SQL Server has enormous performance problems! What can you do? How can you identify the problem and resolve it fast? Which tools provides you SQL Server for this task? In this session you will see a lot of different tools with which you can do effective SQL Server troubleshooting. You will learn how to identify performance bottlenecks with those tools, and how to resolve the identified bottlenecks.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 4

Level: Advanced

Session Code:

Date: March 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Many DBAs have heard the term Analysis Services, but don't really know what it's for or who would use it. In this session, Mark will explain the use cases for Analysis Services, illustrate how it improves performance for large data sets and eases report writing, and will go through a practical example of building a first Analysis Services solution.

This session will be practical for SQL 2005 through 2008 R2, but he will also take the time to explain what changes in SQL 2012 and the new Tabular mode.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 2

Level: Beginner

Session Code:

Date: March 24

Time: 12:00 AM - 1:00 AM

Room: TBD


My last session on managing large environments turned out to be more talk than proof, it contained a bunch of war stories and almost no demos.
This session will be the other way around, we're going to spend most of our time in powershell and we'll build a whole monitoring system from scratch.
I'll use powershell remoting and real world demo's based on my own day to day practice.
To keep the promise of a level 300 session I'll spend some time in the beginning to explain the concepts of powershell remoting,
after which I'll build a monitoring system step by step in the second part of the session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 1

Level: Intermedia

Session Code:

Date: March 24

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 3

Level: Intermedia

Session Code:

Date: March 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Drive Greater Application ROI, Deeper Business Insights, and Faster Time to Market...
Learn how SQL Server 2012 can help you Reduce Your Costs and Increase ROI on Mission Critical Applications while Innovating with New Technology. 
•          Reduce total cost of ownership of Mission critical and line of business applications  
•          Increase ROI on current IT investments
•          Improve time to market on new IT investments
•          SQL Server 2012: an overview of changes to SKU line-up and licensing model
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 4

Level: Beginner

Session Code:

Date: March 24

Time: 12:00 AM - 1:00 AM

Room: TBD

I present this session @ Red Gate SQL-in-the-City Conference (London - July 2011)This session will explain the basic principles of SQL Server's data compression feature, how it functions, what options you can choose, and how it performs under differing workloads. We will look at how to integrate data compression into your current schema designs and the challenges you will likely encounter, examining the all-important performance aspects and the configuration changes to consider along with SKU editions requirements. We will also look @ Red Gate's "SQL Storage Compress" product to show how their data compression tool can tackle these data growth challenges in a different manner.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 1

Level: Beginner

Session Code:

Date: March 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Pete Harris, SQL Server Product Planner for Microsoft will lead you through the training offered by Microsoft in the area of SQL Server 2012 and SQL Server 2008.  He will be supported by Chris Testa-O’Neill, e-learning author, Microsoft Certified Trainer and Senior Consultant at Coeo and a guest MCM / MCA. The session will cover certifications such as:
•             Microsoft Certified Technical Specialist
•             Microsoft Certified IT Professional
•             Microsoft Certified Master
•             Microsoft Certified Architect
The Session will also identify and explore available learning channels (Microsoft official courses – instructor led training / e-learning / press books) to support you in achieving your certification 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 2

Level: Beginner

Session Code:

Date: March 24

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 4

Level: Beginner

Session Code:

Date: March 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Introduction to the Tabular Model in Analysis Services 2012
The Tabular model in Analysis Services 2012 is the new alternative to building cubes: it’s easier to develop with (especially if you come from a relational database background) and its in-memory, column-store database provides blindingly fast performance. This session will provide a basic introduction to building Tabular models and discuss their strengths and weaknesses compared to cubes.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 3

Level: Advanced

Session Code:

Date: March 24

Time: 12:00 AM - 1:00 AM

Room: TBD

There are lots of DQ issues we are going to talk about some of the common issues and later see how we can handle them. Issues such as
1.  Misspelled names 
2.  Misspelled addresses – addresses which do not exist, e-mail addresses 
3.  Duplication

Pretty much everyone suffers from these problems so come to this session to learn a new way to deal with them in SQL Server 2012 Data Quality Services
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 2

Level: Intermedia

Session Code:

Date: March 24

Time: 12:00 AM - 1:00 AM

Room: TBD

In this diverse session we will take an in-depth look at moving to the SQL 2012 platform and the upgrade strategies at your disposal. Specifically we will take a deep dive into preparing and reporting for upgrade, upgrade strategies, performing the upgrade, knowing the upgrade was successful.

This session will therefore look at some advanced scenarios such as SQL Server 2012 on Server Core, preparing for Always On Availability Groups, upgrading your SQL Failover Cluster, storage migration.

Attend this must see session and you too can have the “Moves like Jagger”.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 1

Level: Advanced

Session Code:

Date: March 24

Time: 12:00 AM - 1:00 AM

Room: TBD

With the addition of non-transactional filestream, filetable, semantic search and full-text search support for property search, SQL Server 2012 provides an excellent platform for searching over traditional relational as well as unstructured document data. This talk covers the motivation, implementation, and components that expands and inegrates search capabilities.
Speaker:

Session Type:
Regular Session

Track:
Room 3

Level: Advanced

Session Code:

Date: March 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Session Details not available
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 2

Level: Intermedia

Session Code:

Date: March 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Delivered by Noemi Moreno, Business Intelligence Specialist and Tom Austin, SQL Team Lead at Red Gate Software.In this session, Noemi and Tom explain how they developed a system to import information from Twitter into a SQL Server data warehouse, and to export their analysis into Google Docs. They also discuss how Red Gate’s database development tools helped them collaborate on the project without having to pick between their favourite IDEs. Session attendees have the chance to enter the competition to win a SQL Developer Bundle.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 3

Level: Beginner

Session Code:

Date: March 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Always On offers a huge leap forward in terms of high availability. This sessions is a demo based introduction to the high availability changes in Denali emphasising key features and benefits.

During the demonstration we will show how to seamlessly upgrade a database from SQL 2005+ to Denali with ZERO down time and then use the Always on features to simplify reporting, availability and disaster recovery.

This session will be useful for anyone who is working in a high availability environment or currently using replication to provide reporting and looking for a neater solution.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 2

Level: Advanced

Session Code:

Date: March 24

Time: 12:00 AM - 1:00 AM

Room: TBD

The new Business Intelligence and Data Visualisation functionality are key to the changes in SQL Server 2012. We will take a look at:

- Power View and its impact for Data Visualisation
- PowerPivot improvements and new features
- Reporting Services and its future in Sharepoint

Come to this session in order to 'hit the ground running' with Business Intelligence and Data Visualisation in SQL Server 2012.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 2

Level: Intermedia

Session Code:

Date: March 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Ever wondered what happens under the hood when you query your SQL Server database? Well, it’s somewhat like asking for a special meal for dinner. During this session, I will use a cooking analogy to describe the life cycle of a query and the journey it takes through SQL Server’s working parts. By comparing the concepts of SQL Internals to a familiar idea, you will have a clear understanding of the underlying processes involved in returning data from a SELECT query. Once we’ve established a frame of reference for a simple read operation, we’ll look at an UPDATE statement and consider the additional factors associated with a write operation.  By session's end you should have a clear overview of what happens when a query hits your server.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 1

Level: Beginner

Session Code:

Date: March 24

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2012 introduces a number of exciting new features that will change the way we design, deploy and manage SSIS packages. We will explore the new features, understand how to take advantage of them and formulate some best practices for efficient management of these packages
Speaker:

Session Type:
Regular Session

Track:
Room 4

Level: Intermedia

Session Code:

Date: March 24

Time: 12:00 AM - 1:00 AM

Room: TBD

The SQL Server 2012 release of SQL Server Integration Services (SSIS) includes a broad range of new features and enhancements designed to ease adoption for new users and to increase productivity for experienced SSIS developers. In this demo intensive session, Matt Masson – Senior Software Development Engineer on the SSIS team – guides you through the new developer focused functionality in SQL Server 2012. We’ll look at the productivity enhancements in SQL Server Data Tools (formerly the Business Intelligence Development Studio), team development enhancements, and the new Change Data Capture (CDC) features that ship with the product. If you haven’t seen the new SSIS features in SQL Server 2012 yet, you won’t want to miss this session!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 4

Level: Intermedia

Session Code:

Date: March 24

Time: 12:00 AM - 1:00 AM

Room: TBD

The release of SQL Server 2012 brings long-awaited technologies and improved scalability to the database platform.  
While historical best practices will continue to apply, added product features such as AlwaysOn, PowerView, Column Store, now brings an extra dimension to consider when deploying and optimizing storage for SQL Server 2012.
This session will cover Storage Best Practices for both existing SQL Server editions and 2012 in common and feature-intense areas.  Designing for OLTP, OLAP/DW/BI environments also is addressed.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 1

Level: Intermedia

Session Code:

Date: March 24

Time: 12:00 AM - 1:00 AM

Room: TBD

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