SQL DBA Blog

Tag: AWS

  • How to Manage S3 Buckets with AWS CLI

    This is a post on how to help manage S3 Buckets with AWS CLI, and to help explain some local Operating System (OS) considerations when running such commands. First of all, you will need to be authenticated to your AWS Account and have AWS CLI installed. I cover…

    Read More

  • How to Install & Configure AWS CLI on Ubuntu

    This guide will walk you through the steps to install and configure AWS CLI version 1 on Ubuntu (20.04). Topics Covered: 1. Updating Local Packages2. Installing AWS CLI on Ubuntu3. Checking Installed AWS CLI Version4. Configuring AWS Profile5. Running AWS CLI Commands 1. Updating Local Packages To start,…

    Read More

  • How to Install and Configure AWS CLI on Windows

    This post is a how-to for installing & configuring AWS CLI (Version 2) on Windows. In this guide, we’re going to download the AWS Command Line Interface installation media and run through the simple installation. Once done we’ll configure AWS CLI, which you’ll need an AWS Account to…

    Read More

  • AWS CLI: List IAM Users

    Managing AWS IAM users is essential for maintaining control and security in your cloud environment. The AWS CLI provides a simple command to list all users in your AWS account. Basic Command The aws iam list-users command returns details about all IAM users, such as user names, ARNs,…

    Read More

Useful SQL DBA Posts

SQL Server Performance
– Get Full SQL Server System Info Fast
– Quick Performance Troubleshooting Scripts
– Identify Missing & Unused Indexes
– Get Wait Stats & Top Consuming Queries
– Get Exclusive Locks on Tables
– Get Last Node Blip in SQL Server FCI
Security & Maintenance
– Get Estimated Database Backup/Restore Time
– Get Last Database Backup Dates/Times
– Get Database Sizes & Space Used
– How to Get Table Sizes
– Get Index & Heap Fragmentation Levels
– Get SQL User Permissions and Roles
– Creating SQL Users on Availability Groups
– Audit Failed Login Attempts

Categories

– Microsoft SQL Server
– Windows Server
– PowerShell
– Linux & WSL
– Other

Tags

Always On Availability Groups (AAG) AWS Certificates & Encryption Change Data Capture (CDC) Database Admin Database Backups & Recovery Database Mirroring Deleting Data Error Messages Git Commands Importing & Exporting Data Linked Servers Linux Admin Logging & Monitoring Measuring Databases Microsoft Patching PowerShell Scripts SQL Server Agent SQL Server Database Files SQL Server Data Types SQL Server Management Studio (SSMS) SQL Server Network Connectivity SQL Server on Linux SQL Server Patching SQL Server Performance SQL Server Permissions SQL Server Processes (SPIDs) SQL Server Replication SQL Server Scripts Windows Admin Windows Authentication Windows Automation Windows Events Windows Firewall Windows Subsystem for Linux (WSL)