We might have seen the error “Cannot install SQL Server cluster on a computer that runs Microsoft Windows Server 2003 “ during the process of SQL Server Installation in Windows Server 2003. Let us discus why we get the error and how to recover from the error
Problem Description
You cannot install SQL Server cluster on a [...]
Introduction
In a production environment, it is not always easy to determine why the sql job has failed and what has happened during the job step execution. The checklist provided here will help in arriving at a decision or give clear direction to troubleshoot
Checklist: First thing first, so let us go sequentially:
Check that the [...]
Continue reading about Troubleshooting SQL Server 2005 Jobs Failure
Just a day before working on one of the projects, I had to take a backup of one database of 30 GB. My hard drive lacked sufficient space at that moment. Fortunately, I had two 16 GB USB Drives with me. Now, the question was how to take a backup in two equal sizes, each [...]
Continue reading about Split Backup Files while Backup and Restore SQL Server Database
Welcome back, In the last two article we have been discussed about General Checklist and Security Related Checklist for ASP.Net Developers. These checklist are found to be very useful for developers perspective. Now we shall discus something about ASP.Net Performance Improvement Tips. I have listed down some of the Performance Related Tips for ASP.Net Applications
Reduce [...]
In this article we are going to discus some of the Security Related Checklist for ASP.Net Developers. I have four main areas to discus about the security related issues
Input Validation and Authentication Checklist
Web Services Security Checklist
Data Access Security Checklist
Client Script Maintainability Checklist
Scope : Input Validation and Authentication Checklist for ASP.Net Applications
Use client side validation.
Every [...]
Continue reading about ASP.Net Developers Checklist – Security Checklist
There are many tricks that can be used when you write T-SQL code. One of these is to reduce the amount of network data for each statement that occurs within your stored procedures. Every time a SQL statement is executed it returns the number of rows that were affected. By using "SET NOCOUNT ON" within [...]
Continue reading about SET NOCOUNT ON to improve Stored Procedure Performance in SQL Server
This article provides consolidated guidelines/checklist for writing scalable, clean and high performance web applications using ASP.NET. Close adherence to the rules will help developers and code reviewers to understand a piece of code.
The article is divided into three parts as mentioned below.
Scalable and Maintainable
Meeting all the security standards
Giving high performance.
The following guidelines list [...]
Continue reading about Checklist/Guidelines for ASP.Net Developers
SQL Server 2005/2008 has a default Mail Engine in it, We can send email from SQL Server itself using the Database Mail. Database Mail is not active by default, in order to activate the Database Mail we need to follow Database Mail Configuration wizard or we need to execute sp_configure stored procedure with appropriate parameter.
Database [...]
Continue reading about Database Mail in SQL Server 2005/2008
After taking backup, we need to verify the database backup to assure the SQL Server Backup is taken correctly. we can verify the database backup either by T-SQL statements or SSMS.
The RESTORE VERIFYONLY command checks the backup to ensure it is complete and the entire backup is readable. The does not do an actual [...]
SQL Compare is a Data comparison and synchronization tool from Redgate, This is an effective tool for SQL developers, Test Engineers and SQL DBAs to accomplish their task. The specialty of the software is that it can be used with live database, Database Snapshots as well as SQL Scripts.
Some of the identical features of [...]
Continue reading about SQL Compare – Compare and Synchronize tool for SQL Server Database
