I was thinking the other day about why Colonial Pipeline shutdown their flow of oil for weeks after their ransomware attack - rather than simply restoring from backup and/or keeping...

The example presented in the article, executing a stored procedure within a loop for a set of input parameters, is one of those scenarios where looping is justly applied. Refactoring...

When I do use looping in conjunction with SQL, it's because I'm doing something DBA-ish: like looping across databases to execute a DBCC or BACKUP command, or querying meta data...

One thing engineers can do is install the sensors and self driving software in cars - but just don't connect it to the steering, breaks, etc. Human drivers, who volunteer...

"Must have minimum eight years' experience with SQL, coding queries, SCUD, stored procedures and data import/export."

scud (verb):

1. to move or run swiftly especially as if driven forward

2. to run before...

In many cases, the "DBA" may in actuality be a jack of all data related trades - expected not only to keep the databases running but also create all the...

Mobile apps is another example where many companies fail. Often times, the root of the problem is that an "enterprise application" may be nothing more than a customer facing GUI...

For a Windows shop, is there any practical benefit, like in terms of licensing costs or performance, for running SQL Server on a non-containerized Linux instance? For example, could anyone...

...

Regarding Erics suggestion, thats definitely a nifty idea. In our case, I'd be a bit concerned about the amount of data growth that we would produce this way but...

Yes, because of the way ColumnStore data is organized, it is great for read performance but poor for write performance. However, the most efficient way to mitigate something (in this...

One option is to create a table or view that contains the set of values, and then inner join on col_1 and/or col_b.

This would abstract the set of values from...

Performance has a lot to do with page caching and how much memory has been allocated for use by SQL Server. Logical reads (prefetched from memory) are much faster than...

...

Eric, maybe I didn't understand your meaning then when you said:

"so for everyone to mount a flag in their front yard seems to me like a form of virtue...

Whatever happened to the emoji feature? Sometimes I feel like we post something and the underlying emotion is taken out of context.

I have no problem with the USA flag, but I wouldn't mount it in my front yard, for much the same reason that I only wear...