Should Stored Procedure name start wi...

Should Stored Procedure name start with SP_ ??? - NO, user defined Stored Procedures, should not start with SP_, as ... http://ping.fm/cm9uh

List 10 difference between TRUNCATE &...

List 10 difference between TRUNCATE & DELETE statement in SQL Server? http://ping.fm/NmDGT

How to trace Deadlock in SQL Server ?...

How to trace Deadlock in SQL Server ? - What is a DEAD LOCK in SQL Server? When two or more transactions conflict in... http://ping.fm/6fdhj

Does Mirroring works with FileStream ...

Does Mirroring works with FileStream databases ? - NO, FILESTREAM doesn’t work with mirroring and database Sna... http://ping.fm/atHex

How to Monitor Database Mirroring, SQ...

How to Monitor Database Mirroring, SQL Server? - SQL Server Mirroring can be monitored SQL Server Management Studio ... http://ping.fm/9qKEw

What is SQL Server Feature Pack ? - W...

What is SQL Server Feature Pack ? - What is SQL Server Feature Pack ? The Feature Pack is a collection of standalone... http://ping.fm/zlNnn

How to perform SQL Server Mirroring M...

How to perform SQL Server Mirroring Manual Failover? - What is SQL Server Mirroring Failover ? When the principal se... http://ping.fm/AiEfQ

SQL Server 2008 R2 Cumulative Update ...

SQL Server 2008 R2 Cumulative Update 5 is released - Microsoft has released Cumulative Update 5 for SQL Server 2008 ... http://ping.fm/OwXNO

How to Setup Mirroring in SQL Server ...

How to Setup Mirroring in SQL Server ?(Screen Shots) - What is Mirroring in SQL Server ? Database mirroring is an al... http://ping.fm/MdRZ4

Database mirroring must be removed be...

Database mirroring must be removed before you drop SQL Server database http://ping.fm/AnEY9

Can we have Mirroring between Standar...

Can we have Mirroring between Standard and Enterprise editions ? http://ping.fm/PHEw9

How to get SQL Server Install Directo...

How to get SQL Server Install Directory / Error LOG via TSQL Statement ? http://ping.fm/kYhhw

How to Monitor SQL Server Log Shippin...

How to Monitor SQL Server Log Shipping? - LOG Shipping can be monitored SQL Server Management Studio or via TSQL Que... http://ping.fm/9zUdh

SQL Server DENALI HARDON DMVs and Fun...

SQL Server DENALI HARDON DMVs and Functions – SYSTEM View MAP http://ping.fm/a6In5

How to subscribe for SQL Server Cloud...

How to subscribe for SQL Server Cloud Services (SQL Server AZURE) FREELY ? http://ping.fm/NXOIc

What is SQL Server Crescent - Crescen...

What is SQL Server Crescent - Crescent, is a new Microsoft Business Intelligence tool (ad hoc reporting) which is pl... http://ping.fm/jzXhp

What is SQL Server Crescent - Crescen...

What is SQL Server Crescent - Crescent, is a new Microsoft Business Intelligence tool (ad hoc reporting) which is pl... http://ping.fm/Ht0jb

SQL Server Developer Tool "Juneau" ??...

SQL Server Developer Tool "Juneau" ??? - "Juneau" is going to be a high productivity development environment... http://ping.fm/vAQnC

Do you know what is Enhanced in Denal...

Do you know what is Enhanced in Denali for HIGH Availability ? http://ping.fm/RS0fL

Can We connect to SQL Server Denali u...

Can We connect to SQL Server Denali using 2008/2008 R2 SSMS ? http://ping.fm/r8LPg

How to use THROW command (Error Handl...

How to use THROW command (Error Handling) in SQL Server ? - What is THROW in SQL Server ?     &#... http://ping.fm/G7DvK

SQL Server Atlanta ? Proactive Monito...

SQL Server Atlanta – Proactive Monitoring - What is SQL Server Atlanta Project ? Microsoft Atlanta is a cloud-based,... http://ping.fm/x99L8

What are the Features of HADRON in SQ...

What are the Features of HADRON in SQL Server DENALI (2011) ? http://ping.fm/qbuDb

How to use OFFSET / FETCH option in ...

How to use OFFSET / FETCH option in SQL Server Order By Clause ? http://ping.fm/ui2nA

How to Restore Database in SQL Server...

How to Restore Database in SQL Server 2011 (Denali) from an older SQL Server version? http://ping.fm/khXR6

What is Sequence in SQL Server ? - SQ...

What is Sequence in SQL Server ? - SQL Server 2011, Denali, introduces a new alternative to identity columns. There ... http://ping.fm/LMCDU

What is the Difference between Identi...

What is the Difference between Identity and Sequence in SQL Server? http://ping.fm/FD4At

What are ate Discontinued Features an...

What are ate Discontinued Features and Functionalities, which will not be available, in SQL Server Denali (2011)? http://ping.fm/UWqWb

What is COLUMNSTORE Index in SQL Serv...

What is COLUMNSTORE Index in SQL Server? - What is COLUMNSTORE Index ? The SQL Server Denali (2011) launched a new t... http://ping.fm/BPsI0

Weekly Note : What is new in SQL Serv...

Weekly Note : What is new in SQL Server 2011 ? - Last week, I spent a lot of time on working with SQL Server Denali ... http://ping.fm/zUuZd

What is HADR in SQL Server ? - What i...

What is HADR in SQL Server ? - What is HADR in SQL Server ? "HADR" is a High-Availability and Disaster Recov... http://ping.fm/CzdQ3

How to Implement HADR (a high-availab...

How to Implement HADR (a high-availability and disaster recovery solution) in SQL Server ? Step by Step Guide with s... http://ping.fm/maZ5d

List of DMV and DMF availability acro...

List of DMV and DMF availability across all SQL Server Versions http://ping.fm/jzQwm

What are the new DMV and DMF are adde...

What are the new DMV and DMF are added in SQL Server 2011 ? - Here is the List of DMV's (Dynamic Management Views) a... http://ping.fm/CTZG8

VIDEO : SQL Server Contained Database...

VIDEO : SQL Server Contained Database - The Following Video covers What is Contained Database Why Contained Database... http://ping.fm/d5pAc

How to Create Server Roles in SQL Ser...

How to Create Server Roles in SQL Server ? - Can we create user defined Server Roles in SQL Server ? YES, we can cre... http://ping.fm/Zewnz

Compatibility Levels supported by SQL...

Compatibility Levels supported by SQL Server 2011 (Denali) - What are the compatibility Levels supported by SQL Serv... http://ping.fm/TJsjU

New Permissions added in SQL Server 2...

New Permissions added in SQL Server 2011 (Denali) - Following are the New Permissions added in SQL Server Denali. Al... http://ping.fm/B0wRh

How to use Managed Code (CLR) in SQL ...

How to use Managed Code (CLR) in SQL Server? Video - SQL CLR Integration allows you to create database objects that ... http://ping.fm/2rE4i

SQL Server 2011 (Denali) Certificatio...

SQL Server 2011 (Denali) Certification - Microsoft have announced that the next version of SQL Server Certifications... http://ping.fm/X4wkz

How to turn off Auto Recovery (AUTO S...

How to turn off Auto Recovery (AUTO Save) in SQL Server Management Studio? http://ping.fm/rvhcC

What is Relational Database Managemen...

What is Relational Database Management System - What is Relational Database Management System ? A relational databas... http://ping.fm/eWWov

Introduction to RDBMS : Day 1 : Chapt...

Introduction to RDBMS : Day 1 : Chapter 1 - In this session, you will learn to: Define a Database Management System ... http://ping.fm/x8v5c

What are T-SQL Enhancements done in S...

What are T-SQL Enhancements done in SQL Server 2008 - What are T-SQL Enhancements done in SQL Server 2008 ? SQL Serv... http://ping.fm/aYUdh

How to install SQL Server (2011) Dena...

How to install SQL Server (2011) Denali Sample Databases - Sample databases form SQL Server Denali (2011 can be down... http://ping.fm/pTUuz

SQL Server Denali no longer support D...

SQL Server Denali no longer support DTS packages - SQL Server 2011 / Denali no longer supports Data Transformation S... http://ping.fm/LqPEV

How to Disable/restrict SSRS Export f...

How to Disable/restrict SSRS Export format ? - SQL Server Reporting Services (SSRS) supports export to different for... http://ping.fm/MWzhr

Denali : Integration Services now Sup...

Denali : Integration Services now Supports undo and redo (CTL+Z and CTL+Y)operations http://ping.fm/c7t2P

SQL Server MiracleDB - What is Miracl...

SQL Server MiracleDB - What is MiracleDB in SQL Server ? MiracleDB is user database created by DBA to operationally ... http://ping.fm/vmSUh

SQL Server Denali : Changed Startup P...

SQL Server Denali : Changed Startup Parameter : New Feature - Changing SQL Services Startup Parameters is very easy ... http://ping.fm/yXDbF

Video : Install SQL Server Denali Set...

Video : Install SQL Server Denali Setup (Install SQL Server 2011) http://ping.fm/uJ3Ep

SQL Server Interview Questions - SQL ...

SQL Server Interview Questions - SQL Server Basic Interview Question Answers, soon I am going to post my own Intervi... http://ping.fm/iHutv

How to secure against SQL injection ?...

How to secure against SQL injection ? - What is SQL Injection? The ability to inject SQL commands into the database ... http://ping.fm/K2u8t

SQL Error : Msg 801, Level 20, State ...

SQL Error : Msg 801, Level 20, State 1, Line 1 A buffer was encountered with an unexpected status of 0x%x. http://ht.ly/1a0wRF

Hardware and Software Requirements fo...

Hardware and Software Requirements for Installing SQL Server http://ping.fm/okWOT

Video : How to Add a Node to an Exist...

Video : How to Add a Node to an Existing SQL Server 2008 Failover Cluster http://ping.fm/A7P6W

Video : How to Setup Replication with...

Video : How to Setup Replication with SQL Server 2008 ? - What is Replication ? Replication is the mechanism for cre... http://ping.fm/DvCUD

Video : How to implement Resource Governor

This Video demonstrates

How to Enable & Disable Resource Governor using SQL Server Management Studio
How to create Resource Pool ?
How to create Workload Group ?
Create a Classification Function ?
How to monitor the resource pools using performance monitor?
What is Resource Governor ?
How to use Resource Governor?
What is the use of Resource Governor ?
How to implement Resource Governor ?

From: http://ping.fm/4MBCJ

Video : How to Export SQL Server Data...

Video : How to Export SQL Server Data to Excel - Copying data from SQL Server to Excel is business requirement. Toda... http://ping.fm/iaUUf

How to Implement Transparent Data Enc...

How to Implement Transparent Data Encryption (TDE)? - What is Transparent Data Encryption (TDE)? Transparent Data En... http://ping.fm/nUPs1

SQL Server 2011 ? New Version Release...

SQL Server 2011 – New Version Release - SQL Server 2011, Yes, Microsoft has planned for it and working on same line,... http://ping.fm/cbujZ

Best Practice ? SQL Server Error Log ...

Best Practice – SQL Server Error Log Management - What is the SQL Server Error Log? SQL Server maintains its own err... http://ping.fm/984dv

SQL Error : Msg 204, Level 20, State ...

SQL Error : Msg 204, Level 20, State 1, Line 1 Normalization error in node http://ping.fm/iIoFs

SQL Server DBA Resume

SQL DBA Resume with 10+ years of Experience

From: http://ping.fm/NqBGB

SQL Server 2005 Service Pack 4 CTP av...

SQL Server 2005 Service Pack 4 CTP available - The CTP version of Service Pack 4 (SP4) for Microsoft SQL Server 2005... http://ping.fm/rGhYS

How to Enable PAE in Windows Server 2...

How to Enable PAE in Windows Server 2008 - PAE (Physical Address Extension) is an Intel-provided memory address exte... http://ping.fm/9yhye

How to Install and Configure Master D...

How to Install and Configure Master Data Services – Video - Master Data Management (MDM) comprises a set of processe... http://ping.fm/khoor

How to Set up Maintenance Plan to Bac...

How to Set up Maintenance Plan to Backup Databases (Video) - Setting up a Maintenance Plan to Backup Databases This ... http://ping.fm/8paN4

New Features in SQL Server 2008 R2 - ...

New Features in SQL Server 2008 R2 - Here are five of the most important features you should watch for in SQL Server... http://ping.fm/i1eSH

Msg 21, Level 20, State 1, Line 1 War...

Msg 21, Level 20, State 1, Line 1 Warning: Fatal error %d occurred at %S_DATE. Note the error and time, and contact ... http://ht.ly/19Ie0C

SQL Server Management Studio (SSMS) ?...

SQL Server Management Studio (SSMS) – Keyboard Shortcut Keys http://ping.fm/zRRXl

SQL Server Management Studio ? Client...

SQL Server Management Studio – Client Statistics - SQL Server Client Statistics,Client Execution Time ,Query Profile... http://ping.fm/4bP9n

Microsoft SQL Server 2008 Service Pac...

Microsoft SQL Server 2008 Service Pack 2 - Microsoft SQL Server 2008 Service Pack 2 (SP2) is now available for downl... http://ping.fm/PWjCW

Is it possible to restore a backup of...

Is it possible to restore a backup of a SQL Server 2008 database onto an instance of SQL Server 2005? http://ping.fm/Y0DLR

SQL Server Update Statistics with FUL...

SQL Server Update Statistics with FULL SCAN -   Sometimes you just need a quick method to update all statistics... http://ping.fm/fH99o

Why Should I Use Extended Events in S...

Why Should I Use Extended Events in SQL Server 2008 ? - SQL Server Extended Events (Extended Events) is a general ev... http://ping.fm/6nH5M

How Much Space is used by all SQL Ser...

How Much Space is used by all SQL Server Databases ? - This is the very handy question during the operational suppor... http://ping.fm/MqJH7

SQL Server 2005 memory configuration ...

SQL Server 2005 memory configuration - Some notes on memory configuration management for SQL server 2005 (32bit and ... http://ping.fm/BssXj

SQL Server Trainer ? Profile

DBATAG, specialized in SQL Server Corporate trainings and SQL Server Consulting. Please download the attached profile for your ready reference.

From: http://ping.fm/KiPqc

SQL Server Trainer ? Profile - DBATAG...

SQL Server Trainer – Profile - DBATAG, specialized in SQL Server Corporate trainings and SQL Server Consulting. Plea... http://ping.fm/TtWg0

SQL Server Securable ? Permissions / ...

SQL Server Securable – Permissions / Security - SQL Server 2005 introduced a new concept to SQL Server security and ... http://ping.fm/VUjML

SQL Server Advance L3 Workshop in HCL...

SQL Server Advance L3 Workshop in HCL, NOIDA – Oct 04 to Oct 08, 2010 http://ping.fm/OsLV7

How to change default value of SELECT...

How to change default value of SELECT or EDIT top rows in SSMS 2008 ? http://ping.fm/QQEXu

Find All SQL Servers in your Local Ne...

Find All SQL Servers in your Local Network - Today, somebody asked me, how can I find what all are SQL Server Instan... http://ping.fm/wpP2O

Microsoft SQL Server 2008 R2 ? PowerP...

Microsoft SQL Server 2008 R2 – PowerPivot for Microsoft Excel 2010 http://ping.fm/F15BA

How to convert LiteSpeed backup to a ...

How to convert LiteSpeed backup to a native SQL backup ? - SQL Lite Speed is a well known SQL backup software. At ti... http://ping.fm/P3pnt

"Black Box" in SQL Server 2008 - In S...

"Black Box" in SQL Server 2008 - In SQL Server 2008, the Default trace is enabled by default during the installation... http://ping.fm/2UQdb

SET STATISTICS TIME ON ? how to read ...

SET STATISTICS TIME ON – how to read results? - The SET STATISTICS TIME command is used in order to identify parse, ... http://ping.fm/DB5i8

Find All Queries executed on a partic...

Find All Queries executed on a particular Table - Question : what all select queries are running against a particula... http://ping.fm/DV0qw

SQL Monitoring with DDL Triggers - We...

SQL Monitoring with DDL Triggers - We can create a DDL trigger to audit operations such as creating or dropping tabl... http://ow.ly/18TD3N

If you wanted to know : What is Stor...

If you wanted to know :

What is Stored in tempdb ?
A more about tempdb Internals
How to Monitor tempdb
How to Optimize tempdb
tempdb Space Allocation
Tips for Optimizing tempdb
How Many Physical Files Should tempdb Have ?
How to Move tempdb ?

Checkout the answer at :
http://ping.fm/P7SeW

SQL Server Training

Training

We have been providing Online and Classroom Trainings. We undertake interactive and quality trainings with real-time orientation on SQL Development (DEV), Database Administration (DBA) and Business Intelligence (MSBI) modules.

Certifactions Training

MCITP – SQL Server 2008, Implementation and Maintenance
MCITP – SQL Server 2008, Database Development
MCITP – SQL Server 2008, Business Intelligence Development and Maintenance
MCTS – SQL Server 2005
MCITP – SQL Server 2005 DBA
MCITP – SQL Server 2005 Developer
MCITP – SQL Server 2005, Business Intelligence Development and Maintenance


Courses Offered
SQL Server Development Training
SQL Server Administration Training
Microsoft Business Intelligence Training
Certification Oriented Trainings
DBA Job Support
MSBI Job Support
SQL Server Training

Training Methods
Online Training
Offline (Class Room)Training
Corporate Training
Weekend Training
Weekend Workshops
Fast Track Courses
Interview Assistance
Training Features


Study Material
Real Time Methodologies
Recorded version of each session
Example Case Studies
24*7 Availability for doubts
Sample Projects
Resume Preparation
Interview guidance and tips
Mock Interviews
FAQs and Best Practices