There was nothing in the logs other than the login failures related to the anonymous login. The service did not restart prior to that (had been running since July 18).

Still...

Hi Lowell,

The accounts are trusted for delegation, as are the servers. The SPN's were created automatically when the service account was changed (did not mean to imply the originals were...

The GDPR is just the the first ripples of a tsunami of change. If we as data professionals want to be ahead of the wave, and not be swamped by...

Hi Carlton,
"SSCrazy" isn't my screen name, it's my rating on SSC 🙂

I just re-read your question myself, and I missed the word "delta" (haste makes waste!). A...

If the structure of each table is identical (same columns, data types), and if by "merge" you mean "combine", then investigate UNION and UNION ALL. The former will combine all...

I'm a proponent of using the terminator, and enforce it via a clear coding standard and code walkthroughs and reviews. For legacy code, we use SQL Prompt's Format feature, which...

In 2014, I discovered, you can execute the GRANT statement without the user existing in the database, and SQL Server will obligingly add the user. However, the user will be disabled...

Relaxation starts with the drive home. I put on my Van Morrison playlist and hit the road. It helps that I've gradually trained myself not to let other drivers get...

PDF format is a hard page break format, unlike HTML. The rules that apply to page breaks in that format are different and may be at odds with your intent....

Not only do learning styles vary from individual to individual, but an individual may prefer different styles depending on the material to be covered, and the ultimate goal of the...