複寫疑難排解 Replication Troubleshooting

複寫疑難排解 Replication Troubleshooting   從TLog讀取 sp_replcounters (Transact-SQL) Returns replication statistics about latency, throughput, and transaction count for each published database. This stored procedure is executed at the Publisher on any database. sp_replcounters sp_repltrans (Transact-SQL) Returns a result set of all the transactions in the publication database transaction log that are marked for replication but have…


複寫監控 Monitor Replication

複寫監控 Monitor Replication Measure Latency and Validate Connections for Transactional Replication 使用Tracer Token監控複寫延遲 保留延遲紀錄作法請參考我這篇   Programmatically Monitor Replication–Programmatically Monitor Replication USE [distribution] GO sp_replmonitorhelppublisher GO sp_replmonitorhelppublisher (Transact-SQL) USE [distribution] GO sp_replmonitorhelppublication @publisher = N’SQLDEV1′ GO sp_replmonitorhelppublication (Transact-SQL) USE [distribution] GO sp_replmonitorhelpsubscription @publisher = N’SQLDEV1′, @publication_type = 0 GO sp_replmonitorhelpsubscription (Transact-SQL) USE [distribution] GO sp_replmonitorsubscriptionpendingcmds @publisher…


Hey, world!

Hey, world!  My name is Rob Paveza, and I’m a Senior Software Engineer on the Microsoft Edge DevTools team – what we informally call ourselves the F12 team.  I’m a “boomerang” employee – I spent some time outside of Microsoft in 2016 and have returned, pretty much just down the hall from where I used…


Calling node.js sqlite callback function using promise and await

Callback pain I was experimenting with sqlite package with node.js the other day and the async programming style is rather painful, so I did some experiment to wrap it with promise + async/await to make it easier to use. This post shows you how to do that. For example, let’s say I’m working with a database with…


Experiencing Alerting failure for Availability Data Type – 01/12 – Resolved

Final Update: Saturday, 13 January 2018 02:23 UTCWe’ve confirmed that all systems are back to normal with no customer impact as of 13 January 2018 02:15 UTC. Our logs show the incident started on Friday, 12 January2018 20:20 UTC and that during the ~6 hours that it took to resolve the issue customers were not able to…


1/18 Webinar: Using PowerApps and Flow to create Line of Business “portals” by Vishwas Lele

This week rejoining us is one of the earliest adopter of PowerApps Vishwas Lele to walk through a common use case of PowerApps: a “portal” for line of Business Applications. Using PowerApps and Flow to create Line of Business Enterprise “portals” for by Vishwas Lele Vishwas will showcase a PowerApp application that is essentially a…


End of Support for Host Integration Server 2010

Microsoft Host Integration Server 2010 will reach end of extended support on January 12, 2021.  If you are using this version, please upgrade to Host Integration Server 2016 before January 12, 2021 to ensure supportability. The following resource is available to help with upgrade: https://www.microsoft.com/en-us/download/details.aspx?id=54950   Have questions about supported products? Visit Microsoft Support Lifecycle…


Quick Guide on Importing Data from SQL Server (or SQL Azure) to Cosmos DB

Sample code here: https://github.com/knethteo/SQLAzuretoCosmosDB This sample does the following: Create SQL DB Table.txt That will create the initial database in SQL Server or SQL Azure The main Program will read the database, parse the data and store them in Cosmos DB Before you start the program, you will have to do step 1, and edit…


Performance degradation in multiple regions – 01/16 – Mitigated

Final Update: Tuesday, January 16th 2018 23:56 UTC The issue has been mitigated.• Telemetry indicated that calls to SPS Extensions were failing due to client authentication errors.• We performed a certificate update earlier today which we suspected was related to the authentication error• While we were in the process of rolling back the certificate update,…