Forum Replies Created

Viewing 15 posts - 3,721 through 3,735 (of 9,244 total)

  • RE: Copy logins with their password

    GilaMonster (1/20/2014)

    Also consider the SSIS Transfer Logins task.

    Oh jesus, not that festering steamy pile of doggy doo doo 😀

    My script is a lot cleaner and easier 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    January 20, 2014 at 6:07 am

    #1681499

  • RE: Copy logins with their password

    SQL_Surfer (1/17/2014)

    I need to copy some databases from one server to another. What is the best way to copy logins with their passwords? Each login has access to multiple databases...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    January 20, 2014 at 5:23 am

    #1681487

  • RE: TDE Enable???

    You would usually purchase certs from a recognised vendor rather than self generating them 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    January 17, 2014 at 1:56 pm

    #1681252

  • RE: Verify Backups

    Talib123 (1/17/2014)

    I'll read through all of this later but the Environment is too large and too much going on to test backups regularly. 150 + Servers. Just one DBA.

    99% of...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    January 17, 2014 at 10:52 am

    #1681176

  • RE: Reclaim free space

    Thats why its not shrinking immediately the pages wont be freed straight away. Ghost cleanup handles that

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    January 17, 2014 at 10:22 am

    #1681164

  • RE: TEMPDB Configuration per vCPU

    Paulo

    The 10% theory is an old and good one, as long one doesn't take it literally.

    As already said, data file growth is not an issue if Instant File Initialization...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    January 17, 2014 at 10:06 am

    #1681158

  • RE: SQL 2008 failover 2 node (A/P) license upgrade from STD to ENT

    Spud312R (1/17/2014)

    We have a 2 node STD sql 2008 sql failover cluster running A/P mode

    We want to upgrade the sql lic from STD to ENT but do not...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    January 17, 2014 at 9:26 am

    #1681130

  • RE: Reclaim free space

    please post the exact commands you used

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    January 17, 2014 at 9:15 am

    #1681124

  • RE: Verify Backups

    Talib123 (1/17/2014)

    How can I tell which of my backup jobs is using the verify option.

    I have an estate with over 80 Servers. Is there a table in the MSDB that...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    January 17, 2014 at 9:13 am

    #1681121

  • RE: TDE Enable???

    you're welcome, thanks for posting back

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    January 17, 2014 at 8:56 am

    #1681108

  • RE: SQL Named Instance Corruption During Multi-Site and AG Testing

    Ah ok no AO yet.

    Has the mirros session ever successfully connected\synchronised?

    What accounts are the sql server services running under?

    Did you use gui or tsql to setup mirroring?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    January 16, 2014 at 4:19 pm

    #1680910

  • RE: Need to make serverproperty('servername') the same as @@servername

    Susan-322874 (1/16/2014)

    We use naming conventions for our SQL Servers and I'm having an issue getting the serverproperty(servername) match the @@servername.

    I know that SQL controls the @@servername and I have that...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    January 16, 2014 at 3:29 pm

    #1680900

  • RE: TDE Enable???

    Sure, you can encrypt connections to SQL Server but it only uses 40 or 128 bit and based on the client. IMHO column level encryption is better, it's likely you...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    January 16, 2014 at 2:53 pm

    #1680885

  • RE: TDE Enable???

    In favour of TDE, it does also automatically encrypt any database backups, users may not just pilfer the backups and go restore them, they'll need the certificate that encrypts the...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    January 16, 2014 at 2:43 pm

    #1680877

  • RE: TDE Enable???

    New Born DBA (1/16/2014)

    Which raises another question. Let's say if there is a DB which consist of 30 tables. All columns in those tables have to be encrypted. Why its...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    January 16, 2014 at 2:41 pm

    #1680874

Viewing 15 posts - 3,721 through 3,735 (of 9,244 total)