Advertisements

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.
 


Advertisements

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 !!!

New Microsoft Azure Portal | Mind = Blown

August 27, 2014 Leave a comment

Microsoft recently announced a first-of-its-kind Cloud experience that brings together cross-platform technologies, services and tools, enabling developers and businesses to innovate at startup speed via a new Microsoft Azure Preview Portal.

“Developing for a mobile-first, cloud-first world is complicated, and Microsoft is working to simplify this world without sacrificing speed, choice, cost or quality,” said Scott Guthrie, executive vice president at Microsoft. “Imagine a world where infrastructure and platform services blend together in one seamless experience, so developers and IT professionals no longer have to work in disparate environments in the cloud. Microsoft has been rapidly innovating to solve this problem, and we have taken a big step toward that vision today.”

Windows AZURE is now Microsoft Azure!

New Portal: portal.azure.com
01_Azure_Portal

 

–> Check in this Video the new “AZURE Portal” & how DevOps just got a whole lot more awesome:


 

The new “Microsoft Azure” Portal provides a fully integrated experience that will enable customers to develop and manage an application in one place, using the platform and tools of their choice. The new portal combines all the components of a cloud application into a single development and management experience.

–> New components include the following:
1. Simplified Resource Management
2. Integrated billing
3. Gallery
4. Visual Studio Online
… for more info visit Microsoft Press, [link].

 

–> Easily Spin-Up a new “SharePoint Farm” in minutes:

You can see here on AZURE cloud how easily and in no time you can Spin-Up a new SharePoint Farm in minutes and few Clicks:
02_Azure_Portal_SharePointFarm

Azure also provides you various options to select SQL Server Plans based upon your preference and budget:
03_Azure_Portal_SharePointFarm_SQLPlans

Otherwise in an on-Premise environment or with any other vendor solution this would take days to setup a new Server (Hardware) with Windows Server OS, SharePoint, SQL Server, etc. installed and get things configured.

 

–> Spin-Up a new “SQL Database” in seconds:

Creating a new SQL Server instance is also very easy where you provide all necessary information in simple steps, like SQL Instance Name:
04_Azure_Portal_SQLServerDB_onAzure
The new instance will be created in seconds and you can access the Instance Create Databases, Tables, Views, other DB Objects and easily Query them via SSMS.

 

–> Microsoft Azure Offerings:
Apart from these 2 offerings that we saw above, Microsoft Azure provides lot more that you can browse in Azure Gallery:
05_Azure_Gallery

I’ll be exploring the new Portal as per my needs and post my experiences in coming posts, so stay tuned!