Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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 »MSSQL
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 »How To Create An Operator On SQL Server
We use the operators to identify the contact list to send mail to. Right click on Operator under SQL Server Agents and call New Operator. …
Read More »How To Configure Database Mail On SQL Server
Under Management on SSMS, right click on Database Mail and select Configure Database Mail. Click “Skip this page in the future” and next. On …
Read More »Always On Availability Group Alert System
There are a few important things to check for SQL Server Always On Availability Group. Did the failover occur on any AG? Does the transfer …
Read More »How To Create Temp Table On SQL Server
In SQL Server, tsql code developers may occasionally want to temporarily keep records on a table. This can be done by creating a table …
Read More »How To Create CHECK CONSTRAINT
Check Constraint limits the values that can be entered into a column. Check Constraint works on Row basis. Allow Null Values to be inserted. …
Read More »