Sign up to the Cyber Samurai mailing list to get a
newsletter straight to your inbox
Oops! Something went wrong while submitting the form.
Sign up to the Cyber Samurai mailing list to get a
newsletter straight to your inbox
Behind every application there is a data store and in most cases that store is a relational database. Charged with guarding and securing your data platforms are the Database Administrators (DBA).
The role of the DBA is one of protection, availability and recoverability. DBA's know the tools, the procedures and technologies to protect your data.
Keeping your data safe and secure is one of the main roles of a DBA. Promoting code from pre-prod to prod that is one for the database administrator.
Integrity is not only about protecting from corruption. It is also about ensuring it has not been changed by anyone without authoirsation.
Being able to access your data at any time has become standard. We use failover clusters, availability groups and replication to maintain up time.
Data platforms need to be monitored at all times for performance issues, backup problems and security incidents. If you are not watching you will never know what is happening.
Learn more
As a business grows more users need to be able to access applications and systems. Keeping track of new starters and leavers is a full time job. DBA's need to be involved in various processes across the business to keep your data safe.
Data grows at an accelerating pace. Keeping track of disk sizes and predicting that growth is important to maintain a healthy server environment.
The most common question a DBA hears is "Is the database running slow?". Performance tuning is the process a DBA goes through to keep it working.
The SQL query plan is a diagram showing what the SQL engine is doing when processing a query. A DBA understands and can tune queries for better performance.
Indexes help queries find the data they need faster like an index in a book. An index can help or it can hinder performance. The DBA can create an index to help.
Databases love memory but storing everything in memory is expensive. Tuning queries can reduce memory requirements saving money on a valuable and expensive server resource.
Hear What Our Valued Clients Have to Say.
"The Cyber Samurai team are helpful, responsive and have delivered value in all areas that we have focussed on."
You always need a disaster recovery plan in place and data platforms are no different.
It goes without saying but You must backup your databases. They are your last line of defence against corruption and accidental deletion.
If you do not test your backups by restoring them then you do not have any backups. An untested backup is just a blank file and completely worthless.
There are three types, full, differential and log. Knowing which are required and when is very important for a backup and disaster recovery plan.
The language of a SQL Server relational database is Transact-SQL or T-SQL for short.
Every application has a database behind it to store and retrieve data. Creating and maintaining a database is the role of the database developer.
The modern approach to database development uses Database DevOps to maintain objects in source control for easier release management.
Restoring from live to dev without cleansing the data is very bad. The modern approach is to generate test data for development.
