Forum Replies Created

Viewing 15 posts - 4,771 through 4,785 (of 39,740 total)

  • RE: SQL Server 2008R2 - SQ Login Security Risks outside of SQL Server

    yes, the sa login can do anything inside the SQL Server, which has XPs, cmdshell, etc, with potential access outside the system. In essence, the concern is that Sa can...

  • RE: Timzone conversion to IST

    I'm not quite sure what you mean here. Do you mean that now the server is in the US, set to a US timezone and all data is stored as...

  • RE: Unable to Apply SQL2014 SP2

    Does this appear as soon as you start setup? There isn't a place/time to choose the instance to apply this against?

  • RE: Detecting Detached Databases

    These days, PoSh would be the way to go. Find all mdfs and then compare them with what's attache. In fact, I was just thinking about updating a script I...

  • RE: QUOTENAME() Types

    The wording of the question was a bit misleading. I should not have conflated a value with a type, as NULL doesn't have a type, but conforms to the type...

  • RE: QUOTENAME() Types

    edwardwill - Thursday, October 4, 2018 8:28 AM

    Three days on the bounce.  Going for a record of borked QotD?

    If your intention...

  • RE: Cloud Backup

    We do need to bake security in from the beginning. This should be a part of all teaching for coding, as well as early on for setting up systems. I...

  • RE: Cloud Backup

    DinoRS - Wednesday, October 3, 2018 4:41 AM

    Being in the Cloud is not the issue, not for Backups neither for Applications...

  • RE: Are the posted questions getting worse?

    ChrisM@Work - Wednesday, October 3, 2018 3:08 AM

    Having a couple of pc's at home to play with is common for developers, but...

  • RE: Who's Using the DAC?

    robert.sterbal 56890 - Tuesday, October 2, 2018 8:33 AM

    Administator should be Adminstrator in:

    One of the best additions to the SQL Server feature set was...

  • RE: Who's Using the DAC?

    ildjarn.is.dead - Tuesday, October 2, 2018 3:58 AM

    SSMS won't work, at least not with SSMS 17.9:

    It does. What you'll find...

  • RE: Who's Using the DAC?

    chris geswein - Tuesday, October 2, 2018 8:51 AM

    I think you have a typo in your first paragraph, last sentence. I think...

  • RE: Give Up on Natural Primary Keys

    sqlvogel - Tuesday, October 2, 2018 12:10 AM

    GDPR effectively gives even more legal weight to the requirement that personal data should always have...

  • RE: Inserting in a Column Set

    morlindk - Monday, October 1, 2018 11:37 PM

    Even without the missing ')', one gets it right! - But it takes a code...

Viewing 15 posts - 4,771 through 4,785 (of 39,740 total)