Recently executed SQL Statements
SELECT last_execution_time , [text] AS [Statement] FROM sys . dm_exec_query_stats CROSS APPLY sys . dm_exec_sql_text ( sql_handle ) ORDER BY last_execution_time …
Failover Clustering
Failover Clustering High availability option, standby instance on a different node In case of failover: active transactions are rolled back, connections retry, reconnect to other node Single copy of …
SQL Server 2008 Database Mirroring
Database Mirroring Software solution for high availability. Per database and not per server. Increase data protection, availability, upgrade availability. Careful – A lot of things live outside the d…
DBA database management checklist
Problem For both old and new DBAs there are fundamental procedures that should be addressed and proper processes put in place to handle various areas of database management for SQL Server. Whet…
Deprecated Features – SQL Server 2008
BACKUP LOG .. WITH NO_LOG / TRUNCATE_ONLY Almost every dba uses “BACKUP LOG <mydb> WITH TRUNCATE_ONLY or NO_LOG” statement to truncate the database; Basically when you truncate the log file…