Viewing 15 posts - 121 through 135 (of 5,986 total)
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...
January 5, 2023 at 3:19 pm
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.
December 19, 2022 at 4:18 pm
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...
December 19, 2022 at 4:10 pm
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...
December 16, 2022 at 5:23 pm
Does Red Gate SQL Monitor use Profiler traces or Extended Event traces?
December 14, 2022 at 5:52 pm
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...
November 30, 2022 at 4:09 pm
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...
November 22, 2022 at 1:41 pm
The firewall on database server should only be accepting connections from the web application server and a limited range supporting your IT department, right?
November 21, 2022 at 9:06 pm
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...
November 21, 2022 at 8:58 pm
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...
November 15, 2022 at 4:25 pm
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...
November 15, 2022 at 3:53 pm
DevOps is a collection of tools and processes for deploying code. It's a means to an end - but not the end goal.
November 8, 2022 at 2:40 pm
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...
October 26, 2022 at 1:12 pm
When evaluating various cloud database platforms, it's not just about SQL features or who can offer the best deal on hosting. Some of these platforms offer amazing scalability.
I was evaluating...
September 30, 2022 at 3:16 pm
When creating DML scripts for deployment, I sometimes implement assertion based logic like in the two examples below.
The use of RAISERROR with severity level 20 causes SQL Server to terminate...
September 28, 2022 at 2:00 pm
Viewing 15 posts - 121 through 135 (of 5,986 total)