Category: SQL Server

C# – Connecting to SQL Server on Ubuntu20.04 -VS Code No.104

Posted on by kumoman

This blog provides instructions on how to connect to and run a select query in SQL Server on Ubuntu 20.04 using .NET Data Provider for SQL Server (SqlClient). Contents ▼1. Connecting to SQL Server on Ubuntu by C#2-1. Installing Ubuntu 20.04.2 LTS2-2. Installing Visual Studio Code2-3. Installing C# extension2-4. Adding “Microsoft package signing key” into the list of trusted keys and adding the package repository as well▼3. Executing a select query in SQL Server by C#3-1. Creating an application and then starting VSCode in the path where the application is generated3-2. Adding System.Data.SqlClient in MytestApp.csproj and saving this file by Ctrl+ S3-3. Restoring the dependencies and tools of a project3-4. … Continue reading “C# – Connecting to SQL Server on Ubuntu20.04 -VS Code No.104”

Python – Create Sample data in SQL Server on Ubuntu v2 No.97

Posted on by kumoman

How to create sample data in SQL Server on Ubuntu using Python is shown in this blog. Contents ▼1. Creating sample data using Python▼2. Prerequisites▼3. Bulk create sample data in SQL Sever3-1. Creating Python code3-2. Results of this python code▼4. Reference▼1. Creating sample data using Python In the past, how to create sample data using the insert query that is created by python code was provided below in this case, this insert query was executed using sqlcmd utility. but this blog all of steps is executed by python without sqlcmd. Python – Creating sample data in SQL Server on Ubuntu No.62 ▼2. Prerequisites How to build an environment using Python … Continue reading “Python – Create Sample data in SQL Server on Ubuntu v2 No.97”

Python -Save data in SQL Server into Azure Blob Storage No96

Posted on by kumoman

How to save the results of select statement into Azure Blob Storage after connecting to SQL Server on Ubuntu through pyodbc using python is shown in this blog. Contents ▼1. Saving data in SQL Server on Ubuntu into Azure Blob Storage▼2. Prerequisites▼3. Developing Python code to save the results of select query in SQL Server into Azure Blob Storage3-1. Creating Python code3-2. Results of this code▼4. Reference▼1. Saving data in SQL Server on Ubuntu into Azure Blob Storage Based on the previous blog using Java as below, pyhon code is shown to save the results of select statement into Azure Blob Storage. Java – Save the results of select query … Continue reading “Python -Save data in SQL Server into Azure Blob Storage No96”

Python – Save data in SQL Server on Ubuntu into a file No.95

Posted on by kumoman

How to save the results of select statement into a file after connecting to SQL Server on Ubuntu through pyodbc using python is shown in this blog. Contents ▼1. Saving data in SQL Server on Ubuntu into a file▼2. Prerequisites▼3. Developing Python code to save the results of select query in SQL Server into a file3-1. Creating Python code3-2. Results of this code▼4. Reference▼1. Saving data in SQL Server on Ubuntu into a file Based on the previous blog using Java as below, pyhon code is shown to save the results of select statement into a file. Java – Put SQL Server select results into a csv file No.70 ▼2. … Continue reading “Python – Save data in SQL Server on Ubuntu into a file No.95”

Python -Run a transactional query SQL Server on Ubuntu No.94

Posted on by kumoman

How to execute commit or rollback for a transactional query using python and pyodbc in SQL Server on Ubuntu is shown in this blog. Contents ▼1. Run a transactional query in SQL Server on Ubuntu▼2. Creating Python code to insert data with False of “autocommit”2-1. Creating Python code2-2. Results of this code2-3. Confirming data in table after connecting to SQL Server by sqlcmd utility▼3. Reference▼1. Run a transactional query in SQL Server on Ubuntu Regarding Java, how to execute a transactional query was shown in this past blog as below. this blog is written to implement it by Python. the autocommit of pyodbc is true. it is meant to commit … Continue reading “Python -Run a transactional query SQL Server on Ubuntu No.94”

Python -Error handling & Retry in SQL Server on Ubuntu No.93

Posted on by kumoman

How to implement the error handling and retry with some interval in SQL Server on Ubuntu by Python is shown in this blog. Contents ▼1. Why do we need an error handling and an retry logic?▼2. Prerequisites▼3. Creating the Python code to implement the error handling & retry logic3-1. Developing a python code for an error handling and a retry logic3-2. Results for this code▼4. Reference▼1. Why do we need an error handling and an retry logic? We often use a cloud service and a remote service through the network. if the network intermittently cause something problems, the client application cannot access these services and will stop. to avoid this … Continue reading “Python -Error handling & Retry in SQL Server on Ubuntu No.93”

Java – Run a transactional query in SQL Server on Ubuntu No9

Posted on by kumoman

How to execute a transactional query in SQL Server on Ubuntu using Java is shown in this blog. Contents ▼1. How to execute a transactional query in SQL Server on Linux▼2. Implement insert query using transaction in SQL Server on Linux2-1. Creating Java code2-2. 実行結果▼3. Reference▼1. How to execute a transactional query in SQL Server on Linux Commit or Rollback by transaction can keep consistency of data when the query fails in the middle of the process. setAutoCommit method of SQLServerConnection class in JDBC Driver can use commit and rollback to implement a transactional query. ▼2. Implement insert query using transaction in SQL Server on Linux 2-1. Creating Java code … Continue reading “Java – Run a transactional query in SQL Server on Ubuntu No9”

Java – Error handling & Retry in SQL Server on Ubuntu No.6

Posted on by kumoman

How to implement the error handling and retry with some interval in SQL Server on Ubuntu by Java is shown in this blog. Contents ▼1. An error handling and a retry logic with interval are mandatory▼2. Creating Java code to implement Error handling & Retry logic2-1. Creating a Java code2-2. Results for this code▼3. Reference▼1. An error handling and a retry logic with interval are mandatory When we connect to cloud services, we often experience the intermittent network issue. in this case, an error handling and a retry logic with some interval are mandatory to keep application working on. ▼2. Creating Java code to implement Error handling & Retry logic … Continue reading “Java – Error handling & Retry in SQL Server on Ubuntu No.6”

Java -AutoRetry connection by JDBC Driver for SQLServer No53

Posted on by kumoman

How to implement auto retry with some internal by Java is shown in this blog. the connection string using Microsoft JDBC Driver for SQL Server “Connection String” has a feature of auto retry with some internal. Contents ▼1. Auto retry with some interval feature of Connection String of Microsoft JDBC Driver for SQL Server (Version 9.4 以上)▼2. Writing Java code to implement auto-retry when failing to connect to SQL Server2.2. Showing logs when the connection succeeded.2.3. Showing logs when the connection failed▼3. Reference▼1. Auto retry with some interval feature of Connection String of Microsoft JDBC Driver for SQL Server (Version 9.4 以上) As the mandatory setting for a cloud service, … Continue reading “Java -AutoRetry connection by JDBC Driver for SQLServer No53”

Java – Execute a Select query in SQL Server on Ubuntu No.8

Posted on by kumoman

How to run a select query in SQL Server on Ubuntu using Java is shown in this blog. Contents ▼1. Prerequisites▼2. Executing a query in SQL Server on Ubuntu by Java2-1. Creating Java code to execute Select query1-2. Results of this code▼2. Reference▼1. Prerequisites Creating a table “t1” in a database “TestDB” and inserting data intho this table are executed by sqlcmd utility. “sa” user is used in this sample. ▼2. Executing a query in SQL Server on Ubuntu by Java 2-1. Creating Java code to execute Select query 1-2. Results of this code Current Timestamps: 2020-05-26 06:52:10.564 [main] INFO ExecuteQSQLSvr – Connect to SQL Server successfully retrieve c1    c2 … Continue reading “Java – Execute a Select query in SQL Server on Ubuntu No.8”