Viewing 15 posts - 166 through 180 (of 6,031 total)
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
Just yesterday, I had to troubleshoot an issue where CPU was pegged at 99%, and I determined the bottleneck to be a high volume query executed by the eCommerce application...
September 27, 2022 at 6:30 pm
Viewing 15 posts - 166 through 180 (of 6,031 total)