Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type

Sessions Found: 44
If you dread database deployments and find them to be problematic, come join Steve Jones for a discussion of the issues and challenges in this area. Steve will present a vision of the work Red Gate has done in trying to make database deployments easier and faster.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
7. Admin & Tools

Level: Intermedia

Session Code:

Date: November 16

Time: 12:00 AM - 1:00 AM

Room: TBD

With the standard SQL Server Reporting Services (SSRS) engine, you can quickly and easily deliver basic charts. In real-life reporting, however, requirements are much more complex. You need to follow the techniques for enhanced information delivery by applying methods from Edward Tufte, Stephen Few, or Prof. Rolf Hichert, including ways to visualize by corporate identity or work with spatial information. This session focuses on charts, gauges, and maps and will show you advanced techniques that will help you get the most out of SSRS. We’ll cover tricks and workarounds, tips for building your own charting engine and creating your own maps, and ways to visualize data you never thought possible with Reporting Services. 
Speaker:

Session Type:
Regular Session

Track:
8. Cloud & Big Data

Level: Intermedia

Session Code:

Date: November 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Congratulations on landing your first SQL Server DBA Job.  Do you have a DBA Training Plan?
In this presentation we will follow Alice as she steps into her first days as a new DBA.  We will travel with Alice as she navigates through SQL Server Land following her DBA Training Plan.  We will be watching Alice as she discovers, learns, and actually performs those typical tasks to maintain a SQL Server environment. 
In this presentation Alice will discover the following and more:
•	Monitoring your server
•	Backup / Recovery
•	Managing Databases 
•	Managing and Monitor Resources
•	Installation considerations
•	Managing Security and Auditing
•	SQL Server version management
As Alice travels through SQL Server Land we will be watching Alice as she performs her on the job training exercises.  These demos that Alice will be working through should provide those attending with some examples that will walk us through the actual mechanics of what Alice will need to deal with as SQL Server 
Speaker:

Session Type:
Regular Session

Track:
6. Professional Development

Level: Beginner

Session Code:

Date: November 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Join a panel of Business Intelligence experts from SolidQ and learn the best practices for planning and delivering successful BI solutions.  Join Rushabh Mehta (former PASS President), Brett Tomson and Paul Turley to discuss how to bring BI to your organization, avoid common pitfalls, apply proven design patterns and learn from deployments in companies around the world.  Bring your hard questions and be prepared for an interactive discussion.In this first of two sessions, learn how to wrangle requirements from the business, plan, prototype, & design your solution.
Speaker:

Session Type:
Regular Session

Track:
2. Business Intelligence

Level: Intermedia

Session Code:

Date: November 16

Time: 12:00 AM - 1:00 AM

Room: TBD

In the second of this 2-part Expert Panel discussion, learn to apply best practices in design to build and deliver a successful BI solution in your organization.  BI solution experts and SolidQ Mentors Rushabh Mehta, Brett Tomson and Paul Turley will help you define an end-to-end BI solution including data sourcing & security, data quality controls, ETL, dimensional design, semantic modeling, interactive dashboards, reports and mobile BI delivery.
Speaker:

Session Type:
Regular Session

Track:
2. Business Intelligence

Level: Intermedia

Session Code:

Date: November 16

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:
6. Professional Development

Level: Beginner

Session Code:

Date: November 16

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2005 introduced partial support for window functions. SQL Server 2012 added much more. If you want to see what's available now and which problems you can adress with window functions, then this is for you. You will also learn about new analytical functions in SQL Server 2012 and you will be ready to use window functions in your own solutions after this session.
Speaker:

Session Type:
Regular Session

Track:
4. Design

Level: Beginner

Session Code:

Date: November 16

Time: 12:00 AM - 1:00 AM

Room: TBD

You have been introduced to Common Table Expression, you understand the ;WITH syntax, but you want to know more. Learn how to recursive queries work with CTEs and how to display hierarchical data. Did you know that you can INSERT, UPDATE and DELETE data from CTEs. Some of the common use cases for CTEs will be covered including finding holes in patterns, finding and removing duplicate data, string parsing, and more.  See how CTEs compare to SQL Server 2012 offset and fetch paging techniques. Get an in depth understanding of the performance behind a common table expression. Understand when the CTE is the right solution, and the wrong solution to use. Finally we will take a look at some classic recursive algorithms and how they can be implemented with CTEs. This session pairs well with the Introduction to Common Table Expressions session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
5. T-SQL

Level: Intermedia

Session Code:

Date: November 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you ever wanted to create a recursive query, but didn't see how to do it. With the Common Table Expressions session you will learn everything needed to start using CTE's for recursive queries, as temporary views, and to use the result set multiple times in the same query. Learn how simplify query syntax using CTE's. One of the most overlooked features of SQL Server is the CTE which not only simplifies the query, but gives you the ability to do things that would otherwise be impossible (or at least very challenging) with SQL Server. The class is designed for people who haven’t used CTE’s before, or for those who want to learn the basics of CTEs including data paging. This session pairs well with the Advanced Common Table Expressions ses
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
5. T-SQL

Level: Beginner

Session Code:

Date: November 16

Time: 12:00 AM - 1:00 AM

Room: TBD

The importance of data quality and common problems associated with data quality.
Companies spend considerable time and money making sure financial data is complete and correct, but don't always excercise the same care and processes with their operational data. This session will be centered on practical solutions, with just enough theory to give some context. It will include the following topics: 
- Data Screening: extensible approach to implementing data quality and monitoring it pioneered by Kimball Group.
- MS Data Quality Services: Overview of functionality and working examples and strong points/limitations.
- Combining data screens and DQS.
- Master Data or Data Quality: where to start
Speaker:

Session Type:
Regular Session

Track:
7. Admin & Tools

Level: Intermedia

Session Code:

Date: November 16

Time: 12:00 AM - 1:00 AM

Room: TBD

DAX is the query and programming language for Analysis Services tabular models, yet many users found DAX hard to learn because they couldn't grasp what the "evaluation context" was. This session will turn you into a DAX expert by mastering this core concept of DAX. You will learn what row context and filter context are and how to access them. You will learn functions which modify row and filter contexts. You will learn the initial context of a calculated column expression, a row level security expression, and a measure expression. You will learn how initial context is created from an MDX query. You will learn how to manipulate filter context using the overwrite and intersect semantics. You will see a lot of examples and learn a few DAX tricks along the way.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
2. Business Intelligence

Level: Intermedia

Session Code:

Date: November 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Deadlocks can be very tricky, unpredictable and generally nasty. Is all hope lost? This demo-intensive session will explore several types of deadlocks and give you some insight into how to track them down and prevent them. We wil start with a quick review of locking and blocking concepts, then take a deep-dive into deadlock demos.
Speaker:

Session Type:
Regular Session

Track:
5. T-SQL

Level: Advanced

Session Code:

Date: November 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Application Developers focus on delivering working code, while DBA's focus on Data Quality.  Since developers vastly outnumber us, we must - somehow - persuade them that our objectives are important, too.  This, in turn, requires that we understand the source of the conflict and learn to see the world from multiple points of view.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
9. New Features

Level: Intermedia

Session Code:

Date: November 16

Time: 12:00 AM - 1:00 AM

Room: TBD

New to BI?  Loading data warehouses got you down?  Do Connection Managers, Control Flows, and Data Flows make your head swirl?  Well, don't fret.  In this session, we will peel back the onion that is SQL Server Integration Services and identify the elements necessary to develop efficient, high performance ETL packages that will shock and amaze your friends and coworkers. Expect to cover several real-world scenarios including implementing best practices around disparate data sources, package design and development, logging, troubleshooting, and deployment.  This will be an interactive session based on your input; come with questions!
Speaker:

Session Type:
Regular Session

Track:
7. Admin & Tools

Level: Beginner

Session Code:

Date: November 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Extended Events are used to gather performance information to help troubleshoot issues within SQL Server. The data can further be correlated with the OS and application event data by directing it to the Event Tracing for Windows log file (ETW). DBAs often need to identify the source of issues hindering database performance. This session will explore the data provided in a 2012 System Health event session. Cases studies & live demos will show how to use the various targets to find current performance bottlenecks and historical trends over time.
Speaker:

Session Type:
Regular Session

Track:
7. Admin & Tools

Level: Intermedia

Session Code:

Date: November 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Confronted with the highest IO of any Windows server in our environment one intrepid DBA was able to reduce IO, space consumption, and blocking to new lows.  This is a case study, based upon actual events where the names of the innocent as well as the guilty are changed to protect the DBA.  Topics covered: DMVs, online operations, Filegroups, Page Compression, and disk formatting best practices.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
3. Performance

Level: Intermedia

Session Code:

Date: November 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn how to make your next SQL Server deployment or tech refresh the basis of a consolidated, elastic, self-managed SQL Server utility. This session will help you understand how to build a highly available SQL Server farm to maximize flexibility and agility while avoiding the traps that force you to SQL Server Enterprise Edition.Are you currently dealing with…•	Standards that force the most expensive software stack? •	High licensing and yearly subscription costs associated with vendor lock-in?•	Multiple deployment models that increase project complexity and dependencies while reducing your flexibility and agility? Wouldn’t you like to...•	Reduce the cost of both SQL Server licensing and infrastructure?•	Have a single operational model that solves all deployment requirements?•	Deploy the edition of SQL server that best solves the business problem without being forced to Enterprise Edition?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
7. Admin & Tools

Level: Intermedia

Session Code:

Date: November 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Performance is getting worse in your SQL Server database, and you're not sure why. You'd like to turn on Profiler, but you've heard that it might hurt your performance. In this session, Microsoft Certified Master Kendra Little will show you which tools help you identify what queries are running in your SQL Server, and which queries are hurting your performance the most-- without killing your performance in the process.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
3. Performance

Level: Beginner

Session Code:

Date: November 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn about the hybrid cloud scenarios enabled in SQL Server 2014 CTP2: Learn about Backup to Windows Azure options, Using Azure storage for your data files, and about the new  wizard to deploy a secondary replica to Windows Azure.  This session is for people who want to understand how to leverage Windows Azure to extend their on-premises applications in HA and DR scenarios.  
Speaker:

Session Type:
Regular Session

Track:
8. Cloud & Big Data

Level: Beginner

Session Code:

Date: November 16

Time: 12:00 AM - 1:00 AM

Room: TBD

There are index methods in SQL Server that can enhance the performance of your queries - but most likely, you aren't using them! If you have a solid knowledge of index basics and want to add to your collection, this is the session for you! I'll show you how filtered indexes, compressed indexes, and indexed views work and can improve performance! 
Speaker:

Session Type:
Regular Session

Track:
3. Performance

Level: Intermedia

Session Code:

Date: November 16

Time: 12:00 AM - 1:00 AM

Room: TBD

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