(Pinal Dave) While working on SQL Server Comprehensive Database Performance Health Check, with a client who uses many different SQL and NoSQL databases. During the consultation engagement, we ended up a very interesting query which actually runs faster on MongoDB and slows on SQL Server.
Other News
18 Things You Can Do to Remove MySQL Bottlenecks Caused by High Traffic (Part Three)
(Peter Zaitsev) A poorly configured MySQL Server can cause severe issues, especially under high load during a traffic spike, yet getting the basics right is not that hard.
Looking At How Browser Zoom Affects CSS Media Queries And Pixel-Density
(Ben Nadel) The older I get, the more zoomed-in my browser tends to become. I just don’t have the patience for small-text – I want my font-sizes to feel luxurious and decadent.
Tech Job Report Gauges COVID-19 Impact: Desire for .NET, C# Skills Decreases
(David Ramel) Tech careers firm Dice’s latest job report attempts to gauge the early impact of the COVID-19 pandemic on hiring. One finding of special interest to Visual Studio Magazine readers is less desire for .NET and C# skills.
Pretty Method Display in xUnit.net
(Jason Roberts) One little-known feature of the xUnit.net testing framework is the ability to write test method names in a specific way and then have them converted to a ‘pretty’ version for example in Visual Studio Test Explorer.
Will a BLOB eat all my memory?
(Connor McDonald) Probably the most common usage for large objects (CLOBs and BLOBs) is to store them in a database table.
sqlplus: error while loading shared libraries: libsqlplus.so: wrong ELF class: ELFCLASS64
(Laurent Schneider) This error usually while you do something wrong. Wait, what’s an error when you do everything right?
Oracle WebLogic Server 14.1.1.0.0 and Oracle WebLogic Monitoring Exporter
(Dirk Nachbar) As the latest release of Oracle WebLogic Server 14.1.1.0.0 is available (see my blogposts https://dirknachbar.blogspot.com/2020/03/oracle-weblogic-141100-available.html and https://dirknachbar.blogspot.com/2020/03/oracle-weblogic-141100-first-look.html), it’s time to test Oracle WebLo
Key Protect as vault for multi-cloud setup
(Henrik Loeser) In my previous blog post, I showed how you can easily encode and upload credentials to IBM Cloud Key Protect. Today, I am going to share sample code with you for retrieving the credentials and turning them back into a JSON object.
Build Advanced XML Reports with New XPath Debugger
(Erin Cavanaugh) Altova StyleVision is a unique, easy-to-use tool for creating business reports using a drag-and-drop visual design interface. StyleVision lets you build reports for XML as well as database and XBRL sources.