Jan 232015

We have said before that indexes are easily the most important database structures insofar as database performance tuning is concerned. Therefore, you must pay keen attention to their configuration, structure and arrangement in order to get the best level of performance out of them. Theory of index fragmentation Fragmentation does not only occur at the file-system level and inside log Read More

Jan 102015

In today’s world of internet blogging/websites, taking a few moments to make an easy, quick and convenient backup of your database will save you untold hours, days or even weeks of hard work. Listed below are seven important things you’ll need to know about backing up your website, before disaster strikes unexpectedly. 1- How Many Times Should You Backup? It’s Read More

Nov 212014

Problem\Issue: User is not able to connect the SQL Server Named Instance ServerName\InstanceName Additional Error Messages: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (Provider: SQL Network Interfaces, error: Read More

Nov 112014

There is undocumented system stored procedure sp_readerrorlog which allows us to read the SQL Server error log files directly using T-SQL. This procedure has total 7 parameters as given below: Parameter Values First Parameter Value of error log file you want to read: 0 = current, 1 = Archive #1, 2 = Archive #2, etc. Second Parameter Log file type Read More

Oct 162014

After having gained an incredible amount of popularity as one of the finest web development frameworks, Asp.net is now available with a validator toolkit that enables the developers to build both, client side and server-side form validation. The MVC programming model available for Asp.net has made its mark in the world of Asp.net development. In today’s blog, I’ll be covering Read More

Aug 112014

In the previous post  SQL Server – AlwaysOn Availability Groups, described enhancement to SQL Server 2014 AlwaysOn Availability Groups. In this post, we will see how to enable SQL Server 2012 AlwaysOn Availability Groups using UI and PowerShell. Using UI Go to SQL Server Configuration Manager >> Navigate to SQL Server Service >> Right Click to SQL Server Service and Read More

Jul 292014

I would like to start this topic with very common question for database administrators. Question: What is difference between the Database Mirroring and Log Shipping? Which is preferable solution? Database Mirroring: Database mirroring is functionality in the SQL Server engine that reads from the transaction log and copies transactions from the principal server instance to the mirror server instance.  Database Read More

Jul 172014

What is Log Shipping? Log Shipping is a basic level SQL Server high-availability technology. It is automated process to send the transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary server instances. The transaction log backups are applied to each of the secondary databases individually. How Log Shipping Read More

Jul 102014

Error Messages : This backend version is not supported to design database diagrams or tables. (MS Visual Database Tools) Cause  : The database to which you are connected does not allow schema modification with the Visual Database Tools. Resolution : Be sure you are connected to the correct database or Use the correct version SQL Server Management tool.

Jun 302014

Many times we face a requirement to perform the unattended installation of SQL Server. In this post we will see the steps to perform the unattended installation of SQL Server 2012 using command line. There are two ways to install the unattended installation of SQL Server 2012 using command line. Specify each required parameter , you may take the parameter Read More

May 272014

Introduction Microsoft introduced the AlwaysOn Availability Groups which is a high-availability and disaster-recovery solution that provides an enterprise-level solution in SQL Server 2012. Using Database Mirroring for local high availability and combining it with Log Shipping for a disaster recovery solution is popular deployment architecture prior to SQL Server 2012. With SQL Server 2012, the Database Mirroring and Log Shipping Read More

May 212014

Now here we have question regarding the Mirroring Database: How can we recover the data from mirror database? How to restore the mirroring database? Here I would like to clear that we cannot restore a database that is involved in Mirroring without removing Mirroring. Removing the Mirroring using T-SQL ALTER DATABASE MirrorTest SET PARTNER OFF; Restore the Mirror Database RESTORE Read More

May 202014

What is Database Mirroring? Database mirroring is a solution for increasing the availability of a SQL Server database. But it has been gained popularity as a disaster-recovery option. How Database Mirroring Working. The principle server sends the active transaction log record to the mirrored server. The mirrored server applies the transaction log record one by one in sequence. Prerequisites The Read More

May 132014

After your installation of CollabNet Subversion Edge, once you will create user that gets the Read-Write Access to all the available repositories because by default Repository Access Rule is (as shown below) [/] * = rw That means Read-Write Access to all Users for all available repositories. You should Edit Repository Access Rule as [/]* = r varinder = rw Read More

May 122014

In the previous post, you have seen the complete installation of Subversion Edge. After Installation, once you will login the web-based console for configuration managing the server. You can see in the below screenshot, Your SVN Server is down yet. Now, first we see some important configuration parameter (Highlighted in Red) that we have to set as per our requirement Read More

May 122014

CollabNet Subversion Edge is a Subversion server distribution that includes a complete software stack of Apache, Subversion and ViewVC as well as a powerful web-based console for managing the server. In this Post, we will see the intallation steps for CollabNet Subversion Edge. Go to URL : http://www.collab.net/downloads/subversion  and download latest version Subversion Edge and within minutes be up and Read More