SSISTester
Quand j'ai commencé à réfléchir à une infrastructure de test pour les packages SSIS, j'ai trouvé trois aspects importants. Tout d'abord, je voulais avoir un UX semblable à l'écriture de tests en utilisant l'infrastructure de test de Visual Studio , donc la méthode typique mettant en cause le programme d'installation, de vérification et de nettoyage … Read More →
Beginning back with SQL Server® 2005, Microsoft® integrated the .NET runtime into the database engine. This runtime engine is called the SQL Server Common Language Runtime (CLR), and is commonly referred to as SQLCLR. SQL Server CLR enables you to extend the capabilities of the SQL Server database engine with the rich programming environment of … Read More →
Sometimes you can get “VT-x is not available. (VERR_VMX_NO_VMX)” error if you are trying to start x64 bit virtual machine in VirtualBox.
Failed to open a session for the virtual machine Windows 10 TP.
VT-x is not available. (VERR_VMX_NO_VMX).
Result Code: E_FAIL (0x80004005)
Component: Console
Interface: IConsole {8ab7c520-2442-4b66-8d74-4ff1e195d2b6}
There are three most common reasons for this error:
Your CPU doesn’t support VT-x … Read More →
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 →
One of the things that has always bugged me about DTS is how difficult it was to transfer the DTS packages from SQL Server to structured storage (aka a file on the disk). In Yukon, DTS packages are always stored as files but in SQL Server 2000 they are stored in SQL Server by default. … Read More →
An easy way to script, document and backup all SQL Agent job using Powershell. The script will create a SQL job called "Backup SQL Agent Jobs" which will script all job and save the script in the specified location.
Code source of article : http://www.dbascript.com/script-all-sql-agent-jobs-using-powershell
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
I recently had to look at a problem that required converting the column values from a set of rows into a single comma separated string. On the face of it this is quite straightforward, but as with many things SQL Server there is more than one way to solve the problem. I’ve presented a few … Read More →
This article illustrates how to call a web service using SQL Server Integration Services (SSIS), store the XML results in a SQL Server database table then query the XML using XQuery.
Introduction
Often enough, there is a huge benefit in knowing how to leverage SQL Server Integration Services to accomplish a data task that depends on a … Read More →
So now I have to resort to doing web service calls the old way, making post requests using MSXML. This is what my stored procedure looks like.
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 →
code source : http://sqlfiddle.com/#!3/210df/2
The other day I truly had a dumbstruck, absolutely floored, speechless moment. I tried to run SQL Server Management Studio and was presented with an error telling me that an exception has been thrown by the target of an invocation. Well that error message was about as helpful as the first time I ever saw the … Read More →
Lorsqu’on travaille sur plusieurs projets, avec différentes technologies, on est amené à faire l’installation de nombreux logiciels pour avoir l’environnement adéquat pour chaque projet. Et même si l’on travaille avec une certaine version d’un logiciel, il faut parfois avoir deux ou trois autres versions d’installées simultanément. Même si de nos jours la performance et la … Read More →
Creating XML
One common requirement is to create an XML structure that is based on the schema of an existing table. Let’s assume that we’ve received a request to create XML data from relevant fields in the Person.Person table, for the person having BusinessEntityID 10001. We need to gather the values from this row:
We need to … Read More →
Table des matières
Qu'est ce que VNC
Prérequis
Installation de tigervnc
Configuration
Les utilisateurs
Les services
Le parefeu
Activation des services
La connexion
Qu'est ce que VNC
Pour toutes les informations sur le protocole VNC se référer à l'article Le service VNC
Prérequis
Il faut bien entendu avoir une interface graphique opérationnelle (Ici GNOME)
On met le système à jour :
Code BASH :
yum update
Installation de tigervnc
On installe les paquets … Read More →
Step 1.
Launch Visual Studio, Select menu Tools | Extension Manager,
Search online gallery for Git Source Control Provider
Download and install.
Step 2.
Go to Tools | Options.
Select Source Control in the tree view
Select Git Source Control Provider from the drop down list, and click OK.
Also, please verify the paths to your favorited git tools are setup correctly.
Open Git … Read More →
Objectives
To develop and test in distributed environment you might use virtualizing tool like VirtualBox to imitate the environment of where number of servers and complex networks resides. But still, you have to move around through VM windows. In order to access all virtual servers using SSH just like we do in the real world, several … Read More →
wpad is short for Web Proxy Autodiscovery Protocol. It's used to tell your browser what proxy it can use without having to go to each and every pc on your network to do so.