Showing posts with the label sql server

How do you Test a database split

What is a database split ? When do we really come across with such a business scenario in our ent…

MS Sql Server installation testing

Installation testing is perhaps one of the most time taking testing category I have ever come acro…

SQL Server - Aggregate Functions

Aggregate functions will find out a calculation process on a collection of values and return a re…

Stored Procedure best practices

A stored procedure is a named and precompiled set of SQL statements and procedural logic that is …

Database Security :

Designing Instance-level Security A]. Configuring Service Account : (1) In SQL Server 2005, when…

Cache object in ASP.NET designs

An effective caching strategy is a key element of any application design. It increases performance…

That is All