Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type

Sessions Found: 32
In this session Dmitri talks about locking in Microsoft SQL Server. He covers various lock types that exist in the product and explains how transaction isolation levels affect locking behavior. Dmitri also discusses why we have blocking in the systems and how to troubleshoot blocking problems and deadlocks.

This is PowerPoint-free session. Only Management Studio, T-SQL Code and bag of candies are in use. 
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will show you 10 tricks from the easy to the difficult.  We'll have a new tip every six minutes and every tip will have a demo.  Some of the tips you might know, some you might not.  Come with your own tips and share with the rest of us.  Let's make a memorable session filled with things we can immediately use in our reporting lives!
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

The term "big data" dominates the headlines in technology news these days, but what is the fuss really all about? What are the implications for traditional data warehousing and reporting? What kind of technology and skill sets do you need to successfully implement to a big data strategy? Come to this session for a gentle, business-focused introduction to big data and leave with some inspiration and practical steps for tackling your first big data project.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you struggling with performance issues and your current tools are not providing answers? Confio’s flagship product, Ignite, may be your answer. This presentation outlines a method for determining the best approach for tuning SQL statements by utilizing response time analysis. Janis will use real-life case studies to demonstrate the techniques.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: April 20

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 new RedShift service.  Attend this talk to learn which services to use and tips for usage in the real world.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

When a developer goes it alone and works on their own feature of a product, there is always a chance that the feature will never be folded back into the main product, thus never released, effectively wasting that developer’s time.  Continuous Integration means every time a developer writes code, that code is folded back into the main project and tested with all the other code. Continuous Integration means no developer is left behind.  Come to this session to learn how you can make sure all the code your developers have written is used, is effective, and works with all the other code being written. Come learn how to deploy software faster, with higher quality, and with fewer database problems!
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: April 20

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:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

Support of the large databases is not a trivial task. Large amount of data negatively impacts system performance and make administration and SLA compliance much more complicated. Data partitioning can help to solve those problems and reduce support and hardware cost. This session demonstrates various approaches of data partitioning available in SQL Server. It compares pros and cons of different partitioning techniques from performance, scalability and administration standpoints. The session also discusses how to reduce hardware cost by implementing tiered storage and demonstrates how to move data between filegroups and/or disk arrays keeping the system online in the different versions and editions of SQL Server. 
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Advanced

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn about Microsoft’s Data Quality Services (DQS), what it is and how it works. You will discover how DQS sets itself apart from conventional data cleansing routines and go through examples on how to begin your own Data Quality Project. What really makes DQS unique and powerful is its ability to access shared knowledge, so we will show you how to access and use this shared knowledge to your benefit.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

Data vault is a compelling architecture for an enterprise data warehouse using SQL Server 2012. A well designed data vault data warehouse facilitates fast, efficient and maintainable data integration across business systems.  In this session I will review the basics about enterprise data warehouse design, introduce you to the data vault architecture and discuss how you can leverage new features of SQL Server 2012 help make your data warehouse solution provide maximum value to your users.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: April 20

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:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will provide a deeper dive into the art of dimensional
modeling. We will look at the different types of fact tables and
dimension tables, how and when to use them. We will also some
approaches to creating rich hierarchies that make reporting a snap.
This session promises to be very interactive and engaging, bring your
toughest Dimensional Modeling quandaries.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: April 20

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:
Track 1

Level: Advanced

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2005 introduced Dynamic Management Views (DMVs) that allow you to see exactly what is happening inside your SQL Server instances and databases with much more detail than ever before. SQL Server 2008 R2 adds even more capability in this area. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session (which is applicable to SQL Server 2005 through 2012), presents and explains over fifty DMV queries that you can quickly and easily use to detect and diagnose performance issues in your environment.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

Tabular models in SQL Server 2012 give us a powerful analytic engine that is faster and easier to implement than traditional multi-dimensional cubes using Analysis Services. In this session, you'll see how to develop analytic models using your existing data sources and learn best practices for preparing data so that it can be effectively used as a Tabular database. In addition to creating the model, you'll see how to quickly add measures, hierarchies, and calculated columns to provide a rich user experience and how the model works with Excel, SSRS and other reporting tools.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server Extended Events can be used to gather a wide range of performance information, and in troubleshooting in SQL Server.  Extended Events use less system resources and provide better information than SQL Profiler and they allow for correlation of SQL Server event data along side of OS or Application event data. This presentation will explore what Extended Events are, how to set them up and use them in several case studies.

Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

It is expected that business reports be insightful and engaging. Region based reporting can be transformed from boring grids to visually interactive maps. This session will describe how to embark upon self-service and mobile BI solutions that are available within the Microsoft BI stack for analytical geospatial reporting. You will learn the basics of geographical data, including GIS, Longitude-Latitude coordinates and free form text. Using these different data types, we will discuss SSRS 2012, Power View and Excel 2013 tools that can leverage insightful analysis. Finally and most importantly, attending this talk will get you started in learning the essential techniques to deliver geospatial reports that tell meaningful stories for users.
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Don't let this happen to you! This session covers current and upcoming hardware from both Intel and AMD.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

Business in the front. Party in the Back. The Mullet strikes a nice balance between "Classy" & "Outlaw".  By applying this model to BI, we'll uncover ways to deliver solutions faster & more efficiently through Lean practices. This session is for anyone who needs to satisfy demanding customers that aren't quite sure what they want, but they need it NOW or they'll lose that critical deal & the world will end!  We'll focus on sequencing deliverables and using PowerPivot prototypes that can be promoted to an AS Tabular model if/when needed.  This process aims to minimize rework while striking a balance between delivering value fast with initial "Cowboy" efforts, and incrementally building a responsible, scalable, maintainable architecture. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

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