Connections: SQL Track
Sep 18, 2013
Video
Windows IT Pro

Practical Uses of Window Functions  

Presented by: Itzik Ben-Gan Connections Track: SQL Server Window functions allow you to perform data analysis computations elegantly and efficiently. Support for window functions was added in two major milestones....More
Sep 18, 2013
Video
Windows IT Pro

Troubleshooting SQL Server with SysInternals Tools  

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
Sep 18, 2013
Video
Windows IT Pro

Maximizing Plan Reuse  

Presented by: Andrew Kelly Connections Track: SQL Server To get peak performance from your SQL Server instance, you need to ensure that the majority of your database calls reuse a previously compiled query plan. Lack of proper plan reuse can add an enormous amount of overhead to your system and can affect overall performance....More
Sep 18, 2013
Video
Windows IT Pro

Efficient Interval Management in SQL Server  

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
Sep 18, 2013
Video
Windows IT Pro

Encryption in SQL Server  

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
Sep 18, 2013
Video
Windows IT Pro

SQL Server Table Partitioning from the Ground Up  

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
Sep 18, 2013
Video
Windows IT Pro

SQL Server Index Internals  

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
Sep 18, 2013
Video
Windows IT Pro

What DBAs Need to Know About Hekaton  

Presented by: Victor Isakov Connections Track: SQL Server Hekaton, Microsoft's new "in-memory tables" architecture in SQL Server, promises to seriously change the type of database solutions that you need to architect and administer....More
Sep 18, 2013
Video
Windows IT Pro

SQL Server Transaction Log Internals  

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
Sep 18, 2013
Video
Windows IT Pro

Build Your Own SQL Server Private Cloud  

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
Sep 18, 2013
Video
Windows IT Pro

Managing SQL Server Performance with Extended Events  

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
Sep 18, 2013
Video
Windows IT Pro

TempDB Performance Troubleshooting and Optimizing  

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
Sep 18, 2013
Video
Windows IT Pro

Virtualizing Exchange Server 2013: Why Not?  

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
Sep 18, 2013
Video
Windows IT Pro

CAS 2013 – Why It Is 3 Better Than CAS 2010 and 6 Better Than 2007  

Presented by: Greg Taylor Connections Track: Exchange Client Access Server (CAS) 2013 – it’s new and shiny, so it must be better at everything than every previous iteration of CAS, right?...More

View All Exchange Track Sessions

Connections: Windows Track
Sep 18, 2013
Video
Windows IT Pro

Hyper-V Best Practices  

Presented by: Alan Sugano Connections Track: IT This session will cover Hyper-V best practices regarding hardware, Server Core, clusters, security, performance, backup, versions, and management. Following these best practices will help ensure that your Hyper-V environment is fast, stable, and secure....More
Sep 18, 2013
Video
Windows IT Pro

Using Orchestrator to Integrate with Azure IaaS  

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

View All Windows Track Sessions

Connections: SQL Track
Sep 18, 2013
Video
Windows IT Pro

Efficient Interval Management in SQL Server  

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
Sep 18, 2013
Video
Windows IT Pro

SQL Server Index Internals  

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

View All SQL Track Sessions

Connections: SharePoint Track
Sep 18, 2013
Video
Windows IT Pro

Top 10 New ECM Features in SharePoint 2013  

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
Sep 18, 2013
Video
Windows IT Pro

Developing Search Applications in SharePoint 2013  

Presented by: Matthew McDermott Connections Track: SharePoint This session looks at what developers can do with the SharePoint Search API to create custom search applications. Whether your goal is to enhance the SharePoint Search center or create custom search applications that take advantage of SharePoint’s powerful search engine....More

View All SharePoint Track Sessions

Connections: Developer Track
Sep 18, 2013
Video

Introduction to .NET Web Development on Azure  

Presented by: Saurabh Pant Connections Track: Development This session will cover .NET web development on Windows Azure, focusing primarily on Windows Azure websites. The talk will cover the capabilities the Azure website platform and its architecture....More
Sep 18, 2013
Video
Windows IT Pro

Creating Data-Driven Mobile Web Apps with ASP.NET MVC and jQuery Mobile  

Presented by: Rachel Appel Connections Track: Development If you need to create new apps or update existing apps, using jQuery Mobile is the easiest way to develop solutions that meet the needs of the ever-increasing audience of the mobile market. jQuery Mobile provides a lightweight, cross-platform framework for developing mobile websites and applications....More

View All Developer Track Sessions

Sponsored Introduction Continue on to (or wait seconds) ×