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


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


Best Practice No.21

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


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


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


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


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


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