Presented by: Argenis Fernandez
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: 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

COMING SOON
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