Viewing 15 posts - 1 through 15 (of 39 total)
If you're into videos, I liked Brian Knight's introductions to clustering at SQL Share:
January 28, 2011 at 7:22 am
The exam is for SQL Server 2008, rather than specifically R2, but I don't think it would hurt to be aware of the extras with R2.
January 28, 2011 at 7:07 am
Absolutely! It's how most of us learn about clustering during the certification paths... it's cheaper than real servers!
April 16, 2009 at 10:13 am
From within the database, you can use Database Mail (SQL2005) or SQL Mail (SQL2000). For SQL2005, there's a good article here:
http://www.sql-server-performance.com/articles/dba/email_functionality_p4.aspx
From an external application such as ASP.net, you...
October 2, 2008 at 10:14 am
I would have expected it revert when the stored procedure has ended, and SQL Server Magazine seems to confirm this:
"The SET NOCOUNT ON statement remains in effect until the stored...
September 11, 2008 at 4:30 am
Keeping log backups and/or full backups for a long time allows you to revert much further back in time if something changed a long time ago, but you've only just...
July 25, 2008 at 7:55 am
It sounds like a database of the same name is on the new server - if that is the case, use With Replace.
July 10, 2008 at 12:50 pm
And rather depressingly, I see that the SQL Server 2008 certification details are up on line now..... argh!
However, the good news is that to upgrade from SQL2005 MCITP DBA to...
July 7, 2008 at 6:56 am
ahutch (6/4/2008)
If your end-goal is to essentially have a copy of the Prod DB as a TestDB, you should use backup/restore instead of copy or bulk insert.
Though good experience comes...
July 4, 2008 at 7:36 am
I drive 20 miles which takes about 35-45 minutes in outer NW London/Hertfordshire, or I can drive to the other office which is 10 miles into W London - and...
July 4, 2008 at 6:55 am
Can't access the URL, but any programming technique described as "evil" is umerited - it's about appriopriate use.
Stored procedures in SQL Server are the primary way to go for data...
July 3, 2008 at 8:12 pm
High fives to both Jeff and Michael - if either of you are ever in the UK, I'll buy you a beer! (or a cider)
July 2, 2008 at 4:55 am
Aha, thanks! I guess I haven't opened a stored procedure since SQL2000....
June 23, 2008 at 1:06 pm
When I used to program through ASP and Vbscript, you didn't need to know the parameter names - just the order of the parameters and the datatypes.
June 23, 2008 at 10:34 am
Tell me about subscriptions?
June 19, 2008 at 8:00 am
Viewing 15 posts - 1 through 15 (of 39 total)