Technology Insights

Connect To Microsoft SQL Server From OSX

If your daily driver is a Macbook or similar and you also manage a network that has Microsoft SQL Server running on it then it can be useful to login to those MSSQL Servers remotely. Even if its simply to view database layout or verify a service is running properly by actually connecting to it there is no doubt that having an easy method to connect to Microsoft SQL from OSX is beneficial. There are a bunch of JAVA based clients such as SQuirreL SQL Client or SQLRazor that are great applications but I personally use DBVisualizer or Navicat which are both described in more detail below.

Technology Insights

Canfield Imaging Systems: Backup VISIA SQL Database And Upgrade VISIA 4.2 To VISIA 5.0

One of my clients uses VISIA medical imaging software from Canfield Imaging Systems for various forms of medical research projects. They have had the VISIA software and imaging station for a year or more and recently needed to upgrade the software to take advantage of some new features available in VISIA 5.0. The client’s VISIA installation was at VISIA 4.2 so it required a major update to get to VISIA version 5.0. Upgrading the software is fairly easy but it is important to make sure you have current backups before the upgrade begins. Follow the directions below to first backup your the Microsoft SQL Server, backup the VISIA files, and then proceed with upgrading VISIA 4.2 to VISIA 5.0.