SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

New Undocumented Feature in SQL Server 2014


Today is the eagerly anticipated launch of SQL Server 2014, I have downloaded and installed a copy of the RTM product and had a play. During some intensive testing I found that there is a new undocumented feature which will allow all registry keys to be available inside of your systems environmental variables. It also means that the default directory for databases, backups, filestreams and any other files you want to import / export will seamlessly connect and work even if you do not specify a path!


How do you turn this on I hear you ask?


Simply enter “-SatNav” as a startup parameter
Use traceflag -20140401


As you would expect from initial findings this appears to be an Enterprise only feature.


Richard Douglas

Richard Douglas is a SQL Server Professional working in the UK where he recently worked as a DBA in women's clothing, not literally he hastens to add! He is certified in SQL Server 2008, runs the Maidenhead SQL Server User Group Pass Chapter and is on the organising committee for SQL Relay. In his spare time plays the trumpet in local symphony orchestras.

His online presence includes:


Leave a comment on the original post [sql.richarddouglas.co.uk, opens in a new window]

Loading comments...