• Adam Thurgar

Oncology App - DBA's

After a technical architecture review, it became apparent to the CIO and CTO of the hospital that this was not a simple environment. In production there where Availability Groups (synch and asynch) across two data centres, the use of TDE and key management, SSL certificates and more SQL Server faetures such as CDC and auditing to come (and SSRS and Power BI). Plus the production environment was reproduced for a testing/training environment and a staging environment.

The key decision here was that they had no DBA resources to manage this whole infrastructure.

They needed to hire a DBA. The suggestion was actually for two DBA's. One senior DBA (or mid to senior) to be the lead and then a junior DBA (or junior to mid). Only with two DBA's could they avoid a single point of failure.

It was very important to the project that this skill shortage was identified early and recruiting could commence before the system went live.

3 views0 comments

Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t