SQL Server

Azure in China

May 17, 2017 .NET, AppFabric, Azure, Azure In China, Azure IoT Suite, Cloud Computing, Cloud Services, IaaS, Intelligent Cloud, Intelligent Edge, IoT Hub, Media Services, Microsoft, Mobile Services, PaaS, SQL Azure, SQL Server, VisualStudio, Windowz Azure 1 comment

Microsoft Azure presence in China is always a question when there is a need for any customer to deploy azure applications specifically for Chinese Regional customers.

Recently I had an interaction with a Microsoft Certified Trainer, who carelessly said Azure only uses Chinese partner based environment is only for serving CDN (Content Delivery Network) needs, partial knowledge is difficult to convince. Being a Certified Trainer, he should have known these. As I recollect my earlier experience with azure, I was aware that Microsoft has partnered with 21Vianet , to setup a Chinese instance of Azure with most possible IaaS, PaaS and SaaS offerings are available to Chinese customers. At the same time data would reside within Chinese governments data privacy and storage regulations.

Similarly other competitor cloud providers such as IBM also partnered with 21Vianet to setup their BlueMix instances in China.

Microsoft Azure in China

General availability of Azure in China through 21vianet partnership has been announced in March 26th 2014. These Azure Services in Chinese region will be operated and sold by 21vianet.

Quoting to Doug Hauger GM- National Cloud Programs, Microsoft

Windows Azure, operated by 21Vianet, is based on the same technology as Microsoft’s global Windows Azure service and offers a reliable, flexible and value-based service to bring Microsoft’s latest cloud technologies and benefits to Chinese customers and propel forward technological development in China as a whole.

Why Partnership?

As per Chinese Government(PRC) Cyber Security Law and Governance policies there is a clear restriction for a foreign entrant to obtain license and provide services to Chinese customers.  All the data relating to Chinese customers should reside within Chinese Data Centres, and foreign companies would have to pass on the operational ownership to a Chinese company in order to operate within PRC(Peoples Republic of China).

In Additional to that on November’2016 new amendments attached to new PRC Cyber Security Law (effective 1st June 2017).


The new law will come into force on 1 June 2017 and has significant implications for the data privacy and cybersecurity practices of both Chinese companies and international organisations doing business in China.

The new PRC Cybersecurity Law intends to combat online fraud and protect China against Internet security risks. In short, it imposes new security and data protection obligations on “network operators”; puts restrictions on transfers of data outside China by “key information infrastructure operators”; and introduces new restrictions on critical network and cybersecurity products.  [Read more from Source]

Where is Azure in China?

You can access Azure in China instance through a separate portal https://www.azure.cn. Azure Portal is available at https://portal.azure.cn/. Pricing information is available on http://www.azure.cn/pricing/pia/  (click on English to get an English version).

Below are two data centre regions Azure is available in China.


Services Offered in Azure China Instances:

Not all all services of Azure including Mobile Services, Analytics and IoT Suite are available for Chinese regions. I will try to cover a specific list of services that are available for China region.Azure China is a few versions behind regular Azure and not all services are supported. Some of the services supported are:

  • Compute – Virtual Machines (For IaaS Services)
  • Compute – Cloud Service (For PaaS Services)
  • Compute – Web Site
  • Data Services – Storage (For Blobs, tables and Queues)
  • Data Services – SQL Database
  • Data Service – HDInsight
  • SQL Database – SQL Import/ExportNetworks – Virtual Network (To communicate between cloud services via Local networks)
  • Service Bus
  • Active Directory
  • Access Control Service – which has its own UI and namespace
  • Caching – only dedicated cache is supported
  • Mobile Service
  • Media Service
  • CDN
  • Traffic Manager
  • Azure IoT Suite
  • Notification Center
  • Event Center
  • Service Fabric
  • Batch Service
  • Flow Analytics, Power BI
  • Document DB, SQL Database, SQL Data Warehouse, MySQL
  • and many more


A list of supported and not supported services can be found at (This is in Chinese, and it is a working document, use google translate to take you through all steps necessary for you to understand services offered in Azure China) http://www.windowsazure.cn/documentation/articles/developerdifferences/#readyonwacn

This also includes all the endpoints that are required for developers to integrate/develop applications targeting China region.

Hope this information was helpful to you. I would assume it would be helpful for some who are specifically looking forward for providing technology solutions for Chinese customers through Azure Cloud.


Visual Studio 2015 – ctp6

February 23, 2015 .NET, .NET Framework, ASP.NET, ASP.NET 4.5, Azure, Azure SDK, BCL(Base Class Library), C#.NET, IE, IIS, Microsoft SDKs, Portable Class Library, SQL Azure, SQL Server, Updates, Visual Studio SDK, VisualStudio, VS2015, WCF, Web API, Windows Phone SDK, Windowz Azure No comments

Microsoft today has released Visual Studio 2015 Community Technology Preview 6 (CTP 6), which includes some new features and improvements, such as new UI debugging tools for XAML, new Control Flow Guard security tool, and feature updates to ASP.NET framework.

For more information about what’s new in this release, please see the release notes.

Download Visual Studio 2015 Ultimate (web | iso)


Visual Studio 2013 – Update 2 is available

May 14, 2014 .NET, .NET Framework, .NET Framework 4.5.2, Azure SDK, Microsoft, SQL Server 2014, Trial Downloads, Updates, Visual Studio 2013, VisualStudio, VS2013, Windows, Windows 8, Windows 8 apps development, Windows 8.1, Windows Azure Development, Windows Phone, Windows Phone 8, Windows Phone 8.0 SDK, Windows Phone Development, Windows Phone Store, Windows Store, Windows Store Development, Windowz Azure, XBOX Development No comments

Microsoft has released the latest update for Visual Studio 2013 with major improvements including support for developing Universal apps for Windows 8.x, Win Phone, and XBOX.

Here are the list of improvements included as part of the release(lending from Visual Studio team blog):

Visual Studio 2013 Update 2 has many new capabilities as well as fixes that address bugs, customer feedback, performance, and reliability improvements. Here are some new capabilities that are part of this and related Updates and links to where you can find more info.

  • Universal Apps. With this release you can now build universal apps that can run on Windows 8.1 and Windows Phone 8.1 while sharing code and assets through shared projects.
  • TypeScript. The TypeScript language is a typed superset of JavaScript that compiles to plain JavaScript. As a typed language you can define classes, modules and interfaces that compiles to JavaScript and runs in any browser.
  • Web Tool. Our web development tools have many new features like SCSS support, a new JSON editor, updated ASP.NET templates, and an improved URL picker.
  • Azure tools. It’s easier to take advantage of Azure with options to create websites and SQL Azure databases directly on Azure for simpler deployment to a development / testing environment.
  • Diagnostics. Our diagnostics tools also got some enhancements. Performance events now let you navigate to user code for MVC Methods or jump to the SQL command for database queries. It is also possible to view the Windows Store diagnostics tools at the same time to see all your diagnostics information on a shared timeline.
  • Slipstream install. You can download Visual Studio with all its latest features from one install that includes Visual Studio 2013 RTM and Update 2 for Visual Studio.

There are a number of other important updates that are available today in addition to Update 2 for Visual Studio 2013:

  • Apache Cordova and Visual Studio. Cordova tools in Visual Studio let web developers build cross-platform mobile applications targeting Android, iOS, Windows and Windows Phone using use their existing skills in HTML and JavaScript. To learn more about Apache Cordova visit http://cordova.apache.org/
  • A cloud optimized .NET. The latest updates to the framework provide a cloud optimized mode that is smaller, lighter weight, and designed for cloud and server workloads.
  • .Net vNext. This update to the .Net framework is optimized for cloud-first and mobile-first development. It enables you to compile C# 6 and VB code with Roslyn compilers, speed up Windows Store apps with the .NET Native ahead of time compiler, and has a cloud optimized mode for ASP.NET apps.
  • TFS 2013 Update 2. It’s worth mentioning again the updates in TFS 2013 like improvements for tagging, charting, shared parameters, cloud load testing application analytics, and a lot more.

Check out Somasegar’s Blog and Brian Harry’s Blog to get more details on some of the highlights in this release. For a quick view at all the features and fixes included in this update go to the KB article.


Visual Studio 2013 – Update 2 (Web / ISO)

SQL Server 2014–CTP1–x64 Available now

June 25, 2013 .NET, .NET Framework, Futures, Microsoft, SQL Server, SQL Server 2014 No comments

Microsoft has made the Community Technology Preview of next version of SQL Server 2014 available to public.

Need more information about SQL Server 2014 CTP1? See the product details page.

You can download from TechNet Evaluation Center: 

DOWNLOAD: SQL Server 2014–CTP1–x64

Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2012–with Analysis Services, Reporting Services and Integration Services projects support

April 12, 2013 .NET, Business Intelligence(BIDS), KnowledgeBase, Microsoft, SQL Scripts, SQL Server, Sql Server 2012, SQL Server Analysis Services, SQL Server Data Tools, SQL Server Integration Services, SQL Server Reporting Services, Updates, VisualStudio, VS2012 No comments

Microsoft has released SQL Server Data Tools and Business Intelligence for Visual Studio 2012 with integrated support for Visual Studio 2012.  When Microsoft released SQL Server 2012,  Data Tools and Business intelligence released with bundled support for Visual Studio 2010 IDE, and this release is a good news for Visual studio 2012 developers. 

Now with this release developers will be able to Visual Studio 2012 for SQL Server Database Business Intelligence related projects using Analysis Services, Reporting Services and Integration Services.

[Quoting from MSDN]

SQL Server Data Tools – Business Intelligence for Visual Studio 2012 includes business intelligence project authoring tools and project templates for SQL Server Analysis Services, Reporting Services, and Integration Services integrated into a Visual Studio 2012 shell.

You can install SQL Server Data Tools – Business Intelligence for Visual Studio 2012 as a standalone business intelligence authoring environment or side-by-side with an existing SQL Server Data Tools installed with SQL Server 2012.

SQL Server Data Tools – Business Intelligence for Visual Studio 2012 uses SQL Server 2012 Setup to install the SQL Server Data Tools – Business Intelligence environment as a shared feature. If you are used to SQL Server Setup, this process will seem familiar to you; however, if you have never run SQL Server Setup to install additional SQL Server features before, this may seem a little confusing.

[Ref: MSDNhttp://msdn.microsoft.com/en-us/library/jj856966.aspx]

Download: Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2012

SSDTBI_VS2012_x86_ENU.exe – 784MB (Version – 11.0.3360.12)

Microsoft SQL Server 2008 R2 Service Pack 2

July 31, 2012 All, HotFixes, Microsoft, SQL Server, SQL Server 2008, SQL Server 2008 R2 No comments

SQL Server 2008 R2 Service Pack 2 (SP2) is now available for download. SQL Server 2008 R2 service packs are cumulative and can be used to upgrade all releases of SQL Server 2008 R2 to Service Pack 2.

SQL Server 2008 R2 Service Pack 2 contains Cumulative Update 1 to 5 from SQL Server 2008 R2 SP1.

The package can be used to upgrade the following SQL Server 2008 R2 editions:

  • SQL Server 2008 R2 Parallel Computing Edition
  • SQL Server 2008 R2 Datacenter Edition
  • SQL Server 2008 R2 Enterprise Edition and Developer Edition
  • SQL Server 2008 R2 Standard Edition
  • SQL Server 2008 R2 Web Edition
  • SQL Server 2008 R2 Workgroup Edition
  • SQL Server 2008 R2 Express Edition

SP2 Version:
Date published:

KB article 2630458 provides additional information about key fixes in SQL Server 2008 R2 SP2.


Get SQL Server 2008 r2 Service Pack 2 and associated downloads

Microsoft® SQL Server® 2008 R2 Service Pack 2

Microsoft® SQL Server® 2008 R2 SP2 – Express Edition

Microsoft® SQL Server® 2008 R2 SP2 Feature Pack

Microsoft SQL Server 2008 R2 – PowerPivot for Microsoft Excel 2010

Microsoft® PowerPivot for Microsoft® Excel 2010 provides ground-breaking technology, such as fast manipulation of large data sets (often millions of rows), streamlined integration of data, and the ability to effortlessly share your analysis through Microsoft® SharePoint 2010.

Microsoft® SQL Server® 2008 R2 Reporting Services Add-in for Microsoft SharePoint® Technologies 2010

The Microsoft® SQL Server® 2008 R2 Reporting Services Add-in for Microsoft SharePoint® Technologies allows you to integrate your reporting environment with SharePoint to experience the benefits of using the collaborative environment provided by SharePoint.


Information Source & Courtesy: Microsoft Download Center