Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...

Programming-specific tasks using SMO objects include complex subjects that would only be required by programs with a specific function, such as backing up, monitoring statistics, replication, managing ...

- The <xref:Microsoft.SqlServer.Management.Smo.Agent.JobServer> object has three collections of jobs, alerts and operators. - The <xref:Microsoft.SqlServer.Management ...

PowerShell gives DBAs a reason to begin using SMO for real, so now we'll find out about all the gory details I was talking to a good friend at Microsoft last week, telling him about the problems I’ve ...

When I joined the SQL Tools team as a PM back in October 2018, my top priority was to release SQL Server Management Studio (SSMS) 18. I expected a fair amount of work but didn’t realize how ...

In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...

Last time we discussed creating a script that can retrieve configuration settings from a list of SQL Servers and placing that data into a SQL Server table. Now, let's take a look at another technology ...

Although spanking new in Katmai, Policy-Based Management already seems mature. The inclusion of PowerShell will reinvent the way DBAs manage their environments by taking complicated cursors out of ...