(Ed Elliott) I installed the 2016 SSMS client recently and in one way or another any of my apps that I have written that use the DacFx ScriptDom have all broken in slightly different ways.

(Joshua Feierman) Because so much of the work of the DBA involved doing things in the right order without missing steps out, checklists are a great way of ensuring that the chance of mistakes is minimised. DBAs generally create the sort of checklist style that suits their way of working, while makin

(Pinal Dave) Sometimes our learnings are questioned and it is important to visit some of my prior blogs to validate the content.

(Ed Elliott) I installed the 2016 SSMS client recently and in one way or another any of my apps that I have written that use the DacFx ScriptDom have all broken in slightly different ways.

(Joshua Feierman) Because so much of the work of the DBA involved doing things in the right order without missing steps out, checklists are a great way of ensuring that the chance of mistakes is minimised. DBAs generally create the sort of checklist style that suits their way of working, while makin

(Pinal Dave) Sometimes our learnings are questioned and it is important to visit some of my prior blogs to validate the content.

(Jason Brimhall) Working with databases, XML, and many software applications, it is not uncommon to deal with fixed schemas. In the database world, it is fairly fundamental to have some sort of schema.

(Shaun Stuart) It’s been quite a while since I last took a look at my script to monitor for endless index defragmenting by Ola Hallengren’s index maintenance scripts.

(Jack Vamvas) The RING_BUFFER_SCHEDULE_MONITOR has been around since SQL Server 2005. It remains a great way of obtaining system CPU utilization information.

(Manvendra Singh) I want to temporarily use a Log Shipped secondary database for Read Only operations, but Log Shipping was not configured for read only operations. I don’t want to reconfigure Log Shipping, so is there a way to do this without redoing Log Shipping.