How to create Transactional Replication
In this article, I am going to demonstrate how to create transactional replication. Transactional...
Creating Database Maintenance Plans
Using database maintenance plans, we can automate basic database administration activities. Maintenance plans are SQL Server integration...
Configuring Database Mail in SQL Server
SQL Server Database Mail has been introduced in SQL Server 2005. Database Mail is a component that can send emails using SQL Server Engine....
Compare Execution Plans in SQL Server
Database Administrator always makes an effort to tune SQL Server query performance. The first step...
Configuring Heterogeneous Database Replication – SQL Server to Oracle
Introduction SQL Server Replication is an SQL Server feature that allows us to transfer data from one instance to another for such purposes...
How to Copy SQL Server Databases from One Instance to Another
Copying or moving databases is one of the most common tasks for data professionals who regularly deal with deploying scripts or new...
Missing Indexes in MS SQL or Optimization in no Time
When executing a query, the SQL Server optimizer tries to find the best query plan based on...
Database Optimization: Indexes
I noticed that very few people understand how indexes work in SQL Server, especially Included Columns. Nevertheless, indexes are the great...
How to Analyze Activity of One Database in SQL Server
Using one SQL Server instance for many projects is not unusual. However, defining the most active project may be quite difficult. Today, I...
Analysis of MS SQL Server for Those Who See It for the First Time
What Problems Will We Consider? If the server notifies “there is no more space on the E...
