Thanks a lot for the feedback is pretty cool to write in sqlservercentral ! 😎

Thanks.

If you like the post, a rating to the article is apreciated.

🙂

Yes, all this features can be done using GUI.

I added some links for more details

Use the references for more information.

Yes, SMO in this case is a better option, but this code is useful to run any command line tool.

For example you can call the DTUtil, Tablediff, sqlcmd, DTexec with...

Yes, this article was just an introduction. I will write a new one named sequences vs IDENTITY.

Personally, I hate the IDENTITY. 😛

Yeah, when I wrote the article the BOL said, that they were going to remove it in future releases. It seems that they changed their minds and updated the BOL.

RAISERROR...

hahahahaha, instead of brute force you should plan differential backups, file and filegroup backups and transaction log backups.

Yeah, usually a nice sql job would be the best option. But, if a customers has already a C# tool centalized to monitor many things like IIS, Windows and SQL...

I agree with all of you guys. Usually the SMO is the best option in C#, but sometimes, we already have the stored procedures done. If we already have T-SQL...

Yes, PS is a great tool to interact with Exchange, AD and other sources.

To create Databases automatically with PS, it may be better to run .sql scripts from powershell.

This demo...

Yes, powershell for SQL Server was included in SQL Server 2008. It was the sqlps. In SQL 2012, the powershell 2.0 includes de SQL command and it is not a...

Yes, I believe that powershell will progress a lot in the future.

What I like about powershell is that Linux and Unix users can also play with it like they were at home. That's why I used the echo. There are many...