Forum Replies Created

Viewing 13 posts - 1 through 14 (of 14 total)

  • RE: Resource Governor & Contained Database Users

    GoldenDBA
    If you are trying to use Resource Governor on a server with contained and non-contained databases, I would recommend using SUSER_NAME() and not USER_NAME(). Keep in mind that...

    Thomas LiddleSQL Server AdministratorVideo Blog - YouTubeWeb Blog - www.thomasliddledba.comTwitter - @thomasliddledbaFacebook - @thomasliddledba

    February 7, 2017 at 12:27 pm

    #1927186

  • RE: Distrubted Availability Groups -- Is this the right idea?

    alex.sqldba - Tuesday, February 7, 2017 9:40 AM

    Hi Thomas,

    Yes, spot on -- whilst we haven't quite got a plan of action for...

    Thomas LiddleSQL Server AdministratorVideo Blog - YouTubeWeb Blog - www.thomasliddledba.comTwitter - @thomasliddledbaFacebook - @thomasliddledba

    February 7, 2017 at 10:03 am

    #1927136

  • RE: Distrubted Availability Groups -- Is this the right idea?

    alex.sqldba - Wednesday, February 1, 2017 9:26 AM

    Evening All,

    We are looking at/reseaching implementing Availability Groups in SQL Server 2016.

    We have two data...

    Thomas LiddleSQL Server AdministratorVideo Blog - YouTubeWeb Blog - www.thomasliddledba.comTwitter - @thomasliddledbaFacebook - @thomasliddledba

    February 7, 2017 at 9:32 am

    #1927123

  • RE: Create and Connect to an Azure SQL Database

    riversoft - Monday, February 6, 2017 9:07 AM

    Thanks for the Article. Do you think this approach, Connect to Azure Sql Database over...

    Thomas LiddleSQL Server AdministratorVideo Blog - YouTubeWeb Blog - www.thomasliddledba.comTwitter - @thomasliddledbaFacebook - @thomasliddledba

    February 7, 2017 at 6:39 am

    #1927073

  • RE: Changing Linked Server Passwords

    vaa4 - Thursday, January 26, 2017 7:12 AM

    Tom,

    You may want to consider using pass-thorough  authentication.  This would make your enterprise more secure, as...

    Thomas LiddleSQL Server AdministratorVideo Blog - YouTubeWeb Blog - www.thomasliddledba.comTwitter - @thomasliddledbaFacebook - @thomasliddledba

    January 26, 2017 at 7:58 am

    #1925064

  • RE: Put your Database under Source Control

    browndog - Wednesday, January 18, 2017 6:51 AM

    Nice article.  Please note that with Visual Studio you can also use SSDT and source control...

    Thomas LiddleSQL Server AdministratorVideo Blog - YouTubeWeb Blog - www.thomasliddledba.comTwitter - @thomasliddledbaFacebook - @thomasliddledba

    January 18, 2017 at 7:11 am

    #1923419

  • RE: Put your Database under Source Control

    rgp151 - Wednesday, January 18, 2017 4:50 AM

    thomasliddledba - Wednesday, January 18, 2017 12:03 AM

    Comments posted...

    Thomas LiddleSQL Server AdministratorVideo Blog - YouTubeWeb Blog - www.thomasliddledba.comTwitter - @thomasliddledbaFacebook - @thomasliddledba

    January 18, 2017 at 7:10 am

    #1923417

  • RE: TDE and Stretch Databases

    If no one has grabbed this, I'll take a crack at the article.  Let me know.

    Thomas LiddleSQL Server AdministratorVideo Blog - YouTubeWeb Blog - www.thomasliddledba.comTwitter - @thomasliddledbaFacebook - @thomasliddledba

    January 17, 2017 at 6:25 am

    #1923152

  • RE: Connect to sql box via cmdshell

    Lord Slaagh - Friday, January 13, 2017 8:28 AM

    Phil Parkin - Thursday, January 12, 2017 1:46 PM

    Thomas LiddleSQL Server AdministratorVideo Blog - YouTubeWeb Blog - www.thomasliddledba.comTwitter - @thomasliddledbaFacebook - @thomasliddledba

    January 16, 2017 at 7:25 am

    #1922977

  • RE: Link a database to version control

    I submitted an article for review

    Thomas LiddleSQL Server AdministratorVideo Blog - YouTubeWeb Blog - www.thomasliddledba.comTwitter - @thomasliddledbaFacebook - @thomasliddledba

    January 6, 2017 at 9:41 am

    #1921156

  • RE: Link a database to version control

    If no one has done one on Red-Gate Source Control, I have experience in this product. I can take a stab at it? Let me know

    Thomas LiddleSQL Server AdministratorVideo Blog - YouTubeWeb Blog - www.thomasliddledba.comTwitter - @thomasliddledbaFacebook - @thomasliddledba

    January 4, 2017 at 8:36 am

    #1920652

  • RE: Changed Linked Server password

    Great. I submitted my first article based on the guidelines. Hope it's sufficient.

    Thanks

    Thomas LiddleSQL Server AdministratorVideo Blog - YouTubeWeb Blog - www.thomasliddledba.comTwitter - @thomasliddledbaFacebook - @thomasliddledba

    January 4, 2017 at 7:38 am

    #1920614

  • RE: Changed Linked Server password

    This seems easy enough. I'd like to take a crack at this or has it already been completed? I saw no replies.

    Thomas LiddleSQL Server AdministratorVideo Blog - YouTubeWeb Blog - www.thomasliddledba.comTwitter - @thomasliddledbaFacebook - @thomasliddledba

    January 3, 2017 at 2:19 pm

    #1920502

Viewing 13 posts - 1 through 14 (of 14 total)