Microsoft SQL Server 2008

Implementing Data Compression in SQL Server 2008

Edwin M. Sarmiento — Thu, 04 Sep 2008 15:39:00 GMT

This video demonstrates how to estimate storage space savings and how to implement data compression in SQL Server 2008. Data compression reduces the size of tables, indexes or a subset of their partitions resulting in reduced the storage costs and increased query performance by reducing I/O and increasing buffer-hit rates

Multi-server Query Execution

Edwin M. Sarmiento — Mon, 30 Jun 2008 06:15:00 GMT

Have you ever wanted to execute a query on as many SQL Server instances as possible only once? This video will demonstrate how you can use SQL Server 2008 Management Studio to run a query across multiple instances making tasks like server configuration, generating reports and configuration comparison as easy as you can imagine.

Working with TSQL Debugger

Edwin M. Sarmiento — Sat, 28 Jun 2008 15:25:00 GMT

This video demonstrates the TSQL Debugging feature in SQL Server 20008. If you have used Visual Studio before, you'll find the the debugging process very similar as SQL Server Management Studio is just a Visual Studio shell. You'll be able to step thru your TSQL code line-by-line, showing you the current state of your code and variables, set breakpoints at certain lines of codes to tell the debugger to pause, and so much more.

Working with Table-Valued-Parameters (TVP)

Edwin M. Sarmiento — Sun, 15 Jun 2008 00:11:00 GMT

This video demonstrates the use of table-valued parameter in SQL Server 2008. Table-valued parameters (TVP) are a new parameter type in SQL Server 2008. Table-valued parameters are declared by using user-defined table types. You can use table-valued parameters to send multiple rows of data to a Transact-SQL statement or a routine, such as a stored procedure or function, without creating a temporary table or many parameters.

Use the accompanying TSQL script and C# 3.5 client application to better understand how simple it is to create and use TVPs

Exploring the MERGE statement

Edwin M. Sarmiento — Sat, 14 Jun 2008 23:53:00 GMT

This video demonstrates the concepts behind the use of the MERGE statement in SQL Server 2008. The MERGE statement in SQL Server 2008 is a new DML statement that combines multiple DML operations. It performs INSERT, UPDATE, or DELETE operations on a target table based on the results of a join with a source table. This statement enables you to merge two tables based on a set of criteria. You can use the demo script to try it out

Implementing Change Data Capture

Edwin M. Sarmiento — Mon, 26 May 2008 04:20:00 GMT

Change data capture or CDC is a new feature in SQL Server 2008 that is designed to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in an easily consumed relational format. This gives DBA and developers the ability to track DML changes without having to write triggers.

Exploring Database Backup Compression

Edwin M. Sarmiento — Sun, 25 May 2008 05:52:00 GMT

This video will demonstrate how to use database backup compression in SQL Server 2008. Database backup compression significantly reduces the duration of both backup and restore operations which is beneficial for very large databases

Configuring Transparent Data Encryption

Edwin M. Sarmiento — Sat, 17 May 2008 23:29:00 GMT

Security is a major concern in every organization. By default, SQL Server backups are unsecured and run the risk of getting compromised. This video will demonstrate how you can implement transparent data encryption in SQL Server 2008 to secure your database backups. You can download the T SQL script provided so you can try out the procedures on your own

SQL Server 2008 Management Data Warehouse

Edwin M. Sarmiento — Sat, 17 May 2008 23:11:00 GMT

Management Data Warehouse

This video will explain and configure management data warehouse in SQL Server 2008. SQL Server 2008 provides an out-of-the-box data collector that you can use to obtain and save data that is gathered from several sources, which includes TSQL queries, Windows performance counters and SQL Profiler counters. The data collector enables you to use data collection containers, which enable you to determine the scope and frequency of data collection on a SQL Server server system.

Extending Policy-based Management to the Enterprise

Edwin M. Sarmiento — Sat, 17 May 2008 22:35:00 GMT

This video will demonstrate how you can extend policy-based management to the enterprise. You can create policies on a configuration server for testing and evaluate and deploy them on multiple SQL Server instances all at once.

Managing SQL Server 2008 using Policies

Edwin M. Sarmiento — Sun, 11 May 2008 10:43:00 GMT

This video explains and demonstrates how you can use policies to manage SQL Server 2008. Policy-based management is a new feature in SQL Server 2008 which allows you to define and enforce policies for configuring and managing SQL Server across the enterprise. The demonstration illustrates how you can use policies to implement a standard naming convention for database objects such as stored procedures

Installing SQL Server 2008

Edwin M. Sarmiento — Wed, 30 Apr 2008 07:44:00 GMT

This video demonstrates how to install SQL Server 2008 on a Windows Server 2003 machine. The installation is pretty straight-forward. If you have installed SQL Server 2005 before, the process will be very familiar but you will notice the differences in the user interface and the new features included as part of the installation