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

The firewall on database server should only be accepting connections from the web application server and a limited range supporting your IT department, right?

Regardless of whether you have an AOG listener, you can connect directly to either the primary or secondary using a connection string similar to that below. If connecting to the...

Yes, IoT monitoring is a good application for industrial, healthcare, and the environment. I have a Ring security system and love it. I guess drones fall under the category of...