Forum Replies Created

Viewing 15 posts - 121 through 135 (of 5,986 total)

  • Reply To: The SPU

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

  • Reply To: Are You Still Using Portable Drives?

    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.

  • Reply To: Are You Still Using Portable Drives?

    Rod at work wrote:

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

  • Reply To: Are You Still Using Portable Drives?

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

  • Reply To: Poking the Bear

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

  • Reply To: Cloud First Software

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

  • Reply To: Using SQL Audit to monitor index create / drop / alter events ?

    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...
  • Reply To: Login attempt from different IPs in the errorlog

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

     

  • Reply To: web connection string to database that are in Alwayson Availibility group

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

  • Reply To: Practical IOT

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

  • Reply To: What's the Edge Case?

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

  • Reply To: DevOps is Culture

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

  • Reply To: Cone of Uncertainty

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

  • Reply To: Cloud Databases

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

  • Reply To: The Right Connection

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

Viewing 15 posts - 121 through 135 (of 5,986 total)