(Pinal Dave) During my recent Comprehensive Database Performance Health Check Developer showed me a slow query which used ROWLOCK hint. The common understanding is that with the help of ROWLOCK hint SQL Server only locks a single row which eventually leads to performance but in their case, it was ac
Community
Bing.com runs on .NET Core 2.1!
(Mukul Sabharwal) Bing.com is a cloud service that runs on thousands of servers spanning many datacenters across the globe. Bing servers handle thousands of users’ queries every second from consumers around the world doing searches through their browsers, from our partners using the Microsoft Cognit
Analyze MySQL & MariaDB Error Log Messages using Monyog
(Shree Nair) The MySQL error log is an essential part of database server performance monitoring. Whenever something goes wrong or performance degrades, the Error Logs are usually the first place we look to start troubleshooting.
18c Database installation on Windows
(Connor McDonald) If you’re a Windows enterprise, or you want to run your 18c database on your Windows laptop/desktop for research and education, then there has been some good news this week.
ADF Performance Monitor: Monitoring with Percentiles
(Frank Houweling) What is best metric in performance monitoring – averages or percentiles? Statistically speaking there are many methods to determine just how good of an overall experience your application is providing. Averages are used widely. They are easy to understand and calculate – however th
Contextual Chatbot with TensorFlow, Node.js and Oracle JET – Steps How to Install and Get It Working
(Andrejus Baranovskis) Blog reader was asking to provide a list of steps, to guide through install and run process for chatbot solution with TensorFlow, Node.JS and Oracle JET.
Perform SOAP request with advanced headers in Informatica Powercenter Designer
(harleydk) My colleague had a problem in trying to access a SOAP web service. Specifically, he needed to provide extended SOAP headers in regards to the security requirements, a SAML assertion in this case, and the standard Informatica Web Transformation wasn’t doing much for him.
Quick start tips for using the new MSSQL-CLI SQL query tool
(Michael Otey) The new MSSQL-CLI command-line tool provides many enhancements over SQLCMD CLI that enable you to quickly write and run T-SQL queries across Linux, macOS and Windows.
Analyze Actual Execution Plan
(Grant Fritchey) One of the many new sets of functionality introduced in SQL Server Management Studio 17 is the new option “Analyze Actual Execution Plan.” If Microsoft continues down this path, there will be a lot of useful functionality at some point.
Introduction to GraphQL and Designing Simple Query API with ASP.NET Core 2.0
(Gökhan Gökalp) I couldn’t find enough time to write a new article for a few months. In fact, I wrote some part of this article in August, but I could not complete it. 🙂 Finally, I did!