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

Hey All,

Thank you for the answers!

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.

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

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

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

Thanks!

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

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

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

Any suggestions on where to look for modern training(book or course)? I'm guessing older training is going to focus on SSAS,SSRS etc.

Sorry, not trying to hijack the thread! We will try to build a data warehouse for sure. I think we may also end up implementing a data lake, though I've...

I'm just entering the BI space , and so is the company that employs me. We are planning on implementing a DW for the first time and using MS BI(SSAS,SSIS,SSRS)...

Top lessons I've learned about employment:

Take charge of your career. Decide what you really enjoy doing and find a job doing that. I waited far too long to pick...

Hi,

I noticed the author used an ID column of IDENTITY as the PK in every table. This appears to be a best practice based on what i've  read online. Can...

Thank You all for the information!