Presented by: Argenis Fernandez
Running Time: 74 min
Connections Track: SQL Server
In this demo-packed session, we will explore the use of SysInternals tools such as Process Monitor, Process Explorer, and many others to troubleshoot various problem scenarios with SQL Server....More

Presented by: Itzik Ben-Gan
Connections Track: SQL Server
An interval represents a set of values between some low and some high values. In reality, there are different kinds of intervals that you might need to represent in your database, such as temporal (e.g., sessions, appointments, periods of validity)....More

Presented by: Steve Jones
Connections Track: SQL Server
Securing your data is becoming increasingly important for data professionals. This session will cover the encryption features available in SQL Server to help you better secure data. Transparent Data Encryption, symmetric keys, asymmetric keys, and hashing functions will be covered in a number of demos....More

Presented by: Denny Cherry
Connections Track: SQL Server
In this session, we will explore the SQL Server table partitioning features that were introduced in SQL Server 2008. We'll look at how to create partitioned tables and indexes, as well as the internals of the table....More

Presented by: Tim Chapman
Connections Track: SQL Server
Proper indexing is critical to every SQL Server installation. Having the correct indexes is imperative; having the incorrect or excessive indexes can be detrimental to system performance....More

Presented by: Tim Chapman
Connections Track: SQL Server
The transaction log plays the most critical role in any SQL Server database. In this session, we discuss the importance of the transaction log and the roles it plays inside the database engine. We look at how logging and recovery work, the checkpoint process, write-ahead logging, and steps you need to take as a DBA to ensure proper management of the transaction log for a SQL Server database....More

Presented by: Ben DeBow
Connections Track: SQL Server
Do you know what SaaS and DaaS are? If not, you should. SQL Server as a Service (SaaS) and Database as a Service (DaaS) are otherwise known as the private cloud—the ability to offer your customers (external or internal) a reliable, scalable, and manageable way to easily deploy SQL Server systems and databases....More

Presented by: Jason Strate
Connections Track: SQL Server
One of a DBA's primary responsibilities is managing the performance of a SQL Server environment. When performance problems arise, DBAs need to have the correct tools in place to be able to dig in and discover the issues that are occurring....More

Presented by: Eddie Wuerch
Connections Track: SQL Server
Every SQL Server instance relies on the tempdb database. Whether through explicit use with #temp tables or @table variables, or implicit use through working space for many other operations, most tempdb databases get quite a workout....More

Connections: Exchange Track

Presented by: Jeff Mealiffe
Connections Track: Exchange
The debate over whether to virtualize an Exchange deployment continues. In this session, we will cover the latest product group guidance as it relates to the Exchange 2013 release....More

Presented by: John Savill
Connections Track: IT
This session will guide attendees through the key steps to integrate with Azure IaaS using System Center Orchestrator. The new Azure Integration Pack for Orchestrator will be explored, including how its cascading dependency structure works....More

Connections: SQL Track

Presented by: Itzik Ben-Gan
Connections Track: SQL Server
An interval represents a set of values between some low and some high values. In reality, there are different kinds of intervals that you might need to represent in your database, such as temporal (e.g., sessions, appointments, periods of validity)....More

Presented by: Tim Chapman
Connections Track: SQL Server
Proper indexing is critical to every SQL Server installation. Having the correct indexes is imperative; having the incorrect or excessive indexes can be detrimental to system performance....More

Connections: SharePoint Track

Presented by: John Holliday
Connections Track: SharePoint
The Enterprise Content Management (ECM) features in SharePoint have steadily improved with each new release of the platform. In this session, we'll explore the top 10 new ECM features that have been added to SharePoint 2013, with an emphasis on "new."...More