Importance of transaction log in SQL Server
Transaction logs are a vital and important component of database architecture. In this article,...
Creating Database Maintenance Plans
Using database maintenance plans, we can automate basic database administration activities. Maintenance plans are SQL Server integration...
Using Working Folder to Source Control Database
This article is a walkthrough of how to use the working folder option of source control for managing SQL Server databases. In this article,...
Simplifying Unit Testing Main Stored Procedure Which Also Calls a Utility Procedure
This article provides a walkthrough of database unit testing a stored procedure which contains a...
How to Generate Test Data in SQL Server
When testing the functionality of your application or the performance of a specific stored procedure or an ad-hoc query in the development...
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....
Passing Data table as Parameter to Stored Procedures
Real-world database applications need to make multiple requests from the front end to the database...
How to Test Azure Web Application Performance through Microsoft Azure and Visual Studio
Before deploying your application into production, doing a performance load test is imperative for measuring future performance and ensure...
Backup and Restore FILESTREAM-Enabled Database
In my previous articles, I explained how to create and configure the FILESTREAM feature in SQL server instance. Moreover, I demonstrated...
Storing Files in SQL Database Using FILESTREAM – Part 2
In my previous article, I described how to configure FILESTREAM in SQL Server, create...
