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

The inclusion of PowerShell will reinvent the way DBAs manage their environments by taking complicated cursors out of management scenarios. This is the debut of PowerShell in SQL Server, and there are ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...