(Jeff Smith) One of the improvements for version 18.3 was a much improved, performant query builder.
Author: SSWUG Research
(Grant Fritchey) Once upon a time, someone, somewhere, wrote a list of bad query performance tips and they’ve been copied all over the internet, over and over.
(Cay S. Horstmann) Guides you through compiling and running three typical Java programs—a console application, a graphical application, and an applet—using the plain JDK, a Java-enabled text editor, and a Java IDE.
(Debasis Saha) Entity Framework is an open-source framework which totally depends on ORM Framework (Object Relational Mapping). This framework gives an opportunity for the developer to work with data using different domain objects which specified in the model classes.
(Wagner Franchin) MySQL Group Replication (GR) is a MySQL Server plugin that enables you to create elastic, highly-available, fault-tolerant replication topologies. Groups can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a time.
(Anthony Giretti) The creation of unit tests is an important step in ensuring the quality of a project. In general, most public methods are tested, but what if you want to test a non-public part of the project?
(Pinal Dave) Just another day, I received an email from a user who has over 350 thousand tables in a single database. He was my earlier customer of Comprehensive Database Performance Health Check. He was facing indeed a very strange issue where his metadata table was locking up and we fixed that by
(Mayank Prasad) From MySQL 5.7.11, encryption is supported for InnoDB (file-per-table) tablespaces. This is called Transparent Tablespace Encryption or sometimes referred as Encryption at Rest.
(CliveW) This week there was a good discussion on how to show an SLA view in Log Analytics, which was similar to a feature in System Center Operations Manager, the output and query I’m sure will be useful for others.
(Peter Vogel) When I’m doing batch processing against a database, I use ADO.NET and SQL. But, when I’m creating an online, transactional application, I use Entity Framework (which you can think of as a wrapper around ADO.NET) and LINQ.