Microsoft on 31st March 2016 announced the free availability of Developer Edition of SQL Server, currently 2014. The Developer Edition is meant for development and testing only, and not for production environments or for use with production data.
With SQL Server 2014 Developer edition developers can build any kind of application on top of SQL Server. It includes all the functionality of Enterprise edition, but is licensed for use as a development and test system, not as a production server.
So, with this edition you are getting the Database Engine as well as DW/BI capabilities ( i.e. SSIS /AS /RS) for free 🙂
This is a very good news for Developers, as till now the SQL Server Express edition used to be the free database for entry-level development, which has lot of limitations like:
1. Only Database Engine, no DW/BI suit (absence of SSIS/RS/AS).
2. Max size of a DataBase is set to 10GB (but you can create multiple databases)
3. No SQL Agent
4. Single CPU utilization
5. Max 1 GB RAM allocation
6. Max 16 number of instances per server
Hence this is a very good deal that you can now get full featured suit of SQL Server with Database Engine as well as with all DW/BI capabilities for free to play, develop and learn with.
I am super excited to announce the availability of my Whitepaper at Microsoft IT Showcase on:
1. In-Memory OLTP helps ESBI meet their users’ business requirements for increased agility.
2. Columnstore Indexes reduce the amount of time it takes to run and render SRSS reporting data.
3. Temporal data reduces the amount of support tickets received from the field due to inaccurate data.
4. Row-Level Security provides a more reliable and standardized method to easily control which users can access data.
5. Dynamic Data Masking helps limit exposure of sensitive data, preventing users who should not have access to the data from viewing it.
6. Query Store provides better insight into the performance differences caused by changes in query plans.
7. Active Query Statistics allows a view of active query execution plans and helps identify and fix blocking issues while queries are running.
8. SQL Stretch Database helps improve performance to frequently used data while preserving access to archived data.
Please check my other posts on SQL Server 2016
Scott Guthrie, Executive Vice President, Cloud and Enterprise Group, Microsoft on March 7, 2016 announced plans to bring SQL Server to Linux. He mentioned that this will enable SQL Server to deliver a consistent data platform across Windows Server and Linux, as well as on-premises and cloud, targeting the availability by mid-2017.
You can sign up for a Private preview here.
Recently in a Data Driven event Shawn Bice, General Manager, Database Systems Group, Microsoft showcased the capabilities and new features of SQL Server 2016. While demonstrating he gave a glimpse of SQL Server preview version running on Linux, and you can see the version in the snapshot below:
Microsoft SQL Server (Preview) – 13.0.8000.6 (X64)
Feb 24 2016 22:03:46 2015.0130.8000.06
Copyright (c) Microsoft Corporation
on Linux (Ubuntu 15.10)
Well I’m very excited and looking forward to download the SQL Server Linux preview and do some hands on.
Microsoft announced their new and improved USCMO webcast programs!
The USCMO (U.S. Central Marketing Organization) team manages and optimizes programs through the customer lifecycle in order to drive business results of conversion, pipeline, and managed costs.
Each webcast will stream live with interactive Q&A and will be made available on demand.
–> Please check the webcasts below you might be interested to register:
|Webcast Title||Webcast Date||Registration URL|
|Protect Your Business Against Online Fraud||1/20/2015||http://aka.ms/protectblog|
|Social in the Enterprise||1/21/2015||http://aka.ms/enterpriseblog|
|Windows Server 2003 Migration: Hardware Modernization||1/22/2015||http://aka.ms/WS03blog|
|It’s a New Year, Be Ready to Adapt||1/22/2015||http://aka.ms/adaptblog|
|HIPAA Compliant Cloud Solutions with Microsoft BAA||1/23/2015||http://aka.ms/BAAblog|
|Announcing the Enterprise Cloud Suite||1/26/2015||http://aka.ms/suiteblog|
|Get a fresh start in 2015 with new Windows devices||1/28/2015||http://aka.ms/windeviceblog|
|Need fast AND affordable? Why not try SQL Server?||1/29/2015||http://aka.ms/SQLserverblog|
|Mobile Productivity in the Modern Workplace||2/4/2015||http://aka.ms/mobileblog|
|Windows Server 2003: Most Common Application Migration Concerns||2/5/2015||http://aka.ms/commonblog|
|Enabling Customer Insights Using Business Analytics||2/12/2015||http://aka.ms/customerblog|
|Windows Server 2003: Security Risk and Remediation||2/18/2015||http://aka.ms/remeblog|
|The Connected Workforce||2/18/2015||http://aka.ms/connectedblog|
|Fine Tune Your Supply Chain with Better Insight||2/19/2015||http://aka.ms/fineblog|
Microsoft today announced the general availability of Azure Redis Cache, as well as its related pricing changes.
Azure Cache is a family of distributed, in-memory, scalable solutions that enables you to build highly scalable and responsive applications by providing you super-fast access to your data. It’s based on the popular open source Redis Cache, and it gives you access to a secured, dedicated Redis cache that’s managed by Microsoft.
–> Microsoft offers following types of Azure Cache:
1. Azure Redis Cache: Built on the open source Redis cache. This is a dedicated service, currently in General Availability.
2. Managed Cache Service: Built on App Fabric Cache. This is a dedicated service, currently in General Availability.
3. In-Role Cache: Built on App Fabric Cache. This is a self-hosted cache, available via the Azure SDK.
–> This provides you:
1. High performance: Azure Redis Cache helps your application become more responsive, even as user load increases, and leverages the low-latency, high-throughput capabilities of the Redis engine. This separate distributed cache layer allows your data tier to scale independently for more efficient use of compute resources in your application layer.
2. Great features: Redis is an advanced key-value store, where keys can contain data structures. It supports a set of atomic operations on these data types, and it supports master/subordinate replication, with fast non-blocking first synchronization, auto-reconnection on net split, and more. Other features include transactions, Pub/Sub, Lua scripting, and keys with a limited time to live.
3. Easy to use and manage: Provision Redis cache using the Azure Management Portal. You can use Redis from most programming languages used today. Easily manage and monitor health and performance in the Azure Preview portal. Let Microsoft manage replication of the cache for increased availability.
4. Azure Managed Cache Service: Azure Managed Cache Service is based on the App Fabric Cache engine. It also gives you access to a secure, dedicated cache that is managed by Microsoft. A cache created using the Cache Service is also accessible from applications within Azure running on Azure Websites, Web & Worker Roles and Virtual Machines.
5. In-Role Cache: In-Role Cache is based on the App Fabric Cache engine. In-Role Cache allows you to perform caching by using a dedicated web or worker role instance in an application deployed to Microsoft Azure Cloud Services. This provides flexibility in terms of deployment options and size but you manage the cache yourself.
–> Microsoft Azure Redis Cache will be available in two tiers:
1. Basic: A Single Cache node. Multiple sizes. Ideal for Development/Test and non-critical workloads.
2. Standard: A replicated cache in a Two-node Primary/Secondary Configuration. Includes SLA and replication support. Multiple Sizes.
Cache is available in sizes from 250MB upto 53GB.
–> Just use your subscription on Microsoft Azure Portal to spin up a new “Redis Cache” service:
–> Here is Step-by-Step documentation on how to use “Azure Redis Cache”, [link]
–> For more info on “Azure Caching” check my friend’s blog, [link] – Author: Ganesh Shankaran.