SQL Server 2014的认证(MPR测试)中常见技术问题及指导(Guidance)

  ??ISV????SQL Server 2014???,????????,???????,?????,?????? ??,??????????????,???????blog,???????: ??????(Microsoft Platform Ready Test Tool for SQL Server 2014),??SQL Server 2014 ?? ?????????????????????????,????????????SQL Server 2014 Enterprise????,???2012(???????)????????,??????????? ???(Gold)??????SQL Server 2014 AlwaysOn Failover Cluster,??????????? ????:High Availability Solutions (SQL Server) ???,?????Azure????????????,???????????????Domain?????????,???????????????,????? ??SQL Server AlwaysOn?????,???????????blog,????,???????: ????,??????SQL Server Azure VM?AlwaysOn???(HA)???????(Status diagnostics) ????(Gold)??,???(Silver)??,???????????????????: 1??????compatibility level of ALL databases to 120,???????2014?,??????,?????:               ALTER DATABASE database_name SET COMPATIBILITY_LEVEL…

0

一步两步,一步两步,快速构建SQL Server VM AlwaysOn in Azure

  ??????????(Microsoft Virtual Academy,MVA)??????ITPro?DBA???????Azure???????(Data Service)???,?«?Windows Azure VM???SQL Server?????????»,???????????Azure ???/?????(VM/VN)?????,??SQL Server AlwaysOn?????????(Failover Cluster)? ??Azure????????,???????????,??????????” ????,????,???????,??????…“ ??????Azure?????,?”???Virtual Machine“??”SQL Server“,???????”SQL Server 2014 AlwaysOn“,????????????????????,??: ?????????,?????????(Domain Controller, DC);???????,?????????DC???,???MVA???Demo?????,?????????(Production),??????????,????DC,??SQL Server ???Instance???????IP(Internal IP)??????,????????????? ??????”Create“,???????,???: ???,????????????,?????(Availability Group)???????(Listener)?????????????? ???????(Virtual Network)?????????,???,????????????VN???? ??,??VN???????????????,????????????,???,????Site-to-Site??Point-to-Site???,?????: ????????????????,????????,???????SQL Server VM AlwaysOn Failover Cluster??????? ??????????,?????????????,???PowerShell?????,???????????????,?????????????: · AlwaysOn Availability Groups in Azure (GUI) · AlwaysOn Availability Groups in Azure (PowerShell) · Listener…

0

SQL Database性能(Performance)的可规划性(Predictability)及度量(Measurement)

  ??????????????,????????/????????????????????????(PC)????(Server)????(Virtualization)????(Private Cloud)????(Public Cloud),???????/IT?????????? ??,??????????????????,?????(Measurement)???(Monitoring)?????(Benchmarking)???(Tuning)/??(Optimization)?,???????????,???????????? ??????SQL Server???????,???SQL Database,?PaaS??????????,??????????,?????????????? ???SQL Server?SQL Database???,???:?SQL Server?Microsoft Azure SQL Database???????? ???SQL Database,??????:Web?Business????????????,??????? ????????:??(Basic)???(Standard)???(Premium),?????Standard???Premium??,?????????(S0/S1/S2?P1/P2/P3),??????????????????????,“??”?????????????????????;“??”????????????;“??”??????????????,?????????????? ??SQL Database????????,????:http://www.windowsazure.cn/pricing/details/sql-database/ ??????Web?Business??????,???????????????,????????,???,??????”??”??,???????????????,??????/??? ??,???????????,??,?PowerShell?,??Set-AzureSqlDatabase?????;?REST API?,????Update Database / ServiceLevelObjectiveId???;??,??DBA,????ALTER DATABASE … MODIFY (EDITION = …)?T-SQL?????? ?????????????,???????????????????,?SQL Database????/???(Predictable Performance)? ?SQL Database?????????DTU,??????,?Database Throughput Unit,??DTU?????(CPU)???(Memory)??(Read)??(Write)????????????? ??,???????????/??,??????????,??????????????????????: ??:??(Basic)???(Standard)???(Premium) ????(????????)????DTU??,?S0/S1/S2?P1/P2/P3? ?????(???????????),??????(??500G) ????,????/???? ???SQL Database?????(Monitoring)???(Measurement),??????????????????? ?????????????Azure????(Management Portal),?????????????,???: ?????????(DBA)??????IT?????,??????master.sys.resource_stats?userdb.sys.dm_db_resource_stats,??????????? ??????,???:http://msdn.microsoft.com/en-us/library/dn269979.aspx ??,????Visual Studio???,???Azure SDK?,???Visual Studio?IDE????SQL Database?????,???:

0

从SQL Server到Microsoft Azure SQL Database的技术迁移及利器

  ???????????????,????????????;???????,????????????????,????????????????????????????? ??????????,?????IT??/??????Azure????/?????,???????????:IaaS?PaaS???,IaaS??????Azure??????SQL Server(??????????MySQL)???????,?????????,?SQL Server VM in Azure;?PaaS??????,????????????????,??????(OS)???????,???????????????????,?Azure???SQL Database? ??SQL Server VM in Azure???,????????????????,?????SQL Server VM???Failover Cluster?AlwaysOn???,?????????????: SQL Server AlwaysOn Availability Groups in Azure ??????(MVA)?? – ?Windows Azure VM???SQL Server????????? ????,??????SQL Server Azure VM?AlwaysOn???(HA)???????(Status diagnostics) ??????,??????SQL Server??????????????????,???????SQL Server VM in Azure???? ??,??????????????IT???DBA??????????,?????????,??????????PaaS??? ???SQL Database????,?????????????????????????/????????????????????? ????????????????Azure SQL Database??SQL Server???????????MSDN???????,?: Azure Subscription and Service Limits, Quotas, and…

2

两把利器,帮你深刻洞察SQL Server Azure VM上AlwaysOn高可用(HA)方案的运行状态(Status diagnostics)

  ??Microsoft Azure????????(Business Critical),???????????????;???Azure IaaS(???????),?Azure VM???SQL Server???,????????,??AlwaysOn?????????(Failover Cluster)???????????? ??,????????????????(Microsoft Virtual Academy,MVA)?????,???:«?Windows Azure VM???SQL Server?????????»,????????Azure VM???SQL Server AlwaysOn????????????,?????: http://www.microsoftvirtualacademy.com/training-courses/835 ?????Azure???,??????????AlwaysOn Failover??,?????SQL Server 2012?SQL Server 2014???,???????????(Virtual Network)?????????(Domain Controller),???: ??Microsoft Azure????(Management Portal)?,???????????????????: ??????,????AlwaysOn???????,????????????(diagnostics)?????,??????????????? ??????????SQL Server Management Studio??“View AlwaysOn Health Events”,?????????????(Dashboard)???,???: ?????????????????????,???: ?????,AlwaysOn???????,?????????????????????????,????????????????? ???????????????????????????????? ?????:?SQL Server?ErrLog???????????????: SQL Server 2014: <Data Drive>:\Program Files\Microsoft SQL Server\MSSQL12.<instance name>\MSSQL\Log SQL Server 2012: <Data…

2

搭建跨订阅的虚拟网络到虚拟网络(VNET-to-VNET)连接,实现更灵活、更复杂的云服务部署

  ??,Microsoft Azure??????(Virtual Network),???????????(Point to Site)????????(Site to Site)??,?IT????????,????????(Hybrid Cloud)????????? ???????,??Azure?????????????1?1??,???????????????????,????????????,????????? ????Azure??,?????Azure(??Mooncake,MC),??????????????????(Multiple Site to Site)??????????(VNET-to-VNET)?????????(Dynamic Routing Gateway)?,????????????????,???????????,????????? ?????,????,???????! ????????Azure MC???,??????????SQL Server,??AlwaysOn????????(High Availability,HA)??,???????????;???????,????????Linux?Web???????????????????????????,?????????(?????)? ???????????????,????????,?????????????,??????????????????;???????,???????????,??????????,????????(??)???(??)? ??????????????,??????;?????????????,??????????????????????????,???????????????? ???: ??,????????????????,???: ??,???“???????VPN”,???: ??????,??????????????:????????????(VNET-to-VNET)?????,???????????????????,?????????????????: ???????????,?????????,??????????(Dynamic Gateway)????????????,?????????????,????????,???????????,???????IP? ??,?????,????????????????????IP??,?????PowerShell???????????????: Get-AzureVNetGateway -VNetName $vnetname ???????VIPAddress?????(Management Portal)???????????????VIP???vNet??? ????????????(??vNet1?vNet2)?,????????????,?vNet1???????,?vNet2????VPN??IP??(??????VIP??)?????,???: ??????,????vNet2??????????????????: ??????,????,?????????????????????,??????????????,????PowerShell????????????: ??????????????,??“??”,??????????????,??????,???????“????”???,???????????,???????????? ????????????????????: <LocalNetworkSites>     <LocalNetworkSite name="vNet2">         <AddressSpace>             <AddressPrefix>10.0.0.0/8</AddressPrefix>         </AddressSpace>     <VPNGatewayAddress>xx.xx.xx.xx</VPNGatewayAddress>   </LocalNetworkSite>  …

1

SQL Server 2014正式上市(General Availability),在Windows Azure虚拟机(VM)可以同步使用

4?1?,SQL Server 2014????(General Availability)? SQL Server 2014?????????,???????????????????????,??????????????????????????,???????????????????????????????????????,????????????????????? ?????SQL Server 2014??????: ??????,????,Windows Azure??????SQL Server???(VM)??(Image)?????,???????????RTM??????: Windows Azure????????????????: · ???(Entperprise) · ?????(DataWarehousing) · ???(Standard) · Web? ?SQL Server 2014?Windows Azure???,?????????,???: ????: · ?????? · ?????SQL Server???????????Windows Azure Blob????,??: CREATE CREDENTIAL mystoragecred WITH IDENTITY = ‘mystorage', SECRET = ‘<your storage access key> BACKUP DATABASE mydb TO URL ='https://mystorage.blob.core.windows.net/backup-container/mydb-20130411.bak' WITH…

0

Windows Azure中国区开始支持实现自动伸缩(AutoScale),目前处在预览阶段(Preview)

??,Windows Azure?????????????(AutoScale),?????????(Preview)? ???,??????“???”?,?????????“??????”??????????????,?????????????? ???????,??????????????,??????“??”??,??: ????????:??????????(Availability Set)??????????,??????????? ????????????,??????????:Windows Azure????????(AutoScale) http://blogs.technet.com/b/nevin_dongs_blog/archive/2013/08/28/windows-azure-autoscale.aspx ??????????????,??????50%???,???????????

0

通过软件保障(Software Assurance)实现SQL Server在Windows Azure虚拟机(VM)的许可移动性(License Mobility)

??,????????(Microsoft Virtual Academy)??????:? Windows Azure VM ??? SQL Server ?????????? http://staging.microsoftvirtualacademy.com/training-courses/835#?fbid=YLWfBUsNgJ8 ???????????Windows Azure ?????SQL Server??????,???????????????????????????,???Windows Azure?????SQL Server?????????? SQL Server??????????????Windows Azure ??????,???????????? Windows Azure ?????SQL Server???,??????????????????????,????????? ??SQL Server 2012?2014?AlwaysOn??,??Windows Server?????Failover Cluster??(WSFC),??1??????(Primary Server),???????????,???????(Secondary Server)?????????????????????????????????????????? ???????????????????,?????????????????????/???,????????????,??????????,????????(BI)??????????????,???????????????(workload)? ???????: ??????SQL Server 2012???????1?????+4?????????,?SQL Server 2014???1?????+8?????????,?????????? ???????,????????????Windows Azure???(VM)???SQL Server????????,??SQL Server?????????,????????(License Mobility)??? ??SQL Server???,????:http://www.microsoft.com/licensing/about-licensing/sql2012.aspx ???????(License Mobility),????:http://www.microsoft.com/licensing/software-assurance/faq.aspx#expand-content-4 ????,?????????????????????(Windows Azure?)???????????,??????,????????,??????SQL Server???????,???????????(Windows Azure)???????,???????????(Hybrid Cloud)????? ??,???????????,??????????(License Mobility)??????…

0

Windows Azure设计模式(Design Patterns)及使用

  2??,??patterns & practices(P&P)??????Windows Azure?????(Design Patterns),?????????????????????? ????:http://msdn.microsoft.com/en-us/library/dn568099.aspx   ??,??????24?????,?: Cache-Aside Pattern Circuit Breaker Pattern Compensating Transaction Pattern Competing Consumers Pattern Compute Resource Consolidation Pattern Command and Query Responsibility Segregation (CQRS) Pattern Event Sourcing Pattern External Configuration Store Pattern Federated Identity Pattern Gatekeeper Pattern Health Endpoint Monitoring Pattern Index Table Pattern Leader Election Pattern Materialized View…

0