Forum Replies Created

Viewing 15 posts - 8,236 through 8,250 (of 39,803 total)

  • RE: Need to find new vehicle service records for last six months

    The excel data doesn't allow anyone to set this up, nor does the Word document make it easy to understand what you did.

    It's helpful to say, I run this:

    select unitid

    ...

  • RE: Crack that Encrypted Data

    tripleAxe (4/20/2016)


    robert.sterbal 56890 (4/19/2016)


    Has anyone set up 2 virtual machines on their desktop, one for browsing and email and one for everything else?

    I've done this recently. Got burned with letting...

  • RE: Need to find new vehicle service records for last six months

    First, it's helpful to give some mockup like this, using some sample data:

    CREATE TABLE Service

    (

    UnitID INT

    , Servicedate DATE

    , ServiceType VARCHAR(200)

    ,...

  • RE: Basline TDE

    When you baseline, compare that to your current prod environment as well to see if you can extrapolate the perf levels between them.

  • RE: Crack that Encrypted Data

    John Hanrahan (4/19/2016)


    A couple of notes:

    For web browsing a pretty safe way is to use a VPN service. You can sometimes get lifetime service for 30ish dollars. It...

  • RE: Crack that Encrypted Data

    robert.sterbal 56890 (4/19/2016)


    Andrew..Peterson (4/19/2016)


    robert.sterbal 56890 (4/19/2016)


    Has anyone set up 2 virtual machines on their desktop, one for browsing and email and one for everything else?

    I use an Ubuntu VM for...

  • RE: Crack that Encrypted Data

    Yet Another DBA (4/19/2016)


    I suppose one problem is if the ransomware sits dormant for a couple of weeks and then activates. A restore from a 2 week? or 5 week...

  • RE: Are the posted questions getting worse?

    Luis Cazares (4/19/2016)


    GilaMonster (4/19/2016)


    And more homework in the forums. Is it wrong to want to post a sensible-looking but completely incorrect query as answers?

    That would be too easy for them....

  • RE: Database Handle Failed

    I'm not sure what you mean by "bring database to run". That doesn't make sense in English.

    Is there a SQL Server item in the control panel/Programs? This is usually an...

  • RE: PHP and MSSQL

    I haven't done the PHP connection, but users are usually not listed as server\administrator for a SQL login. Usually you would put in just Administrator.

    Make sure you don't have the...

  • RE: What's Your Downtime?

    I'm not sure I consider Verizon a tier 1 cloud provider. I think they might disagree, but my view is they've gotten into a business they don't understand and convinced...

  • RE: Are the posted questions getting worse?

    Maybe accuracy in CPU math is overrated?

    http://www.sqlservercentral.com/links/643469/349632

  • RE: Are the posted questions getting worse?

    They're not bad here, but they are off by days, and with snow, can be way off on amounts. Even 24 hours out.

    Seems like half the time they say snow...

  • RE: Basline TDE

    I'm not sure there's much out there. Typically I've seen TDE in the 5-10% CPU range, increase, but I haven't looked to see what percentage of that is tempdb. It's...

  • RE: EXEC XP_CMDShell running in SSMS 2012

    xp_cmdshell isn't interactive, so anything you run here would have to run without any additional input from the command line.

    I have been able to automate things like http://ftp.exe by using...

Viewing 15 posts - 8,236 through 8,250 (of 39,803 total)