TechNet
Products
IT Resources
Downloads
Training
Support
Products
Windows
Windows Server
System Center
Internet Explorer
Office
Office 365
Exchange Server
SQL Server
SharePoint Products
Lync
See all products »
Resources
Curah! curation service
Evaluation Center
Learning Resources
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Script Center
Server and Tools Blogs
TechNet Blogs
TechNet Flash Newsletter
TechNet Gallery
TechNet Library
TechNet Magazine
TechNet Subscriptions
TechNet Video
TechNet Wiki
Windows Sysinternals
Virtual Labs
Solutions
Networking
Cloud and Datacenter
Security
Virtualization
Updates
Service Packs
Security Bulletins
Microsoft Update
Trials
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Related Sites
Microsoft Download Center
TechNet Evaluation Center
Drivers
Windows Sysinternals
TechNet Gallery
Training
Training Catalog
Class Locator
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
e-Learning overview
Certifications
Certification overview
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Other resources
TechNet Events
Second shot for certification
Born To Learn blog
Find technical communities in your area
Support options
For small and midsize businesses
For enterprises
For developers
For IT professionals
From partners
For technical support
Support offerings
For home users
More support
Microsoft Premier Online
Microsoft Fix It Center
TechNet Forums
MSDN Forums
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Sign in
Nevin Dong's Blog
Tags
Active Directory
AD
Alwayson
analytics
Android
Architecture
AutoScale
Azure
bandwidth
Big Compute
Big Data
Billing
BitLocker
Blob
cloud service
connected
Data Disk
Design Pattern
diagnostics
DIP
Dynamics
EF
Endpoints
Event Hub
github
Hadoop
HDInsight
High Availability
Hybrid Cloud
IaaS
Instance
IOPS
iOS
Java
JavaScript
LINUX
Live to code
Local Group Policy Editor
Log
Mahout
Management Portal
Management Service
MapReduce
Media Services
Metric
Microsoft Azure
Migration Assistant
Mobile Services
Mooncake
Multi-tenancy
Notification Hub
Notification Service
Open Source
Oracle
OSS
P&P
Patterns & Practices
Performance
PNS
Powershell
Private Cloud
Public Cloud
Queue
RAID
Reference Architecture
REST API
scalability
SDK
Service Bus
Service Heath Dashboard
Site to Site
SQL Database
SQL Server
SSD
Storage
Store App
Subscription
table
Throttling
Upgrade
VIP
Virtual Machines
Virtual Network
Virtualization
Visual Studio
VM
VM Depot
WAMS
WATK
Web Sites
WebLogic
Windows 8
Windows 8.1
Windows Azure
Windows Azure Connect
Windows Azure Mobile Service
Windows Azure Web Sites
Windows Phone 8
Windows Store App
WNS
Browse by Tags
TechNet Blogs
»
Nevin Dong's Blog
»
All Tags
»
sql database
Related Posts
Blog Post:
从Web Server向Azure WebSites迁移的利器(Migration Assistant)
Nevin (Naiwen) Dong
将Web应用迁移到云端,常见的做法是采用IaaS模式,即创建虚拟机(Virtual Machine,VM)并在上面分别部署Web Server、Database Server、Cache Server、DNS Server等;当访问负荷增大的时候,则增加虚拟机的数量来实现伸缩。 之前曾讨论过,可以将数据库服务器(Database Server)采用Platform as a Server(PaaS)模式来提供,也有相关的 迁移工具来帮助从SQL Server迁移到Azure SQL Database 。 Azure网站(WebSites)是一种完全托管的平台即服务 (PaaS) 产品,便于快速高效地构建...
on
25 Dec 2014
Blog Post:
SQL Database性能(Performance)的可规划性(Predictability)及度量(Measurement)
Nevin (Naiwen) Dong
性能是一个大家经常关注的问题,直接体验就是系统/应用的运行速度、响应时间、并发用户数等。从个人机(PC)、服务器(Server)、虚拟化(Virtualization)、私有云(Private Cloud)到公有云(Public Cloud),性能一直是开发/IT运营持续改进的领域。 当然,性能也是一个需要深入的专业知识的工作,性能的度量(Measurement)、监控(Monitoring)、基准测试(Benchmarking)、调优(Tuning)/优化(Optimization)等,都需要对技术的深入理解,需要专业的工具进行辅助。 当我们由使用SQL Server等数据库服务器,迁移到SQL...
on
17 Dec 2014
Blog Post:
从SQL Server到Microsoft Azure SQL Database的技术迁移及利器
Nevin (Naiwen) Dong
数据服务是几乎所有应用都要依靠,或者对外提供的关键性服务;一些关键性应用,例如企业级应用、在线游戏、电商等,对数据服务的可用性、一致性、伸缩性等有更高的服务等级要求。 随着云计算技术的推广,越来越多的IT管理/开发者考虑在Azure云中建立/使用数据库,主要有两种模式可以考虑:IaaS和PaaS。其中,IaaS模式是通过在Azure云创建及部署SQL Server(或其他服务器软件例如MySQL)的虚拟机的方式,提供及使用数据服务,即SQL Server VM in Azure;而PaaS模式则更简单,使用者可以不必关注底层更多的细节,例如操作系统(OS)、存储、网络等,而更加关注数据库服务器...
on
12 Dec 2014
Blog Post:
在WebSites中使用EntityFramework访问SQL Database时可能遇到的一个连接问题
Nevin (Naiwen) Dong
最近碰到一个奇怪的问题,发生在一个典型的Microsoft Azure云应用开发场景:利用Azure WebSites快速开发云Web应用,同时利用SQL Database来存储数据并提供数据服务;使用Entity Framework,可以快捷、高效地在客户端建立数据模型,便于访问SQL Database中的数据并进行交互。 问题是:为了开发方便,在本地Visual Studio开发环境中开发WebSites应用,连接到Azure上的SQL Database的时候,一切正常;但将本地代码部署到Azure上的WebSites的时候,发现SQL Database数据连接出错。 典型的错误提示信息如下...
on
9 Jul 2014
Blog Post:
Microsoft Azure SDK + Visual Studio 2013,让Azure开发和管理更容易
Nevin (Naiwen) Dong
最近重新装了电脑,将操作系统升到了Windows 8.1。 安装Visual Studio 2013 Ultimate版( http://www.visualstudio.com/en-us/downloads/download-visual-studio-vs.aspx ),然后安装Microsoft Azure SDK for Visual Studio 2013( http://azure.microsoft.com/en-us/downloads/?fb=zh-cn )。当然,也没忘安装PowerShell命令行工具。 用管理员身份权限运行Visual Studio,在Server Explorer工具面板上看到了Microsoft...
on
8 May 2014