More in SQL Server

  • Jan 27, 2014
    Video
    Windows IT Pro

    Session 1: Data Integrity and Recovery  

    Presented by: Robert Davis Running Time: 37 min Data integrity forms the basis for building a disaster recovery strategy. We’ll take a look at the built-in mechanisms for protecting integrity and detecting corruption. We will cover standards and best practices everyone should follow and demonstrate how and why the practices will protect against and prevent data loss....More
  • Dec 12, 2013
    video
    Windows IT Pro

    Session 3: Extending the Core Farm for Added Business Value  

    Presented by: Colin Spence This session covers additional key topics that can provide great value to the core SharePoint environment to meet specific business needs and provide value to the organization:...More
  • Dec 12, 2013
    video
    Windows IT Pro

    Session 2: Configuring “Rock Solid” SharePoint Farms  

    Presented by: Colin Spence While the Configuration Wizard makes the SharePoint 2013 configuration process deceptively easy, there is much more to the configuration of a reliable and stable SharePoint environment. This session will cover critical areas that need to be addressed for enterprise deployments:...More
  • Dec 12, 2013
    video
    Windows IT Pro

    Session 1: Building the Foundation on SQL Server 2012  

    Presented by: Colin Spence Since SQL Server forms the foundation of the SharePoint environment, it is critical that it be designed properly to scale appropriately and meet the organization’s needs. Topics to be covered will include these: Overview of the benefits and advances in SQL Server 2012 Pros and cons of physical vs. virtual configurations, use of aliases, multiple instances, and other design decisions Review of differences between SQL Server 2012 versions...More
  • Nov 21, 2013
    video
    Windows IT Pro

    Session 3: Automating the DBA's Workload  

    Presented by: Allen White An introduction to Policy-Based Management and a demonstration of how to set up PBM using PowerShell, followed by a walkthrough of the registered server and Central Management Server setup via scripts. Then a discussion of maintaining a server inventory and gathering SQL Server performance data via PowerShell, and a demonstration on using PowerShell Remoting to manage multiple servers simultaneously....More
  • Nov 21, 2013
    video
    Windows IT Pro

    Session 2: Scripting Backups, Restores and ADO.NET Using SQL Server  

    Presented by: Allen White A walk through the process of scripting backups and restores for SQL Server, as well as doing index maintenance and database integrity checks. Then an introduction to accessing data in SQL Server via ADO.NET, and a closer look at accessing the data objects via SMO, exposing ways of managing SQL Server not practical via T-SQL....More
  • Nov 21, 2013
    video
    Windows IT Pro

    Session 1: PowerShell Basics  

    Presented by: Allen White An introduction to the basics of PowerShell, the language constructs and logic flow, allowing you to build your own library of functions and scripts to automate your own workflow. This will be followed by an introduction to Server Management Objects (SMO), which is the Management API for SQL Server....More
  • Nov 20, 2013
    video
    Windows IT Pro

    Session 4: Self-Service Data Visualization with Report Builder  

    Presented by: Stacia Misner Let's face it. A team of professional report developers is hard-pressed to keep up with the information needs of business users. With some up-front planning, and some features built into SQL Server Reporting Services (SSRS), you can create a self-service BI environment that lets business users help themselves to a variety of data visualizations....More
  • Nov 20, 2013
    video
    Windows IT Pro

    Session 3: Using PowerPivot  

    Presented by: Stacia Misner Traditional BI solutions often require a team to gather, massage, and load data into structures suitable for analysis, and this process takes time. What if the data you need to analyze today isn't going to be ready until months from now? Or perhaps you have access to a new data source, but no one is certain yet how useful it would be for ongoing decision making....More
  • Nov 20, 2013
    video
    Windows IT Pro

    Session 2: Using Power View for Analysis and Visualization  

    Presented by: Tyler Chessman Power View is an interactive data exploration, visualization, and presentation technology. First introduced in SharePoint 2010, Power View is now also part of Excel 2013. In this session, you’ll learn how to quickly get up to speed with Power View to analyze and visualize data....More
  • Nov 20, 2013
    video
    Windows IT Pro

    Session 1: Introducing Power Query (formerly known as Data Explorer)  

    Presented by: Tyler Chessman Microsoft Power Query is a new self-service business intelligence (BI) tool that helps users find and prepare data for analysis. Available as an add-in for both Excel 2013 and Excel 2010, Power Query makes it easier to discover, combine, and refine both public and private data sources....More
  • Oct 15, 2013
    Video
    Windows IT Pro

    Session 3 – SQL Server High Availability Solutions – A Real World Perspective  

    Presented by: Allan Hirt While the previous session was focused on describing the individual technologies themselves, this final session of the day will focus on building a solution that meets your needs. Based on the years of Allan’s experience, this session will focus on what works and point out what does not. The different availability options in SQL Server will be compared and contrasted so that you can see how they might or might not fit your needs as well as work together....More
  • Oct 15, 2013
    Video
    Windows IT Pro

    Session 2 – Understanding the SQL Server Availability Features  

    Presented by: Allan Hirt Before you can design a solution, you have to understand the options that you have available to you. This session will cover the most popular options such as failover clustering instances, availability groups, and more. Other options, such as virtualization and third-party solutions, will also be discussed....More
  • Oct 15, 2013
    Video
    Windows IT Pro

    Session 1 – Business Continuity: The Real Reason for HA and DR  

    Presented by: Allan Hirt Technology features should never be the starting point for any implementation. These decisions often lead to more downtime and less uptime if the technology choice was not right or cannot be administered by the current staff....More
NEW: John Savill's Microsoft Azure Master Class

A new Master Class with John Savill! Get 12 hours of detailed instruction covering that will make you the Master of Microsoft's Public Cloud!

During this training attendees will learn:

* How and when to use Azure
* How to integrate Azure with existing infrastructure including networking and Active Directory
* How to Implement single pane of glass management for a complete hybrid environment

Thursdays, July 24th through August 14th
 

Upcoming Conferences

Register now to get the best rates available!

Windows Forums

The Windows IT Pro forums are moving to myITforum.com! Get answers to questions, share tips, and engage with the IT professional community.

Sponsored Introduction Continue on to (or wait seconds) ×