Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type

Sessions Found: 42
With the vast amount of changes that occur in our daily business environments, it becomes more and more difficult to achieve our corporate goals without some ‘lighthouse’ to guide our way. Data mining, (while not a panacea to resolve or ‘control’ the effects of these changes), can provide us with statistical trends by analyzing our data and highlighting probable outcomes.

In this hands on BEGINNERS presentation we shall be looking at Microsoft SQL Server’s Data Mining capabilities and we shall be discussing:

1)  Defining what questions we want answered and how to go about this in an effective and efficient manner.

2)  Creating the data model.

3)  How to gather the necessary data, discussing the training and testing aspect.

4)  Processing the model.

5)  Extracting information from our finished model, discussing the implications of this information.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Application Development

Level: Intermedia

Session Code:

Date: April 18

Time: 1:30 PM - 2:30 PM

Room: Thoreau

In many data warehouses we model fact tables with measures based on attributes which we can count and do arithmetic upon. It is more difficult to handle fact tables with measures based on length of intervals of events happening in the source systems. So questions like "What are the typical waiting times in our order process?" are seldom modelled in the data warehouse. Especially if the event data comes from different source systems. In this talk I will show you how Effektor has overcome this difficult problem using an auto generated data warehouse based on metadata on the objects in the EDW/DM layers. In this approach you can auto generate the process data warehouse if only you have the timestamps present in the EDW layer and are able to correlate them. The talk will consist of slides and demos. Examples is taken from Danish reporting on cancer treatment
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Sponsor Spotlights

Level: Advanced

Session Code:

Date: April 18

Time: 12:00 PM - 1:00 PM

Room: Lexington

This talk will give you an introduction into monitoring SQL Server using Policy Based Management and Central Management System which is provided out of the box with SQL Server. I will then show you how you can combine these features with the Enterprise Policy Management Framework on codeplex to provide monitoring for your whole SQL Server farm. This topic assumes you know nothing about PBM and CMS and will include lots of examples with only a few PowerPoint slides. 
Speaker:

Session Type:
Regular Session

Track:
Database Administration

Level: Intermedia

Session Code:

Date: April 18

Time: 1:30 PM - 2:30 PM

Room: Longfellow

Scorecards allow company executives and management teams monitor their progress against key metrics. These metrics could be financial, customer, internal business operations etc. In this session, I will show you to utilize SSRS to develop balanced scorecards.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: April 18

Time: 4:00 PM - 5:00 PM

Room: Hawthorne

How are your servers running? What is going on in your SQL Server? How are you trending? When will you need the next server? Do you need to throw more hardware at SQL or more query tuning? (Or both?) In this session – we will share some free tools, techniques and approaches you can take right now with resources you already have to answer these questions and more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Database Administration

Level: Beginner

Session Code:

Date: April 18

Time: 1:30 PM - 2:30 PM

Room: Bunker Hill

Being a DBA is tough job--there are on call situations to deal with, and managing a large amount of servers with less resources is a constant challenge in corporate environments. In this session you will learn techniques to reduce the amount of manual effort in your job, and keep you three steps ahead of your users. Learn techniques such as:
	• Fully Automating SQL Server Installations
	• Dynamically Adding Databases to an Availability Group
	• Syncing jobs and logins between Availability Group members
	• Patching SQL Servers automatically
	• Other techniques for process automation
This session will benefit both new and Senior DBAs, as well as anyone who wants to automate themselves into a promotion.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Database Administration

Level: Beginner

Session Code:

Date: April 18

Time: 2:45 PM - 3:45 PM

Room: Hawthorne

Clustered implementations of SQL Server instances (FCIs) have traditionally used some sort of attached, or shared storage. However, sometimes that is not the best way to deploy an FCI, especially if you are looking to deploy in the cloud-be it Windows Azure or Amazon EC2. Sometimes you may even want a cost-effective disaster recovery solution without the need for SAN replication. Come hear Microsoft Cluster MVP Allan Hirt discuss your storage options to not only create a #SANLess cluster, but also to increase the availability of your SQL Server instances using SSD and flash-based PCIe storage or the cloud.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Sponsor Spotlights

Level: Beginner

Session Code:

Date: April 18

Time: 12:30 PM - 1:30 PM

Room: Lexington

Let's cut to brass tax.  What is the quickest way to create a central performance health repository, where we can continuously collect, upload, store, monitor and report on SQL Server Health of multiple instances?  If you are using SQL 2008 and higher, the short answer is MDW, otherwise known as a management data warehouse.  MDW is a native feature available in SQL Server, "out of the box" - why not use it? In this session, we will take you through the setup, from the wizard and beyond. To creating, configuring, and deploying the MDW in a jiffy, as well as creating custom collections to capture your own desired performance metadata. We'll discuss baselines, trends, and understanding the data. We'll show you the reports as well, and how to expand upon MDW.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Database Administration

Level: Beginner

Session Code:

Date: April 18

Time: 1:30 PM - 2:30 PM

Room: Bunker Hill

A database by its very nature is one of the most resource intensive applications you will ever virtualize. This is even more difficult to do correctly in the context of a virtualized infrastructure that is a shared resource environment. We will look at every possible dynamic to virtualizing a database from Design, Storage, Memory and Network considerations. This presentation is based upon material given at VMworld from a presentation that was in the top 10 out of all presentation given. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Database Administration

Level: Intermedia

Session Code:

Date: April 18

Time: 4:00 PM - 5:00 PM

Room: Thoreau

John knows everything and goes out of his way to correct you at every turn.  Mary is agreeable to a fault and just placates everyone.  Mike is full of doom and gloom and whines constantly. Are these your co-workers? Relatives? Frenemies? You? Learn two golden rules to reduce the stress produced by the difficult people in your life.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Professional Development

Level: Beginner

Session Code:

Date: April 18

Time: 4:00 PM - 5:00 PM

Room: Bunker Hill

We will import AdventureWorks2014 into an SSDT project.  We will discuss customization possible with SSDT (templates and snippets) to produce artifacts that conform to your standards. We'll also look at limits of localdb and strategies to deal with them.  Finally – we’ll look at Enterprise deployment strategies with DACFx.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Application Development

Level: Intermedia

Session Code:

Date: April 18

Time: 2:45 PM - 3:45 PM

Room: Lexington

Most DBA's rarely establish Service Level Agreements (SLA) with the Management and if they do they sometimes just come up with some random numbers for availability. Then when at some point something goes really wrong everybody wonders why it takes so long to bring everything back online.
 
This Session will teach you how to ask the right questions, analyze your databases and servers and generate from the gathered data a realistic SLA.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Non Technical

Level: Intermedia

Session Code:

Date: April 18

Time: 11:00 AM - 12:00 PM

Room: Bunker Hill

Explore some of the mistakes and misconceptions DBAs tend to have about SSIS.  Also look at the performance and scalability of ETL vs ELT with real world examples and sample code.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Integration and SSIS

Level: Advanced

Session Code:

Date: April 18

Time: 11:00 AM - 12:00 PM

Room: Thoreau

There’s just so much to do to get your systems to run in an optimal fashion, but where do you start. This session will walk you through an extensive checklist of things you can do to better manage your servers, databases and code. We’ll start with server configurations and what you can do with them. We’ll then move through standard administrative tasks that will help with performance. Then it’s off to the intricacies of database design and how that can affect performance. We’ll finish up with T-SQL and where it can hurt or help your systems. All examples in the session will use readily available tools that are a standard part of SQL Server. Get your own systems to run faster with the information you’ll receive.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Performance Tuning

Level: Intermedia

Session Code:

Date: April 18

Time: 4:00 PM - 5:00 PM

Room: Longfellow

This session focuses on Microsoft’s BI technologies and its abilities to make advanced easy to use, accessible, insightful, and actionable decisions, all while helping clients increase organizational performance. With the recent release of SQL Server, Microsoft dramatically enhanced the Microsoft BI platform. During this session Plus Consulting, one of Microsoft's top global BI partners, will explore the improvements to SQL Server self-service reporting and talk about creating blended value from your BI platform. We’ll show you why the combination of Microsoft Office 2013, SharePoint Server 2013 and SQL Server 2014 are an excellent solution for creating self-service dashboards, scorecards, KPIs, pivots, data exploration and discovery, collaborative.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Sponsor Spotlights

Level: Intermedia

Session Code:

Date: April 18

Time: 12:30 PM - 1:30 PM

Room: Bunker Hill

Are you someone (A DBA, Developer, etc) that connects to SQL Server to use data?
You probably hear a lot about how protected your database can be when at rest. But what about when you connect to SQL and start running some queries?
Using a simple hacking technique we will dig into some packets on our network and see what's in them. You may be shocked! Then we will create a self-signed SSL certificate, use it to encrypt our connections on the SQL Server,  and see the actual changes in the packet as hackers would.
*Warning - do not try some of these demos at work without proper permissions as hacking techniques are used. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Database Administration

Level: Intermedia

Session Code:

Date: April 18

Time: 11:00 AM - 12:00 PM

Room: Concord

Integration Services 2012 offers a brand new way to store, log, and execute SSIS packages – the SSIS Catalog. How does the Catalog work? Can it be customized? Can it be extended? Yes it can! In this presentation, Andy Leonard shows you how!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Integration and SSIS

Level: Beginner

Session Code:

Date: April 18

Time: 9:45 AM - 10:45 AM

Room: Thoreau

Thinking about making a move to the Azure cloud? This session will give a basic overview of the Azure IaaS service before doing a deep dive into explaining exactly what it takes to make sure your SQL Server deployments in the cloud are highly available.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Database Administration

Level: Intermedia

Session Code:

Date: April 18

Time: 2:45 PM - 3:45 PM

Room: Thoreau

You’ve read some of the content of well-known Data Warehousing books – now what?  How do you take the structures and disciplines inside such books as the Ralph Kimball series and implement them?  This session will take several of the key concepts in Data Warehousing and demonstrate some implementations using SQL Server Integration Services and Analysis Services.  We’ll look at items such as Type 2 Changing Dimensions, Confirmed Dimensions, Dimension Outriggers, Role-Playing Relationships, Many-to-Many Bridge table relationships, Factless Fact tables, Handling of NULL foreign key values, and more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: April 18

Time: 1:30 PM - 2:30 PM

Room: Concord

Is the list of servers you manage growing and growing? Are you starting to wonder if there is a more efficient way to manage your SQL Server instances than T-SQL and SSMS? In this session we will give you an introduction to PowerShell with a focus on SQL Server. In this session, we will cover the basics towards configuring and using PowerShell. We will also cover the basic syntax of PowerShell that will help you get started in the right direction. Finally, we will conclude the session with some examples that could make your SQL Admin life a lot easier.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Database Administration

Level: Beginner

Session Code:

Date: April 18

Time: 9:45 AM - 10:45 AM

Room: Hawthorne

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