So, the cloud is like a super buffet where every type of food imaginable is right there for the taking at a price point that's less than you would spend...

We used to use magnetic tape for arhiving data and avoided needing to delete it OR to pay ongoing costs for online storage.

...

And another thought about this, we...

A useful feature would be declaration of user defined global constants at the server or database level.

For example:

DECLARE CONST @@PI NUMERIC(12,10) = 3.1415926535;
DECLARE CONST @@StatusInProcess TINYINT =...

Really, going forward companies should minimize the amount of PII data that they collect about their customers. There comes a point of diminishing return where the usefulness of data in...

Well, you can't just sit down and ask a handful of software engineers or DBAs.

A few years back, I worked on a team implementing a CCPA compliance project - or...

I developed and maintain a 'DBA Dashboard' application for internal use in our organization. It allows anyone in IT to view a SPID activity report, disk space and backup history,...

As a bit of a sidebar, I just watched the day 3 presentation that Kimberly Tripp gave.  It seems that really old technology still prevails and that technology is...

• This reply was modified 2 years, 8 months ago by Eric M Russell.

When ranking programming languages, it's important to consider that some languages like SQL and HTML are domain specific. While certainly not the most robust in terms of functionality or "sex...

Maybe instead of entirely new chip designs optimized for data processing, it could be stripped down chips that contain only the necessary instructions, so they can be less expensive (more...

According to the front page of Backblaze's website, they are currently managing 2,280,426,850,155,030,000 bytes of customer data.

That's 2.2 Exabytes.

One word of caution about FB. Sometimes one can have their FB account either locked or disabled/removed because some FB algorithm gets it into its head, that you've said...

Backing up your photos and personal documents to removable storage and then losing it is a nightmare scenario. For that reason, I think thumb drives and SD cards are a...

Does Red Gate SQL Monitor use Profiler traces or Extended Event traces?

When it comes to developing database objects and SQL, I make an effort to stick with plain 99% ANSI compliant code and data types, so the code and data can...

I've already got SCHEMA_OBJECT_CHANGE_GROUP.

Here are all the audit groups I'm using:

ALTER DATABASE AUDIT SPECIFICATION [SQLAudit_$($database.name)_DDL]
ADD (SCHEMA_OBJECT_CHANGE_GROUP),
ADD (SCHEMA_OBJECT_OWNERSHIP_CHANGE_GROUP),
ADD (SCHEMA_OBJECT_PERMISSION_CHANGE_GROUP),
ADD (DATABASE_OBJECT_OWNERSHIP_CHANGE_GROUP),
ADD (DATABASE_OBJECT_PERMISSION_CHANGE_GROUP),
ADD (DATABASE_OWNERSHIP_CHANGE_GROUP),
ADD (DATABASE_PERMISSION_CHANGE_GROUP),
ADD (DATABASE_ROLE_MEMBER_CHANGE_GROUP),
ADD (APPLICATION_ROLE_CHANGE_PASSWORD_GROUP),
ADD (AUDIT_CHANGE_GROUP),
ADD (DATABASE_CHANGE_GROUP),
ADD (DATABASE_OBJECT_CHANGE_GROUP),
ADD...