Author: Varun R
Varun is a Microsoft Certified IT Professional working as a Infra Architect in Fortune 100 company. He has written so many articles in his blog www.sqlinfo.in. He is a member in Professional Association for Sql Server (PASS).He holds around 10+ years of Experience in Database Design,Development , Business Intelligence & Administration. He has designed Data center for Fortune 100 companies. His area of skills lies in Data center design, Cloud computing, Business Intelligence etc.
SQL SERVER – ERROR FIX- Adventure works installation error – “Fatal Error Occurred”
Today when I tried to install the Adventure works...
Varun R
SQL Server – SSRS – Different Stages and types of Reporting
In Previous post, we learnt evolution of SSRS and...
Varun R
SQL Server – SSRS – Introduction to Reporting Services
SQL Server reporting is a powerful feature in SQL...
Varun R
SQL SERVER – DMV – For finding the Page count, index level, record count of an Index
This is a small post for finding the page count,...
Varun R
SQL Server – Importance of Coding standards – FIX – Msg 15225, Level 11, State 1, Procedure sp_rename, Line 338 No item by the name of could be found in the current database, given that @itemtype was input as ‘(null)’.
Mostly we all know that sp_rename is a system...
Varun R
SQL Server – Business Intelligence Overview- OLTP vs. OLAP
Online Transactional Processing (OLTP) refers to...
Varun R
SQL SERVER –FIX- Error- Failed to connect to an IPC Port: The System cannot find the specified path.- Database Engine Tuning Advisor (DTA).
Today when I was working on a Performance Tuning...
Varun R