Aug 312015

Databases have the nasty habit of growing to mammoth sizes with continued usage over years. And it is common knowledge that databases that grow too large become prone to problems such as corruption, mismanagement etc. It thus becomes important to keep tabs on their growing sizes before they reach the point of no return. That’s why organizations engage in frequent Read More

Jul 242015

Single Instance Pros Only one instance needs to be administered on the single machine. There is no duplication of components or processing overhead, such as having to run multiple database engines on the same computer. This means that the overall performance of a server with a single instance may be higher than a server running multiple instances. A single instance Read More

Mar 242015

PostgreSQL Cookbook published with over 90 hands-on recipes to effectively manage, administer, and design solutions using PostgreSQL cookbook written by Chitij Chauhan who is leading expert in the area of database security, with expertise in database security products such as IBM Infosphere Guardium, Oracle Database Vault and Imperva. You can know more about the Book here With the goal of teaching Read More

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, 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 has made its mark in the world of 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