My wife and I moved into our house a couple of years ago, and since it had previously been rented out to students it needed gutting and putting back together...

I'm the other way round - though the number of SQL instances we manage in our business is pretty small (<10). But then I do have a different SA...

Encryption's a hot topic in our business at the moment. As we're a government agency and there have been a number of high profile news releases regarding loss of...

Here in the UK there seems to be an obsession about speed cameras, and recently there was a report about a guy who challenged his speeding ticket and used his...

We fixed this problem a while ago now, but I thought I would update this topic with our solution in case anyone else came across the same problem. It's...

Exactly. From a change control perspective it makes it so much harder to keep track of which updates have been applied to however many instances of SQL you have.

We...

I'd agree with Alzdba.

We're rolling out SQL 2005 at the moment mainly it's had 2 service packs and for me this is an indicator that the manufacturer's put some effort...

You don't always have to remove the publication from your production database prior to backup, but when you come to restore it in your test environment, be prepared for some...

And to deprecate it too (meaning to condemn or denounce) might be a bit over the top! Surely just depreciating the framework will suffice.

SQL Server 2005 still supports SQL-DMO applications, however this framework will be deprecated in SQL Server 3008

... At least there's no rush!

I couldn't agree more!  Here in the UK (though I doubt it's just confined to these shores!), it's often all too easy to overlook the local tradespeople for the bigger...

It's interesting looking at the elapsed time periods between each versions of SQL.  From my point of view, I can't believe SQL 2005 has been out for 18 months now! ...

Pete,

Thanks for the tip!  At the moment we delve down to the minute level.  As this is going to be an archive cube to be used for trend analysis, we...

Steve,

Thanks for this.  Your solution sounds good, but unfortunately we're lumbered with the Standard edition, and not Enterprise, so partitioning is not an option.

Also, we haven't hit the heady heights of...

You can run the xp_cmdshell extended stored procedure and pass in a command line string to execute your vbscript

However, if your vbscript returns information from your tables in your database,...