Friday, December 31, 2010

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

Thursday, December 30, 2010

List 10 difference between TRUNCATE &...

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

Wednesday, December 29, 2010

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

Tuesday, December 28, 2010

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

Monday, December 27, 2010

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

Wednesday, December 22, 2010

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

Tuesday, December 21, 2010

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

Monday, December 20, 2010

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

Sunday, December 19, 2010

Can we have Mirroring between Standar...

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

Saturday, December 18, 2010

How to get SQL Server Install Directo...

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

Friday, December 17, 2010

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

Tuesday, December 14, 2010

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

Monday, December 13, 2010

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

Sunday, December 12, 2010

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

Saturday, December 11, 2010

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

Thursday, December 9, 2010

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

Wednesday, December 8, 2010

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

Tuesday, December 7, 2010

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

Monday, December 6, 2010

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

Sunday, December 5, 2010

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

Saturday, December 4, 2010

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

Friday, December 3, 2010

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

Thursday, December 2, 2010

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

Wednesday, December 1, 2010

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