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

When designing the initial model for a database, I'd rather err on the side of tight constraints (ie: default to not-null if the business can't think of a good reason...

DevOps is a collection of tools and processes for deploying code. It's a means to an end - but not the end goal.

There needs to be an abstraction layer between the application and the physical implementation of the database (tables and columns). Some will call for using web services or a microservices...