1
kudos
spam Kudos Remove

Use the Best Tool for the Task - Part 2

published 983 days, 19 hours, 10 minutes ago posted by sasa 992 days, 8 hours, 51 minutes ago
Saturday, September 12, 2009 12:46:25 PM GMT Thursday, September 03, 2009 11:06:10 PM GMT

Yesterday I posted about how Transact-SQL was better suited than SMO for gathering details about database files for a database with very large files. Today I'd like to point out that creating the database I used to test that fix was far easier with PowerShell and SMO than any other method. SQL Server, and Transact-SQL specifically, are very good at set-based activity, and that's a good thing. Relational databases are based on a set model. To create all the files I needed for my test I needed an itera...

category: Management | clicked: 1 | | source: sqlblog.com | show counter code
tags: PowerShell, SMO

No comments yet, be the first one to post comment.

To post your comment please login or signup