Archive

Archive for the ‘Microsoft’ Category

Good news – Microsoft makes SQL Server “Developer Edition” free for developers !

April 1, 2016 2 comments

 
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.

SQL Server 2014 Dev Ed free

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 🙂

 

[Download the SQL Server 2014 Developer Edition free here]
 

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.
 


My whitepaper published on – Top 8 features of SQL Server 2016

March 14, 2016 Leave a comment

I am super excited to announce the availability of my Whitepaper at Microsoft IT Showcase on:

Microsoft IT looks at the top eight features of SQL Server 2016
 

Microsoft IT Showcase - SQL Server 2016 Top-8 features

Download : Word | PDF
 

Summary:

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.
 

Download : Word | PDF
 

Please check my other posts on SQL Server 2016
 


SQL Server on Linux – Microsoft announcement

March 12, 2016 Leave a comment

SQL-Loves-Linux_2_Twitter-002-640x358
 

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)

SQL on Linux
 

Well I’m very excited and looking forward to download the SQL Server Linux preview and do some hands on.

Check more at https://www.microsoft.com/en-in/server-cloud/sql-server-on-linux.aspx
 


Categories: Linux, Microsoft Tags:

Microsoft’s upcoming USCMO Webcasts | Digital Events

January 16, 2015 Leave a comment

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

Thanks !!!

Microsoft Azure Redis Cache – General availability

September 25, 2014 2 comments

Azure_RedisCache

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.

** Click here for PRICING DETAILS **


–> Just use your subscription on Microsoft Azure Portal to spin up a new “Redis Cache” service:

Azure06_RedisCache

–> 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.