Build Schedule

Advanced Filters:
  • Track

    clear all












  • Speaker


  • Level


  • Session Type

Sessions Found: 54
Does your data sit around mocking your best attempts to support good data practices?  Databases are also bound by the GIGO rule: Garbage In is Garbage Out.  In this presentation, Karen shows you examples of the types of mistakes, misunderstandings and outright cheats that lead to poor data quality, mistrust in IT systems and overall smelliness in our IT solutions.  Using real-life evidence of her own data in your systems.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Dev / Design

Level: Beginner

Session Code:

Date: September 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Join Thomas LaRock and Karen Lopez for valuable interviewing tips from both sides of the desk. Based on Tom's blog posts of 10 Things I Hate About Interviewing You and 10 Things I Hate About Interviewing With You, this session will be packed with valuable insight and tips to help you sail through your next job interview
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Dev / Design

Level: Intermedia

Session Code:

Date: September 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Does this sound like you? You were just given access to SSRS and you want to make a report. Or, you're a DBA and could use a daily report. Either way, I've got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed. We’ll even look at the differences between building a report in BIDS (Business Intelligence Development Studio) and Report Builder 3.0. We’ll use SSRS (SQL Server Reporting Services) 2012. The query makes no difference, this time it's all about the output. 
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: September 21

Time: 12:00 AM - 1:00 AM

Room: TBD

In this talk Lynn will share her real-world experience deploying solutions to the AWS cloud.  She will focus on data solutions such as EC2 w/SQL Server, RDS w/SQL Server and more.  Her talk will include coverage of NoSQL offerings such as Glacier, S3 and DynamoDB.  She will also cover the RedShift  and the new Data Pipeline service.  Attend this talk to learn which services to use and tips for usage in the real world.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: September 21

Time: 12:00 AM - 1:00 AM

Room: TBD

The easiest part of any deployment is running the deployment script on production. But what have you done to prepare that script for production? Was the script tested? Is the script tightly coupled with the application code? 

The difference between a successful deployment and a failed or problematic deployment is all the preparation work you’ve done to ensure that you’re deploying the right script, the right way to your production environment. This session will explore best practices that you can implement within your environment   to ensure that your deployments are as successful as they can be.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: September 21

Time: 12:00 AM - 1:00 AM

Room: TBD

For decades humans have been collecting data in ever increasing formats and exponentially increasing volumes. Data collection tools have historically outnumbered data analytics tools, hence leading to a huge backlog of raw data waiting to be analyzed. This backlog has increased dramatically in recent years with the explosion of social media and the advent of a plethora of Internet connected devices. The challenge in clearing the backlog was exacerbated by requirements imposed by various analytics technologies to get data into common formats that would then be pumped into standardized data models.  The big data revolution challenges this approach by tapping into various, high velocity and large volume sources to identify correlations and patterns that we could only dream of identifying using traditional analytic technologies. In this presentation I will discuss the history of big data tools and will briefly discuss Microsoft HDInsight,an Apache Hadoop compatible Big Data implementation.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: September 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
Speaker:

Session Type:
Regular Session

Track:
Other

Level: Beginner

Session Code:

Date: September 21

Time: 12:00 AM - 1:00 AM

Room: TBD

We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance.  I have given this talk over FORTY times now and it is always very highly rated!
Speaker:

Session Type:
Regular Session

Track:
Dev / Design

Level: Intermedia

Session Code:

Date: September 21

Time: 12:00 AM - 1:00 AM

Room: TBD

This is an expanded and updated version of the session I presented at the SQL Rally in Orlando. We will cover Tactical Data Governance and in detail specific code examples, using Stock and Custom SSIS Transforms ,Data Models, SSAS Cubes used to create and populate a Metadata Mart as defined by Michael Belcher(Gartner). We  will demonstrate incorporating complete custom Data Profiling capabilities (SSIS Transform Scripting, TSQL) capable of Profiling any Source and Targeting any destination. In addition we will implement Data Quality(Address Correction, Fuzzy Matching) and Visualization via PowerPivot , Excel and QlikView. Last will will demonstrate code generation.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: September 21

Time: 12:00 AM - 1:00 AM

Room: TBD

SharePoint makes it easy for users to create their own dashboards but there's more to dashboards than just fast and easy set-up. This session will explore not only the characteristics of an effective BI dashboard using SharePoint 2013, but also the design flaws to avoid. Attend this session and learn how to perform a dashboard makeover. Starting with a review of a dashboard that uses technology correctly but not as effectively as it could, you’ll explore common problems found in dashboards, learn the characteristics of good dashboard design and discover how to implement a dashboard that communicates information clearly and concisely. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: September 21

Time: 12:00 AM - 1:00 AM

Room: TBD

The presenter will consider different architectures to move data across environments during the software development life-cycle. Whether you start from scratch working with XP, or you have to establish processes in already existing organization working in waterfall, whether the data to move is 1 MB or terabytes, the presenter will present ways to handle the tasks and outline the cons and pros of each approach
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Dev / Design

Level: Intermedia

Session Code:

Date: September 21

Time: 12:00 AM - 1:00 AM

Room: TBD

As a Data Warehouse / ETL developer who sometimes waits weeks or months without capturing or loading any source data while a new data warehouse / mart target model is being defined, would you instead like to be able get ahead of the curve by – quickly and mostly automatically – designing and even loading a robust and fully history-tracking DW / staging repository?  Or, have the recent requests from sponsors – requests that your DW reporting / analytics solution also supply data for upcoming Master Data Management needs – got you a little nervous about your data transformations?  If either of these scenarios resonate, you will appreciate Data Vault, an emerging DW design and architecture.  Leaving this session, you will be familiar with Data Vault’s simple design fundamentals, appreciate its potential for task automation, and understand where and when it fits your needs.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: September 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Great database performance starts with great database design. During the database design process it is important to select your datatypes wisely. The wrong choices will often lead to wasted space, increased response times, and less stability. Additionally you run the risk of having your design not scale as well as it should. Leave this session armed with the knowledge you need to help your databases perform at their peak efficiency. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Performance

Level: Intermedia

Session Code:

Date: September 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Each of our database systems has its complexities, its idiosyncrasies, its touchy points. Digging into each of these, understanding them, baselining them and monitoring them is an essential part of a DBA's job. Doing these simple tasks in such a way that allows you to sleep at night while your systems churn away safely and gracefully is an art that we all attempt to accomplish.
We will discuss various ideas, tools, approaches, and solutions to how to monitor different pieces of our systems. Examples, code, tools, will all be shown off and shared so we can all do better. 
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: September 21

Time: 12:00 AM - 1:00 AM

Room: TBD

This session focuses on error handling in SQL Server Integration Services 2012.  Different techniques and strategies will be introduced for error handling in control flow, data flow, and script tasks as well as how to dynamically handle errors.  
Speaker:

Session Type:
Regular Session

Track:
Dev / Design

Level: Advanced

Session Code:

Date: September 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Query optimizers are highly complex pieces of software, which even after 40 years of research, still face several technical challenges in some fundamental areas. As a result, there may be cases when even after you've provided the query optimizer with all the information it needs, you still don’t get an efficient execution plan for your queries. This session will show you the current challenges and limitations of query optimizers in general and the SQL Server query optimizer in particular, along with solutions or workarounds to avoid each of these problems.
Speaker:

Session Type:
Regular Session

Track:
Performance

Level: Advanced

Session Code:

Date: September 21

Time: 12:00 AM - 1:00 AM

Room: TBD

This is a lecture and demonstration on how to deploy highly available SQL Server instances in the Amazon EC2 cloud presented by Microsoft Cluster MVP David Bermingham.  Starting with preparing the EC2 environment including configuring  the VPC, routing and security, Bermingham then continues on and shows you how to configure both AlwaysOn Availability Groups as well as AlwaysOn Failover Clusters for cross availability zone failover.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: September 21

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will focus on patterns and practices that are successful in designing Data Warehouse and Business Intelligence solutions. Designing an analytic database is different from designing a transactional database. This presentation will provide thorough coverage into the foundation of analytic database design: Facts and Dimensions. We'll also discuss the Star and Snowflake schema, dimension hierarchies, multiple calendar dimensions and how all of this fits with the query and reporting tools used to actually present information.   
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: September 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Quick overview of the SQL# CLR library where we'll examine a few implementations of some of the functions that I've found useful. Some examples will include string manipulation, file handling, as well as some RegEx usage. There are over 225 procedures and functions, user defined aggregates, and user defined types ... and counting. Come explore some of the interesting problems that SQL# can solve. If you'd like to download and view the CLR library ahead of the presentation, you can get most of the CLR features for free at www.sqlsharp.com.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Dev / Design

Level: Intermedia

Session Code:

Date: September 21

Time: 12:00 AM - 1:00 AM

Room: TBD

This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.
Speaker:

Session Type:
Regular Session

Track:
Performance

Level: Advanced

Session Code:

Date: September 21

Time: 12:00 AM - 1:00 AM

Room: TBD

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