Forum Replies Created

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

  • Reply To: Power BI vs SSRS

    Thanks for the article.

    The photo on licensing caught my attention. The $209 for Standard - CAL. Is that per user? What would constitute a user?

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

  • Reply To: Is the Database a Series of Microservices?

    Interesting analogy here. And quite on point. Thanks so much, Steve.

    On microservices, some points of view are that traditional RDBMSes do not quite fit into the design pattern. That each...

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

  • Reply To: Do We Need to Learn Linux?

    I know a former colleague and Linux lover who will laugh me to scorn if he sees this article. 🙂

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

  • Reply To: SQL Server on Amazon RDS vs SQL Server on Amazon EC2

    I must add for integrity sake that I noticed recently that Azure SQL could be way cheaper than Amazon RDS actually.

    https://azure.microsoft.com/en-us/services/azure-sql/#features

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

  • Reply To: SQL Server on Amazon RDS vs SQL Server on Amazon EC2

    A few things that might help

    1. Remember you might still need Amazon SES when configuring Database Mail
    2. Explore Amazon's Calculator to determine what you can save https://calculator.aws/#/

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

  • Reply To: Lock Scenarios Using sys.dm_tran_locks

    Thanks so much for the feedback and corrects. I have updated it. I'm sure it sill reflect once the changes are approved.

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

  • Reply To: Investing in Speed

    Absolutely profound. I think it also speaks to the difference between buying an asset and buying a liability as often talked about by Robert Kiyosaki. An asset produces generates revenue,...

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

  • Reply To: The IDENTITY Column Property

    Steve Collins wrote:

    It's great to see this article!  I'm going to sit this pie fight out though.  Two items I would toss in fwiw:

     

      <li style="list-style-type: none;">

    1. The return type of...

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

  • Reply To: The IDENTITY Column Property

    Michael L John wrote:

    Good job!

    There is one things that could probably be added to this.  An identity is incremented when an attempt to insert is performed.  Even if the insert fails, the identity...

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

  • Reply To: Parameter pain

    Plan Guides. I have never used them either. Sounds intriguing.

    Thanks Sir for the article.

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

  • Reply To: The NoSQL Misdirections

    Thanks for the article. 1 Trillion rows caught my attention. How would you compare and RDBMS row to a NoSQL row. Can I consider a NoSQL "row" as a single...

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

  • Reply To: Stairway to Database Containers Level 3: Building Custom Container Images by Hand

    Inspired to see you never stop learning and teaching new technology, Steve.

    When I first used SQL Server on Linux, I noticed SSMS on my machine didn't render the Linux directories...

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

  • 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

  • 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

  • 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

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