Practical Microsoft SQL Server 2008 Training
on Video & Audio CD-ROMs

 TEST DRIVE
 BUY ONLINE
 BUY OFFLINE
 CONTACT US
 REFERENCE
 NEWSLETTER
 LINKS


Testimonials

"3 months ago I ordered the SQL 2008 Grand Slam training course and just wanted to let you know, I passed 2008 DBA exams. Thank you all for having such a powerful video training package which contributed to my success! I'll have Human Resources update my personal file at work. You guys are the very best. Again, million thanks."
Mitch Carney

"Finally, my university professor suggested contacting SQLUSA staff for suggestions on SQL Server data warehousing and business intelligence research work. I have gone through your website and realized you are the right training company to give the suggestions."
Martin Dale

"I support a SQL server and run ad-hoc queries for management and some custom views, created a few tables and basic stored procedures for Crystal Reports in the past. After studying SQL Server 2008 Administration training videos, I was able to set up the database mail to notify me when a job fails. I am now able to monitor the database for performance, to measure the effectiveness of a query or procedure, and to make sure we're running efficiently. In addition, I can now develop real complex procedures for reporting. Thanks SQLUSA."
Christian Johansson












 

 

 

 

 

 

SQLUSA.com
FREE TRIAL

GoogleCheckout
Search

 Free Trial Registration
Email*
How Did You Hear About Us? 
Name
Country 
State 
Zip 
  *Required
Advance Your Career
SQL Server 2008 training is now available on 21 full-motion screencast CD-ROMs with audio narration for configuration, administration, design, programming and data transfer. Learn SQL Server 2008 the fun way! Multimedia training is far more effective than live class training. It simulates the real-world environment for excellent memory retention and success on the job as a database professional. You can stop the screencast video any time and practice the lesson on your SQL Server. Learn from your own computer at a pace that suits you. You can replay the video and audio instructional units as many times as you need to. Gain practical knowhow fast and save big over expensive classroom training. Learn the new features of SQL Server 2008 from The World Leader in SQL Server Training.

The Best SQL Server 2008 Training
Database Administration, Design, and Programming are all included in this easy-to-learn video/audio CD-ROM collection from Silico-Magnetic Intelligence. Whether you are learning SQL Server 2008 Administration for the first time or adding to your professional skills set, you will find that SMI’s Practical Training via full-motion CD-ROM™ contains thorough, outstanding, well-prepared content that is second to none. Like training one-on-one with an experienced database professional, each unit is presented in full-motion screencast video allowing you to see the steps and hear the explanations.

Instructions by a Top SQL Expert
The instructor is Kalman Toth,   MCDBA, MCITIP, Senior SQL Server 2000/2005/2008 Architect. By mastering one CD-ROM a day, you can become a Microsoft SQL Server 2008 administrator in 21 days. Naturally, you can also proceed at your own pace, be it ten weeks or ten months. The comprehensive CD-ROM course is focused on practical solutions to real-world database, client server administration and programming problems. Full-motion screen video and rich audio make the subject matter understandable, and reusable as reference material in the future.

Audience for SQL Server 2008 Training
Database administrators (DBA-s) and system administrators, who implement and manage Microsoft SQL Server 2008 RDBMS; MCITP, MCTS and MCSE candidates; C#, VB, Web, .NET, Java, C++ and database developers; systems analysts and software engineers who need to know more about the administration and programming of SQL Server 2008 as well as logical data modelling and database design.

Prerequisites for Multimedia SQL Server 2008 Training
SQL Server 2008 learners must have a solid working knowledge of the Windows environment. Any database or programming experience is a huge plus. This is the most extensive, practical and the best Microsoft SQL Server 2008 Administration multimedia training currently available in North America, or anywhere in the World.

Objective: Excellence in Database Professions
The CD-ROM based course will allow learners to identify and configure all major aspects of a Microsoft SQL Server 2008 RDBMS. It shows and tells applying live screencast video and audio, how to install and configure an SQL Server 2008, create and manage databases and database devices both in Management Studio and with T-SQL scripts in Query Editor, copy, move and script databases, learn the architecture of pubs, Northwind, AdventureWorks & AdventureWorks2008 sample databases, configure enterprise security with logins, users, roles and policy-based management, apply data encryption to columns in tables and entire database, backup and restore SQL Server 2008 databases using visual tools in Object Explorer and T-SQL scripts, configure permissioning for server and database roles, secure database against SQL injection attack, understand the principles of database design, logical and physical data modelling, design, create and manage database objects, program scripts, stored procedures, user-defined functions and triggers in Transact-SQL, entity, domain and referential database integrity enforcement, business rules enforcement, import and export data with bcp and the SSIS Import/Export Wizard, implement automated tasks with SQL Server Agent including configuring operators, users, alerts and jobs, learn disaster recovery techniques: backup strategies, log shipping and replication, optimize the performance of SQL Server 2008 with indexing and the use of advanced tools like SQL Server Profiler and Windows Performance Monitor, XML import/export & Xquery language, full-text indexing & search, indexed views, and database mail setup, SQLCMD & Powershell, stored procedure debugging. There is strong emphasis on practical applications and real life examples. (See full list below)

About the Industry Expert Trainer Kalman Toth, MCDBA, MCITP is a designer of over 60 databases worldwide with 15 years of database administration and development experience on SQL server 4.2, 6.5, 7.0, SQL Server 2000, SQL Server 2005, SQL Server 2008 and Sybase. His clients include: Citibank, Bank of Sweden, Deloitte-Touche, Swiss Bank, Lehman Brothers, Salomon Brothers, Merrill Lynch, Reuters, IBM and major consumer ecommerce companies. He holds M.Phil. degrees in Computing Science and Physics from Columbia University, where he also taught Computer Science.

CD 22: Bonus
The bonus CD-ROM includes all the T-SQL, Command Prompt, XML, SQLCMD and PowerShell scripts used in the instructional units for SQL Server 2008 database administrators, designers and developers. The bonus CD also includes the 10-step Performance Tuning Bootcamp instructions/scripts as well a complete set of accounting database table definitions for General Ledger(GL), Accounts Payable(AP), Accounts Receivable(AR) and Inventory.

Bonus Book: Accelerated SQL Server 2008
The 816 pages expert tuition and approach to rapid learning in Accelerated SQL Server 2008 will enable SQL Server and other database professionals to make the leap to the latest release of Microsoft’s flagship database management system quickly. Take full advantage of the new features of SQL Server 2008, know what tools are available, and quickly realize the power and ease of use that SQL Server 2008 has to offer: Lightning–quick introduction to SQL Server 2008; Written by top experts in the field; Provides a solid grounding in key features and technologies; What you’ll learn: Manage SQL Server installations through the brand–new Declarative Management Framework; Protect yourself from downtime with high–availability features such as failover clustering; Speed your applications by taking advantage of new performance–enhancement features in SQL Server 2008; Find what you need using full–text search; Store, retrieve, and manage XML in the database; Derive competitive advantage from business intelligence tools such as Analysis Services & Reporting Services;

21 CD-ROMs Equivalent to 3 Years of Job Experience
SMI's CD-based SQL Server 2008 training is like training one-on-one with an international industry expert -- full motion screen video allows you to see the steps, hear the explanations, and perform the critical tasks. This is the complete training solution for passing related certification exams, excelling on an interview and performing well in the workplace. It is convenient, giving you the freedom to learn at your own pace, wherever and whenever it suits your schedule. CD-ROM is easy to use, with streamlined interface featuring one-click navigation. 100% guaranteed.

 
 
Multimedia Microsoft SQL Server 2008 Administration training on 21 full-motion screencast video and rich audio CD-ROMs $695.

Enlarge
 

CD-ROM 1 - OVERVIEW (2 hours 50 minutes)
1. Introduction and Welcome Notes
2. Your First SQL 2008 Email Report to the CEO
3. 2008 the Feature-Rich Sequel to 2005
4. What is New in SQL Server 2008
5. History of Relational Database Technology & SQL
6. Microsoft DBA Career Opportunity
7. SQL Server 2008 for Developers
8. The Advantages of the SQL Language
9. Enterprise Scale, Performance & Responsiveness
10. Data Warehousing & Business Intelligence
11. Microsoft's New BI Drive: BI for the Masses
12. New SSIS Data Profiling Task & DW Population
13. Enhanced OLAP Analysis Scale & Performance
14. Enterprise Reporting Engine & MS Word Reports
15. Temporal, Spatial Data Types & IntelliSense
16. Ten Guidelines for DBA & Developer Excellence


CD-ROM 2 - MANAGEMENT TOOLS (3 hours 2 minutes)
1. Editions of SQL Server 2008
2. Installing & Configuring SQL Server 2008
3. Installing & Configuring Part Two
4. Installing & Configuring Part Three
5. Program Group & Creating Desktop Shortcuts
6. First Look from Management Studio
7. SQL Server 2008 Upgrade Advisor
8. SQL Server Configuration Manager and Facets
9. Installing AdventureWorks2008 Database
10. SSIS Import and Export Wizard
11. Familiarizing with Query Editor
12. Books Online & the Graphical Query Designer
13. SQL Server Profiler & Tuning Advisor
14. Business Intelligence Development Studio - BIDS
15. Analysis Services - SSAS
16. Reporting Services - SSRS


CD-ROM 3 - ENTERPRISE SECURITY (3 hours 2 minutes)
1. Principals, Securables and Permissions
2. Metadata Visibility by Principals
3. Setting up Logins with Management Studio
4. Setting up Logins, DB Users, Roles with Statements
5. Fixed Server Roles and Permissions
6. Policy-Based Management for Better Security
7. DB User and Role Management with MS
8. Creating Security Accounts in the Enterprise
9. SCHEMAs and Security Hierarchy
10. Transparent Data Encryption (TDE) of Data
11. Extensible Key Management & Data Auditing
12. CREATE CERTIFICATE, Encryption and Decryption
13. 3DES Encryption of Credit Card and Bank Data
14. Asymmetric Key - Public Key & Private Key
15. Clear Text Encryption and Decryption
16. RSA 512-bit, 1024-bit & 2048-bit Encryptions


CD-ROM 4 - DATABASE BACKUP (3 hours 5 minutes)
1. Site Server Architecture and Deployment
2. RAID Disk Storage Architecture - SAN
3. Storage Offers from Major Computer Manufacturers
4. Dell SQL Server Database Advisor Tool
5. GUI Database Backup with Management Studio
6. Database Backup Using Scripts
7. Differential, Transaction Log & COPY-ONLY Backup
8. Advanced Database Backup Options
9. Policy-Based Management of DB Backups
10. Creating a Database Maintenance Plan
11. The bcp Utility for Flat File Import/Export
12. Configuring Database Mail
13. Backup Success or Failure Email Notification
14. Enabling Database Backup File Compression
15. Database and Backup File Encryption
16. 7 Keys to SQL Server 2008 DBA Success


CD-ROM 5 - DATABASE RESTORE (3 hours 2 minutes)
1. Restoring Transaction Log Backups in Order
2. Restore a Database to a Point in Time after Crash
3. Disaster Recovery Planning
4. Backup Set Verify with RESTORE VERIFYONLY
5. Database Restore with Visual Tools & Scripts
6. Policy-Based Management of DB Recovery
7. Recovery of Databases at Server Startup
8. Copy Database Using Backup, Copy & Restore
9. Restoring the master, model & msdb Databases
10. Media Sets and Families - Overwrite or Append
11. Initializing and Password Protecting Media
12. Moving 2 Terabyte DB from Phoenix to Boston
13. Restore Completion Database Mail Notification
14. Flat File Bulk Import with BULK INSERT
15. Openrowset, Opendatasource and Openquery
16. Configure Management Data Warehouse Wizard


CD-ROM 6 - PERMISSIONING (2 hours 35 minutes)
1. Builtin and Implied Permissions
2. Understanding Permissions Hierarchy
3. CREATE SCHEMA with AUTHORIZATION
4. System Administrator(sa) Permissions
5. Non-sa Server Roles Permissions
6. Fixed Database Role Permissions
7. Object Ownership Within the Database
8. Policy-Based Management of Permissions
9. Object Permissioning Using Object Explorer
10. Statement Permissioning Using Scripts
11. Object Ownership Chains & Object Dependencies
12. ALTER SCHEMA and ALTER AUTHORIZATION
13. Developing Permissioning Strategy
14. Securing Against SQL Injection Attacks
15. Working with the New PUBLIC Server Role
16. TOP 7 SQL Server Security Vulnerabilities


CD-ROM 7 - DATABASE INFRASTRUCTURE (2 hours 42 minutes)
1. Create Database by Using Management Studio
2. Accounting Database Setup and Initialization
3. Create Database by Statement Execution
4. Exploring Database Properties - sp_helpdb
5. Primary and User-Defined Filegroups
6. Alter Database & Configure Database Options
7. Architecting & Implementing FILESTREAM Storage
8. Create Database Advanced Features
9. Remove, Rename DB by Object Explorer & Scripts
10. Database Snapshot for Reporting & Safeguarding
11. Moving Databases between Different Servers
12. Scalability and Very Large Databases - VLDB
13. DB Policies - Declarative Management Framework
14. Audits; Database & Server Audit Specifications
15. DBCC; CheckDB, ShrinkDatabase & Other Commands
16. Executing Generate SQL Server Scripts Wizard


CD-ROM 8 - SAMPLE DATABASES (2 hours 47 minutes)
1. Installing SQL Server Sample Databases
2. Conceptual Diagram of AW2008 Entity Model
3. Visio Diagram of AdventureWorks2008 Database
4. Primary Key and Foreign Key; RDBMS Basics
5. 1NF, 2NF & 3NF Normal Forms in AdventureWorks2008
6. AdventureWorks2008; Bike Manufacturer OLTP DB
7. AW2008 Business Scenarios & AW Data Dictionary
8. Reviewing AdventureWorks2008 New Features
9. AdventureWorksDW2008 Data Warehouse Database
10. HierarchyID Based Trees in AdventureWorks2008
11. Creating, Saving & Emailing Database Diagrams
12. pubs Book Publishing Sample Database Overview
13. Northwind Food & Drink Supplier Sample DB
14. Advanced Review of pubs Database Diagram
15. Advanced Review of Northwind Database Diagram
16. Accounting DB Review: GL, AP, AR & Inventory


CD-ROM 9 - DATABASE DESIGN (2 hours 54 minutes)
1. Understanding Logical Data Modelling
2. Working with Table Column Data Types
3. New; DATE, TIME, DATETIMEOFFSET & DATETIME2
4. CREATE TABLE by Script & Using Object Explorer
5. Primary Key and Foreign Key Constraints
6. Database Diagram Design in Object Explorer
7. Logical Database Modelling with Visio
8. Relational Database Design with Visio
9. Reverse Engineering a Database with Visio
10. ALTER TABLE and Changing Tables by MS
11. Designing Compressed Tables & Indexes
12. Partitioned Table, Partition Function and Scheme
13. Create Partition & Manage Partition Wizards
14. The Data Compression Wizard
15. Code, Translate and Lookup Table Design
16. Database Design and Programming Standards


CD-ROM 10 - THE SELECT STATEMENT (3 hours 1 minute)
1. Inner Join, Self Join, Outer Join and Cross Join
2. Basic SQL SELECT and SELECT INTO Statements
3. Sorting SELECT Query Results with ORDER BY
4. Exploring CTEs, Nested & Correlated Subqueries
5. SELECT with UNION, UNION ALL, ROLLUP and CUBE
6. Date & Time, String and Math System Functions
7. Exploring Configuration & System Statistical Functions
8. Dynamic SQL for Automatic Query Generation
9. The GROUP BY Clause & Aggregate Functions
10. Working with Hierarchy ID and Metadata Functions
11. TOP, ROW_NUMBER, RANK, DENSE_RANK and NTILE
12. Understanding Recursive Queries & Tree Processing
13. Creating Comma-Delimited Lists with XML Path
14. Crosstab (Matrix) Query with CTE and PIVOT
15. Building Multidimensional Crosstab Query
16. Architecting Business Intelligence Dashboards


CD-ROM 11 - MODIFY DATA (3 hours 2 minutes)
1. INSERT INTO Statement with VALUES Clause
2. Understanding INSERT and SELECT Subquery
3. INSERT and EXECUTE Statement
4. Data Removal with the DELETE Statement
5. Data Modification with the UPDATE Statement
6. Working with the MERGE Statement
7. Synchronizing Two Tables with MERGE
8. Modifying Data with Cursors, Subqueries & JOINs
9. Logged and Minimally-Logged Operations
10. Creating Audit Trail with the OUTPUT Clause
11. Combining INSERT with CTE and OUTPUT
12. UPDATE with CTE, OVER & PARTITION BY
13. Deleting Duplicate Rows with CTE
14. Updating Binary Mask and CSV List Columns
15. Using UPDATE with the FROM Clause
16. UPDATE with GROUP BY Aggregate Subquery


CD-ROM 12 - DATA INTEGRITY (3 hours)
1. Data Integrity Constraints in AdventureWorks2008
2. Surrogate Key Architecture, Natural Key & GUID
3. PK, FK, UNIQUE & CHECK Constraints; Defaults
4. Data Integrity Enforcement with Triggers
5. Working with Data Integrity Templates
6. Stored Procedure vs. Ad-hoc SQL Script
7. Entity, Domain and Referential Database Integrity
8. Entity Integrity Definition Using Management Studio
9. Listing and Scripting Data Integrity Objects
10. Understanding Domain Integrity Enforcement
11. Implementing Referential Integrity Constraints
12. Creating User Defined Integrity Objects
13. Exploring Table-Level CHECK Constraints
14. Enterprise-Level Business Rules Enforcement
15. Transactions for Data Integrity Maintenance
16. Comparing and Synchronizing Databases


CD-ROM 13 - PROGRAMMABILITY (3 hours 4 minutes)
1. Stored Procedure Design and Programming
2. Exploring Table-Valued, XML & OUTPUT Parameters
3. Stored Procedures in AdventureWorks2008 Database
4. DML - Data Manipulation Language Triggers
5. Trigger Examples with DELETED & INSERTED Tables
6. Discovering INSTEAD OF Triggers & AFTER Triggers
7. DDL - Data Definition Language Triggers
8. Designing & Creating Views - Modifying Data
9. Table-Valued, Scalar-Valued & Inline Functions
10. Understanding Plan Guides for High Performance
11. Temporary Tables, Table Variables & tempdb
12. EXECUTE AS for Execution Context Definition
13. Multiple, Nested, Cascading & Recursive CTE-s
14. Grouping Sets for Multiple Groupings Definition
15. Spatial Data Types: Geography & Geometry
16. Applying Manual Debugging Techniques


CD-ROM 14 - TRANSACT-SQL (3 hours 1 minute)
1. TRANSACT-SQL, Batch, and Scripts
2. BEGIN, COMMIT, ROLLBACK TRANSACTION
3. Using TRY…CATCH Blocks for Exception Handling
4. Locks, Isolation Levels and Deadlocks
5. Snapshot Isolation for OLTP Concurrency
6. PROGRAMMING STATEMENTS in Transact-SQL
7. User Defined and System Stored Procedures
8. Working with Linked Servers & 4-part Reference
9. Exploring CROSS APPLY & OUTER APPLY Operators
10. DBA Script Generator Using Query Editor
11. Discovering Undocumented T-SQL Features
12. Dynamic PIVOT and Matrix (Crosstab) Scripts
13. INTERSECT and EXCEPT Set Operators
14. FILESTREAM Data and SPARSE Columns
15. Optimizing with Database Engine Tuning Advisor
16. Debugging with the Transact-SQL Debugger


CD-ROM 15 - SSIS IN THE ENTERPRISE (2 hours 52 minutes)
1. ETL & Integration Tool; Integration Services
2. SSIS Import/Export Wizard - Creating Shortcut
3. Exporting Database Data to Flat File
4. Exporting Database Data to Excel
5. Exporting Database Data to Access
6. Exporting Database Data to Another DB
7. Exporting Database Data in XML Format
8. Importing from Flat File to Database
9. Importing from Excel to Database
10. Importing from Access to Database
11. Importing OLAP Cube Data to Database
12. Importing XML Data to Database
13. Saving and Editing SSIS Package
14. Scheduling SSIS Package for Execution
15. Understanding SSIS Control Flow Basics
16. Simple SSIS Data Flow Transformations


CD-ROM 16 - SQL SERVER AGENT (2 hours 50 minutes)
1. Automating Database Administrative Tasks
2. Configuring SQL Server Agent - Startup Account
3. Reviewing Job Scheduling in Windows Environment
4. Properties of Jobs, Defining Jobs with SSMS
5. Multi Steps Jobs with Completion Options
6. Creating Jobs Using Scripts
7. Database Mail Setup for Notifications
8. Manage Schedules, Job Categories & View History
9. Configuring Operators Using MS
10. Configuring Alerts Using MS
11. Security; Configuring Proxies Using MS
12. Trouble Shooting SQL Server Agent
13. Automating Night & Weekend Processing
14. Database Maintenance Plan Jobs
15. Executing Jobs & Checking Status from Scipts
16. Exploring the Job Activity Monitor & Reports


CD-ROM 17 - DISASTER RECOVERY (3 hours 8 minutes)
1. Log Shipping for Disaster Recovery
2. Live Demonstration of Log Shipping
3. Configuring Database Transaction Log Shipping
4. Log Shipping Jobs: Backup, Copy & Restore
5. Failover to Standby DB in Case of Disaster
6. SQL Server 2008 Failover Clustering
7. Snapshot, Transactional & Merge Replication
8. Live Demonstration of Transactional Replication
9. Publishers, Subscribers & Distributors Setup
10. Replication Monitor, Agents and Profiles
11. Configuring Replication Using Scripts
12. Exploring the Distributor DB & Troubleshooting
13. Change Publishing, Distribution & Subscription
14. Database Mirroring for Failover Redundancy
15. Single Server Site Disaster Recovery Strategy
16. Compare Log Shipping, Mirroring & Clustering


CD-ROM 18 - MANAGEMENT STUDIO (3 hours 1 minute)
1. Dynamic UI, Docking, Auto Hiding Windows
2. Working with Query Editor - IntelliSense Option
3. Navigating Registered Servers & Object Explorer
4. SQL Server Activity and Performance Reports
5. DB Transactions, Disk & Index Usage Reports
6. SSIS Object Explorer - Package Management
7. Policy Management: Policies, Conditions & Facets
8. Resource Governor Configuration
9. Advanced Template Explorer and Design
10. Object Search and Object Explorer Details
11. Management Studio Top Menubar Walk Through
12. Toolbars, Server Properties & Right Click Menu
13. Databases Properties & Right Click Menu
14. Policies, Server Registration Export & Import
15. Activity Monitor and SQL Server Logs
16. Replication, Security, and Management Nodes


CD-ROM 19 - PERFORMANCE TUNING (3 hours 13 minutes)
1. Ten Step Performance Tuning Bootcamp
2. Performance Related Dynamic Management Views
3. Exploring Covering Index & SET STATISTICS IO ON
4. Reviewing Deadlock Visualization & Avoidance
5. Working with Windows Performance Monitor
6. Correlating Perfmon Chart with Profiler Trace
7. Blocking & 24/7 Monitoring of Databases
8. Setting up Trace Using SQL Profiler
9. Analyzing Trace Table or File in Query Editor
10. sp_who, sp_lock and sp_monitor Commands in QE
11. Discovering Available Options in SQL Profiler
12. Index Design for Superior Performance
13. Index Fragmentation & REBUILD with FILLFACTOR
14. Exploring Index-Related DMVs and DMFs
15. The Database Engine Tuning Advisor
16. Understanding & Using Execution Plans


CD-ROM 20 - EXTRA TOPICS (3 hours 6 minutes)
1. Sending Email Messages with Results of Queries
2. Formatting Queries/Sprocs for HTML Email
3. Scheduling Email Reports for Distribution
4. Exploring SQL Server Configuration Manager
5. Instant Trace Query in SQL Server Profiler
6. Introducing the Visual Query & View Designer
7. Advanced Design with Query & View Designer
8. XML Overview, FOR XML Clause & OPENXML
9. Discovering Xquery - XML Query Language
10. Understanding XML Query, Value & Modify Methods
11. Designing Primary & Secondary XML Indexes
12. Working with Command Prompt & xp_cmdshell
13. Improving Performance with Indexed Views
14. Full-text Indexing and Full-text Search
15. Upgrading and Migrating to SQL Server 2008
16. Service Packs, Cumulative Updates & Downloads


CD-ROM 21 - HOW TO (3 hours 3 minutes)
1. How To Resolve OLTP Performance Bottlenecks
2. How To Debug Parametrized Stored Procedures
3. How To Solve - "Worked Yesterday, Broken Today"
4. How To Cleanse Data; ISNUMERIC, ISDATE & ISNULL
5. How To Format a Date in SQL Server 2008
6. How To Setup Alert Notification for DDL Changes
7. How To Use SQLCMD Mode to Edit SQLCMD Scripts
8. How To Connect as Dedicated Administrator - DAC
9. How To Best Maintain 24/7 E-Commerce Databases
10. How To Monitor CPU Busy, Disk Reads and Writes
11. How To Use Event Viewer for Troubleshooting
12. How To Setup Linked Server & ODBC Datasource
13. How To Admin from Command Prompt; sqlservr.exe
14. How To Use the PowerShell Scripting Shell
15. How To Connect Access 2007 to SQL Server 2008
16. How To Bulk Import & Export XML Documents


Bonus CD
CD 1 T-SQL Scripts
CD 2 T-SQL Scripts
CD 3 T-SQL Scripts
CD 4 T-SQL Scripts
CD 5 T-SQL Scripts
CD 6 T-SQL Scripts
CD 7 T-SQL Scripts
CD 8 T-SQL Scripts
CD 9 T-SQL Scripts
CD 10 T-SQL Scripts
CD 11 T-SQL Scripts
CD 12 T-SQL Scripts
CD 13 T-SQL Scripts
CD 14 T-SQL Scripts
CD 16 T-SQL Scripts
CD 17 T-SQL Scripts
CD 18 T-SQL Scripts
CD 19 T-SQL Scripts
CD 20 T-SQL Scripts
CD 21 T-SQL Scripts

Availability:
Products usually ship on the next 1 or 2 business days.
Shipping worldwide with UPS Air.

 
 
 
     
  Copyright 2002-2008, SMI Corp. All Rights Reserved.  
     
  Microsoft is a trademark of Microsoft Corporation.
SQL Server 2008 is a program product of Microsoft Corporation.
SQL Server 2005 is a program product of Microsoft Corporation.
SQL Server 2000 is a program product of Microsoft Corporation.