Compress SQL Server Backup in Right Way

Varinder Sandhu Guest Post, SQL, SQL-Backup & Restore

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 […]

Learn More

PacktPub – PostgreSQL Cookbook Review

Varinder Sandhu Others

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 bit.ly/1CkxzNe […]

Learn More

Top 7 Things Website Owners Should Know When Backing Up Their Website

Varinder Sandhu Guest Post

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 […]

Learn More

Unable to connect the SQL Server Instance – 26 – Error Locating Server/Instance Specified

Varinder Sandhu SQL, SQL-Advanced, SQL-Tips and Tricks, Varinder Sandhu

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. […]

Learn More

SQL Server – How to read the SQL Server Error log files using TSQL

Varinder Sandhu SQL, SQL-Advanced, SQL-Query, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

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. […]

Learn More

Leveraging Validator Toolkit for ASP.NET MVC to Build Client and Server-Side Form Validation

Varinder Sandhu .Net Framework, ASP.Net, Guest Post, MVC

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 […]

Learn More

SQL Server – Database mirroring vs Log Shipping

Varinder Sandhu SQL, SQL-Advanced, SQL-Tips and Tricks, Varinder Sandhu

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 […]

Learn More

SQL Server – Backend version is not supported to design database diagrams or tables. (MS Visual Database Tools)

Varinder Sandhu SQL, SQL-Tips and Tricks, Varinder Sandhu

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 […]

Learn More

Previous Posts