Forum Replies Created

Viewing 15 posts - 1 through 15 (of 367 total)

  • Reply To: Does Log Data Belong in a Table or a File?

    As Eric Russell pointed out back in 2016, I've used a hybrid approach before where the data is written to a file for performance and in case the server crashed,...

  • Reply To: Where Does NoSQL work well?

    Eric,

    In you situation, your essentially extracted the customer-centric data into a single document per customer then used a document database for that very purpose. Good use there considering the data...

  • Reply To: Where Does NoSQL work well?

    I think that NoSQL environments have their use cases and shine well in those. I think the biggest problem is when we try to use NoSQL tools to replace RDBMS...

  • Reply To: Create a Tally Function (fnTally)

    Jeff Moden wrote:

    I also consider that to be mostly a "marketing for Microsoft" site.  Consider the number of hits the bloody community put on the "dark theme" request in SSMS and...

  • Reply To: Parameters in RAISERROR

    Jason- wrote:

    In order to use one of the other data types we have to use a different type specification. While you can use all of those listed datatypes in RAISERROR...

  • Reply To: Parameters in RAISERROR

    I checked my answer against the Microsoft Docs and it states:

    argument

    Are the parameters used in the substitution for variables defined in msg_str or the message corresponding to msg_id. There can be 0 or...

  • Reply To: Data Saturdays and SQLSaturday

    I have to admit that this is an opportunity to be more inclusive than to just SQL Server. In addition to on-prem SQL Server, I also work on both SQL...

  • Reply To: Virtual PASS

    I began presenting for SQL Saturday in 2012 with focus on fundamental skills to help guide new people and to help refresh skills for more seasoned folks. This has been...

  • Reply To: Allowing Failure

    Jeff Moden wrote:

    What's sad is that it usually takes multiple such lessons to knock the chip of their shoulder.

    Yep, that's because they still don't accept responsibility! I've been in similar situations...

  • Reply To: Allowing Failure

    When my kids were growing up, I'd often give them a chance to fail at something in a safe environment just so they would learn to not just take my...

  • Reply To: All I Want for Christmas

    I totally agree with you Steve. While I do enjoy working from home and look forward to doing so permanently, I also long for in-person SQL Saturday events and other...

  • Reply To: Prized PII

    skeleton567 wrote:

    Aaron, I think fax machines and paper were actually more secure than cloud computing.  We used fax machines for decades and never experienced any security issues at all that...

  • Reply To: Prized PII

    Having worked in healthcare for the past 15 years, I fully understand and appreciate the need for data security and privacy. However, I do get frustrated at situations that prevent...

  • Reply To: Your Favorite IDE

    Because I've been working with Redshift, Postgres and DB2 (yeah, don't hold it against me), I've become a fan of dBeaver. I also use it with SQL Server for general...

  • Reply To: Collecting Toxic Waste

    I have to agree with Gamberoni in that explaining a design, code, test, etc. to someone else is very useful. I've often found that when I get stuck, if I...

Viewing 15 posts - 1 through 15 (of 367 total)