Not a problem Jeff, I don't mind these kinds of deep Qs about the product. I welcome them in fact.

So let's get started.

"Sorry for not doing a dive on...

I've got a few mins so I'll add to what Jen posted.

6. What's the SLA for support if something goes haywire? Does such support exist?

On top of what Jen said,...

That's a broad topic and motivations are varied. However, I suggest you begin with some auditing tutorials so you can be familiar with capabilities.

That said, it helps you with...

Or if you don't have Ent then you can use SPs to query the tables and split them up into dated ranged.

When you call the SP you can make a...

I often suggest this course of action when shops have issues with online reindexing. We put the varchar(max) cols into their own table and the main table can now...

Here are a couple links for some articles I've written.

One is a slideshow on the features:

http://www.infoworld.com/article/2606990/database/147960-10-best-new-features-in-SQL-Server-2014.html

http://www.infoworld.com/article/2610600/database/review--sql-server-2014-pushes-the-pedal-to-the-metal.html

I've got an intro to ASP.NET on my site. It's from a few yrs ago but I believe everything still holds.

As far as how to do it all in...

You're not giving us enough info on what you're looking for.

SQL doesn't prevent you from creating windows groups or users so I don't understand the nature of your question.

To my knowledge you can't update data in excel and easily push it back to SQL. Getting the data into excel is easy, as you can have a data...

While Grant is right, you shouldn't use Profiler GUI directly against your servers, I think it depends on what SP 2005 is on. I think it has to be...

are you restoring over a current DB on the same box? So in other words, are you restoring the DB over itself?

Post the restore stmt you're using.

But by all...

yep, there ya go.

Ok so it's 77% full it look like... now take a log backup then run it again and post those results.

Ok, and what method are you using to check log size?

Use DBCC SQLPERF(LogSpace)

and post the results for that DB.

Sure you can. You just have to turn on the previous deployment method.

I'm trying to remember right now where it is, but try package properties or maybe deployment properties....