2

SQL Tip-1 | Don’t forget to recycle your SQLServer ErrorLog

Many a times I’ve seen that DBAs forget to recycle the ErrorLog of their critical SQLServers. Now I also understand that SQLServer Error Log is very important & can help you troubleshoot many issues...

0

Read Before you even think of Installing SQLServer 2014 CTP1

SQL Server 2014 CTP1 is out with lots of cool & exciting features, if you’ve not yet downloaded it, you can get it from below mentioned link: http://www.microsoft.com/en-us/sqlserver/sql-server-2014.aspx If you are want to try...

0

Best Practice No.21

When choosing service accounts, consider the principle of least privilege. No related posts.

0

Best Practice No.20

Don’t forget to backup System Databases (Master, Model and Msdb) while configuring Backups for your SQL Server Instance. Related posts: Best Practice No.14 Best Practice No.6 Best Practice No.8 Best Practice No.10 Best Practice...

0

SQLServer Day 20th July 2013 | Gurgaon & 3rd Aug 2013 | Bangalore

Hi Friends, SQLServerGeeks.com cordially invites you to SQL Server Day, the monthly dose of SQL Server knowledge & learning. And this time we are coming to two cities in India; Gurgaon & Bangalore. We...

0

Best Practice No.19

Always keep Data and Log files on separate Physical Disk. Related posts: Best Practice No.6 Best Practice No.22 Best Practice No.11 Best Practice No.5 Best Practice No.16

0

Best Practice No.18

Avoid using SELECT * FROM <Table_Name>, try to use only the required Columns & Rows – if possible. Related posts: Best Practice No.6 Best Practice No.9 Using Covering Index Best Practice No.3 Best Practice...

0

Best Practice No.17

Configure start-up mode of your cluster SQL Services to Manual. Related posts: Best Practice No.23 SQL Tip-2 | Make Sure the startup type of your SQL Service is Automatic* Best Practice No.13 Best Practice...