(Pinal Dave) SQL Server Performance Tuning is what I do for leaving and every single day, I get different problems to solve. Just another day I was hired for just 1 hour to solve one specific problem of my client with whom I had worked on Comprehensive Database Performance Health Check.
Community
Retrofit – A REST Client for Android (Retrofit 2.X)
(Nipunu W) In this tutorial, we’re going through the basics of Retrofit and creating an Android client for HTTP requests against the GitHub API.
Excel Dynamic Arrays And FilterXML
(Chris Webb) I’ll admit that I’m a bit less excited about Excel dynamic arrays than I was when I last blogged about them.
Optional vs Required parameters in Stored Procedures
(Kenneth Fisher) If you are executing a stored procedure with a bunch of parameters it can be a bit of a pain if you have to pass a value in for each of them.
Advanced JSON Understanding how to Exploit Db2 Capabilities in the NoSQL World by George Baklarz
This week we have a video presentation from George Baklarz.
Promises and Static Values
(David Walsh) Async can throw a real wrench into the cogs of our programming workflows, all despite the fact that async is the modern JavaScript pattern.
Preview Features in Visual Studio
(Stephanie) The Preview Features page under Tools > Options > Environment has a new look! We introduced the Preview Features page so that you can easily find these capabilities and be able to control their enablement.
Performance Case Study: Parallel Data Access Using Parallel Struct Iteration In Lucee 5.2.9.40
(Ben Nadel) A couple of weeks ago, I was very excited to discover that Lucee 5 supports parallel iteration of data structures. And, given this parallel iteration, I started exploring the developer ergonomics of asynchronous data accesses using parallel iteration.
Q&A with AI Developer Henk Boelman: Hands-On with Microsoft’s New AI and IoT Technologies
(Becky Nagel) We caught up with Henk Boelman, Microsoft AI MVP and Cloud AI Architect, to learn more about what’s exciting in AI, his favorite features in Microsoft Cognitive Services and Windows IoT and the latest updates on his upcoming day-long hands-on lab for Live! 360, “Build Your Own A.I. Pow
About MySQL and Indexes
(Frederic Descamps) MySQL supports different types of Indexes. They depend on the storage engine and on the type of data. This is the list of supported indexes: