When it comes to migrating a SQL Server database from one environment to another, admins tend to rely heavily...
Tag Archive for: database
4sysops - The online community for SysAdmins and DevOps
Azure Data Studio vs. SQL Server Management (SSMS)

If your Windows systems administration work touches SQL Server products, you need to know when Azure Data Studio is...
Migrate a SQL Server Database to Azure SQL Database

Learn how to assess and migrate your on-prem SQL Server databases to Azure SQL Database by using Microsoft's Data...
Copy SQL Server database

Considering that many Microsoft enterprise products rely on SQL Server, many admins face the task of copying the SQL...
Enable TLS on SQL Server

Secure Socket Layer (SSL) and Transport Layer Security (TLS, which builds on the now deprecated SSL protocol) allow you...
Create and manage append blobs with PowerShell

Before diving into how to manage append blobs using PowerShell, let's have a quick look at the blob types...
Interact with Azure Cosmos DB with PowerShell

Learn how to perform core administrative tasks on the Azure Cosmos DB using Azure PowerShell.
Setting Up SQL Server Always On availability groups (AG) on AWS EC2 Instances

In this article, we offer a step-by-step guide on how to set up a SQL Server Always On availability...
Backup script for SQL Server databases

Every now and then, a sysadmin has to deal with SQL Server backups. In this article, we'll set up,...
Amazon RDS on VMware

Amazon Relational Database Service (RDS) is a new joint solution from Amazon and VMware. In this article, you'll learn...
Install SQL Server 2019 (Express) on Windows Server Core and activate remote management

Microsoft recommends Windows Server Core for most infrastructure services and for applications such as Exchange 2019. You can also...
New features in SQL Server 2019 GA

SQL Server 2019 has now been released as GA and offers many great new features. Let's take a look...
Installing service packs on a SQL cluster with PowerShell

In this post, you will learn how to automate installing SQL server service packs on a SQL cluster with...
Best practices for running Microsoft SQL Server on VMware vSphere

If you run Microsoft SQL Server on VMware vSphere, you do so to have more flexibility, high availability, and...
Sync Active Directory users with a SQL database

Syncing Active Directory (AD) users with a SQL database is a common task many IT administrators encounter. In this...
Deploy a MS-SQL database using AWS RDS and PowerShell

Using Amazon Web Services (AWS), we can use their Relational Database Service (RDS) to deploy an MS-SQL database quickly...
Create an Azure SQL database with PowerShell

Using the Azure PowerShell module, we're able to create an Azure SQL database with just a few lines of...
Manage Azure Table storage using PowerShell

Azure Table storage is a data store you can use to store structured data in a non-relational way. Azure...
Excel Get & Transform – Connect to data sources

With Get & Transform in Excel 2016, you can easily connect to various data sources such as Active Directory,...
How to deploy an Azure SQL Database

Nowadays Azure SQL Database has nearly full parity with its on-premises counterpart, SQL Server. Learn how to deploy a...