Best Practices for WordPress Security on Azure

This article was put together by Mangesh Sangapu and Yi Wang. Shout-out to Cory Fowler and Sunitha Muthukrishna for additional tips. WordPress Security is often an overlooked feature. Customers are quick to configure their site, but often forget to fine tune the security aspect. Here we have compiled steps that will help make your WordPress site…


MySQL In-App Configuration for PHP Content Management Systems

Read more about MySQL In-App here. Content Management Systems such as WordPress, Drupal, Joomla contain the database credentials within a configuration file. If you decide to use MySQL In-App for development purposes, you will quickly realize that you need to modify these credentials to work with MySQL In-App. Below is a table containing the default…


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…


Using the handheld device for reporting serial numbers as finished in production 

Introduction A new flow for the handheld device has been released with KB article: 3148600. This flow enables the user to register the finished good serial number when reporting as finished in production. This flow is targeting a process where the finished good serial number is generated under the following conditions: It is assigned by…


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…


Do not change Linux files using Windows apps and tools

I have to provide this guidance at least 2-3 times a day so instead I am publishing it here so everyone can find / link-to this guidance. There is one hard-and-fast rule when it comes to WSL on Windows: DO NOT, under ANY circumstances, access, create, and/or modify files in your distro’s filesystem using Windows…


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…


Dear Meetup Organisers

This article is now hosted at http://martink.me/articles/dear-meetup-organisers All blog articles will be hosted on http://martink.me going forward