Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
You can keep the database-level code that you need to use every time in the application through “stored procedures” in the database. You can …
Read More »MSSQL
How To List Active Queries On PostgreSQL
In this article I will explain you to list active queries in postgresql. First you must connect to postgresql. You may want to read …
Read More »SQL Server Account Lockout Policy
Account Lockout Policy is a security mechanism used by SQL Server. For example, consider someone who is trying to log in with a user …
Read More »SQL Server Maintenance
I find OLA HALLENGREN’s maintenance script very successful and practical. In this article I will tell you where to download and install the script that …
Read More »sp_configure(Server-Level Configurations in SQL Server)
You can configure SQL Server with sp_configure at instance level. In this article I want to explain most important configurations in sp_configure. First we …
Read More »How To Create a Linked Server To Connect To SQL Server From SQL Server
I have described to create linked server to connect to oracle from sql server in my article titled “How To Create a Linked Server …
Read More »How To Create a Linked Server To Connect To Oracle
In some cases, a database that resides on SQL Server may require the data to be retrieved from the Oracle database. Requirements First, …
Read More »How To Define a New Login To The Linked Server
Previously, I have described the definition of a linked server to connect to Oracle in my article titled “How To Create a Linked Server To …
Read More »How To Give Permission To Developers For Change Their Passwords On SQL Server(Grant Alter)
Sometimes developers need a permission for change their login’s password. if you do not give them to necessary permission they can not change their …
Read More »SQL Server Best Practices and Configurations that need to be made After Installation
In this article, we will examine the configurations that need to be made after SQL Server Installation. You can find the details of the …
Read More »