Better Triage: Getting hospital care delivered properly

If you have seen my recent posts on LinkedIn you probably know that I am looking to interact with healthcare professionals to brainstorm ideas on how Triage can be improved. In this post I will cover what Triage is and some common issues identified with the process and my attempt at a solution. I am…

Training DBA from other countries

Technology is a universal language so training DBAs from other countries is not really a challenge when covering technical aspects. But here are a few things to keep in mind. Time zones- lunch breaks are different for different people. Office hours – Availability of daylight usually impacts office hours and typically there is a difference…

sys.Dm_db_database_page_allocations()

This new DMV is basically a modified version of the DBCC IND command that is used to display the page allocations for a specific database object like a table. The advantage of the DMV is that it’s readily portable and provides a more complete picture of the allocations of the pages to the object it…

SQL Server Replication Series Part 1

This blog is the first in a series on the topic of SQL Server replication. The topics are the same for the most part for SQL Server 2008 R2 or 2012. In case there are any obvious differences we will call them out as we go along. Replication is one of Microsoft SQL Servers high…