Thursday, May 28, 2015

SQL Server 2016 CTP2 is ready, get it now!

Starting May 27 you can download your own copy of SQL Server 2016 Community
Technology Preview 2 from this site:

Since it's lifetime is 120 days download right away to test drive. You can
download a CAB file or an ISO file. I believe there is a virtual image on the
Microsoft Azure cloud as well.

SQL Server 2016 has taken a big, big step in what it can offer compared to the
previous versions.

It offers a whole lot of benefits listed here from a
Microsoft site:

◾Enhanced in-memory performance provide up to 30x faster transactions, more
than 100x faster queries than disk based relational databases and real-time
operational analytics
◾New Always Encrypted technology helps protect your data at rest and in motion,
on-premises and in the cloud, with master keys sitting with the application,
without application changes
◾Built-in advanced analytics– provide the scalability and performance benefits
of building and running your advanced analytics algorithms directly in the core
SQL Server transactional database
◾Business insights through rich visualizations on mobile devices with native
apps for Windows, iOS and Android
◾Simplify management of relational and non-relational data with ability to
query both through standard T-SQL using PolyBase technology
◾Stretch Database technology keeps more of your customer’s historical data at
your fingertips by transparently stretching your warm and cold OLTP data to
Microsoft Azure in a secure manner  without application changes
◾Faster hybrid backups, high availability and disaster recovery scenarios to
backup and restore your on-premises databases to Microsoft Azure and place your
SQL Server AlwaysOn secondaries in Azure
You can get it for both x32 and x64 bit architectures.

SQL Server 2016 CTP2 CAB file:
Download the following files from the Evaluation Center to a temporary directory on your device:


Once the download has completed, extract the zip files then double click on the SQLServer2016CTP2-<architecture>-<language>.exe to begin the installation process.

PowerShell Pro Tools is a Visual Studio Community 2017 extension that you can try free

I see there is at least one extension, PowerShell Pro Tools that you can download. You can find it in the Visual Studio Community 2017...