Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type

Sessions Found: 45
Starting with the 2005 release, SQL Server captures information about the workload on an instance, which you can use to monitor the system, gather performance metrics, and validate system settings.  This information is available via Dynamic Management View and functions and officially they "return internal, implementation-specific state data." This session gives an introduction to these concepts, how they make DBA life much sweeter and we discuss many of the different community queries available to help you get jump started in your environment.  We also open up the floor for ideas of how you are using these views/functions.
Speaker:

Session Type:
Regular Session

Track:
Performance/Internals

Level: Beginner

Session Code:

Date: September 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Releasing changes can feel like the most stressful part of managing databases. Whether we're in a development shop reviewing changes from several unique development instances, a healthcare shop walking a series of changes through an extreme change management process, or the only DBA pushing manual changes into production, hitting that final button is stressful.

In this session, we'll build a deployment pipeline that will reduce the stress and risks we're used to from manual deployments while providing a framework for cleaner change tracking and management, shorter release windows, and the ability to keep numerous environments in sync with the latest available changes without constant restores. While the primary focus will be an end-to-end demo, we'll also discuss the business value of deployment pipelines, how they reduce risk and enable us to move faster, and alternatives to the set of tools used in the demo.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: September 06

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, we will discuss and demonstrate backup and recovery of your on-premises SQL Server databases to and from Windows Azure, a key Hybrid Cloud capability of SQL Server 2014.  We will discuss key feature concepts such as the enhanced Backup UI, Restore UI, encrypted backups, SQL Server backup to URL, and the SQL Server Backup to Windows Azure Tool. We will also discuss the scenarios for integration of this technology.
Speaker:

Session Type:
Regular Session

Track:
Cloud/Big Data

Level: Intermedia

Session Code:

Date: September 06

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, 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:
BI

Level: Intermedia

Session Code:

Date: September 06

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:
BI

Level: Intermedia

Session Code:

Date: September 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Problem with Windows server, IO storage or SQL Server stopped your business dead in its tracks?  Together we'll explore "check engine lights" for your SQL Server warning you of pending doom.  I'll cover Performance Monitor, IO STACK, Dashboards, ErrorLogs, and DMVs to keep your server and SQL Server running smooth.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Performance/Internals

Level: Intermedia

Session Code:

Date: September 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Cloud, Cloud, Cloud.  Microsoft is "all in". CxOs love the idea of renting compute resources.  You know this is where our profession is headed, but when and how fast.  When should you jump on board?  The good news is cloud will not eliminate or even reduce the need for IT and Data professionals.  The bad news is our world and our profession is changing.  Come see what Microsoft Azure has to offer Data Professionals.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Cloud/Big Data

Level: Intermedia

Session Code:

Date: September 06

Time: 12:00 AM - 1:00 AM

Room: TBD

For those of you that don’t have a full time DBA on staff, this session is built around you. I will give you the skills and tools necessary to successfully manage Microsoft SQL Server. Automation is the key to any monitoring effort and SQL Server is no different. I will show you publicly available tools and scripts to alert you when key areas of SQL Server are being stressed. Proactively monitoring SQL Server will make you more efficient and allow you to continue your success within your role.
Speaker:

Session Type:
Regular Session

Track:
Professional Development

Level: Beginner

Session Code:

Date: September 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Throughout my career, I've seen developers do some pretty crazy things to databases (and truth be told, I've done some of these myself!). Come to this session to learn what we do (from opening up the database to SQL Injection attacks, how SQL can use Referential Integrity to optimze queries, and the pitfalls of using NOLOCK), why it's bad to the database server (or your career)... and alternatives that can be used instead. Trust me... your DBA will love you for making these changes.
Speaker:

Session Type:
Regular Session

Track:
T-SQL/Dev

Level: Intermedia

Session Code:

Date: September 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Sometimes you really need to see what your SQL Server is truly capable of doing. You need to find the bottlenecks on performance that could prevent you from adding additional workloads, more users or more databases, whether you are in a virtual or physical environment and regardless of your SQL Server version. But first you have to know what is happening under the hood right now. In this session we will look at how to load test SQL Server while monitoring the important performance metrics and then extrapolate from that data what would happen if you added more users.  We might even cover how to automate this process for other servers. We will also dive into PowerView and SSRS to see how they compare on delivering appealing visualizations of the collected data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: September 06

Time: 12:00 AM - 1:00 AM

Room: TBD

F# is the functional language that ships with Visual Studio.  It is a great language that combines the power of functional programming with the benefits of being a 1st class citizen in the .NET stack.  One feature unique to F# is type providers.  Type providers are constructs to allow you to dynamically connect and consume data sources ranging from Sql Server to Json to Hadoop to MongoDb and everything in between.  Type providers are particularly useful analyzing very large datasets where it is impossible to code-gen the schema.  They are also very useful for developers who want to write fewer bugs. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
T-SQL/Dev

Level: Beginner

Session Code:

Date: September 06

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will discuss and demonstrate the cloud integration capabilities of SQL Server 2014, the Windows Azure Platform, and scenarios for leveraging hybrid cloud infrastructure. We will discuss and demonstrate deploying SQL Server 2014 running on a Windows Azure Virtual Machine and also discuss and demonstrate the Windows Azure SQL Database.  We will also discuss best practices and demonstrate techniques for managing both on-premises and cloud-based resources.
Speaker:

Session Type:
Regular Session

Track:
Cloud/Big Data

Level: Intermedia

Session Code:

Date: September 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Most of the time you’ll see ETL being done with a tool such as SSIS, but what if you need near-realtime reporting? This session will walk through the basic transformations to build a Kimbal-style data warehouse from an OLTP database and demonstrate how to keep your data warehouse updated using Service Broker messages from your OLTP database.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: September 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you just breaking into the query tuning side of managing your SQL Servers?  In this session, we will cover the basics you need to start leveraging execution plans as part of your tuning process.  We will discuss how SQL Server creates and uses plans, and how to collect them.  Once we have the plans, we will go step-by-step through how to read them, and what the most common operators mean.  We will look at the different types of operators not just from a standpoint of what they do, but how they can impact query performance.  We will also cover how good database design and maintenance allow you to get better execution plans through having the right indexes and up-to-date statistics.

Speaker:

Session Type:
Regular Session

Track:
Introductory Topics

Level: Beginner

Session Code:

Date: September 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Both DBA’s and Developers should be acutely aware of what it takes to ensure that every call to SQL Server has the best chance of reusing a previously generated query plan. Having to generate a new plan each time will waste precious resources and ultimately prevent you from obtaining peak performance and scalability for that SQL Server Instance. We will cover the fundamentals of how query plans get reused and how you need to write your code to take advantage of that. Lots of demos will show just how critical some of your code choices can be in order to obtain peak performance. 
Speaker:

Session Type:
Regular Session

Track:
Performance/Internals

Level: Beginner

Session Code:

Date: September 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Tired of clicking through all those setup screens and entering the same information over and over again? I know I am, so I'm doing something about it...I'm automating my installs!  From base SQL Server installs to Service Packs, Cumulative Updates and even Client Tools for DBA's and Developers, I'll show you ways to automate your installs using SQL Server FineBuild (CodePlex Project).  We'll cover many of the scenarios you may encounter and you'll walk away with some pre-built install scripts to help get you started.
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: September 06

Time: 12:00 AM - 1:00 AM

Room: TBD

I have been new to something at some point in my life, new town, new job or new profession. Now, I am the new DBA!  Feeling overwhelmed, not sure where to begin.  I know I have data and maybe lots of it.  I need a friend and mentor to help me discover my new role. Select wants to be my friend, in fact Select and I need to become best friends.   For Select and I to become best friends, we need to learn about each other, our weaknesses and our strengths. Come along, Select wants to introduce you to all of Selects friends.  Let’s meet Where, Join, Group By and more of Select friends. Come along, let’s discover Select and his friends.
Speaker:

Session Type:
Regular Session

Track:
Introductory Topics

Level: Beginner

Session Code:

Date: September 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Another in TheSQLGuru's very popular "Deep Dive" series, this time covering indexing.  You will learn about the internal structures of heaps, clustered indexes and nonclustered indexes.  We will examine included columns and covering indexes, filtered indexes, indexed views, indexing DMVs and finding the right indexes.  There are some incredibly helpful graphics as well as some nice samples to help you transition theory to practice.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
DBA

Level: Advanced

Session Code:

Date: September 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this demo heavy session we will clear up the confusion.
Speaker:

Session Type:
Regular Session

Track:
Performance/Internals

Level: Intermedia

Session Code:

Date: September 06

Time: 12:00 AM - 1:00 AM

Room: TBD

You have more and more servers to manage and less time to accomplish everything. You're writing scripts to automate those tasks but they still take time to run. PowerShell remoting allows you to manage servers without the overhead of Remote Desktop, and allows you to run processes on all your servers simultaneously.  In this session we'll walk through how PowerShell remoting works, how to set it up, and how you can save time getting things done more quickly.
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: September 06

Time: 12:00 AM - 1:00 AM

Room: TBD

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