Forum Replies Created

Viewing 15 posts - 1,276 through 1,290 (of 2,756 total)

  • RE: Are the posted questions getting worse?

    Grant Fritchey (11/18/2016)

    jasona.work (11/18/2016)

    So someone dug in to how MS has SQL2016 working on Linux[/url], only to find that *horrors* they're using essentially a containerization type solution. Just enough...

    November 18, 2016 at 8:13 am

    #1913440

  • RE: Login Trigger

    Beatrix Kiddo (11/18/2016)

    If this is a copy & paste, could it just be that typo?

    Then in master database I queried:

    SELECT * from sys.all_objects where name LIKE '%connecction_limit%';

    As it's a server...

    November 18, 2016 at 8:05 am

    #1913436

  • RE: Share the Interesting Work

    Hopefully in the next year I'll get a backup DBA, if / when that happens, I'd like to think I won't stick them with the boring parts.

    But, considering the position...

    November 18, 2016 at 7:53 am

    #1913432

  • RE: Are the posted questions getting worse?

    So someone dug in to how MS has SQL2016 working on Linux[/url], only to find that *horrors* they're using essentially a containerization type solution. Just enough Windows kernel for...

    November 18, 2016 at 7:18 am

    #1913422

  • RE: Are the posted questions getting worse?

    Ed Wagner (11/17/2016)

    Hugo Kornelis (11/17/2016)

    Grant Fritchey (11/17/2016)

    Ed Wagner (11/17/2016)

    Grant Fritchey (11/16/2016)

    in Standard and Web (WHOOOP!).

    It's a pretty exciting day.[/url]

    I didn't make it through the entire presentation, but I read...

    November 17, 2016 at 11:18 am

    #1913178

  • RE: Are the posted questions getting worse?

    GilaMonster (11/17/2016)

    Luis Cazares (11/17/2016)

    GilaMonster (11/17/2016)

    jasona.work (11/17/2016)

    So really, if you could figure out a way to live without Agent, you could drop down to Express and *really* save some money...

    And with...

    November 17, 2016 at 10:56 am

    #1913165

  • RE: Are the posted questions getting worse?

    Phil Parkin (11/17/2016)

    jasona.work (11/17/2016)

    Hugo Kornelis (11/17/2016)

    EDIT: To clarify, *some* features that were enterprise only were in my opinion also easy to explain and understand. But not all. Stuff like compression...

    November 17, 2016 at 10:53 am

    #1913162

  • RE: Are the posted questions getting worse?

    Hugo Kornelis (11/17/2016)

    EDIT: To clarify, *some* features that were enterprise only were in my opinion also easy to explain and understand. But not all. Stuff like compression and TDE should,...

    November 17, 2016 at 9:37 am

    #1913135

  • RE: Are the posted questions getting worse?

    Ed Wagner (11/17/2016)

    Grant Fritchey (11/16/2016)

    in Standard and Web (WHOOOP!).

    It's a pretty exciting day.[/url]

    I didn't make it through the entire presentation, but I read the announcement - thank you for...

    November 17, 2016 at 7:30 am

    #1913063

  • RE: short date q.

    Presuming by "short date" you mean yyyy-mm-dd format, you could do this:

    CONVERT(date, getdate())

    You could also further tune that with the various date style options.

    But, it's possible if this is in...

    November 16, 2016 at 1:19 pm

    #1912912

  • RE: NEWBIE TO THE DBA LIFE

    Another book I'd suggest would be "Troubleshooting SQL Server: A Guide for the Accidental DBA"

    You can get the PDF for free from Red Gate (disclaimer: I don't work for Red...

    November 16, 2016 at 10:08 am

    #1912861

  • RE: Are the posted questions getting worse?

    GilaMonster (11/16/2016)

    jasona.work (11/16/2016)

    My response to that was two words, one of which I shouldn't use in polite company and the first was "holy"

    :w00t:

    I was screaming at my monitor last night.

    I...

    November 16, 2016 at 9:18 am

    #1912832

  • RE: Are the posted questions getting worse?

    Grant Fritchey (11/16/2016)

    Announcements include:

    SP1 for 2016 (which also has CREATE OR ALTER).

    A single development surface. This means all functionality in Enterprise is also in Standard and Web (WHOOOP!).

    vNext community preview...

    November 16, 2016 at 8:57 am

    #1912825

  • RE: Are the posted questions getting worse?

    GilaMonster (11/16/2016)

    Ed Wagner (11/16/2016)

    Care to drop any hints?

    No. Not until the announcements are made.

    Check Twitter later (Grant, Tom LaRock, Kendra, etc) they should be tweeting the highlights (I'm trying...

    November 16, 2016 at 8:38 am

    #1912820

  • RE: Log Shipping: From SS2014 Server to SS2016 Server?

    Gail Wanabee (11/15/2016)

    3) Cannot open backup device "\\serverName\TestLogShipping\TestLogShipping.bak"

    4) Operating system error 5(Access is denied.).

    Those two lines right there indicate a permissions problem.

    As Kevin indicated, make sure the SQL Agent service...

    November 15, 2016 at 12:54 pm

    #1912647

Viewing 15 posts - 1,276 through 1,290 (of 2,756 total)