Varun R | SQLINFO - We play with data and technology - Part 11

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 – Line Number in SQL Server Management Studio(SSMS)

When we run a script in SQL Server we may face...

19 May30 Oct

Varun R

SQL SERVER – How to find which SQL Server Version/Edition you are using?

You can use SELECT @@Version to find the...

6 May30 Oct

Varun R

SQL SERVER – ADD/DROP A COLUMN IN A TABLE

How to add and drop a column to a table in SQL...

21 Apr30 Oct

Varun R

SQL SERVER – DISABLE/ENABLE ALL TRIGGERS IN A DATABASE

Recently I came across a situation to disable all...

21 Apr30 Oct

Varun R

Database Performance Tuning –Basic Things to know

This feature is dedicated to Preethy kammath a...

8 Apr30 Oct

Varun R

SQL SERVER – CURSOR – A SIMPLE EXAMPLE

Today one of my colleagues named sukanya...

6 Apr6 Apr

Varun R

SQL SERVER – RESTORE VERIFYONLY – TO CHECK WHETHER DATABASE BACKUP CORRUPT OR NOT

Today is April 1st Fool’s day So today I am...

1 Apr1 Apr

Varun R

SQL SERVER – BEWARE OF USING PREFIX “SP_” IN USER DEFINED STORED PROCEDURE

During the Analysis of a database, I found some...

31 Mar31 Mar

Varun R