Getting a List of the Striped Backup Files
If you have a list of striped backup files, how can you find the latest backup set? Steve Jones uses dbatools and PowerShell to automate this process.
2019-10-03
2,299 reads
Search results for "availability+groups"
Your search for "availability+groups" returned 100 results:
Cloud Computing Basics - Achieving High Availability
Learn about high availability in the cloud at a conceptual level.
2022-03-28
1,406 reads
SQL Server technical documentation - SQL Server | Microsoft Learn
Always On availability groups · Always On failover cluster instance · Database mirroring · Log shipping · Replication. Security. Overview. SQL Vulnerability ...
The case for SQL Server Agent 2.0
SQL Server Agent is heavily used by many organizations, but it hasn't changed much in years. This article speculates on some new features that might improve the scheduler.
2020-12-21
3,302 reads
Updating an expired SQL Server TDE certificate
Now you might be wondering how you can generate a new certificate to replace the previous certificate and the steps if the database is in an Availability Group.
SQL Server in Azure Virtual Machines - Performance Optimizations
When deploying SQL Server in an Azure virtual machine, you can take advantage of several Azure Infrastructure-as-a-Service (IaaS) features that enhance performance of the SQL Server database engine. This article explores a couple of these enhancements, with a particular focus on increased I/O throughput facilitated by the Solid State Drive (SSD) storage available on most Azure virtual machines (VMs).
2017-01-17
5,354 reads
Fixing "Login failed for user" error in SQL Server
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
40,447 reads
When one of your DBA colleagues leaves the company, what is your checklist?
A colleague left the company, a couple of days after SQL Server processes start failing...what do you do?
2020-09-29
6,123 reads
Views in SQL Server 2019 with SSMS
This article explores how to create and use views in SQL Server 2019 using SSMS.
2021-12-27
5,739 reads
My SQL Server Database is Corrupt - Now What?!
How do you recover from corruption if your organization doesn't have a disaster recovery handbook? And how can you prevent the same corruption from recurring?
2013-01-29
8,063 reads
Blogs
How Redgate Flyway Can Boost Your DevOps Journey
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Building a Docker image with Docker Build Cloud
In a previous blog post we went through how to build a Docker container...
Top 8 Courses to Learn SQL for Data Science in 2024 & Beyond
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
Forums
client_app_name is empty in Extended Events output but present in sp_who2
I'm tracing activity on one database and would like to include the client_app_name in...
How to compare data in customer table with other customers to find related cust
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
process records in loop
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Question of the Day
The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers