Forum Replies Created

Viewing 15 posts - 2,026 through 2,040 (of 19,560 total)

  • RE: TDE Database Restore

    You can check for the certificate to see if it has been restored by use of the catalog view.

    select *

    From sys.certificates

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 23, 2014 at 12:26 pm

    #1747608

  • RE: Restoring the Database

    Restoring from network works. Problems that can arise are related to network latency and or network hiccups that could cause the restore to take a long time or cause...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 23, 2014 at 12:20 pm

    #1747604

  • RE: TDE Database Restore

    It's not the master key but the encrypting certificate that needs to be restored to the new server.

    Here is an article that shows the steps needed.

    http://msdn.microsoft.com/en-us/library/ff773063.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 23, 2014 at 12:19 pm

    #1747603

  • RE: Are the posted questions getting worse?

    Jack Corbett (9/23/2014)

    Not sure if it is related, and this post will likely fix it, but I haven't been getting email notifications from The Thread, since it was...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 23, 2014 at 11:17 am

    #1747590

  • RE: Are the posted questions getting worse?

    Sean Lange (9/23/2014)

    djj (9/23/2014)

    Greg Edwards-268690 (9/23/2014)

    Anyone have suggestions of things to see in or near Branson, Missouri?

    Taking a road trip down there in a bit.

    Do they still have the Titanic...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 23, 2014 at 9:32 am

    #1747548

  • RE: Testing in Production

    Sean Lange (9/23/2014)

    SQLRNNR (9/23/2014)

    Sean Lange (9/23/2014)

    I will just leave this here.

    And to go with that, there is a shirt.

    Can't see it. Not sure if it is NetNanny or the link...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 23, 2014 at 9:15 am

    #1747533

  • RE: Testing in Production

    Sean Lange (9/23/2014)

    I will just leave this here.

    And to go with that, there is a shirt.

    Uploaded img. Source was from Grants twitter feed.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 23, 2014 at 9:03 am

    #1747527

  • RE: Are the posted questions getting worse?

    Lynn Pettis (9/23/2014)

    edit: Delayed double post.

    Dang it, If not for the quote bug I was gonna post a quip about it. But you beat me to it.;-)

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 23, 2014 at 8:54 am

    #1747519

  • RE: Where's the Thread?

    Stefan Krzywicki (9/23/2014)

    TomThomson (9/23/2014)

    Stefan Krzywicki (9/22/2014)

    I'm kind of hoping this becomes the new thread.

    Ah, all becomes clear. The thread wanted a companion, so it inserted itself between some spam...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 23, 2014 at 8:47 am

    #1747510

  • RE: Today's Random Word!

    Thanks for the trip down memory lane.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 23, 2014 at 8:46 am

    #1747508

  • RE: Today's Random Word!

    Sean Lange (9/23/2014)

    Ed Wagner (9/23/2014)

    Sean Lange (9/23/2014)

    Ed Wagner (9/23/2014)

    SQLRNNR (9/23/2014)

    Ed Wagner (9/23/2014)

    SQLRNNR (9/23/2014)

    aggregate

    Function

    junction

    Conjunction

    School House Rock

    Bill (one of the episodes I remember from the 1980s)

    Flashback

    http://www.youtube.com/watch?v=tyeJ55o3El0

    Very odd. Your link wants to...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 23, 2014 at 8:45 am

    #1747507

  • RE: Today's Random Word!

    Ed Wagner (9/23/2014)

    SQLRNNR (9/23/2014)

    aggregate

    Function

    junction

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 23, 2014 at 7:38 am

    #1747458

  • RE: How many rows will be returned?

    Thanks for the question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 23, 2014 at 7:36 am

    #1747457

  • RE: Today's Random Word!

    aggregate

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 23, 2014 at 7:32 am

    #1747452

  • RE: Where's the Thread?

    HanShi (9/23/2014)

    TomThomson (9/23/2014)

    Stefan Krzywicki (9/22/2014)

    I'm kind of hoping this becomes the new thread.

    Ah, all becomes clear. The thread wanted a companion, so it inserted itself between some spam threads...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 23, 2014 at 7:30 am

    #1747449

Viewing 15 posts - 2,026 through 2,040 (of 19,560 total)