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 ...
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 ...
The purpose of the job is 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.
I'm not a SQL server admin (And it seems no one in this company is) but I know some of the basics. Got a bit of an issue right now and I can't troubleshoot it because our SQL Server log files are 15GB ...