SQLServer Day 11th January 2014 | Gurgaon
Hi Friends, SQLServerGeeks.com cordially invites you to SQL Server Day, the monthly dose of SQL Server knowledge & learning. And this time we are going to cover both Dev and ITPro Audience with two...
MVP Community Day \ PowerShell Day 9th Nov’2013 | Gurgaon
Dear Friends, This Saturday (9th Nov’2013) South East Asia MVP Community is celebrating MVP Community Day, a day dedicated to Knowledge sharing & Learning. On this very day New Delhi PowerShell User Group...
SQLServer Day 26th October 2013 | Gurgaon | Bangalore | Hyderabad
Hi Friends, SQLServerGeeks.com is planning a multi city SQLServerDay, Yes – This time on 26th October 2013 we are doing Free SQLServerDay in three cities in India: Bangalore, Gurgaon and Hyderabad. We bring you...
Find Users with DBOwner Database role
Scenario: Auditors need a list of Users who have DBOwner Database role on any of the database which are hosted on Tier 1 Servers. Giving this information was Very easy for few servers where...
Best Practice No.37
Check Database consistency at-least once every month. Related posts: Best Practice No.5 Best Practice No.6 Best Practice No.22 Best Practice No.11 Best Practice No.25
Best Practice No.36
Do proper capacity planning for the growth of your Transaction log file and size them accordingly – don’t leave it to Auto-grow on default setting to avoid performance hit. Transaction Log files cannot take...
SQL Tip-9 | Track the Original Login–even if the Execution Context is switched
Few months ago I started a series where I explained all about Execution Context & Context switching, you can use Execution context switching for many reasons but if you are auditing execution context can...
Best Practice No.35
In your backup strategy avoid taking daily backups of your read-only databases, monthly full backup is more than enough. Related posts: Best Practice No.20 Best Practice No.14 Best Practice No.6 Best Practice No.33 Best...