Reseller Storefront

Over the past several weeks I have received numerous questions from various partners regarding the reseller storefront. This project is a web application that acts as a storefront for Microsoft partners and enables them to sell Microsoft offers to their customers. It can be deployed directory from Partner Center or using the Azure Resource Manager…


Developers Choice: Query progress – anytime, anywhere

Edit (4/23/2018): due to a possible random AV running your favorite monitoring stored procedure, please make sure you install KB 4078596 in your SQL Server 2016 and SQL Server 2017. Edit (9/24/2018): this feature is now enabled by default in SQL Server 2019. Trace flag not needed anymore! Also, new query hint query_plan_profile to enable…


Developers choice: Columnstore index in Standard and Express Edition with SQL Server 2016 (SP1)

On 16th Nov 2016, Microsoft announced the support for ‘Consistent Programming Surface Area’ across all editions of SQL Server with few exceptions. Please refer to the SQL Server 2016 SP1 release blog post. The key value proposition is that it allows customers to use the same code base independent of the editions in SQL Server.  For example, An ISV…


OMS – Longer retention of up to 2years

As a team a lot of our days are now spent talking about OMS, one key OMS change recently was to enable the retention of data for more than the typical 7 , 30 or 365 days.  You can now go to 2 years if required.  See the blog from Richard Rundle that tells you…


SQL Server 2016 Service Pack 1 (SP1) released !!!

With cloud first strategy, the SQL Product Team has observed great success and adoption of SQL Server 2016 compared to any previous releases. Today, we are even more excited and pleased to announce the availability of SQL Server 2016 Service Pack 1 (SP1). With SQL Server 2016 SP1, we are making key improvements allowing a…


Data Migration Assistant: How to run from command line

With DMA v2.1 and above when you install DMA, it will also install dmacmd.exe in %ProgramFiles%Microsoft Data Migration Assistant. Use dmacmd.exe to assess your databases in an unattended mode. This is especially useful when assessing several databases or huge databases. Output the result to JSON or CSV file.  Note Dmacmd.exe supports running assessments only. Migrations are not…

8

Memory metrics for an Azure Web App and App Service Plan

Did you ever wonder why memory utilization for a Web App is different than the memory utilization of the App Service Plan, as shown in Figure 1? The App Service Plan in thei example is a SMALL BASIC mode machine. Average memory is 50.68MB which is about ~2.8% of the 1.75GB available for a SMALL…


Lesson Learned #7: Monitoring the transaction log space of my database

In many support cases, our customers want to monitor the available space for the transaction log space for their database or to know what caused an error when the transaction is full. Unfortunately, there is not supported to use DBCC SQLPERF(LOGSPACE) nowdays. For this reason, I would like to share with you another view where you could find out…


Log Shipping Monitoring and Troubleshooting

Log Shipping Monitoring and Troubleshooting 交易紀錄傳送監控與疑難排解 1.Log Shipping status View the Log Shipping Report (SQL Server Management Studio) https://msdn.microsoft.com/en-us/library/ms181149.aspx To display the Transaction Log Shipping Status report on a server instance Connect to a monitor server, primary server, or secondary server. Right-click the server instance in Object Explorer, point to Reports, and point to Standard…