Don’t keep the System Database files & Windows installation on same disk. Related posts: Best Practice No.6 Best Practice No.19 Best Practice No.11 Best Practice No.5 What do you mean by Principals? (with respect to SQL Server)
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 so in theory there is nothing wrong with a large Error Log but at times this could be very frustrating. Let’s [Read More]
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 out all\any of these cool features you might want to install this version but before you even think of doing this [Read More]
When choosing service accounts, consider the principle of least privilege. No related posts.
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 No.15
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 bring you 5 rock star speakers and 5 intriguing sessions. This is yet another opportunity to learn maximum from SQLServerGeeks.com across [Read More]
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
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 No.24