Tags » Database Administrator

Top Tips to Maintain the Security of Database Environment

It’s very difficult to be confident about the security of database environment? Because databases may contain sensitive or regulated information, critical applications or stored functions, ensuring database security is undoubtedly a number one priority. 960 more words

Database Administrator

UPDATE Statement with .WRITE - Minimally logged operation during Partial/Full Update

The .WRITE clause is an integral part of the UPDATE statement. Commonly it’s used to perform a partial update on big data set of VARCHAR (MAX), NVARCHAR (MAX) and VARBINARY (MAX) data types. 299 more words

Database Administrator

DIY DBA - hobbyist or menace?

Musings on a consultant’s world.

We’ve all met them.  Either at work, on a project or in social interaction, the person who you meet and they say “oh, you’re an Oracle DBA… me too.   740 more words