Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 30
Fuzzy Matching, Similarity Matching or Record Linkage is the most critical and least understood process in any Data Warehouse, BI, Integration, Big Data , Data Quality, MDM , Social Network or integrating crap effort. Over at LinkedIn there is Group run by Henrik Liliendahl Sorensen for Data Matching, Bill Winkler, principal researcher at the US Census" has written a series of white papers on record linkage and particular a technique called "Blocking Indexs". In addition we wil cover William Cohen Research Professor, Machine Learning Department, Carnegie Mellon University white papers an implementations. Presented will be our collection of "real world" examples(Code) and you will leave a master of record linkage and the concepts behind it
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Intermedia

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

In this presentation Aaron will cover how to collect data from multiple SQL Servers using SQL Server 2008 Integration Services (SSIS). Then he will use SQL Server Reporting Services (SSRS) to report detail on that data. After that he will use SQL Server Analysis Services (SSAS) to create a KPI. Finally he’ll present that KPI on a dashboard via a web page. The goal of this presentation is to show how seamless the Microsoft Business Intelligence products are. If you’ve only used a few of these products, you’ll appreciate seeing them together all at once. Code will be provided.
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Ted Krueger will join Hope in presenting this session. Consulting is a mystical career path that is often questioned: should I do it, can I do it and why should I do it? Come join us on a discussion of the Pros and Cons to consulting with an emphasis on SQL Server and Microsoft Technologies. We'll field questions with real world experiences. Once you leave this open floor session, you'll be able to make better choices in your own professional development and how consulting may or may not effect it.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Imagine an environment where moving a database from a SQL Instance to another is as simple as just restoring the database. (Yes, no other steps!) SQL Server 2012 RC0 now supports Partial Contained databases.  We will cover the different levels of containment, configuring SQL Server to support it, and much more (i.e. Demos).
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Every organization that stores data stores dirty data, and suffers with how best to handle this unpleasant fact.Organizations must rely on people to deal with data problemseither by paying them to clean it or paying them to work around it. Either way it is costly and only becomes more so over time. Finally with the release of SQL Server 2012, there is a tool to help. Learn how to use the key parts of Data Quality Services: how to create a Knowledge Base, how to create Data Cleansing Projects to cleanse data both in the DQS client and inside SSIS 2012, and how DQS Matching Projects can integrate with Master Data Services for de-duplication of data. Session focuses on DQS, but also explains how DQS, MDS, and SSIS work together.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Sometimes, bad things happen in a server, and someone has to investigate. What kinds of tools are out there for Database Adminstrators, and what are some common methods that we can use to explore what has happened the "aftermath" of something going wrong? This session will explore some methods, tools, and examples that I've used as the database administrator to uncover and analyze "what went wrong".
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

SSRS 2012 provides a brand new feature called data alerts. It allows users to monitor changes in report data and send data alert messages by email when report data follow rules that define data of interest to you. This session introduces this great new feature and will show real world scenarios for its application.
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, attendees will be treated to an introduction to tabular mode.  Installation, configuraiton, development tips, maintance, and end user reporting options will all be introduced.  A description of BISM and what it means for our beloved Multi-Dimension cubes will be discussed.  Attendees wanting to know when to use tabular, and when to stick with multi-dimensional will want to attend this introductory session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Windows Server 2008 introduced Server Core, the operating system without the Graphical User Interface. SQL Server 2012 is the first version of SQL Server to support Server Core. To gain the maximum efficiency from your servers you want to make use of Server Core and with PowerShell you can effectively manage SQL Server in that environment. This session will demonstrate how to manage SQL Server 2012 on Windows Server Core and provide scripts to help you perform the common tasks you need to perform on that platform.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Advanced

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Optimal configuration and maintenance of the I/O subsystem is critical and can ultimately be responsible for higher response times of your applications. The HDDs are by design about 1 million times slower than the memory or CPU. In this session we analyze the different options that exist for durable storage, what are their pros and cons . Solid state drives are a viable option and we are going under the covers to see how you can best use them as an alternative to a large and expensive SAN in your infrastructure
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

A Dynamic Dialog session: Whether you’re considering implementing business intelligence for the first time, have completed projects in the past (and are perhaps looking at later phases), or are somewhere in between, an investment in this session will likely pay dividends. Business Intelligence Architect and Microsoft MVP Bill Pearson leads a dialog about common pitfalls or traps that we can encounter in designing and implementing BI. We’ll discuss, as a group, environmental and other challenges we have experienced, and share ways to avoid or minimize them, in our ongoing efforts with BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

What exactly does it mean to parallelize a query? Why would the optimizer do this and what are the benefits and what are the drawbacks?? Is it always faster? Can it cause problems? Are there reasons we might NOT want parallelization? What can prevent it's use by the engine? These are some of the topics we will cover as we dig into this facet of the SQL Server relational engine.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Advanced

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Parameter Sniffing is usually thought of as the bad guy, in association with a performance problem in your database. Contrary to the popular belief, Parameter Sniffing is usually the good guy, continuously working under the hood to help your database applications run faster. However, it can sometimes go wrong, causing severe performance degradation of your queries. 
In this session we will discuss the workings of Parameter Sniffing and demonstrate how it helps improve the performance of your database applications. We will also explore how Parameter Sniffing can go wrong and its impact. Several ways to fix bad Parameter Sniffing will be demonstrated to help make an appropriate choice for your scenario.
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Intermedia

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Perfomance is a concern for every dba.   How do you baseline performance?  What do you do when users complain about performance?   What tools can you use to gather data and how do you analyze that data?   We will start a basic performance troubleshooting methodology and move into more specifics of what data to collect and how to use that data to isolate a performance problem.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Many DBA's and sysadmins are starting to use PowerShell to automate routine/daily tasks.  A task that can be time consuming to setup on each server is performance monitoring with Perfmon.  A great way to automate that task is to use PowerShell.  So, let's take a venture into PowerShell land and see how to write our very first script.  Along the way we will capture performance counters and then export them to a blg formatted file for viewing.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Powershell has become a very popular scripting language for Windows, Exchange, Sharepoint and other admins. In this session, we'll get our heads down and our inner geek on as we explore how Powershell can add value to our lives a DBAs. We'll explore how Powershell can handle common tasks as well as several tasks that are difficult or even impossible with TSQL. We'll wrap up by discussing how Powershell could be used to fully automate your install and post-install processes, standardizing your environment. Get your typing skills honed as you will leave here desiring to never click again.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Want to invest in your long term career success? You need to network. C’mon give it a try! It’s not that bad! This presentation will explain some in-person networking tips and some do’s and don’ts for networking on LinkedIn. Takeaways include: -How to find events -Tips on getting to most out of attending events -How to develop and maintain your network of contacts -A Review of Linkedin networking best practices and profile optimization strategies.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

With an ever increasing workload, security is often hoisted upon the DBA. So where do you start? Sometimes it's better to start off by understanding what an attacker could do to you in order to get a clearer picture of what you need to do to prevent it. In this session, we will delve into the key features of the SQL Server and explain what the various attack vectors are, what an attack can do with them,  and what you can do about them. We'll also look at important features such as SQL Audit that, while not helping to prevent, can definitely help you in definitely help in figuring out what is going on. It'll be AWESOME!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Issue a "SELECT {data} FROM {myTable}" statement and users need to trust the data returned is accurate. What happens when multiple processes access the same data? What happens further if one of those process is an UPDATE or even a DELETE statement? How about if both processes will be updating that data? Understanding Isolation in SQL Server is paramount in ensuring data integrity in your system. We will cover the different levels of isolation and how they impact what a user views when accessing the data at a given point-in-time.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

See those things around your ankles? You hope they're your socks because no DBA wants to be caught with their pants down.

Whether you're an accidental DBA, a DBA who has just inherited a bunch of servers, or someone who works in a shop that won't buy monitoring tools, this session will help you get basic monitoring in place to make sure you know what's going on in your environment.

You'll learn how to implement seven simple scripts that perk their ears up and start barking like a dog after a stranger walks in the house. They are the canary in your coal mine. You'll know when backups fail, when they run longer than usual, when data files are getting full, when transaction logs have excessive VLFs, and more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

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