database administration

Minimal Downtime Storage Migration of Large Databases

• by DineshKarunarathna

• SQLServerCentral

• Database Migration
• Log Shipping

• Article

This article shows how we were able to migrate a TB size database to new storage with minimal downtime.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

Log in or register to rate

2021-02-24

2,379 reads

• Discuss

SQL Server triggers: The good and the scary

• by Additional Articles

• SimpleTalk

• Database Administration

• Article

SQL Server triggers are another tool in your DBA or Dev toolbox. Edward Pollack explains what can go wrong with triggers and how to correct those issues.

2021-02-18

Search SQL Server error log files

• by Additional Articles

• SimpleTalk

• Database Administration

• Article

The SQL Server error log is helpful for troubleshooting issues. Greg Larsen demonstrates several ways to search SQL Server error log files.

2021-02-11

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

Exploring errors to reveal unauthorized information

• by Additional Articles

• SimpleTalk

• Database Administration
• SQL

• Article

Database administrators can never stop thinking about security. In this article, Fabiano Amorim shows how data can be revealed through error messages when views are used to secure rows.

2020-11-25

Fixing "Login failed for user" error in SQL Server

• by DineshKarunarathna

• SQLServerCentral

• SQL Installation
• SQL Monitoring
• SQL Server 2016
• SQL Server 2017
• SQLServer

• Article

In this article, I am going to explain fixing a problem related login failure error with SQL Server. The Problem One of the common error in the SQL Server error log is "Login failed for user 'DomainName\ServerName$'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]". Even though it says that […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2020-11-24

4,036 reads

• Discuss

Storage 101: Monitoring storage metrics

• by Additional Articles

• SimpleTalk

• Database Administration

• Article

Well tuned storage is essential for SQL Server performance. In this article, Robert Sheldon explains the metrics that are important to watch.

2020-11-10

SQL Server Synonyms

• by Additional Articles

• SimpleTalk

• Database Administration

• Article

SQL Server synonyms can be used to permanently alias database objects in the same or another database. In this article, Greg Larsen demonstrates how to use synonyms and the many reasons to consider using them.

2020-10-20

Understanding SQL Server Recovery Models

• by Additional Articles

• SimpleTalk

• Database Administration

• Article

The database recovery model controls how a SQL Server database can be backed up and restored. In this article, Greg Larsen explains the three recovery models and what to think about when choosing a recovery model for a database.

2020-09-21