Viewing 15 posts - 1 through 15 (of 22 total)
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...
September 15, 2025 at 1:57 pm
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...
September 8, 2025 at 2:01 pm
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...
August 29, 2025 at 2:21 pm
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...
March 19, 2025 at 3:01 pm
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...
February 4, 2025 at 4:04 pm
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...
December 9, 2024 at 2:42 pm
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...
November 4, 2024 at 5:10 pm
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.
October 22, 2024 at 12:23 pm
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....
May 3, 2024 at 3:31 pm
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...
November 7, 2023 at 9:47 pm
Thanks all for the suggestions. Do you all have any recommendations for learning resources (books, or sites) on this topic?
Thanks!
September 25, 2023 at 8:08 pm
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...
July 11, 2023 at 1:57 pm
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...
March 16, 2023 at 7:21 pm
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...
June 6, 2022 at 9:57 pm
Viewing 15 posts - 1 through 15 (of 22 total)