Category: SQL Server

Python – Creating sample data in SQL Server on Ubuntu No.62

Posted on by kumoman

How to create sample data in SQL Server on Ubuntu is shown in this blog. These steps are available for Windows OS, too. Contents ▼1. What is Microsoft SQL Server ?▼2. Prerequisites▼3. Creating sample data in bulk3-1. Preparation3-2. Developing “insertmultipledata.sql” to create sample data by python3-3. Executing the sql statement in “insertmultipledata.sql” by sqlcmd.exe3-4. Confirming the generated sample data using sqlcmd.exe▼4. Reference▼1. What is Microsoft SQL Server ? There are many kinds of SQL Server. for example, Azure SQL Database in cloud, Azure Synapse Analytics – SQL pool (SQL Data Warehouse) and on-premise SQL Server on Azure Virtual Machine (VM) etc We can find the version of SQL Server and hot … Continue reading “Python – Creating sample data in SQL Server on Ubuntu No.62”

Java – Put SQL Server select results into a csv file No.70

Posted on by kumoman

How to put results of select in SQL Server on Ubuntu into a csv file by Java is shown in this blog. Contents ▼1. Prerequisites1-1. Installing SQL Server1-2. Installing Visual Studio Code1-3. Installing Maven1-4. Generating sample data in SQL Server1-5. Executing a select query in SQL Server using Java▼2. Executing select statement in SQL Server and this results are put into a csv file using Java2-1.Creating a directory2-2. Creating a project using Apache Maven2-3. Deleting the existing App.java and AppTest.java2-4. Starting Visual Studio Code2-5. Updating pom.xml to use libraries of operations in SQL Server (Ctrl+S)2-6. Creating sqlsrvlocaloutput.java2-7. Confirming the csv file after executing this Java code▼3. Reference▼1. Prerequisites There are … Continue reading “Java – Put SQL Server select results into a csv file No.70”

Python – How to connect to SQL Server on Ubuntu  No.92

Posted on by kumoman

How to connect and run select query for a table in SQL Server on Ubuntu using Microsoft ODBC Driver for SQL Server by Python are shown in this blog. Contents ▼1. Connecting to SQL Server on Ubuntu▼2. Connecting to SQL Server and Select using Python2-1. Installing SQL Server on Linux2-2. Installing Microsoft ODBC Driver for SQL Server2-3. Creating a python code to connect to SQL Server on Linux and run Select2-4. Results of this python code when it work fine.▼3. Reference▼1. Connecting to SQL Server on Ubuntu In the past, how to connect and run queries using Java are shown in this blog as below. (As of 2022/12) ▼2. Connecting … Continue reading “Python – How to connect to SQL Server on Ubuntu  No.92”

Java – Update Statistics in SQL Server on Ubuntu No.91

Posted on by kumoman

How to update statistics for the table in SQL Server on Ubuntu by Java is shown in this blog. Contents ▼1. The latency of a query execution in SQL Server▼2. Prerequisites2-1. Reference Java – Creating sample data for SQL Server on Ubuntu No.89▼3. Updating statistics and re-generate a query execution plan by Java3-1. Creating a project using Apache Maven3-2. Deleting the existing App.java and AppTest.java files3-3. Starting Visual Studio Code3-4. Adding a library in pom.xml for the operation in SQL Server and saving pom.xml (Ctrl+S) 3-5. Creating sqlupdstat.java code3-6. The results of this Java code▼4. Reference▼1. The latency of a query execution in SQL Server We often see the latency … Continue reading “Java – Update Statistics in SQL Server on Ubuntu No.91”

Java – Creating sample data for SQL Server on Ubuntu No.89

Posted on by kumoman

In this blog, how to create sample records for SQL Server on Ubuntu using Java is shown. Contents ▼1. Creating sample data using Java▼2. Prerequisites2-1. Checking Java – Generating the sample data on SQL Server No.87 to execute below.▼3. Creating sample data for SQL Server by Java3-1. Create an Apache Maven project3-2. Remove the existed both App.java and AppTest.java3-3. Start Visual Studio Code3-4. Update pom.xml as below to run query on SQL Server and save it (Ctrl+S)3-5. Creating Java code sqlsample2.java3-6. Results of this code▼4. Reference▼1. Creating sample data using Java In the past blog, these blogs are shared. they use .sql file to create data by sqlcmd. In this … Continue reading “Java – Creating sample data for SQL Server on Ubuntu No.89”

Java – Generating the sample data on SQL Server No.87

Posted on by kumoman

In this blog, How to generate the sample data on SQL Server is shown. the key point is to use sqlcmd to run queries in Java. Contents ▼1. Generating the sample data using Java▼2. Prerequisites2-1. Installing SQL Server on Ubuntu2-2. Installing Microsoft JDBC Driver 8.2 for SQL Server2-3. Install Visual Studio Code2-4. Install Maven2-5. Create a query to create a database and a table▼3. Generate a sample data using java3-1. Create an Apache Maven project3-2. Remove the existed both App.java and AppTest.java3-3. Start Visual Studio Code3-4. Update pom.xml as below and save it (Ctrl+S)3-5. Connect to MySQL and execute select query3-6. Results of this code3-7, Check the generated data▼4. Reference▼1. … Continue reading “Java – Generating the sample data on SQL Server No.87”

Java – Connect to SQL Server on Ubuntu No.5

Posted on by kumoman

In this blog, how to connect to SQL Server on Ubuntu using Java is shown. Contents ▼1. What is SQL Server on Ubuntu▼2. How to connect to SQL Server on Ubuntu2-1. Installing SQL Server on Ubuntu2-2. Installing Microsoft JDBC Driver 8.2 for SQL Server2-3. Connection String of JDBC Driver for SQL Server2-4. Output of this code▼3. Reference▼1. What is SQL Server on Ubuntu SQL Server is Relational Database (RDB) provided by Microsoft. SQL Server works on both Windows and Linux. we can use free trial version which is called as “Express Edition” within 180 days. ▼2. How to connect to SQL Server on Ubuntu 2-1. Installing SQL Server on Ubuntu … Continue reading “Java – Connect to SQL Server on Ubuntu No.5”

Java – Connection String of Microsoft JDBC Driver for SQL Server No.7

Posted on by kumoman

I would like to share the detail of connection string of JDBC Driver for SQL Server in this blog. Contents ▼1. Connection String of Microsoft JDBC Driver for SQL Server ▼2. Example for the connection string of JDBC Driver for SQL Server▼3. Reference▼1. Connection String of Microsoft JDBC Driver for SQL Server Connection String contains login timeout, socket timeout,query timeout, query timeout, authentication way and application name etc. ▼2. Example for the connection string of JDBC Driver for SQL Server We can avoid intermittent connection issue by implementing timeout, retry and interval of retry etc. This is an example for the connection string of Microsoft JDBC Driver for SQL Server. … Continue reading “Java – Connection String of Microsoft JDBC Driver for SQL Server No.7”