Calling a Stored Procedure from VB.Net or C# Program

http://theITvideos.com/ This Tutorial can be used for both VB and C# programs. This is a very simplest video showing how to call a stored procedure from VB.Net … source

SQL SERVER – FIX: Arithmetic Overflow Error in Object Execution Statistics Report in Management Studio

Many times, there are unforeseen conditions and few developers can’t predict which writing the code of a product. This is the reason we have bugs in the products and we Continue ReadingSQL SERVER – FIX: Arithmetic Overflow Error in Object Execution Statistics Report in Management Studio

SQL SERVER – AlwaysOn Automatic Seeding Failure – Failure_code 15 and Failure_message: VDI Client Failed

Recently I wrote a blog explaining a situation where taking log backup can break automatic seeding and synchronization would not work. Below is the blog reference. SQL SERVER – AlwaysOn Automatic Continue ReadingSQL SERVER – AlwaysOn Automatic Seeding Failure – Failure_code 15 and Failure_message: VDI Client Failed

How to Estimate Space Saved by Data Compression in SQL Server? – Interview Question of the Week #167

Question: How to Estimate Space Saved by Data Compression in SQL Server? Answer: It has been long since I have heard this question. I remember I used to answer this question Continue ReadingHow to Estimate Space Saved by Data Compression in SQL Server? – Interview Question of the Week #167

SQL SERVER – Mirroring Error 1456 – The ALTER DATABASE Command Could not be Sent to the Remote Server Instance

As a part of my consulting, I still get few clients who prefer to use database mirroring over Always On Availability Group. In this blog we would cover about one Continue ReadingSQL SERVER – Mirroring Error 1456 – The ALTER DATABASE Command Could not be Sent to the Remote Server Instance