SQL Server Database Replication
Database replication is the technology to distribute data from the primary server to secondary...
Overview of Data Compression in SQL Server
The database is a critical and vital part of any business or organization. The growing trends predict that 82% of enterprises expect...
Navigating SQL Server Error Logs
Introduction One of the key skills you need as a database administrator or an IT person is generally the ability to monitor systems very...
How to create Snapshot Replication
The concept of snapshot replication is simple. It generates and distributes the snapshot of schema...
How to create Transactional Replication
In this article, I am going to demonstrate how to create transactional replication. Transactional replication generated a snapshot of...
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...
Storing Files in SQL Database Using FILESTREAM – Part 2
In my previous article, I described how to configure FILESTREAM in SQL Server, create FILESTREAM-enabled database and tables. Moreover, I...
SQL Database Administrator Interview Tips
Interview is the most significant step of SQL database administrator recruitment. During the interview, a technical person or interviewer...
Moving Existing Table From Primary Filegroup to Different Filegroup
In this article, I am going to explain how to move a table from the Primary filegroup to the...
