Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 23
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:
1. Dev

Level: Advanced

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

The MERGE statement was introduced in SQL Server 2008, and it offers a tremendous value.
Most people do know the basic function of MERGE: synchronising imported data with base data by inserting new rows and updating existing rows, all in one go. But MERGE can do much, much more.
In this demo-rich session, Hugo Kornelis will present the full syntax of the MERGE statement, explain all the options, and show the possibilities. He will also demonstrate that the introduction of MERGE might have made your existing triggers incorrect, and how to fix the problems.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
1. Dev

Level: Intermedia

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

What does Azure offer to Business Intelligence developers, and to those who use Business Intelligence every day? Come to this session to see how you can transfer your skills in SSIS and SSRS to add Azure to your existing Business Intelligence skill set. We will look at:

- the differences in developing SSIS packages that use Azure as a source and as a target.
- developing SSRS reports deployed to Azure.
- mobile devices and Azure such as tablets

Come and see the similarities and differences in using Azure SQL Business Intelligence, and learn to avoid some of the 'gotcha!' pitfalls. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
4. SQL Azure + Extras

Level: Intermedia

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

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.

I present this session @ Red Gate SQL-in-the-City Conference (London - July 2011) & will also be presenting this @ SQLSaturday #105 Dublin event
Speaker:

Session Type:
Regular Session

Track:
2. DBA

Level: Beginner

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

In 1982 the Dragon 32 entered the home computer market but unfortunately there was one small problem ...lower-case letters were almost impossible to access. Two years later, Dragon was no more. In 2008 MS released Server Core providing a fast streamlined edition of Windows with minimal GUI support. As of SQL 2012, installation to W2008R2 Core is now a supported option and means the biggest administrative change to a DBA since the release of SQL 2005 ...or will it?

We will demonstrate OS configuration through Cmd line utils and PowerShell, SQL installation, Remote Admin and Clustering on Core. Will the lack of GUI support send Server Core in the same direction as the Dragon 32 or spell a bright new future for SQL & Windows Server computin
Speaker:

Session Type:
Regular Session

Track:
2. DBA

Level: Advanced

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Want to know what's new in SQL Server 2010 BI stack?Come and see what cool features you can take advantage of SQL Server with SharePoint Server 2010
Speaker:

Session Type:
Regular Session

Track:
4. SQL Azure + Extras

Level: Beginner

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session will be shown a first look to the new SSIS 2012 version. This new version has lot of enhancements and new features. New environment, new tasks, new approaches to deal with packages, and several other stuff that I evaluated during last months of writing a SSIS book for the Packtpub publisher.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
3. BI

Level: Beginner

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

You have seen Power View, and you have seen the new SSAS BISM Tabular models in SQL Server 2012. But are you really a master of the unknown? Come to this session, and join the ranks of those who leave the darkness, and uncover the integration between Power View and BISM Models. Weapons, demos, and techniques will enlighten your way. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
3. BI

Level: Intermedia

Session Code:

Date: March 17

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:
3. BI

Level: Intermedia

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

The session provides an overview of AlwaysOn and introduces the key new features and capabilities that will help businesses achieve the high availability SLA for mission critical applications.
Speaker:

Session Type:
Regular Session

Track:
2. DBA

Level: Intermedia

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will focus on more agile patterns & techniques applied to the usual Microsoft BI stack. Main topics will be: rapid feedback cycles, test automation, flexible integration processes, analysis services flexible models and some others.
Speaker:

Session Type:
Regular Session

Track:
3. BI

Level: Intermedia

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

The complete title is: Open your mind to new Transact-SQL features in SQL Server 2012: OVER clause and Running and Sliding Aggregates
The session will have two speakers (Eladio and Enrique Catalá (ecatala@solidq.com)
SQL Server 2012 is closer than ever to fully implement the ANSI Windowing functions. In this session we will get deeply into the OVER clause; you will understand how to use the OVER clause in SQL Server 2008, and what are the improvements in SQL Server 2012. The session will cover practical examples with running and sliding aggregates, running totals, and the new analytical functions; The attendee will learn by practical examples how to dramatically improve the performance in his/her Transact-SQL queries.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
1. Dev

Level: Advanced

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

In this presentation it will be clarified when and why parameter sniffing is a problem in SQL Server stored procedures. Of course we will offer several solutions for this problem and discuss which solution is applicable in which scenario. 
Speaker:

Session Type:
Regular Session

Track:
1. Dev

Level: Intermedia

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Power View is Microsoft's Data Visualisation tool. Where does it get it right, and where does it get it wrong? Using demos, we learn about Power View whilst assessing it based on current cognitive research around Data Visualisation principles by luminaries such as Stephen Few, Tufte and others. We will:

- investigate Power View based on current cognitive research around Data Visualisation principles
- look at the features of Power View
- look at where Power View is supplemented by other parts of the Microsoft Business Intelligence stack

Come to this session if you really want to think about the best ways of presenting data to your Business Intelligence data consumers, and see how to apply these principles in Power View.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
3. BI

Level: Intermedia

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

There are several enhancements regarding security and auditing in SQL Server 2012.

This session will cover some of them in the following (new) topics:
- Default Schema for groups;
- User-defined Server Roles;
- Contained Databases:
           - Authentication without Logins;
           - SQL Users with passwords.

anf if time permits:
     - Sql server audit enhancements:
              T-SQL Stack Information;
              User-defined audit event
Speaker:

Session Type:
Regular Session

Track:
4. SQL Azure + Extras

Level: Intermedia

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

This session describes how SQL Server internally stores table data. 
Although you can use SQL without understanding the internals of data storage, a deep knowledge of how data is stored will improve the development of efficient applications.
This session explores the basic of metadata that keeps track of data and index storage information.
Speaker:

Session Type:
Regular Session

Track:
2. DBA

Level: Intermedia

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

The three main topics of this session are:
1. Perform a brief introduction what Extended Events are and the basic concepts/objects behind this feature.
2. Talk about the what's new in SQL Server 2012 and show the new UI and how to use it
3. Present some tipical scenarios where Xevents can help on the troubleshooting of different kind of issues
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
2. DBA

Level: Intermedia

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

This demo driven session will show some of the most outstanding from SQL 2008R2 to 2012 in terms of differences in information output by SHOWPLAN, which may prove helpfull when you are troubleshooting or performing query tuning.
Speaker:

Session Type:
Regular Session

Track:
1. Dev

Level: Intermedia

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server is the guy being around for quite some time and SQL Azure is the new kid on the block. What would a fight between the two look like? What would each of them bring to the arena? In this session will get a look at the resources that SQL Server, as well as SQL Azure, would get to the fight arena and also see how a team-up between them would leverage a set of scenarios.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
4. SQL Azure + Extras

Level: Intermedia

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will travel through the two SQL Server 2012 Analysis Services modes: Tabular and Multidimensional. We will focus on the advantages and business scenarios of the new Tabular mode and we will discuss real-life situations in which we should apply tabular or dimensional approaches, focusing on the main differences and features in each mode.This session will be co-presented with Andre Santana.
Speaker:

Session Type:
Regular Session

Track:
3. BI

Level: Intermedia

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

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