Forum Replies Created

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

  • RE: Correct Old Mistakes

    phonetictalk (12/24/2015)


    It would be fascinating to hear from the developers in stories like this (at least anonymously).

    Was it due to pressure, or was it due to a lack of experience/knowledge?...

  • RE: SSIS error when configuring data flow task with .xls file

    Since it's .XLSX, make sure the connection is using the provider that supports Excel 2007+ instead of the provider for the older .XLS format.

  • RE: Correct Old Mistakes

    My kids had (and still use occasionally today) a VTech Leapster handheld game console. However, we never registered it; they simply play the games. It's not neccessary for comanies to...

  • RE: Doubt in isolation level

    Yeah, but could you reproduce the non-blocking behaviour?

  • RE: Web site Product Pics : fileserver OR FileStream

    With the exception of secure document storage, I don't see the point in containing BLOBs in a relational database. With what you're suggesting, the website would hit your database whenever...

  • RE: Doubt in isolation level

    I actually can't reproduce this. I'm using SQL Server 2014, and Session 2 WILL wait for Session 1 to commit on the 2nd run, which is what we'd normally expect...

  • 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,...

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