I feel somewhat prophetic:

http://jonmorisissqlblog.blogspot.com/2016/03/text-searchingprocessing.html

"I can't help but wonder if there's a strategy to get Azure full-text indexes both stored on and hitting Hadoop on the back-end.  How would...

My take on the article is that you chose correctly when you went with Solr.  After all it has everything you were after with phonetics, and...

EXECUTE AS LOGIN 

Are there active DDL changes running?

SQL 2005, but it still applies:

https://support.microsoft.com/en-us/kb/321247

"Configure the network share that is configured to hold the transaction log backups to have read/change permissions for the account under which SQL Server services...

Thanks for the replies. I put together a blog post here:

CAST as numeric rounding issue (Oracle Number to SQL Server numeric)

One thing I've learned from all of this...

Not to be a smart a$$: http://lmgtfy.com/?q=Alwayson+Availability+Groups+backup+secondary

There is a difference between an Alwayson Availability Groups and a alwayson failover cluster. It sounds like you're asking about the former.

It usually depends on the size of the organization. I've been places where sysadmins do monthly windows updates and DBA's do SQL service packs only. I've also been...

Do you know if you installed a named instance or the default?

Take a look at sql server configuration manager, and post a screenshot if you're unsure how to tell.

https://www.mssqltips.com/sqlservertip/1775/different-ways-to-execute-a-sql-server-ssis-package/[/url]

#7, there's a screenshot of "runas"

This SAP application I'm setting up runs SSIS on one of the app boxes.

SCOM has the potential to capture a lot of data...

Removing Replication

Have you tried repair, as mentioned here?

http://stackoverflow.com/questions/22000496/sql-server-install-bug-failed-to-launch-local-scenarioengine-exe