Thank you all for sharing your thoughts. There are so many things come up, Hadoop, SQL2012, cloud. Even within SQL Server itself whatever version we are working on,...

BI/Data warehousing is always on my wish list. There are so many new technologies coming out these days. It is hard to know all of them. Nevertheless,...

This is really good!

Marios Philippopoulos (1/27/2011)

---

Vivien Xing (5/7/2008)

---

I sent a feedback to Microsoft. Package version feature will be considered for the next major release. If you have any comments to add...

Take a look here: http://msdn.microsoft.com/en-us/library/cc966412.aspx

IO size = 64 KB is not enough.

Steve, you always brings us great editorials. An excellent resource for knowledge, ideas and trends.

I am your loyal reader and your editorials make me stay with SSC. Keep...

Do you have any space in the database name? I noticed that a trailing space in the backup file from your post.

For this case, when/if BE can better benefit the organization.

Backup strategy involves...

Marios Philippopoulos (10/2/2009)

---

I guess, at the end of the day, the question to ask is this:

Why replace the SQL native functionality for backups with a 3rd party tool, especially...

A couple comments here:

1. BE can do all kinds of DB backups. They have very good documentation about how to set it up and optimization for SQL backups. ...

This may help for service startup dependency:

http://support.microsoft.com/kb/193888

This discussion makes me think about Brad McGehee’s How to Become an Exceptional DBA. This is not a commercial.

I like Steph Brown’s saying. It’s worth a quote.

“I would...

dbo.benyos (10/23/2009)

---

For instance, a guy with some UNIX knowledge will never write a script to replace strings in a text file. He'll use SED command instead. If you only know...

For tracking login, SQL Serer 2008 new feature “SQL Audit” does better job than trigger/profiler/3rd party or home-grown tools as SQL Audit is native to SQL Server, while the others...

create the stored procedure; create a SQL scheduled job to exec this stored procedure in the job step.