index

http://www.sqldts.com/272.aspx

These are custom tasks and tools.

Transfer Packages Sample Application 3 Sep 2002
SQLDTS.com Article: Transferring DTS Packages

41795 Hits

DTS ActiveX Helper 26 Apr 2005
A simple COM component which wraps the GetExecutionErrorInfo method using variant types for returning data, compatible with ActiveX Script Tasks. Full source code included (VB6).

11196 Hits

SQLDTS FTP Read More →

index

Use this Stored Procedur for create script from all job in one database :
And for all DataBase in SQL Server use this Stored Procedure
Maintain files of sql for each table then use cygwin to run a shell script that cats them together then run it on the server.
Code source of this article : https://stackoverflow.com/questions/3361163/automatically-create-scripts-for-all-sql-server-jobs

index

Cet article décrit les éléments suivants concernant cette version du correctif :

Les problèmes qui sont résolus par le package de correctifs
Les conditions préalables à l’installation du package de correctifs
Si vous devez redémarrer l’ordinateur après avoir installé le package de correctifs
Si le package de correctifs est remplacé par un autre package de correctif logiciel
Si vous devez modifier Read More →

index

 

Table of Contents

Introduction

Background
Prerequisites
Recommendations
Disclaimer

FAQs

Help! I’m lost!
But I don’t want to use the Brian Keller VM!
I already have MS RM set-up. What’s the minimal work I need to do to add a DB to my system?

System Overview
Exercise 1 – Source Controlling your Database

Linking a Database to source-control

Exercise 2 – Getting your Database into the Continuous Integration Process

Part Read More →

index

Simple Way To Use Pivot In SQL Query
This post intends to help T-SQL developers get started with PIVOT queries. Most business applications will need some sort of PIVOT queries and I am sure many of you must have come across pivoting requirements several times in the past.
Let us have a table name Invoice which has Read More →

tools

Liquibase is a dabasebase chane management tool. Rather than writing SQL directly against the database to create, update or drop database objects, developers define their desired database changes in XML files.
Any change to database are grouped into "ChangeSet", the best practice is one changeset per modification to make roll back easily. Changes to database can Read More →

mysql-data-at-rest-encryption

1. Install Java
Liquibase 3.x requires Java 1.6+ so lets get that installed first
2. Get the Liquibase Code
I'm just going to install put Liquibase in the home directory for now
3. Install MySQL
4. Install the MySQL connector for Java
5. Create the MySQL database
6. Create a Changelog file
Add the following...
7. Run Liquibase
8. Create a liquibase.properties file
Add the following...
9. Read More →