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...

• This reply was modified 4 years, 11 months ago by Aaron N. Cutshall.

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...

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...

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...

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...

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...

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...

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

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...

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...

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...

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...

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...

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...

I beg to differ on the answers. The QOT basically said that all but the SET variable would reset @@ROWCOUNT to zero, however BOL states the following:

• Statements that make...