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 2 weeks, 3 days 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

When I was working as a minframe application designer and developer, I was one of those 10x engineers.

I never thought the others in the team did not earn their salaries,...

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

Where there is honey it will attract wasps.  There are many types of wasp:

* Inexperienced, mostly young and independent, playing with the free stuff that is out there and working...

• This reply was modified 6 months, 2 weeks ago by EdVassie.
• This reply was modified 6 months, 2 weeks ago by EdVassie.
• This reply was modified 6 months, 2 weeks ago by EdVassie.