Forum Replies Created

Viewing 15 posts - 3,076 through 3,090 (of 6,035 total)

  • RE: Running as SysAdmin

    You can do a brute force dictionary query against the sys.sql_logins table to discover the password for any sqlserver login, including 'SA'.

    declare @pw table (pwtext varchar(180) not null primary key);

    ...

  • RE: Byte Me: Private Cloud

    Ed Wagner (12/23/2015)


    Alvin Ramard (12/23/2015)


    Eric M Russell (12/23/2015)


    Alvin Ramard (12/23/2015)


    Eric M Russell (12/23/2015)


    Putting your data in the cloud: that's then you save a backup to external disk, and then have...

  • RE: Byte Me: Private Cloud

    Alvin Ramard (12/23/2015)


    Eric M Russell (12/23/2015)


    Putting your data in the cloud: that's then you save a backup to external disk, and then have it boosted up the Space Station for...

  • RE: Running as SysAdmin

    Indianrock (12/23/2015)


    How is SA ( with good password properly managed and not used by applications ) any worse than your own "admin" sysadmin login?

    Because it can be shared across multiple...

  • RE: Byte Me: Private Cloud

    Putting your data in the cloud: that's then you save a backup to external disk, and then have it boosted up the Space Station for safe keeping; right? :Wow:

  • RE: Byte Me: Private Cloud

    Alvin Ramard (12/23/2015)


    Ed Wagner (12/23/2015)


    mjh 45389 (12/23/2015)


    Eric M Russell (12/23/2015)


    Eric M Russell (12/23/2015)


    mjh 45389 (12/23/2015)


    I was in a shop at the weekend and they were selling external hard drives as...

  • RE: Select the rows that has only numeric data in varchar field

    sql_novice_2007 (12/23/2015)


    Hi I have a ZipCode column in the address table and this column has some invalid zipcodes like 'a36477','445-2'.

    I am trying to write a query to select only those...

  • RE: Database Design Question

    But regardless of the implementation, you need to let the developers know this deployment isn't going into production until after New Years at the very least. Has this been tested...

  • RE: Database Design Question

    I generally contain things like CRM Comments, Phone Numbers, and often times Status Codes in a separate table. They are not 1:1 static attributes in the same way that SSN,...

  • RE: Hacking Data

    Matt Miller (#4) (12/22/2015)


    Eric M Russell (3/23/2011)


    An MP3 player and an automobile engine are two unrelated systems that should not be tightly coupled.

    Hmm that reminds me of some quotes I...

  • RE: CLR Yes or no?

    The only practical use for CLR in a data warehouse that comes to mind is perhaps a custom aggregate function.

  • RE: Byte Me: Private Cloud

    Eric M Russell (12/23/2015)


    mjh 45389 (12/23/2015)


    I was in a shop at the weekend and they were selling external hard drives as 'Private Clouds'! Things like this are not going to...

  • RE: Byte Me: Private Cloud

    null

  • RE: Byte Me: Private Cloud

    null

  • RE: SQL server slowdown by increasing processors?

    awarnke 39611 (12/22/2015)


    Thank you all for your replies.

    Jacob you are correct it is a virtual environment. We tried giving priority to the processors, but not much change. We...

Viewing 15 posts - 3,076 through 3,090 (of 6,035 total)