Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 28
Or, using unit tests to produce better quality code and do less (re)work!

In this brisk session we will discuss some of the reasons to unit test your procedures as well as which tests are and are not appropriate as unit tests. We will look at how to use the open source tSQLt framework to achieve repeatable unit tests, including Test Driven Development approaches and writing tests for existing stored procedures; in short everything you need to begin writing unit tests for the stored procedures in your databases.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Finding the best way to implement complex logic in TSQL can be more challenging then you’d expect. Often, the developer just makes the query bigger and more complex but this is not always ideal. We’ll look at how and when you should split larger queries into smaller chunks. We’ll explore the implication of larger queries, using temporary tables, table variables, functions and view, derived tables and sub queries and CTEs. 


Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session I'll cover advanced HA and DR architectures for SQL Server 2012 that also enable you to scale-out certain workloads.  This will include design patterns and configuration best practices for Availability Groups (AG) and Failover Cluster Instances (FCI) across different sites as well AG replicas between FCIs.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Virtualisation is a hot topic at the moment and the chances are your business is probably looking at or already implemented virtualisation to some degree. As a DBA there will be pressure for you to virtualise your SQL Servers too.  Many DBAs are reluctant to virtualise their SQL servers usually because of the fear that that performance will suffer. If virtualisation is done properly though SQL Server will run perfectly well on a virtual platform and you may even get some added HA benefits thrown in for free.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

We all know about the low startup costs of using cloud based SQL Servers, but what are the (hidden) costs and benefits?

In this session, we will run thought the supported feature sets of each and how they stack up against one another.
Does one perform better than the other? Are they better for different work loads?

If the demo gods are with us, will can see they both in action and you can see for yourself!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Database replication doesn't get much attention, especially now that the AlwaysOn features have been released into the wild.  

However, replication offers another way to make data available on multiple servers/locations that steps outside of "normal" HA/DR scenarios.

This session will explain what database replication is, what the different parts are that make up the replication architecture and when/why you would use replication.

The content will be valid for all versions of SQL Server from 2005 onward,
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2012 introduced SQL Server Data Tools (SSDT) Database projects. In this session I shall explore how to develop SQL Server databases using SSDT and demonstrate why I think declarative, offline, database development is something we should all consider.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

At the heart of SQL Server is the cost based optimizer.  Stop and think about that a minute, it attempts to give the “best plan” based on the cost of the work undertaken.  How does it know the cost of the work before its done the work ? This isn’t a conundrum, it doesn’t.  It estimates!  How does it estimate ? That is statistics.
This will be a deep dive into how the optimizer makes its decisions to give you a plan, the things that can go wrong and how you can have influence over these choices.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Advanced

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

I know what you're thinking, Powershell is not an ETL tool. And you're probably right.
But I keep running into weird requests that were just easier to fix with Powershell.
I'll show you why some things are not easy in SSIS. 
I'll also discuss how you can work around a lot of that instead of switching to Powershell like I did.
This session will be around 70% "why is this hard in SSIS and can you work around it?"  and 30% "Look how cool Powershell is"
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: March 09

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 2

Level: Intermedia

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Loading and managing large data sets in 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 manage your very large data sets, by using layered partitioning. We will walk through partitioned tables and partitioned views, before moving on to the concept of layered partitioning. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Advanced

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Give your queries a multidimensional makeover. 
In this session we'll look at the structure and basics of MDX, the MultiDimensional query eXpression language for querying Analysis Services OLAP cubes. We'll start at the beginning, so you need no previous MDX experience!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will take a look at, and hopefully bust, my list of common myths and misconceptions I see and hear about on a daily basis. 
We will look at areas such as Indexing / SARGability, joins & sub queries, nested views, query plans and a host of other myths. Using lots of a demos and examples attendees will walk away with a better understanding of the best ways to use TSQL and hopefully bust at least one myth or misconception that they have 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

You’ll learn simple tricks to write better code, scripts, and tables. Plus, you’ll gain a deeper understanding of common database development and administration mistakes, and how you can avoid them.

Plus, you’ll learn how to take corrective action when:
•The optimizer isn’t using all available processors 
•The database engine fails to report all the resources a query has used 
•The optimizer uses the wrong plan 
•Database tables cause memory issues 
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Now that Power View users can connect to multidimensional BI Semantic Model (cubes) we will have a look at how to get the best out of this interactive data exploration, visualization and presentation for multidimensional models. 
The session we'll present
- An understanding of the Multidimensional Model Objects in Power View
- How to create a Shared Report Data Source Connection to a Multidimensional Model
- How to create a Power View Report with a Multidimensional Model Data Source
- An visual exploration of a Multidimensional Model by using Power View
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD


PowerShell has evolved (again). PowerShell v3 released earlier this year comes with:
  
•	new cmdlets, 
•	enhancements to familiar cmdlets, 
•	better help system, 
•	workflow, 
•	PowerShell Web Access 
•	+ Lots more 
This is an opportunity for you to see the important new features first hand.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

A DBA running SQL Server 2008 or above will often need to understand if it is worth trading CPU cycles for I/O by enabling row or page compression. The benefits can be significant, but does the cost in core licensing offset the storage capacity saved? Often, comparing the workload before and after compression isn't an option. How then can you make an educated guess about the cost of compressing tables and indexes?  In this session, we will use Grade of the Steel type workloads to quantify the CPU cost of enabling different types of compression. Using CPU profiling, we will try to quantify the cost of this feature.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: March 09

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 2

Level: Intermedia

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Session Details not available
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Injection is still one of the biggest reasons various websites and applications get hacked.
The solution as everyone tells us is simple. Use SQL parameters. But is that enough?
 
In this session we'll look at how would an attacker go about using SQL Injection to gain access to your database, see its schema and data, take over the server, upload files and do various other mischief on your domain.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: March 09

Time: 12:00 AM - 1:00 AM

Room: TBD

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