Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 27
Quote: “A good DBA is a lazy DBA”. When you have to manage a few SQL Servers, it’s not that hard to be a lazy DBA and to automate your day to day activities. But when you have to manage over 100 instances, it can become a tough job. Just imagine how you will deploy a new maintenance job on all your instances? Are you going to connect to each server one by one? Not really… Microsoft provides an enhanced set of multi-server management tools. The purpose of this sessions is to point out which SQL Server tools you can use for multi-server management. The session is bulk loaded with demos and it will give you a good idea what features can be helpful in your environment. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: March 22

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server Management Studio is at the heart of any SQL Server DBA or developer’s day. We take it for granted  but rarely do we take a look at how we can customise or improve it to make our day to day work easier and more productive. 
This presentation will show you how to use SSMS and will look at many of the hidden features and shortcuts that you had forgotten about or didn’t know were there.
At the end of this session you will have learnt at least one new feature of SSMS that you can use to improve your productivity.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: March 22

Time: 12:00 AM - 1:00 AM

Room: TBD

R, the statistical programming language, is another open-source program making inroads into the Microsoft world.  This session will show you how to get data into R directly from SQL Server, perform different forms of analysis, and output to various formats.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: March 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Ever tried to import a file with the Import/Export wizard?
Or created a bunch of SSIS packages to process a data warehouse load?
Then you know how much work it is to specify the metadata correctly just to create a package that actually works.
Wouldn't it be cool if you had a descriptive language which looks at your metadata and just created the packages for you?
This is what BIML is all about. 
In this session I explain what BIML is, how it works and I'll show you how you can generate your packages and quickly respond to changes.
You can expect a demo rich session with lots of notes from the field and practical examples.
This is not just for BI developers, DBA's or SQL dev's who need to import or export data occasionally will learn some quick and easy tricks as well.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: March 22

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session I will explain what PowerView is and the benefits it can bring to your business; followed by an overview of how you can deliver it to your business using SQL Server 2014 and SharePoint 2013.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: March 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Illustrate how multipurpose queries can lead to issues with scalability and performance. Show a few alternatives that will work for smaller and simpler queries while highlighting their limitations for more complex queries. Then work through building a dynamic search query to resolve the identified performance issues. Touching on: • Testing. • Tuning each part of the query in isolation. • Plan cache re-use • Security – SQL injection attacks and authorisation / code signing. • Possibly, mentioning greater re-use and extendibility.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: March 22

Time: 12:00 AM - 1:00 AM

Room: TBD

We all know that ‘Indexing’ is KING when it comes to achieving high levels of performance in SQL Server. 
When Indexing also combines 2 of the Enterprise features: Partitioning & Compression, we can often see substantial gains.

Learn how to identify those objects that benefit greatly from being Partitioned or Compressed, OR combining both of these features to even greater effect.

Using Demos to illustrate the performance gains with real-world examples, Take away advanced scripts for use in your own environments.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: March 22

Time: 12:00 AM - 1:00 AM

Room: TBD

The most common feedback I receive about the MCSA in SQL Server 2012 is that the requirement to pass the data warehousing exam can be difficult for the DBA to achieve. In this session we look at key features of the data warehousing that will enable you to prepare for the exam with more confidence. 

We will start off by visiting the Microsoft website to look at the exam objectives, we will then look at the key features of the technologies related to the exam through demos, and finish of with a Q&A session.

This is an interactive session, and is intended to work best for those who have specific questions for the exam. The only question you can't ask is "What are the exam questions"
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: March 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Microsoft have released a distribution of Hadoop targeted at making big data accessible to everyone.  Hadoop is different to SQL Server.  Not necessarily better, just different.  It is a tool for a job.  if you have only ever worked with an RDBMS such as SQL Server then Hadoop is going to play with your mind a little and you are going to need to rethink a few things.
This session is going to take Hadoop and break it apart.  I will also look at some of the tooling Hive and Pig.
Keep an open mind and let me show you that Hadoop has lots to offer.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: March 22

Time: 12:00 AM - 1:00 AM

Room: TBD

This is one of the most frequent questions I get from our website visitors (mainly as we provide BI Tutorials).

I have become a BI Developer and I would like to share my experience and thoughts (and get yours) during this session, which will include:

1) We are not born BI Developers and anyone has a chance to become one!
2) It is not easy but it is easier when you have a clear directions how to get there!
3) Permanent vs. Contractor brief explanation of pros and cons!
4) Money is important aspect so we will talk about salaries and contract rates!
5) My journey to becoming a BI developer was not easy and I have started from not knowing English (in 2005) and any aspects of IT and I worked very hard (and Katie; my wife was my main success factor!) but I no longer want to be a BI Developer so last point is where to go next?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: March 22

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will go through the topics of performance, scalability and availbility - the 3 core topics that every DBA needs to know. Performance is at the core and required for every database application (small or mission-critical). In this talk we will go through the concepts, tools and procedures that will help you in monitoring and start fine-tuning the performance or find the root-cause on your data platform. The subject covered here is excerpted from my book "Microsoft SQL Server 2008 R2 Administration cookbook" and "SQL Server 2012 Cube Security How-to". This will also be an ideal beginning for any IT person who is willing step-into DBA world. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: March 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Beginning with SQL Server 2008, Policy-based Management was added to the DBAs toolkit to ease administration, but it only goes so far. This session will cover the principles of PBM, and we'll take a look at how we can make it *work* for us, as opposed to just telling us something is not right. We'll cover PBM and it's insides, Alerts, Operators, Scheduled Jobs, and demo a real-world use when setting up databases.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: March 22

Time: 12:00 AM - 1:00 AM

Room: TBD

We’ve all dealt with them: nightmare queries, huge, twisted monsters that somehow work, despite being ugly and unmanageable. The time has come to tame these beasts, and the solution is available now, in SQL Server 2012.
New T-SQL functions offer out-of-the-box solutions for many problems that previously required complex workarounds. Paging, Running totals, Moving aggregates, YTD, and much more comes at the power of your fingertips in SQL Server 2012. The only thing you need to do is learn the syntax. And that is exactly what this session is all about: a thorough description and explanation of the syntax, and loads of demos to demonstrate how you can use all these new features.
Attend this session to boldly take SQL Server where it has never gone before!
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: March 22

Time: 12:00 AM - 1:00 AM

Room: TBD

The life of a SQL Server DBA is a busy one. A fount of all knowledge, the SQL Server DBA is often interrupted with small questions and routine tasks. This session will show you some functions that you can use to save time spent on this and hopefully inspire SQL DBAs to explore PowerShell further by showing how easy it is to explore SQL Server properties with it.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: March 22

Time: 12:00 AM - 1:00 AM

Room: TBD

As a SQL Server DBA you've probably noticed more and more talk of PowerShell over the last few years. You might have never used it, or perhaps you've even downloaded a few scripts to use, or started reading a tutorial, but aren't really sure what it can do for you?

Then this session is for you. Trying something new for SQL Saturday Exter 2014, this "session" is in fact 2 sessions long (don't worry, you'll still get a break for coffee half way through). 

By the end of them you should have a better understanding of what PowerShell is, and how it can be used with SQL Server, so you can  start writing your own scripts or have a better understanding of how a script you've downloaded works

Session 1 will be a easy high level introduction
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: March 22

Time: 12:00 AM - 1:00 AM

Room: TBD

The query optimizer is at the heart of SQLServer.  Without it SQLServer would be a vastly inferior product, queries would have to be manually tuned at each and every turn, and generally speaking, the optimizer protects us from the complexities and mechanics involved.

Much of the optimizer's internal workings are hidden from the user, but can be revealed by using a selection of undocumented trace flags to gain further knowledge and insight into how your queries and data are processed to create a plan.

This session will be a deep dive into the optimizers' internals and not for the feint of heart.

Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Advanced

Session Code:

Date: March 22

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will take an in depth look at how query plans work. We will go under the covers and see what happens when you run that query. 
We will also take a look at various operators, how they work, why they are chosen and how to avoid them being used in the wrong place / context,.
Attendees of this session will walk away with a greater understanding of query plans and the operators, which will enable them to both better interpret their query plans and also write more efficient SQL code
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Advanced

Session Code:

Date: March 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Quite frankly, some aspects of building out a business intelligence solution are tedious. As you cycle through iterations of your star schema, you’ll find that even a simple data type change in the data warehouse requires you to make corresponding changes to staging tables, SSIS packages, and SSAS multidimensional or tabular models that take a considerable amount of time to implement. But there’s a better, faster way!In this session, we’ll explore lessons from a project that required implementation of a framework to easily generate BI objects based on reusable patterns. We’ll walk through the decision points in the framework design, review the implementation steps, and see demonstrations of how easily you can make iterative changes to your BI solution’s design by using reusable design patterns. Whether you simply want to accelerate change management or reproduce objects in bulk on demand, this session will give you practical tips for automating these processes.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: March 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Sometimes you really need an EAV model. In most cases they are ugly and slow.
After this session you will have gained new insights how to turn your old, slow, EAV model into a slim superfast model.

There will be real life examples from a recent project. With the techniques displayed in the presentation, I cut the execution time down from 134 days down to 0.5 seconds and cut the storage need from 550GB to 45GB.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: March 22

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2014 In-Memory OLTP Technology - AKA Hekaton - is here. Should you be getting excited? Will it prove to be the miracle turbo-boost for your databases that you are hoping for? In this session, three simple questions will be answered: Could you use it? How would you use it? And why would you want to use it? Tidy. So when your boss hears the buzz and wants everything converted ASAP, you'll know the score.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: March 22

Time: 12:00 AM - 1:00 AM

Room: TBD

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