How to create Transactional Replication

Database administration, Database Optimization & Structure

In this article, I am going to demonstrate how to create transactional replication. Transactional...
Read More

Importance of transaction log in SQL Server

Database administration, Transaction Log

Transaction logs are a vital and important component of database architecture. In this article, we’ll discuss SQL Server transaction...
Read More

Creating Database Maintenance Plans

Database administration, Database Optimization & Structure

Using database maintenance plans, we can automate basic database administration activities. Maintenance plans are SQL Server integration...
Read More

Using Working Folder to Source Control Database

Database development, Source control

This article is a walkthrough of how to use the working folder option of source control for...
Read More

Simplifying Unit Testing Main Stored Procedure Which Also Calls a Utility Procedure

Database development, Stored Procedures, Testing

This article provides a walkthrough of database unit testing a stored procedure which contains a utility procedure within it. In this...
Read More

How to Generate Test Data in SQL Server

Database administration, Work with data

When testing the functionality of your application or the performance of a specific stored procedure or an ad-hoc query in the development...
Read More

Configuring Database Mail in SQL Server

Database administration, Database Optimization & Structure • One Comment

SQL Server Database Mail has been introduced in SQL Server 2005. Database Mail is a component that...
Read More

Passing Data table as Parameter to Stored Procedures

Database administration, Stored Procedures, Work with data

Real-world database applications need to make multiple requests from the front end to the database in order to carry out all sorts of...
Read More

How to Test Azure Web Application Performance through Microsoft Azure and Visual Studio

Azure, Cloud, Tools & technologies, Visual Studio

Before deploying your application into production, doing a performance load test is imperative for measuring future performance and ensure...
Read More

Backup and Restore FILESTREAM-Enabled Database

Database administration, Work with data

In my previous articles, I explained how to create and configure the FILESTREAM feature in SQL...
Read More
Close