High Availability SQL Server
This video presents the High Availability and Disaster Recovery basics of SQL Server, including clustering, log shipping, replication, AlwaysOn Availability Groups and more.
Tag: sql server
Deploying a SQL Server Private Cloud Infrastructure using Self-Build
Microsoft provides multiple options to help you manage and deploy a private cloud infrastructure that is optimized for your database workloads including; Self-Build, Reference Architecture, and the new HP Database Consolidation Appliance. This video provides an overview of the Self-Build offer for Optimizing SQL Server for Private Cloud infrastructure.
Create a SQL Server Stored Procedure
A SQL Server stored procedure, sometimes referred to as a stored proc or procedure, allows you to write one or more TSQL statements and store them within your database so that they can be called over and over again without having to write that code a again. This article shows …
SQL Server Wildcard Queries Tutorial
This tutorial shows how to use range and pattern matches in a basic single table query in SQL Server 2005 and 2008. [youtube FCRY-MZNsjA]
Microsoft SQL Server Integration Services Performance Design Patterns
Need a fast data integration solution, but don’t have the time or budget for heavy performance tuning? Come learn how to maximize your ROI by applying trusted design patterns to your Integration Services packages. We talk about how to set performance expectations, and how to put together a simple framework …
Microsoft SQL Server Execution Plans: From Compilation, to Caching, to Reuse
Execution plan reuse is one of the most important aspects of building well-performing and scalable SQL Server solutions. But it’s also the one that is often overlooked during the design phase and becomes very difficult to troubleshoot later. In this session we discuss in detail the following aspects of SQL …