Additional Articles

Trash Destination Adapter

by Additional Articles

sqlis.com

Integration Services (SSIS)

The Trash Destination and this article came from early experiences of using SSIS and community feedback at the time. When developing a package it is very useful to have a destination adapter that does nothing but consume rows with no setup requirement. You often want run a package part way through development, or just add a path so you can set a Data Viewer. There are stock tasks that can be used, but with the Trash Destination all columns are treated as selected automatically (usage type of read-only), so the pipeline knows they are required.

2012-07-06

2,532 reads

Steps to clean up orphaned replication settings in SQL Server

by Additional Articles

MSSQLTips.com

Replication

Learn how to clean up your orphaned replication settings.

2012-07-05

3,518 reads

Email Job Failures Report to DBA using PowerShell

by Additional Articles

Database Journal

PowerShell

MySQL introduced its own brand of job scheduling, called Events, in version 5.1. However, some Database Administrators (DBAs) feel that it isn't quite ready for prime time. This article presents a hybrid solution that uses MySQL Event Scheduling to manage the batch jobs and Windows PowerShell for the error handling.

2012-07-03

2,971 reads

Using a PowerShell Script to delete old files for SQL Server

by Additional Articles

MSSQLTips.com

PowerShell

Many clients are using custom stored procedures or third party tools to backup databases in production environments instead of using database maintenance plans. One of the things that you need to do is to maintain the number of backup files that exist on disk, so you don't run out of disk space. There are several techniques for deleting old files, but in this tip I show how this can be done using PowerShell.

2012-07-02

3,232 reads

Introduction into handling errors in PowerShell for SQL Server tasks

by Additional Articles

MSSQLTips.com

PowerShell

PowerShell is becoming a great tool for managing SQL Server tasks, but like most tasks that are coded there is always the need for error handling to deal with the unknown. PowerShell has several options for handling and capturing error details and in this tip we will explain these options using PowerShell for SQL Server examples.

2012-06-28

3,684 reads

The Lure of Simplicity in IT

by Additional Articles

SimpleTalk

Engineering

A deceptively simple solution to a business re-engineering problem can beguile companies into selecting a compromise that doesn't actually meet all their needs. Simple is great, but not at the expense of functionality. Some IT solutions are complex because the problem is complex, but they can be made conceptually clearer.

2012-06-27

3,279 reads

The Road to Professional Database Development: Database Normalization

by Additional Articles

SimpleTalk

Normalization

Not only is the process of normalization valuable for increasing data quality and simplifying the process of modifying data, but it actually makes the database perform much faster. To prove the point, Peter Larsson takes a large unnormalised database and subjects it to successive stages of normalisation.

2012-06-25

4,835 reads

Steps to Apply a Service Pack or Patch to Mirrored SQL Server Databases

by Additional Articles

MSSQLTips.com

Patching

Planning on patching my SQL Servers to the latest service pack, but not sure how to complete this for a environment that is using database mirroring? In this tip, will outline the environment and then walk through the process of patching mirrored servers.

2012-06-22

3,569 reads

SQL View: Beyond the Basics

by Additional Articles

SimpleTalk

Views

Joe Celko delves into the main uses of views, explains how the WITH CHECK OPTION works, and demonstrates how the INSTEAD OF trigger can be used in those cases where views cannot be updatable.

2012-06-21

4,945 reads

Simple Steps to Prepare Mirror Database for Mirroring in SQL Server

by Additional Articles

MSSQLTips.com

Mirroring

To prepare a database for mirroring, you need to perform the following steps: Script the restore of the latest full database backup, script the restore of every transaction log backup that has been made after that full database backup, copy the full database backup and transaction log backups to the mirror server, and run the restore scripts on the mirror server.
In this tip I will walk through these steps and provide sample scripts to prepare a database for mirroring.

2012-06-20

3,662 reads

All authors

Additional Articles

Trash Destination Adapter

Steps to clean up orphaned replication settings in SQL Server

Email Job Failures Report to DBA using PowerShell

Using a PowerShell Script to delete old files for SQL Server

Introduction into handling errors in PowerShell for SQL Server tasks

The Lure of Simplicity in IT

The Road to Professional Database Development: Database Normalization

Steps to Apply a Service Pack or Patch to Mirrored SQL Server Databases

SQL View: Beyond the Basics

Simple Steps to Prepare Mirror Database for Mirroring in SQL Server

Blogs

PlanTrace Now Supports PostgreSQL

A New Word: the Kinder Surprise

Crash-Consistent Snapshot Cloning - Hyper-V Edition

Forums

The New Wave of Security Threats

There's Too Much to Learn

How to Calculate Distance Between Coordinates in SQL Server

Question of the Day

SSoL Support on the OS