Nice article! I have been lucky enough to have visited 8 of those cities. I look forward to expanding my list!

Redshift is based on an earlier version of Postgres. It was modified to be a columnar database, but it doesn't have many of nice features and functions that were added...

Glad to see that I'm not alone in my confusion here! None of the answers fit the actual situation. As I expected, I got a result set from each table.

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

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 3 years, 3 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...