Sep 022013
 

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 Practice No.18

Sep 022013
 
SQLServer Day 14th September 2013 | 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 coming to two cities in India; Gurgaon & Hyderabad. This is yet another opportunity to learn. The Sessions are Troubleshooting Deadlocks, How to use SQLDiag and SQL Nexus, Hekaton (In-Memory) Database SQL [Read More]

Aug 312013
 

Checkpoint is an internal process that writes all dirty pages (modified pages) from Buffer Cache to Physical disk, apart from this it also writes the log records from log buffer to physical file. Writing of Dirty pages from buffer cache to data file is also known as Hardening of dirty pages. It is a dedicated [Read More]

Aug 222013
 

Always use SQL Server Configuration Manager to change Service account for any SQL Related Service. Related posts: Error while opening SQL Server Configuration Manager – Fixed SQL Tip-2 | Make Sure the startup type of your SQL Service is Automatic* What all changes require a restart of SQL Service? SQL Server AWE Enabled Option | [Read More]

Aug 192013
 
SQL Tip-8 | How to script out multiple SQL Server jobs at once

Migrating SQL Server jobs from one server to another is a critical task and there are many alternatives available for the same, the easiest one available is to script out each and every job and re-create them on the destination server. If there are a few jobs you can very well script out each and [Read More]