SQL and IT tutorials

Latests IT Tutorials

Python tutorials

Zip and Unzip files in Python

How to zip and unzip files using Python scripts and modules? If you’re looking for an easy and efficient way to manage your files in Python, then you’ve come to the right place. In this tutorial, we’re going to show you how to zip and unzip files in Python. Whether you’re working with large files or need to compress your data, we’ve got you

Python tutorials

Manage files in Python at file system level

How to manage files in Python like the create, delete, rename, or move operations? Python programming is a versatile language that can be used for a wide range of tasks. File management is the process of organizing, storing, and manipulating files on a computer or any remote file system. Using Python methods, you can easily automate repetitive file management tasks, such as creating, renaming,

SQL Server errors

SQL Server error login timeout expired with code 0x80004005

The SQL Server error code 0x80004005 login timeout expired is a common error that occurs when trying to connect to a SQL Server instance. This error is usually caused by a problem with the connection settings or a problem with the SQL Server instance itself. There are several reasons why this error may occur. 1. Incorrect SQL Server connection string One of the most

Python tutorials

Work with SQL Server using Python and pyodbc

How to connect to SQL Server with a Python script and the pyodbc library to create a table, select, update and delete data? Welcome to this tutorial on how to work with SQL Server databases using Python and pyodbc! In this course, you will learn how to use Python to interact with a SQL Server database. Whether you’re a beginner or an advanced user,

Python tutorials

Manage text files in Python using read and write methods

Python tutorial on how to manage text files using the open, read, readline, write, writelines, seek and close methods with scripts examples. This tutorial on how to manage text files in Python provide some information and code examples on working with files using Python scripts. Text files are a fundamental part of computer science and are used to store plain text data. They are

T-SQL Tutorials

T-SQL

Split string with delimiter into one column with SQL Server

How to split a string with delimiter with XML or STRING_SPLIT functions with SQL Server ? Split a string with delimiter, like comma or semicolon, into one column using SQL Server. With a T-SQL query, it is possible to cut a string compounded of text, delimited by commas, semicolons, tabulations, dash, underscore, or even dots. It can basically be any special character that defines

T-SQL

Alter SQL Server stored procedure

How to alter a SQL Server stored procedure already in a Microsoft database ? Simply use the alter procedure command instead of the create command to modify an existing SQL procedure. In this example let’s add the grouping on months and employees to sum up and group the data. Let’s also add a sorting option to have the Sales figures by descending amounts. How

T-SQL

SQL Server SELECT queries to select and filter data

Example queries with the SQL Server SELECT function to select, filter and display data. T-SQL tutorial to learn how to use the SQL Server select queries to display and filter data from a table. This is the basic query because SQL, for Structured Query Language, is primarily designed to query and display data from a table. The query is of the type DML for

T-SQL

Implicit conversion from data type XML to NVARCHAR T-SQL error

How to fix the SQL Server Error Implicit conversion from data type XML to NVARCHAR is not allowed? How to convert XML into NVARCHAR with SQL Server? To avoid the SQL Server error conversion from XML to NVARCHAR. The exact message is “Implicit conversion from data type xml to nvarchar is not allowed. Use the CONVERT function to run this query.”. With SQL Server

T-SQL

List user defined table types in SQL Server (UDT)

How to list user defined table types in a SQL Server database? First of all, users declare User Defined Table Type as a particular table structure in the database. This UDT is reusable in database, it is not a system table. It’s a good practice to ensure users can’t insert data with different types or length for example. Or even from different data structure.

T-SQL

Insert or remove SQL Server line breaks from text columns

How to insert or remove line breaks from SQL Server text columns and variables? Tutorial to insert or remove line breaks from SQL Server strings stored in NVARCHAR columns or variables. For example, if you export the string to excel, your line will be cut. Indeed, with SSMS, if you select data containing carriage return or new lines, then the screen displays the full

SSIS Tutorials

SSIS

How to install SSIS in Visual Studio 2019 ?

How to install the SQL Server Integration Services, i.e., SSIS projects, in Visual Studio 2019? This is a Microsoft tutorial about installing SSIS in Visual Studio 2019. Of course, we assume that Visual Studio 2019 is already installed on your computer, which is using for example the Windows 10 operating system. With Visual Studio 2017, SSIS, SSAS and SSRS projects were available with the

SSIS

Run an SSIS package from the command line using the DTExec utility

Integration Services tutorial to run SSIS packages from the command line using the DTExec utility. The DTEXEC Integration Services tool allows users to run and configure an SSIS package from the command line. Indeed, the Microsoft SQL Server suite includes the DTExec.exe executable. This is a scripting tool for controlling and setting up SSIS packages. It is possible to launch the package execution utility

SSIS

How to connect to SQL Server with SSIS ?

How to connect to a SQL Server database with SSIS to import or export data? Tutorial on how to connect to SQL Server with an SSIS package. To connect to a SQL database from an SSIS package, it is necessary and recommended to use the SSIS Connection Manager. It is also possible to use variables to manage connections strings, but it is an advanced

SSIS

Aggregate data with SSIS and the Aggregate transformation

Aggregate and sum data with SSIS to perform the equivalent of GROUP BY in SQL using the Aggregation Transformation. In an ETL project with SSIS, it is common to aggregate data with SSIS, from a SQL Server table to a higher level, such as data marts. That is, in practice, to calculate the sum of amounts for a given business level. To do this,

SSIS

Create a simple SSIS data flow

How to create a simple data flow with SSIS and Visual Studio 2019? This tutorial explains how to create a basic SSIS data flow and serves as an example to get started with a first data manipulation. That is to say to configure a package to extract, transform if necessary and finally load the data in another MS database or another SQL table. A

SSIS

Import Excel cells with SSIS into a SQL table

How do I import a range of specific Excel cells into a SQL Server table with SSIS? When importing data from an XLSX file into a SQL table, it is possible to import specific Excel cells with the SSIS options. The range will necessarily be contiguous, in other words, the Excel cells to be loaded are side by side. However, to load multiple non-contiguous

Python tutorials

Python tutorials

Python Strings

How to use Python strings and dedicated functions like concatenate, index, slice and format texts? Working with strings in Python is a very powerful tool and a long journey. It is one of the most used and important data types in any programming language. Strings are everywhere, from simple messages to complex data formats. This data type is used to display information, to store

Python tutorials

Python lists

Tutorial on Python lists and how to create, append, modify, index, insert or delete elements with scripts examples. Lists are a fundamental data structure in Python and understanding how to use them effectively is crucial for any Python developer. This tutorial covers the basics of lists, including creating and manipulating them, using list methods and comprehension, and working with multidimensional lists. Code examples and

Python tutorials

Work with Python dates and time using the datetime module

If you work with dates and time in Python, it can be a bit tricky. But with the right tools, syntaxes and best practices, it becomes much more easy. Dates and times are an essential part of many applications, and working with them in Python can be challenging. However, with the right tools, it can be quite easy. In this blog post, we will

Python tutorials

Manage text files in Python using read and write methods

Python tutorial on how to manage text files using the open, read, readline, write, writelines, seek and close methods with scripts examples. This tutorial on how to manage text files in Python provide some information and code examples on working with files using Python scripts. Text files are a fundamental part of computer science and are used to store plain text data. They are

Python tutorials

Work with SQL Server using Python and pyodbc

How to connect to SQL Server with a Python script and the pyodbc library to create a table, select, update and delete data? Welcome to this tutorial on how to work with SQL Server databases using Python and pyodbc! In this course, you will learn how to use Python to interact with a SQL Server database. Whether you’re a beginner or an advanced user,

Python tutorials

Manage files in Python at file system level

How to manage files in Python like the create, delete, rename, or move operations? Python programming is a versatile language that can be used for a wide range of tasks. File management is the process of organizing, storing, and manipulating files on a computer or any remote file system. Using Python methods, you can easily automate repetitive file management tasks, such as creating, renaming,

From all categories

Powershell

Copy files recursively in PowerShell including subfolders

This computer tutorial shows how to copy files and folders recursively in PowerShell, using the Windows Copy-Item command. The Copy-Item command allows you to copy a large number of files and folders recursively, in a single command. PowerShell is a shell used to execute commands written in the Windows PowerShell scripting language. The user can run scripts on Windows servers or clients, which are

T-SQL

Split string with delimiter into one column with SQL Server

How to split a string with delimiter with XML or STRING_SPLIT functions with SQL Server ? Split a string with delimiter, like comma or semicolon, into one column using SQL Server. With a T-SQL query, it is possible to cut a string compounded of text, delimited by commas, semicolons, tabulations, dash, underscore, or even dots. It can basically be any special character that defines

SSIS

How to install SSIS in Visual Studio 2019 ?

How to install the SQL Server Integration Services, i.e., SSIS projects, in Visual Studio 2019? This is a Microsoft tutorial about installing SSIS in Visual Studio 2019. Of course, we assume that Visual Studio 2019 is already installed on your computer, which is using for example the Windows 10 operating system. With Visual Studio 2017, SSIS, SSAS and SSRS projects were available with the

IT Concepts

SaaS or Software as a Service

Definition of the concept of SaaS or Software as a Service. Software as a Service (SaaS) is a type of software that is hosted on the cloud and can be accessed through the internet. It is also known as “software as a service” in French. One of the advantages of using SaaS for business owners is that they do not need to purchase or

IT Concepts

DBMS or Database Management System

A database management system (DBMS) is a set of hardware and software. It is a set of means that allows one or more computers or servers to store, organize and retrieve data. Firstly, a DBMS performs data storage but also manages their processing, security and integrity. The DBMS stores the information in tables where each row represents an element or object. And each column

IT Concepts

Cryptocurrency Mining definition and concepts

Definition of the Cryptocurrency mining used to calculate and validate transactions on the blockchain. What is the Cryptocurrency Mining ? It is the process of verifying transactions on a blockchain and adding them to the public ledger in exchange for a reward in the form of a cryptocurrency. It is also known as Crypto Mining or just Mining. The first miner to solve a

MS-DOS

Find my IP address with cmd

To access information on the Internet, a Windows 10 PC needs a unique address that can be used to find the desired content. This address is called the Internet Protocol Address (IP). To find my IP address on Windows 10 in CMD, there are mainly two methods, the first with the MS-DOS command prompt and the second with the graphical interface from the Windows

T-SQL

SQL Server partitioning

SQL Server table partitioning allows to physically split the data of one table on the disk. Partitioning means data division that allows to directly access one unique partition instead of all the data from the table. First, why all large tables should have partitions? When accessing hundreds of million lines, it becomes very tricky to get a large bunch of data in seconds. Partitions

T-SQL

Create a SQL Server view with encryption

How to create a SQL Server view with the encryption option? The WITH ENCRYPTION option allows you to hide the view code. Here is an example of code in T-SQL language to create a view with the WITH ENCRYPTION option. Create a SQL Server view with the encryption option First, here is the original tutorial with the script for creating the sales view used

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock