Author: Peter Whyte
-
What’s New in the SQL Server 2019 Installation Wizard
SQL Server 2019 was released on November 4, 2019, at Microsoft Ignite, following months of testing with release candidates. In this post, I’ll share my experience with the SQL Server 2019 installation wizard, highlighting key features and improvements that will be useful for DBAs. Key Features of SQL…
-
Domain Join Sanity Checks
In order to join a Windows Server to a domain, you may need to request that the network team open certain firewall rules. The network requirements for this process can be complex and may vary depending on your specific environment. After joining a domain, especially in a new…
-
How to Create MySQL Databases & Tables
Setting up MySQL databases and tables is a foundational skill for database administrators and developers. Whether you’re using Windows, Linux, or a cloud environment, this guide is aimed to help you create databases and tables in MySQL. Topics covered: > Create a MySQL Database> The USE DATABASE Command>…
-
How to Remove Old Windows Upgrade Files
When your machine is upgraded to a newer version of Windows, it leaves behind the C:\Windows.old directory. This folder contains backups of the previous Windows version and can take up significant disk space. Important Note:The Windows.old folder allows you to roll back to the previous Windows version. If…
-
How to Install MySQL on a Windows Computer
Installing MySQL on a Windows computer is a straightforward process, however selecting the right options is key for a smooth setup. This is a simple how to for installing MySQL Community Server and MySQL Workbench on Windows. I recommend you walk through this yourself if learning MySQL and…
-
How to Run Scheduled Tasks with SQL Server Express
SQL Server Express lacks SQL Server Agent, which means scheduling tasks like index maintenance, backups, and other recurring operations requires an alternative approach. The best way to achieve this is by using Windows Task Scheduler with sqlcmd and a batch script. In this guide, we will walk through…
-
sqlcmd Examples (SQL Server)
The sqlcmd utility allows you to execute Transact-SQL commands directly from the command line using ODBC, enabling SQL Server batch execution without the need for a GUI. This post contains sqlcmd examples to help you understand it more. sqlcmd is essential for running SQL queries, automating tasks, and…
-
How to Rename Schema’s in SQL Server
Changing the schema of a table in SQL Server can be a rare task for database administrators but a more common requirement for database developers. This guide walks through how to move a table from one schema to another using the ALTER SCHEMA statement. During my time as…
-
Adding & Removing SQL Features via Command
This post will guide you on how to add and remove features from SQL Server via the command line. The process includes checking installed features, installing a new feature (such as replication), and uninstalling a feature when no longer needed. The following areas will be covered within this…
Categories
- Linux & WSL (26)
- Microsoft SQL Server (103)
- Other (13)
- PowerShell (51)
- Windows Server Admin (45)
Tags
Always On Availability Groups (AAG) (4) AWS (4) AWS Redshift (6) Database Admin (72) Database Backups & Recovery (14) Database Mirroring (2) Error Messages (5) Failover Cluster Instances (FCI) (1) Git Commands (6) Importing & Exporting Data (2) Linked Servers (3) Linux Administration (2) Logging & Monitoring (1) Microsoft Patching (2) MySQL (4) Postgres (6) PowerShell Scripts (2) SQL Certificates & Encryption (3) SQL Server Agent (5) SQL Server CDC (2) SQL Server Data Types (2) SQL Server Management Studio (SSMS) (16) SQL Server Networking (3) SQL Server on Linux (1) SQL Server Patching (2) SQL Server Performance Tuning (6) SQL Server Processes (SPIDs) (7) SQL Server Replication (2) SQL Server Scripts (13) SQL Server Security (4) SQL Server Storage (10) Windows Admin (21) Windows Authentication (2) Windows Automation (1) Windows Events (2) Windows Firewall (4) Windows Subsystem for Linux (WSL) (18)