(Dominic Brooks) Every now and then you come across a feature or a combination of features which has turned into such a dog’s dinner that you wonder how many people can possibly be using it.
Other News
Log rotate and the (deleted) MySQL log file mystery
(Daniel Guzmán Burgos) When running logrotate for MySQL (after proper setting the /etc/logrotate.d/mysql conf file) from anacron, there’s a situation that you might potentially face if the user and password used to execute the “flush logs” command is stored in, for example, /root/.my.cnf file.
SQL SERVER – SSMS Trick – Generating CSV file using Management Studio
(Pinal Dave) In my previous blog I talked about using SQLCMD to generate a comma separate files for the table data.
Nested XML from SQL to JSON
(Jose Segarra) This article describes how to output data from SQL Server as a JSON string.
Microsoft takes .NET open source and cross-platform
(Doris Chen) Today, Microsoft is taking the next big step for the Microsoft developer platform, opening up access to .NET and Visual Studio to an even broader set of developers by beginning the process of open-sourcing the full .NET server core stack and introducing a new free and fully-featured edi
A Guide to Diagram – Part 10 – Inter-Group Links
(Duncan Mills) If you create a diagram that contains groups (containers) there are some special considerations to take into account when writing your layouts.
Disabling InnoDB in MySQL 5.6 and MariaDB 10.0
(Chris Calender) There are a few circumstances where one will not want to run with only MyISAM tables. In this case, it can be beneficial to completely disable InnoDB.
Rising Heroically to the Scalability Challenge
(David Birmingham) At a recent proof-of-concept exercise, a vendor took its offering through the necessary paces to demonstrate its wares in meeting its client’s steep data processing needs. Hopes were quite high.
Specifying Allowed Values, Sample Values and Descriptions For Function Parameters In Power Query–Part 1
(Chris Webb) The other day when I was thinking about Power Query functions (as you do) it occurred to me that they would be a lot more usable if, when you invoked them, you could show your users a dropdown box for each parameter where they could choose all of the allowed parameter values rather than
Coding Fast or Slow
Are you coding? You can ask me this just about any time and my answer will be, “Yes”. Even though I enjoy employing agile techniques for software development, it doesn’t mean that I don’t have a strategy to solve a problem. It doesn’t me there isn’t an architectural process, or no cogitation, about how to solve different issues. It just […]