Setup cannot be performed on Read-only, mapped or compressed drives. FAT32 filesystems proved to be less secure then NTFS systems when using SQL Server 2016. Detailed information on disk space requirements for each feature could be found here.įAT32 filesystem is supported, but it is strongly recommended to avoid it, and use an NTFS formatted drives instead.
Older 32 bit processors are not supported by the SQL Server 2016.Īt least 512 MB of system memory is required, but be aware that some of the features require much more.Īs for the hard drive – at least 6 GB of free space is required, and it heavily depends on additional features that could be installed.
There are several hardware and software requirements that should be taken into consideration before installing new SQL Server 2016:Ħ4 bit processor, with at least 1.4 GHz clock speed. New features have been added, with their respective setup options SQL Server Management Studio has its own installation process, separated from installation of other services Although it is similar to the installation of SQL Server 2014 and other older versions, there are few notable differences: Along with these features, comes the new installation setup. I’m learning but I’m glad I don’t have to transition to that half-baked monstrosity for the entire work day.Microsoft SQL Server 2016 provides faster transactions and queries, deeper insights on any device, advanced analytics, new security technology, and new hybrid cloud scenarios.
When I have to deal with Windows 8 or Windows Server 2012 in a VM or RDP I get a bit frustrated – not just the key combos (I could re-map, but not across every single machine I access) but also the new places you need to really fine-tune the location of the cursor to get anything to happen, and the fact that on every new machine I have to pin a slew of programs to the taskbar so I don’t have to use the new way to find crap.
Currently I have a 15″ MacBook Pro retina (4-core, 16GB), and I still have my Mac Pro from 2008 (8-core, 32GB) which has served me quite well while I’ve been waiting for the new Mac Pro.Įverything I need to do in Windows I do either through RDP or in a VM (I’m a Parallels guy now, but used to prefer VMWare Fusion). That machine is still in service within the family (video recording / processing).
I started with a MacBook Pro 17″ back in 2007 I believe. I have been using Mac hardware exclusively for several years. In a few weeks from now I will do a follow-up blog posting where I’m presenting the results of this survey. And yes – a Mac is just cool and sexy □ And the whole story about the new UI in Windows 8 doesn’t really convinced me.Īnd PLEASE don’t get me wrong: this is NOT a pro/con Windows/Mac survey/blog posting, I’m just interested in the REASONS why people are doing that shift. In my case I just wanted to try a different OS, because I have used Windows on the desktop for almost 20 years (including the DOS area), and I just wanted to see and learn something new. If yes, I invite you to leave a comment, where you should also explain your reasons why you have done that shift. Today I want to ask you a very simple question: Are you also a SQL Server Professional and running on Mac? And for serious SQL Server stuff, I’m using a RDP connection to a full-blown rack server which is hosted in the basement of my house. In my case I’m using a 2012 MacBook Air with a VMware Fusion VM where my SQL Server is installed. Since the summer of last year I have also joined that group of people, and I’m doing the same. I know a handful people who are SQL Server Professionals and using for their day-2-day job a Mac system.