sql server

Infopackets Reader Philip S. writes: " Dear Dennis, We are running Windows 10 on our office machine which has Microsoft SQL (MS SQL) installed. On that machine we use Microsoft SQL Server Manager to enter in data into our databases, though other ... machines can access the Microsoft SQL databases through the network using MS Access DSN files. A few years ago we hired someone to set up our databases; however, we are now running out of space on the C drive as the databases have grown significantly in size. We would like to move the MS SQL databases and then set up a RAID to make the data redundant ... (view more)

Infopackets Reader John R. writes: " Dear Dennis, I'm running Windows 10. For the last week, Windows Update fails every time with this error: 'Critical Update for SQL Server 2016 MSVCRT Prerequisites KB3164398 - Error 0x80070643'. Any idea how to ... fix this? " My response: I have not had this problem before so I asked John if he would like me to connect to his machine using my remote desktop service , and he agreed. The reason for the SQL Server update (KB3164398) failing was an interesting problem, as it was not very obvious. I'll explain more about that further down - for now I'll go through ... (view more)