Minimal Downtime Storage Migration of Large Databases
This article shows how we were able to migrate a TB size database to new storage with minimal downtime.
2024-01-01 (first published: 2021-02-24)
7,609 reads
This article shows how we were able to migrate a TB size database to new storage with minimal downtime.
2024-01-01 (first published: 2021-02-24)
7,609 reads
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
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
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
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
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
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 […]
2020-11-24
47,801 reads
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 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
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
By Steve Jones
tangency– n. a fleeting glimpse of what might have been. I tend to live...
I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which...
The AI revolution isn’t coming – it’s here. Companies are racing to integrate artificial...
Hi All, need help with an SQL query. We have an existing table that's...
I connect to this clustered instance and run : begin distributed transaction Msg 8501,...
Several times in the last couple of days I've had submissions time out with...
What is the output of this code in SQL Server 2022?
select bit_count(0xEF)See possible answers