Excel files can be read using the Python module Pandas. In this article we will read excel files using Pandas.
Related course:
Data Analysis in Python with Pandas
Read Excel column names
We import the pandas module, including ExcelFile. The method read_excel() reads the data into a Pandas Data Frame, where the first parameter is the filename and the Read More →

Follow these instructions.

Enable Multiple RDP Sessions
Log into the server using Remote Desktop.
Open the start screen (press the Windows key) and type gpedit.msc and open it
Go to Computer Configuration > Administrative Templates > Windows Components > Remote Desktop Services > Remote Desktop Session Host > Connections.
Set Restrict Remote Desktop Services user to a single Remote Desktop 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 →

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 →

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 →