dba

SQL Update Statement with Join in SQL Server vs Oracle vs PostgreSQL

• by Additional Articles

• MSSQLTips.com

• Data Platform
• multi-platform

• Article

In this article we look at the different SQL syntax you need to use when updating data when joining tables for SQL Server, Oracle and PostgreSQL.

2021-01-29

DBA in training: Know your server’s limits

• by Additional Articles

• SimpleTalk

• Database Administration

• Article

Comparing current performance to baselines helps DBAs know when there’s a problem. In this article, Pamela Mooney describes how to measure the physical resources drive space, latency, memory, and CPU.

2021-01-06

DBA in training: Backups, SLAs, and restore strategies

• by Additional Articles

• SimpleTalk

• DB Administration

• Article

There are a handful of options when backing up SQL Server databases. A DBA must understand the differences and come up with a plan that protects the organisation’s data. In this article, Pamela Mooney explains service level agreements, recovery models, and some strategies to ensure that the data can be restored quickly.

2020-12-09

SQL Server Backup Types

• by Additional Articles

• SimpleTalk

• Backup
• Backup and restore

• Article

One of the most important responsibilities for a DBA is to ensure that a database can be restored in case of corruption, a dropped table, or another disaster. In this article, Greg Larsen explains the different types of backups available with SQL Server.

2020-12-01

DBA in training: Security

• by Additional Articles

• SimpleTalk

• Database Administration
• DBA

• Article

Securing data is not always easy to do, but it should be the top responsibility for database administrators. From protecting the physical servers to preventing copies of backups files from getting into the wrong hands, there is a lot to consider. In this article, Pamela Mooney covers what DBAs need to think about when securing their organisation’s data.

2020-11-19

Using the SQL Monitor Estate Pages

• by Additional Articles

• Redgate

• SQL Monitor

• Article

Kathi Kellenberger introduces the new Estate monitoring pages in SQL Monitor 9, and explains how they will help DBAs monitor and safeguard the security, stability and availability of all servers in their care.

2019-04-18 (first published: 2019-04-08)

Introduction to SQL Server Security — Part 2

• by Additional Articles

• SimpleTalk

• SQL Server

• Article

In this article, the second in the series, Robert Sheldon demonstrates how to manage the SQL Server security with granting permissions to users, logins, and groups.

2019-02-25

2,336 reads

An Introduction to GitHub for DBAs

• by Additional Articles

• Brent Ozar Unlimited Blog

• GitHub

• Article

Distributed source control is really intimidating: branches, pull requests, merges – will somebody just take my code, for crying out loud? Why does it have to be so complicated and involved?

2019-02-22

3,826 reads

What Is SQLPSX?

• by Additional Articles

• SimpleTalk

• PowerShell

• Article

SQLPSX is a useful library you can add to PowerShell to automate many DBA tasks. In this article, Laerte Junior demonstrates several useful commands and shows you how to create a SQL Agent job using this library to run daily DBA checks.

2018-11-19

3,347 reads

How to Linux for SQL Server DBAs — Part 2

• by Additional Articles

• SimpleTalk

• Linux SQL Server

• Article

SQL Server DBAs are typically quite familiar with security and best practices in Windows but may not understand how security works in Linux. In this article, Kellyn Pot'Vin-Gorman demonstrates how to manage user accounts in Linux and why working while logged in as root is a bad idea.

2018-10-22

2,405 reads