Results of my poll What is Your Favorite Database? SQL Server won with 64% of 1,697 votes, followed by Oracle at 25% and MySQL at 8%.
SQL SERVER – Check if Current Login is Part of Server Role Member
Clients sometimes forget to give me admin rights. IS_SRVROLEMEMBER(‘sysadmin’) checks if the current login is a Server Role Member: 1 means yes, 0 means no.
SQL SERVER – Introduction to JOINs – Basic of JOINs
A simple introduction to JOINs: INNER JOIN and the three OUTER JOIN types, written for members of the Gandhinagar SQL Server User Group who asked for it.
SQL SERVER – FIX : ERROR : The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine Error:2147749896 (0×80041008)
SQL Server 2005 setup on Vista said the System Configuration Checker cannot be executed due to WMI configuration. A batch file from a friend fixed it for me.
SQL SERVER – Interesting Observation of DMV of Active Transactions and DMV of Current Transactions
sys.dm_tran_active_transactions and sys.dm_tran_current_transaction look alike, but one lists active transactions for the instance, the other only your session.
SQL SERVER – Restore or Attach Database Without .NDF or .MDF is Not Possible
Can you restore or attach database files if the .mdf or an .ndf file is missing? In one word, no. Here is why every data file is needed.
Replacing Profiler Traces With Extended Events
Replacing Profiler traces with Extended Events starts with the question, a focused event session, and a bounded target that avoids needless load.