Yes, it will be a named instance instead of a default instance. Your client tools will upgrade, and there are some services, like Integration Services, that are not instance aware...

Hyperbac (from Red Gate software) and Idera have products you can buy that let you restore and work with a backup file without requiring the original disk space. It's a...

I agree with the article, though think it's a little biased against the Royals.

BA isn't everything, which is why we look at five tools for the best players. When I...

Whether or not you fire the guy depends on what has happened in the past. If this is the first time, I'd completely agree. You need to sit down with...

You cannot include second level folders. Only one level deep is how it works.

1. Yes, connect to the server as an administrator, issue the BACKUP DATABASE command in T-SQL.

2. No, any client will work, but you only get one connection. If you use...

Michael,

Thanks for that note. I had read that comment, and didn't get the point across in the editorial. The SAN guys deliberately put less disk behind the LUN. It definitely...

Keep the trigger small and tight to avoid performance stuff, and make sure you write the trigger for multiple rows. Don't set variables to values.

Not this:

...

select @pk = PKID from...

Gail has given a great explanation. There is no BEFORE trigger. The create trigger...for update is the same as the AFTER syntax.

Sorry, no, modify the data in a table.

If I have Customers:

Create table Customers( Customer varchar(20))

go

insert Customers select 'Acme'

union select 'Brad'

go

Now I want to change the Customer name to "Smith" and...

You guys are killing me. More work, then karate before I can even think about BBQ.

I saw Fat Red's on Memphis Beat. Is that a real place?

do what? stop jobs? just call sp_start_job. You can read about the parameters in Books Online. Same for sp_start_job.

You can schedule this to run, and here's a short discussion of...

If you modify a table, the trigger runs after the modification is done, but before it is committed.

George is correct in that each log file backup has different information. The log backup takes all active log records that are committed and copies them to thebackup.

There is no...