When I (along with many other people) had a lot of trouble trying to install SQL Server Management Studio in an attempt to switch from the SQL Server 2008 R2 evaluation to the free Express version, I ...

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

1、 依次点击开始菜单，选择Microsoft SQL Server 2008 R2，然后打开其中的SQL Server 配置管理器程序，即可进入配置界面进行相关服务与网络协议的设置和管理。 2、 启动SQL Server配置管理器并进行相应设置调整。 5、 随后启动SQL Server代理服务即可。 6、 我是这样处理的 ...

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

Let's follow up the last column with a step-by-step breakdown shows how the PowerShell script automates SQL Server backups, manages retention, logs activity and verifies data integrity. In my first ...