Multimedia Library - All

Sep 14, 2015
Video
Windows IT Pro

Creating AlwaysOn Availability Groups in Azure  

Speaker: Michael Otey In this session you’ll see how you can create SQL Server AlwaysOn Availability Group replicas in Azure and use them for cloud-based disaster recovery....More
Sep 14, 2015
Video
Windows IT Pro

DevOps and Data Integration with SSIS  

Speaker: Andy Leonard DevOps is popular with many corporations, for good reason. The practices and principles deliver stability, repeatability, and peace of mind to the modern IT enterprise. Is it possible to leverage DevOps for data integration?...More
Sep 14, 2015
Video
Windows IT Pro

Excel 2013 Tips and Tricks for Displaying a Multidimensional Cube  

Speaker: Thomas LeBlanc New features have been added to the past couple of Excel releases to bring the most widely used desktop reporting application to a full-featured business intelligence reporting tool for multidimensional cubes. This session will be filled with demonstration of all these new features, with slides only as reference to more detailed explanations and uses. Pivot tables will be the main focus of this 75-minute session with visual tools that enhance graphs and dashboards....More
Sep 14, 2015
Video
Windows IT Pro

Handle with Care: Virtual SQL Servers  

Speaker: David Klee Maintaining the performance of a mission-critical SQL Server system during the virtualization process is different from less resource-intensive applications. Practices and processes that have worked for years for less-complex applications can detract from the performance of a large database server; but why? This hypervisor-agnostic session will explore the reasons why SQL Server is so hard to successfully virtualize and give you many strategies for working through each challenge to get the most performance out of your virtualized SQL Server systems....More
Sep 14, 2015
Video
Windows IT Pro

Keynote: Insights to SQL Server 2016  

Speaker: Conor Cunningham Microsoft is in public beta with its upcoming release of its flagship database product, SQL Server 2016. This release is packed with tons of new features to help both DBAs and Developers get more out of their data. In this talk, Conor will cover some of the major features in the release, from the latest in-memory OLTP + DW performance enhancements to improvements in the language surface area to make it easier to use the product in new ways. Many of these same features are also available in Microsoft Azure SQL Database (aka SQL Azure)....More
Sep 14, 2015
Video
Windows IT Pro

Scalable Application Design with Service Broker  

Speaker: Allen White How your business applications directly interact with the corporate database can have a dramatic effect on how successful you are, and one of the biggest issues is performance with large databases. By designing the application to use asynchronous messaging for non-critical updates, you can more effectively tune your critical updates for performance, and make the remaining updates later. SQL Server Service Broker handles asynchronous requests quickly and efficiently, as well as minimizes conflicts with your critical updates....More
Sep 14, 2015
Video
Windows IT Pro

Table Partitioning: The Secret Weapon for Your Big Data Problems  

Speaker: John Sterrett Is big data starting to slow you down? Is data growth putting your maintenance tasks in danger of not meeting your service level agreements? Do you wish you could archive old data with minimal impact to your tables during the archive process? Do you wish you could eliminate the majority of the data in your tables when you query them? If so, it's time to consider implementing table partitioning to help with your general performance and to reduce your maintenance window for completing your maintenance tasks....More
Sep 14, 2015
Video
Windows IT Pro

The Scalable SQL Server Enterprise  

Speaker: Michael Fal In the world of the cloud and DevOps, infrastructure deployments must become faster and more reliable. Whether you plan on using the public cloud or will manage your own private virtual infrastructure, there’s a continuing challenge to execute deployments quickly and consistently. This session will focus on rapidly creating and configuring SQL Server systems using PowerShell and Desired State Configuration....More
Sep 14, 2015
Video
Windows IT Pro

Who Needs SSAS When You've Got SQL?  

Speaker: Meagan Longoria For SQL and .NET developers, SQL Server Analysis Services might seem foreign or unnecessary; however, it can offer many advantages for reporting and data exploration. In this session we'll cover useful features of SSAS and discuss conditions under which it's beneficial. Next, we'll compare the two types of SSAS databases (multidimensional and tabular) and cover how to decide which type is right for your solution....More
Sep 14, 2015
Video
Windows IT Pro

An Introduction to Go for .NET Developers  

Speaker: James Nugent Go is one of the most exciting languages around today. Led by C and UNIX luminaries Ken Thompson and Rob Pike (among others), it was announced to the public in November 2009 and has become the tool of choice across many different areas, especially around operations tooling because of the get things done attitude of the community and designers. Go has the benefit of being a very straightforward way of writing cross-platform code that's statically compiled, requiring no additional runtimes to be installed on deployment targets....More
John Savill's PowerShell Master Class

Join John Savill for the ALL NEW PowerShell Master Class!

In this master-level training course, you get 9 hours of technical training that will make you a PowerShell Master!

Thursdays, February 11th through 25th

By the end of the course, you will understanding how to create custom modules to achieve amazing results in your environment, in non-Microsoft environments and in Azure.

Topics covered will include:

* PowerShell Fundamentals
* Remote Management
* Connecting Commands and Mastering Objects
* Scripting and Custom Modules
* State Configuration
* PowerShell Workflows, Orchestrator SMA, and Azure Automation
* And much more!

 

Join the Conversation

Get answers to questions, share tips, and engage with the IT professional community at myITforum. Are you a data center professional? Join AFCOM for the best data center insights.

Sponsored Introduction Continue on to (or wait seconds) ×