(Marco) With the introduction of Galera replication for MySQL, Codership has, in my opinion, provide the most significant support to MySQL that the community had seen in the last tree years.
Other News
TechTip: Combining Multiple Row Values into a Single Row with SQL in DB2 for i
(Kent Milligan) Often, when looking at a report, a user prefers to see similar values grouped together on a single line of output instead of having those values spread across multiple lines of report.
Intercepting Entity Framework Database Calls
Today I have been looking at the extension in Entity Framework (EF) 6 allowing the auditing of the generated SQL and it’s execution. http://msdn.microsoft.com/en-us/data/dn469464.aspx This is built into the EF library allowing the developer to intercept, log, modify or even cancel the generated SQL code. This can be used to solve any number of problems. If you need to trace […]
Showing Google Chart (Pie) in ASP.Net With Database Using jQuery
(Rahul Saxena) This article shows how to show a jQuery Google chart in ASP.NET with a database SQL Server.
Rapid Deployment of Integrated WebSphere Solutions in Your Cloud
(Barkana Emrah, Antonella Bertoletti, Stefano Bussaglia, Ernest Calalang, Sebastian Kapciak, Leonardo Olivera, Sergio Polastri and Fabio Silva) This IBM Redbooks publication uses the same practical solution and is an extension to Creating Integrated WebSphere Solutions using Application Lifecycle Ma
ReSharper Tips for Quicker Code Delivery
(Eric Vogel) JetBrains’s .NET plug-in will make quick work of code inspections and refactoring. Here are a few tips to work with it that will have you wondering what to do with all your newfound free time.
Sys Schema for MySQL 5.6 and MySQL 5.7
(Miguel Angel Nieto) Performance Schema (P_S) has been available since MySQL 5.5, more than 4 years ago. It is still difficult to see production servers with P_S enabled, even with MySQL 5.6 where the feature is enabled by default.
Create Histograms On Columns That Already Have One
(Anju Garg) The default value of METHOD_OPT from 10g onwards is ‘FOR ALL COLUMNS SIZE AUTO’.
SharePoint 2013 ‘Bring Your Own Device’ (BYOD) Best Practices
(Errin O’Connor) Remote workers and internal or onsite workers empowered with “bring your own device” (BYOD) policies can push the boundaries of IT and the typical IT-driven culture.
Azure SQL Database Auditing
(Marcin Policht) Contemplating migration of on-premises systems to Microsoft Azure commonly raises security and confidentiality concerns since it is associated, at least to a certain degree, with relinquishing some of the oversight inherent to fully managed environments.