Forum Replies Created

Viewing 15 posts - 9,241 through 9,255 (of 9,715 total)

  • RE: Changing Career Gears

    Clive,

    They didn't introduce just one new cert. They introduced 4 of them. @=) All new SQL Server 2005 certification information can be found at the following link:

    http://www.microsoft.com/learning/mcp/mcts/sql/default.mspx

    Hope this...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Changing Career Gears

    If you've been a DBA for 8 years already, go for the MCITP instead (SQL 2005 -and possibly 2008- certs). It'll look much better on your job history. ...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: SQL 2000 DB in SQL 2005

    Glad we could help. @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Certification Rumors and Tips

    The best thing you can do for yourself, Jigisha, is practice, practice, practice.

    There are still a lot of shops which use SQL Server 2000, which might make it worth your...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Restoring bak files

    Chethan,

    I doubt it's an appended backup issue. Media families usually refer to the media the backup is stored on. I.E., tape, UNC disk drive, local disk drive.

    Unless you've...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Why upgrade from SQL 2000 to SQL 2005?

    HTTP Endpoints are much more secure. You can actually dictate the type of traffic you get and, I believe, the network protocol used to access it.

    Not to mention you...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Why upgrade from SQL 2000 to SQL 2005?

    I had originally heard February, but that was like 6 months ago, so I'm not surprised my info is out of date. @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: How to evaluate tools?

    I don't know about demos. Some are good, some are bad. But most of them are canned. Which means the demonstrator is going to show you all...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Why upgrade from SQL 2000 to SQL 2005?

    In addition to Security (and the auditing available with DDL triggers), the main reasons I would add are SSIS, Solution Explorer, Database Mirroring and Snapshots.

    DM & Snapshots are wonderful...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Phantom Table?

    Are you working in 2000 or 2005?

    You posted to the 2k5 forum, but EM is a 2000 tool and in 2k5 you not supposed to be able to...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Job failed:The owner does not have server access.

    First, go into your SQL Server Configuration Manager and verify that NONE of your services are running under the Built-In Administrators account. It doesn't have to be the SQL...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Changing Career Gears

    All, I'm glad my article is generating such positive responses. For those currently going a similar Non-IT to DBA route, I hope my experiences help you along the way.

    Nadeem7971,...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Anyone taken 70-445 (BI exam)?

    Hey, Jorg, the article Steve pointed out also has info on the 446 exam. You might want to check it out.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Left Outer Join Help

    You can also use SUM(ISNULL(Quantity,0)) to do something similar. The difference is that ISNULL simply replaces any NULL values with zero instead of looking for the first non-NULL value.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Anyone taken 70-445 (BI exam)?

    Thanks for the blog, Jorg! I appreciate it!

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 15 posts - 9,241 through 9,255 (of 9,715 total)