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...
SQL Server MVP, Consultant, Speaker, Trainer and Learner ;)
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...
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...
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...
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...
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
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...
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...
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...