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

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

This article explains how to create a SQL Server Agent job using SQL Server Management Studio (SSMS), Transact-SQL (T-SQL), or SQL Server Management Objects (SMO). To add job steps, schedules, alerts, ...

Throughout this series of posts there have been a number of examples of how to use the SQL Server PowerShell provider. However, these were always in context with a specific task (i.e. automating ...

Install-Package Microsoft.SqlServer.SqlManagementObjects SQL Server Management Objects (SMO) Programming Guide C:\Program Files\Microsoft SQL ...

Russell Smith is a technology consultant and trainer specializing in management and security of Microsoft server and client technologies. He is a Microsoft Certified Systems Engineer with more than 15 ...