Free Java Support in SQL Server 2019

Java is one of the most important open source projects in the world today and was introduced almost 25 years ago with Microsoft SQL Server and has since been used by millions of developers around the world and is reportedly the most popular programming language. Became known in the world. SQL Server has a long history with Java, and even more recently the relationship between the two has deepened. It all started over 20 years ago, when early versions of the Java Database Connection Driver (JDBC) were released to enable Java…

Read More

How to restrict SQL Server memory

Follow these steps to limit the amount of SQL Server memory you can use: 1. Connect to the SQL Server Management Studio console by typing ssms in the Run window. 2. Enter the required information including Instance (Server Name), username and password for Instance connection and click on Connect button. 3. Right-click on the Instance you want, select Properties.   4. Click the Memory option on the left side of the screen. 5. In the Maximum Server Memory (in MB) section, enter the desired memory space into MB and click…

Read More

What is SQL?

SQL stands for Structured Query Language is a built-in language for querying a database. With SQL, you can change the data you have in your database the way you want it to be retrieved if you want it to. To practice with SQL you need a database such as SQL – server and Access or Oracle or any other database. Although SQL is a language under the ANSI (American National Standards Institute) standard, each database uses its own version, so some commands in one database may be based on a version…

Read More

How to create a User and SQL server authentication

SQL Server Authentication is a default mechanism to connect to MS SQL Server, but there are times that you need to use SQL Server Authentication to connect to the server, like when you have to connect to an MS SQL Server Database on a different network or when you have an SSPI problem. In order to use SQL Server Authentication, you need to create a SQL Server Authentication Login ID first. we will create a new SQL Server account. Run Microsoft SQL Server Management Studio. with local windows Authentication    Expand the Security folder,…

Read More

How To Restart/Start/Stop/Pause/ SQL Server Service

Just open SQL Server Configuration Manager, we could start, stop, pause or restart SQL Server Service. Step 1: On the Start menu, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click SQL Server Configuration Manager.   Step 2: click on SQL Server Services Step 2:select any instance of SQL Server such as SQL Server (SQLEXPRESS). Right-click any instance of SQL Server such as SQL Server (SQLEXPRESS), and then click Stop, Pause, Start orRestart.  buttons on toolbar, meaning Start, Pause, Stop and Restart.

Read More

How to Install SQL Server 2012

In this post I am going to show you how to install SQL Server 2012 Express Edition or  on Windows Server 2008 r2, I have included Create screen shots of step by step to make things to follow. If you haven’t already downloaded SQL Server 2012 Express, you can get it from Microsoft here.   Step 1. To begin, launch the install program and go to Installation tab.   Step 2. launch the install program and choose the top option to install a new stand-alone installation.   Step 3. SQL…

Read More