It is a while since I retired but my memory is that ssas effective user has nothing to do with Kerberos (with SQL2019).  The authentication system in ssas dates from...

• This reply was modified 4 months, 3 weeks ago by EdVassie.

The article captures my thoughts and puts them into words better than I could.

From my viewpoint, a major weakness of current AI is the indiscriminate nature of the training material....

• This reply was modified 6 months ago by EdVassie.

We used a system of DNS aliases in the connection strings.  The end result was a layer of indirection that allowed us to change the underlying server topology with zero...

• This reply was modified 7 months ago by EdVassie.

I agree that the level of HA should be guided by RTO, RPO and the SLAs agreed with the business. There will often be databases that do not need the...

I have thought for a number of years there is no good reason why an IT project should fail. We as IT Pros have enough skills to get almost anything...

You need to test the impact using a non-production system.  However I have found RCSI to mostly be a useful thing, to the extent that I made it standard for...

I have seen people sometimes get confused about MAXDOP (however it gets applied) and number of threads allocated to a query. They are not the same.

The degree of parallelism applies...

If troubleshooting was easy, they would not need the experts. It is when there is trouble doing the troubleshooting that expertise, in other words previous experience, is needed.

It does not...

As has already been said, the disk topology seen by Windows and the DBA in today's systems is typically logical, not physical.  It is standard for storage administrators to carve...

In your position, where the source environment is old and the target is new, I would aim to do it in the fewest steps. For you this means an intermediate...

Steve is right. It is important to take breaks from work.

I never had a sabattical, mostly the jobs I had did not allow for one. But I (almost) always took...

I think what puzzles me the most is you seem to have a few years SQL experience but are not challenging the initial decision to change the column definition. You...

You seem to have a process. I suggest you try it out on a test system to see if anything breaks.

There are many ways where things could break. If the...

Finding the year in a date is something relatively easy for a human and often difficult for a machine.  However many date formats you think you may have, the data...

Lovely example for a bit of SQL injection