Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 33
2AM. We sleeping well. And our mobile ringing and ringing. Message: DISASTER! In this session (on slides) we are NOT talk about potential disaster (such BCM); we talk about: What happened NOW? Which tasks should have been finished BEFORE. Is virtual or physical SQL matter? We talk about systems, databases, peoples, encryption, passwords, certificates and users. In this session (on few demos) I'll show which part of our SQL Server Environment are critical and how to be prepared to disaster. In some documents I'll show You how to be BEST prepared.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will run through the history of SQL Server Management Studio Add-ins, then goto through the step by step process of creating an Add-in for SQL Server Management Studio 2012.

We will look at some of the cool things you can do and break.

This session is for people who have some C# knownledge and want to extend SQL Server Management Studio.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4 (special)

Level: Intermedia

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging. Key takeaways: 1) Developers can migrate packages from Development, through their lifecycle, to Production without editing SSIS Connection Managers properties. 2) A metadata-driven approach to SSIS package execution. 3) Demonstration of a centralized logging reporting application.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Advanced

Session Code:

Date: September 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:
Track 2

Level: Intermedia

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

IT teams today have many different types of architect, yet their technical skills are just the foundation for a range of soft skills that if they didn’t have wouldn’t earn them the title of architect.

The session will help you understand the type of architect you are or want to become; define the leadership, design and implementation skills you’re likely to need; and review some of the methodologies you could use to help you become a more successful architect.

While the subject is a generic professional discipline, the session is aimed at people with SQL Server DBA or development backgrounds, and refers to the requirements of the Microsoft Certified Architect certification.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4 (special)

Level: Intermedia

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL is fundamental to every deployment of SharePoint, and increasingly many organisations have or are planning some form of SharePoint deployment.  As a SQL Professional you can't ignore SharePoint, and instead you should be actively engaged in its implementation to be to better support the solution.  This session will be an introduction to some of the key considerations around SQL for SharePoint including different database, sizing, naming and a few common issues encountered.   It will also introduce the SharePoint integration to Reporting Services which has been enhanced in SQL 2012.  Finally it will make the case that you how and why you should get actively in your organisations SharePoint deployment. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4 (special)

Level: Beginner

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

Keeping track of database versions, deployment scripts, and any number of ad hoc database changes is a pain. In this session, you’ll see how to manage database changes easily using source control within SQL Server Management Studio. Source controlling databases is faster than you think with SQL Source Control; you can track who made database changes, what they changed, when, and why.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

There are very few applications which are being developed from zero, the most are apps are simply inherited from previous development teams.

This session serves to show some easy implementable practices to follow after inheriting a database. Those practices allow to check some if the database design was done in regards to the actual data, or if while implementing some of the constraints and checks some tables were left behind. :)

The practices shown in this session will allow to check the database design and identify some of the possible performance degradations.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

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:
Track 1

Level: Intermedia

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

Loading data into your Data Warehouse is not always a trivial task. Especially if the source systems can re-deliver data and you want to replace an old subset of your data. The quick answer you always hear is “just use partitioning”, but nobody really tells you how you should design or implement it.

This session will show one way to load and access your data really fast, by using layered partitioning. We will walk through partitioned tables and partitioned views, before moving on to the concept of layered partitioning. We will also take a look at the management and performance benefits (and challenges) partitioning gives us.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Advanced

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you want to speed up your reports over your large tables by 10, 20 or even 50x? Those are the performance improvements that Columnstore indexes can give you – when used properly.
Often touted as a “BI” feature, in reality columnstore indexes can benefit any workload that involves some sort of reporting on large tables. In this session, we’ll first discuss how columnstore indexes work. Once past the basics, we’ll dive in and get dirty, looking at how to rewrite existing queries and change database designs to get the most out of this new index type.
If you are running SQL Server 2012, you can add a columnstore index to your large tables and gain maybe 4x performance – or you can attend this session and make things really fly.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

The T-SQL Merge statement provides a world of opportunities to save a lot of time.In this session we’ll look at how merge can be used to perform complex multi-stage tasks such as loading data into data warehouse dimensions, including the handling of type 0, 1 & 2 slowly changing dimensions.I’ll present a summary of my MSc dissertation findings, comparing the performance of using T-SQL Merge against other more traditional methods of loading slowly changing dimensions in SSIS.We’ll also look at how we can use dynamic SQL to completely automate the generation of the merge statement, resulting in an incredibly simple meta-data configured dimension loads in your data warehouse.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Advanced

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

Microsoft has made serious commitments to mobile Business Intelligence, announced at SQLPass Summit 2011. What is the roadmap?  What's available right now, and how can it be implemented at your organisation?

Come to this session to learn about mobilising Business Intelligence using Sharepoint, Reporting Services, SQL Azure, Excel Services and Power Pivot. Yes, it is possible to have mobile Business Intelligence in your organisation, and come to this session in order to learn how!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will provide insight on what to expect when deploying a highly available end to end SQL Server 2012 Business Intelligence environment as experienced from the field. As well as leveraging the SQL Server Business Intelligence skills that you possess. You will also gain an insight into the additional skills and knowledge that you will need to ensure the successful delivery of technologies such as such as PowerPivot, PowerView, SQL Server Reporting Services and SQL Server Analysis Services on a robust architecture.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

Most servers we deploy today use a NUMA rather than an SMP mainboard architecture and while we might conceptually understand what that means we often don’t appreciate the subtle changes to how Windows and SQLOS work when they run on a NUMA architecture server. To make things even more interesting, we can deploy Soft-NUMA ourselves to request some of the behaviour changes ourselves.

This session will cover:

    what is NUMA and why it exists,
    how Windows responds to NUMA hardware
    how SQL Server 2012 changes its behaviour in the NUMA world. 

We’ll then look at some of the benefits NUMA brings us and how we sometimes need to adapt our monitoring
for the NUMA world.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Advanced

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

Since SQL Server 2005, we've been able to use the vardecimal data type to store decimals efficiently. With SQL Server 2008 came row and page compression, resulting in much better options for compressing our data. However, neither row nor page compression are panaceas! In this session I'll walk you through the internals of row and page compression, and based on that knowledge, enable you to better evaluate when to use which type of compression, if compression should be used at all. Once used, how do we determine its effectiveness? What are the pitfalls? I'll give you a full tool belt of knowledge to bring home and put to use on your databases.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Advanced

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

Partitioning your data allows a whole host of benefits to the performance and maintainability of your databases but still seems to be a dark art known only to a few people.  With every release of SQL Server more features become available to help solve various problems and a lot of them require that your database has been partitioned for that feature to be used effectively.  The most recent feature requiring partitioning is Column Store indexes, without partitioning you would be required to drop them before modifying any data in the base table and then recreating them from scratch.
Speaker:

Session Type:
Regular Session

Track:
Track 4 (special)

Level: Intermedia

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

"Practical Powershell – How to design and build larger scripts"The best Powershell scripts, in my humble opinion, will think like you would and will solve a problem or do a task for you in such a way that you can call the script nine out of ten times with minimal parameters and let it figure out what smart defaults to use.In this session we’ll build a (1) Powershell script to automate one of our many (dba/dev) tasks in order to save us a lot of time.I’ll show you how I design, build, test and debug the bigger scripts and we’ll put in all the bells and whistles that those scripts commonly have. (Like support for  –WhatIf and get-help etc.)
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will deep an in-depth look at some of the most common query plan operators. We'll look at what they do, how they do it and the circumstances in which they are chosen. 

We will look at the good and bad aspects of each and why sometimes they aren't the right tool for the job. 
Using lots of examples we'll investigate the usage and impact they have on your SQL Server.

Hopefully you'll walk away from this session with the knowledge which will give you a deeper understanding of your query plans
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Advanced

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you really understand SQL Servers’ Concurrency behaviour?
Are you sure that Transactions are an ALL or NOTHING operation?
Do you believe Read operations cannot start a Transaction?
Do you really know if READ_UNCOMMITTED is safe for reporting?
Is being Optimistic really better than being Pessimistic?
Can SQL Server 2012 be the solution to all our problems or our worst nightmare?

I look forward to you joining me in this very revealing and thought provoking session where I will provide answers to all these questions and more and make you wish you had known all of this sooner.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4 (special)

Level: Intermedia

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

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