Forum Replies Created

Viewing 15 posts - 16 through 30 (of 138 total)

  • RE: Implementing Stretch Database.

    Deepak Sahu - Wednesday, January 16, 2019 6:25 AM

    Welcome Ken!

    I think by default,table data is separated into Hot Data(that is frequently accessed)...

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

    January 16, 2019 at 7:13 am

    #2019079

  • RE: Implementing Stretch Database.

    Thanks for the article, Deepak.

    I may have missed this in the article but what determines what rows stay on prem and what rows stay in the cloud by...

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

    January 15, 2019 at 10:37 pm

    #2019031

  • RE: The SQL Server LAG Function

    Mike Byrd - Monday, January 14, 2019 3:02 PM

    Yes, the lag function can offset more than row.  Syntax is (from Microsoft):

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

    January 15, 2019 at 10:29 pm

    #2019029

  • RE: The SQL Server LAG Function

    Thanks very much for the article. The performance differences captured and quite impressive.

    Wondering whether we can "LAG to more than one row behind" (haven't looked at the syntax...

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

    January 14, 2019 at 2:25 pm

    #2018880

  • RE: Workplace Encounter: Effects of TLS 1.2

    ken.trock - Thursday, January 3, 2019 10:57 AM

    I had trouble with IISCrypto. Instead, we used Set-Ciphers and DetectCipherConfig Powershell scripts developed by...

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

    January 3, 2019 at 2:59 pm

    #2017928

  • RE: Workplace Encounter: Effects of TLS 1.2

    gavin.harris 53577 - Thursday, January 3, 2019 3:39 AM

    We are currently going through that pain at the moment. So I'd like to...

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

    January 3, 2019 at 2:58 pm

    #2017927

  • RE: Workplace Encounter: Effects of TLS 1.2

    Br. Kenneth Igiri - Wednesday, January 2, 2019 11:46 PM

    Comments posted to this topic are about the item Workplace Encounter: Effects...

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

    January 3, 2019 at 2:56 pm

    #2017926

  • RE: Improving SQL Server 2016 Large Database Performance

    Great Article. Particularly loved the trace flag tips.

    Wondering about two things though:

    1. Can we set optimize for ad-hoc workloads simply because we have a large database?...

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

    June 11, 2018 at 2:45 am

    #1993508

  • RE: SQL Server on Amazon RDS vs SQL Server on Amazon EC2

    curious_sqldba - Tuesday, April 24, 2018 11:52 AM

    Br. Kenneth Igiri - Wednesday, April 11, 2018 10:01 PM

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

    April 24, 2018 at 12:39 pm

    #1988101

  • RE: SQL Server on Amazon RDS vs SQL Server on Amazon EC2

    mauriciorpp - Sunday, April 15, 2018 12:04 PM

    what about performance? assuming EC2 and RDS with same cpu/ram settings, which option woud be...

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

    April 15, 2018 at 2:27 pm

    #1986872

  • RE: SQL Server on Amazon RDS vs SQL Server on Amazon EC2

    curious_sqldba - Wednesday, April 11, 2018 11:16 PM

    Br. Kenneth Igiri - Wednesday, April 11, 2018 10:01 PM

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

    April 12, 2018 at 3:33 am

    #1986530

  • RE: Backing up multiple SQL instance and databases using 3rd party software - Any recommendations

    We use Symantec Netbackup. It is quite robust and handles SQL Server backups across about forty instances. We do get throughputs of up to 20Kbps and restore is easy. You...

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

    December 11, 2017 at 3:51 pm

    #1971677

  • RE: Pre-Login Handshake Acknowledgement Error

    Thanks so much Sue.

    I am logged in via RDP.

    Apparently this was only happening when I used (local). And the I account I was given does not...

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

    November 16, 2017 at 5:58 pm

    #1968454

  • RE: Introduction to Statistics

    Thanks for the article.

    Looking forward to some of the benefits of enabling AUTO_CREATE_STATISTICS

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

    October 17, 2017 at 6:52 am

    #1964001

  • RE: Group Managed Service Accounts (gMSAs) in SQL2016

    This is an awesome feature. I cannot even believe I am just learning about it. Thanks for the article.

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

    October 13, 2017 at 4:17 pm

    #1963654

Viewing 15 posts - 16 through 30 (of 138 total)