(Jesper Krogh) The slow query log is the trusted old method of recording slow query, so the database administrator can determine which queries are in the most need for optimization.
Community
Huge Pages Speeds Startup of Web Servers
(Bobby Durrett) We had issues deploying changes to a large web farm a few weeks back. We had automated the startup of the 25 web servers using a DevOps tool but when it tried to bring them all up at once it took forever and the web servers got timeout errors.
Learned Something New code Formatting
(mdinh) Which is better? Using code in [ ] or Using code in < >
Changing Hostname In OEL7….
(Arista) I am working on refreshing my set up with the latest version of database – Oracle 19c. In order to do so, I have made a new VBox vm with OEL 7.6 as the base operating system.
Writing and Testing Azure Functions with Function Monkey – Part 2
(James) Part 2 in my series of writing and testing Azure Functions with Function Monkey looks at adding validation and returning appropriate status codes from HTTP requests. Part 3 will look at acceptance testing this.
SQL Server FILETABLE – the next generation of SQL FILESTREAM
(Rajendra Gupta) This SQL Server FILETABLE article is the continuation of the SQL Server FILESTREAM series. The SQL Server FILESTREAM feature is available from SQL Server 2008 on. We can store unstructured objects into FILESTREAM container using this feature.
SQL Differences Between Db2 and Informix
(Ember Crooks) I have been working with Informix from a user perspective recently. I learned about some of the SQL differences and developed a greater empathy for developers in the process.
Using Azure DevOps for Build and Deployment of NodeJS application
(Subodh Sohoni) In this walkthrough of using Azure DevOps for the build and deployment of NodeJS application, you will learn how to create NodeJS app, add it to a git repository under the team project of Azure DevOps and use pipelines service of Azure DevOps to do the build, deployment and testing o
Creating Custom Constraints For Razor Pages Routes
(Mike Brind) Razor Page already includes a wide range of constraints that can be used to help disambiguate routes. It is also possible for you to create your own custom constraint and then register that with the routing system.
Making It Up as You Go Along with ExpandoObjects
(Peter Vogel) You can give your users the ability to store any data they want, including stuff they make up at run time, by using an ExpandoObject. In fact, when you don’t know what your data is until run time (and you can live without IntelliSense), an ExpandoObject is your best solution.