I disabled the antivirus temporarily and was able to install SSMS 2016

It turns out the installations was being blocked by McAfee antivirus. 😉

Further checks using procmon show the installer is unable to open or create the following registry keys

RegOpenKey

HKLM\System\CurrentControlSet\Services\WinSock\Parameters

HKLM\Software\Wow6432Node\Microsoft\CurrentVersion\Internet Settings\ZOneMap

HKLM\Software\Microsoft\Windows\CurrentVersion\Setup\PnpLockdownFiles

RegCreateKey

HKLM\Software\Wow6432Node\Microsoft\WBEM\CIMOM

Interesting in my case, it all came clean when I disabled log shipping on the secondary. 🙂

Consider updating the statistics one by one and include a wait interval to reduce the impact on your system. You can also add a sample size for daily updates. Below...

Do you have support for the old applications? If they can reproduce a parallel environment I would recommend you do so and test the upgrade.

Other option is is there...

Grant Fritchey (1/28/2016)

---

To get data moving both directions you're probably looking at Merge Replication. But that requires quite a bit of redesign. You could use transactional replication, but it's a...

sqlm0j0e (1/19/2016)

---

This may sound weird but if you go through the SQL Server for the Oracle DBA class by Microsoft, you'll actually be able to learn quite a lot, including...

JustASQLGuy (2/1/2016)

---

Wouldn't this be a simpler solution and be a bit less confusing?

delete Customers

where CustID in (

...

Thanks a lot.

So the old IP address remains there, correct?

In my case I control memory use with the MAX_SERVER_MEMORY option. Check the total memory on the server and allocate to each instance approprately then make sure lock_pages_in_memory is granted...

Thanks. Actually SQL Server compression works on indexes too actually. In fact it appears the tool in the...

very useful article. Will try it out...

Great article.

Using Windows Auth ONLY is something I have been pushing for in my environment and I have succeeded with two new applications this year. A new version of one...

Its does mean what it says : the user does not exist or SQL server cannot find the user. Is this account an existing local or domain account? Can u...