(Morgan Tocker) As the result of a number of improvements to default values, MySQL 5.6 requires far less configuration than previous versions of MySQL. Having said that, I wanted to write about the settings that you may need to change.
Author: SSWUG Research
Complete tracing of JDBC calls for WebSphere Adapter when interacting with a DB2 database
(Vinod A. Valecha) Learn to configure WebSphere Adapter for JDBC to get complete tracing information for each JDBC call while interacting with a DB2 database, which results in faster problem analysis and resolution.
Information from XML without Parsing in Java
(Debadatta Mishra) In this small post I will provide a very small trick about how to gather information from an XML file without using any conventional parsing techniques in a particular scenario.
Partner TechTip: Master Your Big Data with SEQUEL
(Heath Kath) Big data: This term covers a lot of ground. With no definitive dividing line based on file size, data type, number of records, or job requirements, how do you know if you’re doing big data? Ask yourself, has the size or speed requirements of new analytic initiatives put serious strain o
JSON in DB2
(Curt Monash) There’s a growing trend for DBMS to beef up their support for multiple data manipulation languages (DMLs) or APIs — and there’s a special boom in JSON support, MongoDB-compatible or otherwise. So I talked earlier tonight with IBM’s Bobbie Cochrane about how JSON is managed in DB2.
SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 4
(Pinal Dave) This is the fourth post in the series of finding previous row and next row value in SELECT Statement. Read all the blog post before continuing reading this blog post for complete idea.
Improved Transactions in Entity Framework 6
(Pravinkumar Dabade) Entity Framework 6.0 has improved Transactions. We will explore the UseTransaction() method which allows the context to participate into an already running transaction. We will also explore BeginTransaction() to start a new transaction.
XPath Expressions for Data Reporting
(DAVEMCG) In our earlier post titled Use XPath Expressions to Refine Data Selection, we described how to use XMLSpy to develop an XPath expression to select one table of data contained in a much larger data set provided by the US Department of Education.
SQL Server Composite Primary Key Trivia
(Steve Endow) Coincidentally, after working on a really interesting Dynamics GP SQL Server performance issue earlier this week, I will be having a call tomorrow with another GP partner and GP customer to discuss a different Dynamics GP SQL performance issue.
NHibernate and Stored Procedures in C#
(Jess Nickson) I was recently trying and failing to set up NHibernate (v1.2) in an ASP.NET project. The aim was to execute a stored procedure and return the results, but it took several iterations for me to end up with a working solution. In this post I am simply trying to put the required code in o