0

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...

0

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...

0

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...

0

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...

0

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

0

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...

0

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...