SQL Scripts & Samples

» Database Journal Home

» Database Articles

» Database Tutorials

MS SQL

Oracle

DB2

MS Access

MySQL

» RESOURCES

SQL Scripts & Samples

Tips

» Database Forum

» Slideshows

Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Advertiser Disclosure

Posted Dec 19, 2002

Marcin Policht

By DatabaseJournal.com Staff

Being a long time reader, I'm proud to join the crowd of technology gurus gathered here. I have a fair share of Microsoft exams behind me, a couple of acronyms after my name - MCSE, MCSD, and MCT, decent familiarity with majority of MS BackOffice products (SMS, SQL, Exchange, IIS), programming and scripting languages (VB, C++, VBScript with wsh) and several years of practical experience with Windows environment administration and engineering. My focus these days is on SQL Server and Windows 2000, and I'll attempt to share the most interesting experiences with these products...

Current Articles

Introduction to Azure SQL Database Instance Pools
Considerations for Deploying Azure SQL Database Managed Instances
Introduction to Azure SQL Database Auto-Failover Groups
Running Database Console Commands (DBCCs) on Azure SQL Database
Overview of Azure SQL Database Serverless
Overview of Azure SQL Database Networking
Implementing SQL Server Integration Services with Azure Data Factory
Planning for SAP HANA Deployments in Public Cloud Environments
Implementing SQL Server Integration Services with Azure Data Factory
Backup Techniques Available Exclusively When Using Azure VMs
Deployment of SQL Server 2019 Always On Availability Groups on Azure AKS
Graphical Tools for Accessing Azure Cosmos DB
Introduction to Running SQL Server 2019 on Kubernetes
Introduction to the Cosmos DB Emulator
Importing Data into Azure SQL Database
Configuring Azure SQL Databases Using Azure Resource Manager Templates
Using Azure Resource Manager Templates To Provision Azure SQL Databases
Overview of Azure SQL Database Performance Monitoring
Introduction to Azure SQL Database Hyperscale
Overview of Azure SQL Database Information Protection
Overview of In-Memory Technologies of Azure SQL Database
Azure SQL Database High Availability
Azure SQL Database Business Continuity Enhancements
Introduction to Azure Cosmos DB Global Distribution
Azure SQL Database and GDPR Compliance
Introduction to Azure Cosmos DB Security
Introduction to Azure SQL Managed Instance
Controlling Access to Azure Cosmos DB
Azure Cosmos DB Partitioning
Azure Cosmos DB Consistency Levels
Implementing Azure SQL Database Virtual Network Service Endpoints and Rules
Azure SQL Database Virtual Network Service Endpoints and Rules
Azure SQL Database Long-Term Backup Retention
Network Configuration of SQL Server Always On Availability Groups in Azure
Implementing SQL Server Failover Clustering in Azure
Implementing Azure SQL Data Sync in the Azure Portal
Introduction to Azure SQL Data Sync
Azure SQL Database - Dynamic Data Masking
Backing Up SQL Server Databases Hosted on Azure VMs
Integrating DACPAC deployments of Azure SQL Database with Visual Studio Team Services
Managing Azure SQL Database Recovery
Introduction to SAP HANA on Azure
SQL Server in Azure Virtual Machines - Performance Optimizations
Azure SQL Database - Authenticating Application Access by Using Azure AD Tokens
Azure SQL Database - Implementing Azure AD Authentication
Azure SQL Database - Azure AD Authentication
Introduction to SQL Server Stretch Database
Introduction to Azure SQL Database Temporal Tables
Introduction to the Azure SQL Database Advisor
Implementing Azure SQL Database Elastic Database Jobs
Azure SQL Database Elastic Database Jobs
Introduction to Protecting SQL Server with Azure Site Recovery
Introduction to Azure SQL Database Elastic Database Pools
Azure SQL Database Resiliency - Business Continuity
Azure SQL Database Resiliency - Point-in-Time Restore
Azure SQL Database - Transparent Data Encryption
Azure SQL Database - Row-Level Security
Automated Patching of SQL Server IaaS VMs
Automated Backups of SQL Server Databases in Azure IaaS VMs
Automating Image-Based Deployment of SQL Server on Azure IaaS VMs - Completing the Process
Automating Image-Based Deployment of SQL Server on Azure IaaS VMs - Combining OS Installation and SQL Server Sysprep
Automating Image-Based Deployment of SQL Server on Azure IaaS VMs - Preparing SQL Server
Automating Image-Based Deployment of SQL Server on Azure IaaS VMs - Preparing OS Image
Introduction to Automating Deployment of SQL Server in Azure IaaS Virtual Machines
Managing Azure SQL Database Authorization
Azure SQL Database Auditing
Introduction to Azure SQL Database Scalability
Monitoring Azure SQL Database
Performing Azure SQL Database Management Tasks by Using PowerShell with REST API
Management of Windows Azure SQL Databases via PowerShell with REST APIs
Using PowerShell to Manage Windows Azure SQL Databases
Introduction to SQL Server in Microsoft Azure
Microsoft Azure SQL Database Security - Authentication, Authorization, and Encryption
Microsoft Azure SQL Database Security - Firewall Configuration
Windows Azure SQL Database - Uploading Data by Using the bcp Utility
Windows Azure SQL Database - Uploading Data by using SQL Server Integration Services
Migrating SQL Server Databases to Windows Azure by Leveraging BACPAC Files
Migrating SQL Server Database to Windows Azure - Deploying SQL Database
Migrating SQL Server Database to Windows Azure - Resolving Incompatibility Issues
Identifying Incompatibility Issues When Migrating SQL Server Database to Windows Azure
SSIS 2012 - Introduction to Windows Azure SQL Databases
SSIS 2012 - Using PowerShell to Remotely Execute File System Packages in Multi-Server Scenarios
SSIS 2012 - Using PowerShell to Remotely Execute File System Packages
SQL Server 2012 Integration Services - Leveraging PowerShell in Package Deployment Model
SQL Server 2012 Integration Services - Using PowerShell to Configure Project Environments
SQL Server 2012 Integration Services - Using PowerShell to Configure Package Execution Parameters
SQL Server 2012 Integration Services - PowerShell-Based Project Deployment
SQL Server 2012 Integration Services - Introduction to PowerShell-based Management of SSIS
SQL Server 2012 Integration Services - Introduction to Managing SQL Server with PowerShell
Securing SQL Server 2012 Integration Services Packages using Digital Certificates
SQL Server 2012 Integration Services - Implementing Package Security using Access Control
SQL Server 2012 Integration Services - Unattended Execution of SSIS Packages
SQL Server 2012 Integration Services - GUI-Friendly Ways of Managing Execution of SSIS Packages
SQL Server 2012 Integration Services - Advanced Functionality of Dtexec.exe
SQL Server 2012 Integration Services - Using dtexec.exe to Run File System-based Packages
SQL Server 2012 Integration Services- Using Environments in Package Execution
SQL Server 2012 Integration Services - Package Deployment
SQL Server 2012 Integration Services - Package and Project Configurations
SQL Server 2012 Integration Services - Project Deployment
SQL Server 2012 Integration Services - Package and Project Parameters
SQL Server 2012 Integration Services - Package Variables
SQL Server 2012 Integration Services - Installation and Initial Configuration
SQL Server 2012 Integration Services - Overview
SQL Server 2008 and 2008 R2 Integration Services - Sort Transformation
SQL Server 2008 and 2008 R2 Integration Services - Sampling Transformations
SQL Server 2008 and 2008 R2 Integration Services - Dimension Processing Data Flow Destination
SQL Server 2008 and 2008 R2 Integration Services - Partition Processing Data Flow Destination
SQL Server 2008 and 2008 R2 Integration Services - Customizing Slowly Changing Dimension Transformation
SQL Server 2008 and 2008 R2 Integration Services - Slowly Changing Dimension Transformation - Historical Attributes
SQL Server 2008 and 2008 R2 Integration Services - Slowly Changing Dimension Transformation - Type 1 Changes
Data Mining Model Training Destination in SQL Server Integration Services
Data Mining Query Transformation in SQL Server Integration Services
Data Mining Query Task in SQL Server Integration Services
SQL Server 2008 and 2008 R2 Integration Services - Analysis Services Execute DDL Task
SQL Server 2008 and 2008 R2 Integration Services - Analysis Services Processing Task
SQL Server 2008 and 2008 R2 Integration Services - Using Script Task To Implement FTP Functionality
SQL Server 2008 and 2008 R2 Integration Services - FTP Task
SQL Server 2008 and 2008 R2 Integration Services - Consuming Web Services Using Script Task
SQL Server 2008 and 2008 R2 Integration Services - Message Queuing Using Script Task
SQL Server 2008 and 2008 R2 Integration Services - Managing Remote Processes Using Script Task
SQL Server 2008 and 2008 R2 Integration Services - Managing Local Processes Using Script Task
SQL Server 2008 and 2008 R2 Integration Services - Starting Local Processes
SSIS Script Task and Microsoft Office Automation
Accessing Excel Via ADO.NET Using SSIS Script Task
Script Task and Event Logging in SSIS
Interacting with File System Objects Using SSIS Script Task
Script Task Exception Handling in SSIS
Querying Active Directory using SSIS Script Task
Introduction to SSIS Script Task
Using SSIS Logging to Resolve Runtime Errors and Performance Issues
SSIS Events and Handlers
Protecting the Integrity of SSIS Packages Using Digital Signatures
Securing the Content of SSIS Packages
Executing SSIS Packages Using DTExec
Implementing SSIS Package Configurations
How to Implement Package Variables in SQL Server 2008
The Advantages of Using Variables in SSIS Package Configurations
Characteristics and Common Usage Scenarios of SSIS Variables
Exploring Derived Column Transformation in SQL Server Integration Services
SQL Server Integration Services 2008: Importing Excel Data Using Derived Column Transformation
Importing Excel data into SSIS 2008 using Data Conversion Transformation
SSIS 2008 Import and Export Wizard and Excel-based Data
New and Improved Functionality in SSIS 2008
Introduction to Control Flow and Data Flow of SSIS 2008
SQL Server - Introduction to Business Intelligence Development Studio
SSIS Packages - the Simplest Way to Create Them
Installing and configuring SQL Server 2008 and 2008 R2 Integration Services
Introducing SQL Server 2008 and 2008 R2 Integration Services
Full Text Index Queries using CONTAINS and CONTAINSTABLE
Data searches that leverage existing indexes
Full Text Index Management in SQL Server 2005 Express Edition
Full Text Index Implementation in SQL Server 2005 Express Edition
Full Text Catalog Configuration in SQL Server 2005 Express Edition
Troubleshooting Reporting Services Performance Issues
Troubleshooting Reporting Services
Securing Reporting Services
Securing Reporting Services Data Sources
Securing Data using Linked and Parameterized Reports
Reporting Services System and Item Security
Reporting Services Content Management
Introduction to SQL Server 2005 Express Edition Reporting Services Content Management
Taking Advantage of Sample Reporting Services Reports
The Basic Functionality of Report Designer
Basic Server Reporting Functionality in SQL Server 2005 Express Edition
Initial Configuration of Reporting Services on SQL Server 2005 Express Edition
Installing Reporting Services on SQL Server 2005 Express Edition
SQL Server 2008 Administration in Action by Rod Colledge
Service Broker Poison Message Handling
Handling Service Broker Errors
Service Broker Transactional Support in SQL Server 2005 Express Edition
Security Context of Service Broker Internal Activation
Service Broker Activation in SQL Server 2005 Express Edition
Configuring Anonymous Dialog Security in SQL Server 2005 Express Service Broker Conversation
Conducting Service Broker Conversation Using Full Dialog Security in SQL Server 2005 Express Service
Configuring Full Dialog Security in SQL Server 2005 Express Service Broker Conversation
Configuring Transport Encryption in SQL Server 2005 Express Service Broker Conversation
Establishing Distributed SQL Server Express' Service Broker Conversations Using Certificate-based Authentication
Configuring Certificate-based Authentication in SQL Server Express' Distributed Service Broker Environment
SQL Server 2005 Express Edition - Part 32 - Distributed Service Broker Environment - Conducting Dialogs
SQL Server 2005 Express Edition - Part 31 - Distributed Service Broker Environment - Routing
SQL Server 2005 Express Edition - Part 30 - Distributed Service Broker Environment - Endpoints
SQL Server 2005 Express Edition - Part 29 - Implementing Service Broker Conversation
SQL Server 2005 Express Edition - Part 28 - Implementing Service Broker Conversation
SQL Server 2005 Express Edition - Part 27 - Implementing Basic Service Broker Objects
SQL Server 2005 Express Edition - Part 26 - Introduction to Service Broker
Implementing Upgrade of SQL Server 2005 Express Edition
SQL Server 2005 Express Edition - Part 24 - Planning Upgrade of SQL Server 2005 Express Edition
SQL Server 2005 Express Edition - Part 23 - Manual Upgrade from Microsoft SQL Server Desktop Engine (MSDE)
SQL Server 2005 Express Edition - Part 22 - Upgrading from Microsoft SQL Server Desktop Engine (MSDE)
SQL Server 2005 Express Edition - Part 21 - Using Replication Management Objects
SQL Server 2005 Express Edition - Part 20 - Authenticating Merge Web Synchronization
SQL Server 2005 Express Edition - Part 19 - Authenticating Merge Web Synchronization
SQL Server 2005 Express Edition - Part 18 - Merge Web Synchronization Setup
SQL Server 2005 Express Edition - Part 17 - Merge Web Synchronization
SQL Server 2005 Express Edition - Part 16 - Transactional and Merge Replication
SQL Server 2005 Express Edition - Part 15 - Snapshot Replication
SQL Server 2005 Express Edition - Part 14 - Replication Support
SQL Server 2005 Express Edition - Part 13 - ClickOnce Deployment and Security
SQL Server 2005 Express Edition - Part 12 - ClickOnce Deployment and Updates
SQL Server 2005 Express Edition - Part 11 - ClickOnce Deployment and Maintenance Options
SQL Server 2005 Express Edition - Part 10
SQL Server 2005 Express Edition - Part 9 - Managing User Instances
SQL Server 2005 Express Edition - Part 8 - XCopy Deployment
SQL Server 2005 Express Edition - Part 7 - Post Installation Configuration Tasks (Management)
SQL Server 2005 Express Edition - Part 6 - Post Installation Configuration Tasks (Encryption)
SQL Server 2005 Express Edition - Part 5 - Post-Installation Network Configuration Tasks
SQL Server 2005 Express Edition - Part 4 - Surface Area Configration
SQL Server 2005 Express Edition - Part 3 - Installation
SQL Server 2005 Express Edition - Part 2
SQL Server 2005 Express Edition - Part 1
SQL Server 2005 Integration Services - Templates, Data Sources, and Data Source Views - Part 50
SQL Server 2005 Integration Services - Part 49 - Maintenance Plan Tasks
SQL Server 2005 Integration Services - Part 48
SQL Server 2005 Integration Services - Maintenance Plan Tasks - Part 47
SQL Server 2005 Integration Services - Maintenance Plan Tasks - Part 46
SQL Server 2005 Integration Services - Part 45 - Bulk Insert Task and Format Files
SQL Server 2005 Integration Services - Part 44 - Bulk Insert Task
SQL Server 2005 Integration Services - Part 43 - XML Task continued
SQL Server 2005 Integration Services - Part 42 - XML Task continued
SQL Server 2005 Integration Services - Part 41 - XML Task
SQL Server 2005 Integration Services - Part 40 - Web Service Task
SQL Server 2005 Integration Services - Part 39 - Send Mail Task
SQL Server 2005 Integration Services - Part 38 - Pivot Transformation
SQL Server 2005 Integration Services - Part 37 - Derived Column Transformation
SQL Server 2005 Integration Services - Part 36 - Term Extraction and Term Lookup
SQL Server 2005 Integration Services - Fuzzy Grouping - Part 35
SQL Server 2005 Integration Services - Fuzzy Lookup - Part 34
SQL Server 2005 Integration Services - Lookup Transformation - Part 33
SQL Server 2005 Integration Services - Message Queue Task - Part 32
SQL Server 2005 Integration Services - Performance - Part 31
SQL Server 2005 Integration Services - Performance - Part 30
SQL Server 2005 Integration Services - Digital Signing of Packages - Part 29
SQL Server 2005 Integration Services - Security - Part 28
SQL Server 2005 Integration Services - Working with SQL Server 2000 DTS Packages - Part 27
SQL Server 2005 Integration Services - Checkpoints - Part 26
SQL Server 2005 Integration Services - Transaction Support - Part 25
SQL Server 2005 Integration Services - Package Execution - Part 24
SQL Server 2005 Integration Services - Packages Deployment - Part 23
SQL Server 2005 - SQL Server Integration Services - Package Management - Part 22
SQL Server 2005 Integration Services - Import and Export Wizard
SQL Server 2005 Integration Services - Migration Tasks
SQL Server 2005 Integration Services - Part 19
SQL Server 2005 Integration Services - Part 18
SQL Server 2005 Integration Services - Part 17
SQL Server 2005 Integration Services - Part 16
SQL Server 2005 - SQL Server Integration Services - Debugging Script Component - Part 15
SQL Server 2005 - SQL Server Integration Services - Part 14 - Debugging Data Flow
SQL Server 2005 - SQL Server Integration Services - Part 13
SQL Server 2005 - SQL Server Integration Services - Part 12 - Logging
SQL Server 2005 - SQL Server Integration Services - Part 11 - SSIS Events and Event Handlers
SQL Server 2005 - SQL Server Integration Services - Part 10
SQL Server 2005 - SQL Server Integration Services - Part 9
SQL Server 2005 - SQL Server Integration Services - Part 8
SQL Server 2005 - SQL Server Integration Services - Part 7
SQL Server 2005 - SQL Server Integration Services - Part 6
SQL Server 2005 - SQL Server Integration Services - Part 5
SQL Server 2005 - SQL Server Integration Services - Loop Containers
SQL Server 2005 - SQL Server Integration Services - Part 4
SQL Server 2005 - SQL Server Integration Services - Part 3
SQL Server 2005 - SQL Server Integration Services - Part 2
SQL Server 2005 - SQL Server Integration Services - Part 1
SQL Server 2005 - Setup and Deployment
SQL Server 2005 - Management Utilities
SQL Server 2005 Part 1 - Tools
SQL Server 2005 Security - Part 4
SQL Server 2005 Security - Part 3 Encryption
SQL Server 2005 Security - Part 2 Authorization
SQL Server 2005 Part 1 - Security (Authentication)
SQL Server 2005 Part 5 - High Availability and Scalability Enhancements
SQL Server 2005 Part 4 - High Availability and Scalability Enhancements - Online Indexing, Fast Recovery, Database Snapshots, and Snapshot Isolation
SQL Server 2005 Part 3 - High Availability and Scalability Enhancements - Failover Clustering
SQL Server 2005 Part 2 - High Availability and Scalability Enhancements - Database Mirroring
SQL Server 2005 Part 1 Introduction
SQL Server 2000 Security - Part 14 - Conclusion - Pre- and Post- Installation Recommendations
SQL Server 2000 Security - Part 13 - SQL Injection attack
SQL Server 2000 Security - Part 12 - Auditing with Meta Data Services
SQL Server 2000 Security - Part 11 - DTS Security
SQL Server 2000 Security - Part 10 - Auditing
SQL Server 2000 Security - Part 9 - Replication Security
SQL Server 2000 Security - Part 8 - Introduction to Replication Security
SQL Server 2000 Security - Part 7 - Statement and Object Permissions
SQL Server 2000 Security - Part 6 - Ownership and Object Permissions
SQL Server 2000 Security - Part 5 (Application roles)
SQL Server 2000 Security - Part 4 (Authorization)
SQL Server 2000 Security - Part 3 (Service Accounts)
SQL Server 2000 Security - Part 2 (Authentication)
SQL Server 2000 Security - Part 1 (Net Libraries)
SQL Server 2000 DTS Part 12 - Transactional Support
SQL Server 2000 DTS Part 11 - DTS Designer Tasks - the Message Queue task
SQL Server 2000 DTS Part 10 - DTS Designer Tasks - The Data Driven Query Task
SQL Server 2000 DTS Part 9 - DTS Designer Tasks
SQL Server 2000 DTS Part 8 - DTS Designer Tasks - Transform Data Task
SQL Server 2000 DTS Part 7 - DTS Designer Tasks: the ActiveX Script task
SQL Server 2000 DTS Part 6 - DTS Designer Tasks and Package Workflow
SQL Server 2000 DTS Part 5 - DTS Designer Tasks and Global Variables
SQL Server 2000 DTS Part 4 - DTS Designer Tasks
SQL Server 2000 DTS Part 3 - DTS Designer Connections
SQL Server 2000 DTS Part 2 - Creating DTS Packages using Wizards
SQL Server 2000 DTS Part 1
SQL 2000 and Web Services (XML and SQL part 11)
SQLISAPI and XML Client-Side Processing (XML and SQL part 10)
Using DiffGrams for XML data modifications (XML and SQL part 9)
XML and SQL 2000 (Part 8)
XML and SQL 2000 (Part 7)
XML and SQL 2000 (Part 6)
XML and SQL 2000 (Part 5)
XML and SQL 2000 (Part 4)
XML and SQL 2000 (Part 3)
XML and SQL 2000 (Part 2)
XML and SQL 2000 (Part 1)
SQL Server 2000 Active Directory Integration
Scalability and High Availability of Microsoft SQL Server 2000 (Part 4)
Scalability and High Availability of Microsoft SQL Server 2000 (Part 3)
Scalability and High Availability of Microsoft SQL Server 2000 (Part 2)
Scalability and high availability of Microsoft SQL Server 2000 (Part 1)
Automating SQL Server Management with WMI (part 5)
Automating SQL Server Management with WMI (part 4)
Automating SQL Server Management with WMI (Part 3)

SQL Server 2008 and 2008 R2 Integration Services

Querying Active Directory using SSIS Script Task
Introduction to SSIS Script Task
Using SSIS Logging to Resolve Runtime Errors and Performance Issues
SSIS Events and Handlers
Protecting the Integrity of SSIS Packages Using Digital Signatures
Securing the Content of SSIS Packages
Executing SSIS Packages Using DTExec
Implementing SSIS Package Configurations
How to Implement Package Variables in SQL Server 2008
The Advantages of Using Variables in SSIS Package Configurations
Characteristics and Common Usage Scenarios of SSIS Variables
Exploring Derived Column Transformation in SQL Server Integration Services
SQL Server Integration Services 2008: Importing Excel Data Using Derived Column Transformation
Importing Excel data into SSIS 2008 using Data Conversion Transformation
SSIS 2008 Import and Export Wizard and Excel-based Data
New and Improved Functionality in SSIS 2008
Introduction to Control Flow and Data Flow of SSIS 2008
SQL Server - Introduction to Business Intelligence Development Studio
SSIS Packages - the Simplest Way to Create Them
Installing and configuring SQL Server 2008 and 2008 R2 Integration Services
Introducing SQL Server 2008 and 2008 R2 Integration Services

SQL Server 2005 Express Edition

Full Text Index Queries using CONTAINS and CONTAINSTABLE
Data searches that leverage existing indexes
Full Text Index Management in SQL Server 2005 Express Edition
Full Text Index Implementation in SQL Server 2005 Express Edition
Full Text Catalog Configuration in SQL Server 2005 Express Edition
Troubleshooting Reporting Services Performance Issues
Troubleshooting Reporting Services
Securing Reporting Services
Securing Reporting Services Data Sources
Securing Data using Linked and Parameterized Reports
Reporting Services System and Item Security
Reporting Services Content Management
Introduction to SQL Server 2005 Express Edition Reporting Services Content Management
Taking Advantage of Sample Reporting Services Reports
The Basic Functionality of Report Designer
Basic Server Reporting Functionality in SQL Server 2005 Express Edition
Initial Configuration of Reporting Services on SQL Server 2005 Express Edition
Service Broker Poison Message Handling
Handling Service Broker Errors
Service Broker Transactional Support in SQL Server 2005 Express Edition
Security Context of Service Broker Internal Activation
Service Broker Activation in SQL Server 2005 Express Edition
Configuring Anonymous Dialog Security in SQL Server 2005 Express Service Broker Conversation
Conducting Service Broker Conversation Using Full Dialog Security in SQL Server 2005 Express Service
Configuring Full Dialog Security in SQL Server 2005 Express Service Broker Conversation
Configuring Transport Encryption in SQL Server 2005 Express Service Broker Conversation
Establishing Distributed SQL Server Express' Service Broker Conversations Using Certificate-based Authentication
Configuring Certificate-based Authentication in SQL Server Express' Distributed Service Broker Environment
SQL Server 2005 Express Edition - Part 32 - Distributed Service Broker Environment - Conducting Dialogs
SQL Server 2005 Express Edition - Part 31 - Distributed Service Broker Environment - Routing
SQL Server 2005 Express Edition - Part 30 - Distributed Service Broker Environment - Endpoints
SQL Server 2005 Express Edition - Part 29 - Implementing Service Broker Conversation
SQL Server 2005 Express Edition - Part 28 - Implementing Service Broker Conversation
SQL Server 2005 Express Edition - Part 27 - Implementing Basic Service Broker Objects
SQL Server 2005 Express Edition - Part 26 - Introduction to Service Broker
Implementing Upgrade of SQL Server 2005 Express Edition
SQL Server 2005 Express Edition - Part 24 - Planning Upgrade of SQL Server 2005 Express Edition
SQL Server 2005 Express Edition - Part 23 - Manual Upgrade from Microsoft SQL Server Desktop Engine (MSDE)
SQL Server 2005 Express Edition - Part 22 - Upgrading from Microsoft SQL Server Desktop Engine (MSDE)
SQL Server 2005 Express Edition - Part 21 - Using Replication Management Objects
SQL Server 2005 Express Edition - Part 20 - Authenticating Merge Web Synchronization
SQL Server 2005 Express Edition - Part 19 - Authenticating Merge Web Synchronization
SQL Server 2005 Express Edition - Part 18 - Merge Web Synchronization Setup
SQL Server 2005 Express Edition - Part 17 - Merge Web Synchronization
SQL Server 2005 Express Edition - Part 16 - Transactional and Merge Replication
SQL Server 2005 Express Edition - Part 15 - Snapshot Replication
SQL Server 2005 Express Edition - Part 14 - Replication Support
SQL Server 2005 Express Edition - Part 13 - ClickOnce Deployment and Security
SQL Server 2005 Express Edition - Part 12 - ClickOnce Deployment and Updates
SQL Server 2005 Express Edition - Part 11 - ClickOnce Deployment and Maintenance Options
SQL Server 2005 Express Edition - Part 10
SQL Server 2005 Express Edition - Part 9 - Managing User Instances
SQL Server 2005 Express Edition - Part 8 - XCopy Deployment
SQL Server 2005 Express Edition - Part 7 - Post Installation Configuration Tasks (Management)
SQL Server 2005 Express Edition - Part 6 - Post Installation Configuration Tasks (Encryption)
SQL Server 2005 Express Edition - Part 5 - Post-Installation Network Configuration Tasks
SQL Server 2005 Express Edition - Part 4 - Surface Area Configration
SQL Server 2005 Express Edition - Part 3 - Installation
SQL Server 2005 Express Edition - Part 2
SQL Server 2005 Express Edition - Part 1

SQL Server 2005 Integration Services

SQL Server 2005 Integration Services - Templates, Data Sources, and Data Source Views - Part 50
SQL Server 2005 Integration Services - Part 49 - Maintenance Plan Tasks
SQL Server 2005 Integration Services - Part 48
SQL Server 2005 Integration Services - Maintenance Plan Tasks - Part 47
SQL Server 2005 Integration Services - Maintenance Plan Tasks - Part 46
SQL Server 2005 Integration Services - Part 45 - Bulk Insert Task and Format Files
SQL Server 2005 Integration Services - Part 44 - Bulk Insert Task
SQL Server 2005 Integration Services - Part 43 - XML Task continued
SQL Server 2005 Integration Services - Part 42 - XML Task continued
SQL Server 2005 Integration Services - Part 41 - XML Task
SQL Server 2005 Integration Services - Part 40 - Web Service Task
SQL Server 2005 Integration Services - Part 39 - Send Mail Task
SQL Server 2005 Integration Services - Part 38 - Pivot Transformation
SQL Server 2005 Integration Services - Part 37 - Derived Column Transformation
SQL Server 2005 Integration Services - Part 36 - Term Extraction and Term Lookup
SQL Server 2005 Integration Services - Fuzzy Grouping - Part 35
SQL Server 2005 Integration Services - Fuzzy Lookup - Part 34
SQL Server 2005 Integration Services - Lookup Transformation - Part 33
SQL Server 2005 Integration Services - Message Queue Task - Part 32
SQL Server 2005 Integration Services - Performance - Part 31
SQL Server 2005 Integration Services - Performance - Part 30
SQL Server 2005 Integration Services - Digital Signing of Packages - Part 29
SQL Server 2005 Integration Services - Security - Part 28
SQL Server 2005 Integration Services - Working with SQL Server 2000 DTS Packages - Part 27
SQL Server 2005 Integration Services - Checkpoints - Part 26
SQL Server 2005 Integration Services - Transaction Support - Part 25
SQL Server 2005 Integration Services - Package Execution - Part 24
SQL Server 2005 Integration Services - Packages Deployment - Part 23
SQL Server 2005 - SQL Server Integration Services - Package Management - Part 22
SQL Server 2005 Integration Services - Import and Export Wizard
SQL Server 2005 Integration Services - Migration Tasks
SQL Server 2005 Integration Services - Part 19
SQL Server 2005 Integration Services - Part 18
SQL Server 2005 Integration Services - Part 17
SQL Server 2005 Integration Services - Part 16
SQL Server 2005 - SQL Server Integration Services - Debugging Script Component - Part 15
SQL Server 2005 - SQL Server Integration Services - Part 14 - Debugging Data Flow
SQL Server 2005 - SQL Server Integration Services - Part 13
SQL Server 2005 - SQL Server Integration Services - Part 12 - Logging
SQL Server 2005 - SQL Server Integration Services - Part 11 - SSIS Events and Event Handlers
SQL Server 2005 - SQL Server Integration Services - Part 10
SQL Server 2005 - SQL Server Integration Services - Part 9
SQL Server 2005 - SQL Server Integration Services - Part 8
SQL Server 2005 - SQL Server Integration Services - Part 7
SQL Server 2005 - SQL Server Integration Services - Part 6
SQL Server 2005 - SQL Server Integration Services - Part 5
SQL Server 2005 - SQL Server Integration Services - Loop Containers
SQL Server 2005 - SQL Server Integration Services - Part 4
SQL Server 2005 - SQL Server Integration Services - Part 3
SQL Server 2005 - SQL Server Integration Services - Part 2
SQL Server 2005 - SQL Server Integration Services - Part 1

SQL Server 2005

SQL Server 2005 - Setup and Deployment
SQL Server 2005 - Management Utilities
SQL Server 2005 Part 1 - Tools

SQL Server 2005 Security

SQL Server 2005 Security - Part 4
SQL Server 2005 Security - Part 3 Encryption
SQL Server 2005 Security - Part 2 Authorization
SQL Server 2005 Part 1 - Security (Authentication)

SQL Server 2005 High Availability and Scalability Enhancements

SQL Server 2005 Part 5 - High Availability and Scalability Enhancements
SQL Server 2005 Part 4 - High Availability and Scalability Enhancements - Online Indexing, Fast Recovery, Database Snapshots, and Snapshot Isolation
SQL Server 2005 Part 3 - High Availability and Scalability Enhancements - Failover Clustering
SQL Server 2005 Part 2 - High Availability and Scalability Enhancements - Database Mirroring
SQL Server 2005 Part 1 Introduction

SQL Server 2000 Security

SQL Server 2000 Security - Part 14 - Conclusion - Pre- and Post- Installation Recommendations
SQL Server 2000 Security - Part 13 - SQL Injection attack
SQL Server 2000 Security - Part 12 - Auditing with Meta Data Services
SQL Server 2000 Security - Part 11 - DTS Security
SQL Server 2000 Security - Part 10 - Auditing
SQL Server 2000 Security - Part 9 - Replication Security
SQL Server 2000 Security - Part 8 - Introduction to Replication Security
SQL Server 2000 Security - Part 7 - Statement and Object Permissions
SQL Server 2000 Security - Part 6 - Ownership and Object Permissions
SQL Server 2000 Security - Part 5 (Application roles)
SQL Server 2000 Security - Part 4 (Authorization)
SQL Server 2000 Security - Part 3 (Service Accounts)
SQL Server 2000 Security - Part 2 (Authentication)
SQL Server 2000 Security - Part 1 (Net Libraries)

SQL Server 2000 DTS

SQL Server 2000 DTS Part 12 - Transactional Support
SQL Server 2000 DTS Part 11 - DTS Designer Tasks - the Message Queue task
SQL Server 2000 DTS Part 10 - DTS Designer Tasks - The Data Driven Query Task
SQL Server 2000 DTS Part 9 - DTS Designer Tasks
SQL Server 2000 DTS Part 8 - DTS Designer Tasks - Transform Data Task
SQL Server 2000 DTS Part 7 - DTS Designer Tasks: the ActiveX Script task
SQL Server 2000 DTS Part 6 - DTS Designer Tasks and Package Workflow
SQL Server 2000 DTS Part 5 - DTS Designer Tasks and Global Variables
SQL Server 2000 DTS Part 4 - DTS Designer Tasks
SQL Server 2000 DTS Part 3 - DTS Designer Connections
SQL Server 2000 DTS Part 2 - Creating DTS Packages using Wizards
SQL Server 2000 DTS Part 1

XML and SQL 2000

SQL 2000 and Web Services (XML and SQL part 11)
SQLISAPI and XML Client-Side Processing (XML and SQL part 10)
Using DiffGrams for XML data modifications (XML and SQL part 9)
XML and SQL 2000 (Part 8)
XML and SQL 2000 (Part 7)
XML and SQL 2000 (Part 6)
XML and SQL 2000 (Part 5)
XML and SQL 2000 (Part 4)
XML and SQL 2000 (Part 3)
XML and SQL 2000 (Part 2)
XML and SQL 2000 (Part 1)

Scalability and high availability of Microsoft SQL Server 2000

Scalability and High Availability of Microsoft SQL Server 2000 (Part 4)
Scalability and High Availability of Microsoft SQL Server 2000 (Part 3)
Scalability and High Availability of Microsoft SQL Server 2000 (Part 2)
Scalability and high availability of Microsoft SQL Server 2000 (Part 1)

Automating SQL Server Management with WMI

Automating SQL Server Management with WMI (part 5)
Automating SQL Server Management with WMI (part 4)
Automating SQL Server Management with WMI (Part 3)
Automating SQL Server Management with WMI (Part 2)
Automating SQL Server Management with WMI (Part 1)