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 ...

To plan, manage, administer and secure system databases as well as troubleshoot any database issues affecting system performance and ensure data quality across the databases.

Up next on the exam release schedule is 70-228 Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition exam. The exam covers basic creation, installation, configuration ...

You have the basic script-building skills, so let's build a script that retrieves and stores SQL Server configuration data. My last few columns have dealt with the basics of setting up PowerShell and ...