Forum Replies Created

Viewing 15 posts - 1 through 15 (of 22 total)

  • Reply To: AI Steals Joy

    David.Poole wrote:

    An awful lot of the uses of AI feel like leaning a ladder on the branch of a tall tree, then climbing it to saw the branch nearest the...

  • Reply To: Requiring Technical Debt Payments

    David.Poole wrote:

    There are areas of tech debt I would like to address; however, doing so takes time, money and an acceptance that the necessary changes require the people who need...

  • Reply To: Ghostworkers

    Isn't this purely a problem caused by poor management? The article mentions another statistic about 46% workers don't know what is expected of them.

    As a manager, I have expectations of...

  • Reply To: Lower Your Attack Surface Area

    Interesting post! Would Dynamic Data Masking be the tool to use here?  I"m assuming not, since the data could be unmasked on the development server. Thus the actual data would...

  • Reply To: Data Joining technique help

    ScottPletcher wrote:

    You should definitely switch the key order on the lookup table, i.e., not:

    PRIMARY KEY CLUSTERED ( iid, cart_id )

    but instead do this:

    PRIMARY KEY CLUSTERED ( cart_id, iid )

    Thanks! took...

  • Reply To: NC index creation duration question

    Jeff Moden wrote:

    You do realize that the addition of the new index requires space that might not have been available and that dropping the first NCI made a bunch of space...

  • Reply To: SQL 2022 - CPU High Utilization

    Since we don't have much info on your setup, this is a stab in the dark:

    1. Are you in a virtual environment? Is it shared? could be a noisy neighbor...

  • Reply To: Date Type ETL Question

    Hey All,

    Thank you for the answers!

  • Reply To: Possible oddity in msdb.dbo.backupset

    My first thought would be to check the is_Snapshot column. It could be the case that the backup is being taken by a snapshot.

  • Reply To: The On-Call Load

    I did about 10 years of on-call work as a DBA. From my experience, it seems like 10 years of on-call is about the limit for most people in data....

  • Reply To: Current State of SSIS 2023

     

    Martin Schoombee wrote:

    If I had to place a bet, I would bet that we will see an on-premises version of ADF in the not-too-distant future. Many companies are still on-premises, and...

  • Reply To: SSIS vs TSQL sp

    Thanks all for the suggestions. Do you all have any recommendations for learning resources (books, or sites) on this topic?

    Thanks!

  • Reply To: Bare Metal

    We have a physical 3 node WSFC with 6 SQL FCIs. We are using cross-site AGs for DR. We built this in 2017; running MSSQL 2016. Pretty much everything else...

  • Reply To: Database Design workaround with Views or Synonyms

    I wasn't sure what was more appropriate for the situation: Views, or synonym. Synonym sounds like a better fit. Noted on the license violation; I'm just going to assume it...

  • Reply To: SPLA License question

    IMO you should talk to your Microsoft Representative. I know that software assurance has benefits that include not having to license passive standby servers for HA and DR. I don't...

Viewing 15 posts - 1 through 15 (of 22 total)