Here's the issue. AE requires the cert to be installed for the system and access to resources outside of SQL Server. This also does an encryption outside of the db,...

I see few people use it. Those that do think it's great, but I think this is a bit of you needing to ensure your process fits with DQS, not...

I agree with Jeff. If you want to change passwords, do so though be aware this might mean reboots or restarts. For service accounts, use group service accounts, or strong,...

Edition? This matters.

SQL licensing guide: https://www.microsoft.com/en-us/sql-server/sql-server-2017-pricing

For Standard, only 20 cores are used. If you want 24 cores, you need to go with Enterprise.

You cannot license 8 cores. From the...

I assume this was a dev server of some sort?

Moving the files is good for organization, but it doesn't really matter here. I would likely have left them alone and...

Scott has a good explanation, but I agree with Eirikur, get Grant's book:  https://www.sqlservercentral.com/books/sql-server-execution-plans-second-edition-by-grant-fritchey

OK, I assume you mean that you can look at the SQL Server error log and see this. It is also logged to the Windows Application log, and you can...

Closing. Post here: https://www.sqlservercentral.com/forums/topic/not-seeing-failed-logins-in-log-viewer-or-profiler

Wed am. Not going to the opening party, no ticket, but will be in the WSCC until 4-5.

It's a feast or famine year. Not a good showing, though I really didn't have much on my bench that would have helped.

I'll be at Summit Mon/Tue only.

Thanks, edited the article and you are welcome.

Try this in a file, edit the SQLCMD to match what you need.

@@echo off
setlocal EnableDelayedExpansion
for %%x in (*.sql) do (
  set source=%%x
  echo sqlcmd -E...

• This reply was modified 6 years, 5 months ago by Steve Jones - SSC Editor.

Without persisted, this doesn't work. That was what the question tested, not if you can find a way to index a float column.

Good to hear. If you ever want to write up how this works for you, or how you do the imaging, we'd love to see an article.

If memory serves, it's a mix of commodity and cloud. However, they certainly share lots in the cloud, but use hardware to filter this down to reasonable levesl quickly, so...