More in SQL Server

  • 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
  • Oct 1, 2013
    Video
    Windows IT Pro

    Session 3: Troubleshooting Replication  

    Presented by: Robert Davis Running Time: 56 min We will look at the common problems you might encounter when working with replication. This session will arm you will the troubleshooting techniques that will help deal with a wide variety of problems....More
  • Oct 1, 2013
    Video
    Windows IT Pro

    Session 2: Implementing Replication  

    Presented by: Robert Davis Running Time: 62 min Implementing replication is a lot easier than it seems when you plan for it properly. We look at how to implement different forms of replication and how to deal with common pitfalls. This session also covers alternative forms of initialization, which add complexity but solve some big problems that you might come across when working with replication....More
  • Oct 1, 2013
    Video
    Windows IT Pro

    Session 1: Introduction to Replication  

    Presented by: Robert Davis Running Time: 55 min This session will introduce you to the different forms of replication and explain when and how to use each one. Each replication topology fits certain scenarios and sometimes the right one is obvious. Sometimes, it’s less than obvious and this is where really understanding replication will help you follow the right path....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
  • 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

    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

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