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

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

It’s official: support for Microsoft Corp.’s venerable database offering SQL Server 2005 has come to an end this week. The 10-year-old server product is officially out of Microsoft’s product lifecycle ...

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

A dynamic web application needs an admin section for CRUD actions on the records/tables in the database. Wouldn't it be nice to have a database admin, which can be plugged to any web application? Just ...

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.