More in SQL Server

  • Jan 27, 2014
    Video
    Windows IT Pro

    Session 3: Handling Corruption  

    Presented by: Robert Davis Running Time: 59 min Corruption can happen no matter how much care we take to prevent it. It’s inevitable, so the best course of action is to be ready for when it does happen. We will learn in the earlier sessions how to detect corruption, and now it’s time to learn what to do once you have identified it. We will explore the different types of corruption and the options for handling each type … without data loss....More
  • Jan 27, 2014
    Video
    Windows IT Pro

    Session 2: Recovering Lost Data  

    Presented by: Robert Davis Running Time: 51 min What do you do when someone forgets the WHERE clause on a delete statement or if a table gets accidentally dropped? We will look at ways to proactively prepare for the recovery of lost data and techniques for recovering the data after it has been lost, including techniques for mining the transaction log for the offending transactions....More
  • 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
NEW: John Savill's Microsoft Stack Master Class

Get 30 hours of detailed instruction covering the complete Microsoft solution stack. Invest a few hours each week and become THE Microsoft expert in your organization.

Semester 1: October 30th to December 4th
Semester 2: January 22nd to February 19th

John Savill will cover topics including:

* Deploying, Managing, and Maintaining Windows
* Key Features of Active Directory from Windows 2000 to Windows Server 2012
* Key elements of System Center 2012 and System Center 2012 R2
* Deploying, Migrating to and Managing Hyper-V in Your Organization
* Implementing a Private Cloud
* Using PowerShell to Automate Common Tasks

Enroll by October 23rd and SAVE $245!
 

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) ×