I'm new at this whole DBA thing, so maybe this is totally standard practice.<BR><BR>But we have a software vendor that wants remote access to our SQL server at an admin level to setup and install ...

Late in 2017, I informed you about a public preview for a new data management tool from Microsoft called SQL Operations Studio. SQL Operations Studio is a very flexible and lightweight data management ...

Sometimes you don't need a full-fledged database-management environment. Maybe you just need to go in and add a field, change a table or write an ad hoc query. Certainly you can do all those things in ...

“Free” is a term rarely associated with Microsoft offerings, especially at the server end of the spectrum. Exchange Server, SQL Server, SharePoint, Hyper-V — IT admins know functionality comes at a ...

Despite its steep licensing costs, SQL Server continues to prove its worth over open-source alternatives in some key areas. SQL Server is an expensive part of your IT stack -- SQL Server Enterprise ...

Remote Server Administration Tools (RSAT) are meant for the system and IT administrators. They allow admins to set and manage roles as well as the features that are installed on a Windows Server ...

A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.