(Dave Beulke) Well the votes are in, 22 billion rows is big enough data. It’s not the billions of web logs rows of a Google or Facebook but its big enough for everyone. One of the comments that struck me was that one in a million happens 22,000 times.
Other News
JAXB and Java IO (Files, Streams, Readers, and Writers)
(Blaise Doughan) JAXB supports many different XML sources and targets. In this post I’ll give an overview of how JAXB can be used with those found in the java.io package: File, InputStream, OutputStream, Reader, Writer and their subclasses.
Comparison of MyISAM and InnoDB MySQL Databases
(Alejandro Gervasio) In this MySQL database engine comparison article, we look at the features offered by MyISAM and InnoDB.
Performance Of LEFT OUTER JOIN Insert vs. INNER JOIN Delete Statement
(Ben Nadel) When it comes to database queries, the only kind of JOIN that I like to perform with SQL is an INNER JOIN. They are wicked fast and always satisfying.
Microdata and RDFa Living Together in Harmony
(Jeni Tennison) One of the options that the TAG put forward when it asked the W3C to put together task force on embedded data in HTML was the co-existence of RDFa and microdata. If that’s what we’re headed for, what might make things easier for consumers and publishers who have to live in that world
Workflow 4.0 coded implemented in VS 2010
(Kimi Kalon) As I already describe in my previous article (Start working with Workflow 4.0 in Visual Studio 2010), A workflow is a series of distinct programming steps or phases. Each step is modeled in WF as an Activity.
DataGridView Event Sequences
(Zasky) The DataGridView control generates many events as a user navigates the grid. There are cell entry/exit, row entry/exit, cell and row validation events etc. To make best use of these events you’ll need to know when they occur, and what happens when you respond to these events in different way
Concurrently Move DB2 for i Tables and Indexes to Solid State Disks
(Mark J. Anderson) Significant performance benefits can be achieved when DB2 for i indexes or tables reside on Solid State Disks (SSD). The Change Physical File Member (CHGPFM) and Change Logical File (CHGLFM) commands can now be used to concurrently move a member (or partition) of an index or table
SQL Server Denali T-SQL Debugging enhancements
(Arshad Ali) In one of my previous tips (SQL Server 2008 T-SQL Debugger is back in SSMS) I talked how you can debug your T-SQL routine/module. Although it was very handy for SQL Server Developers to debug code, the tools still lacked some of the basic features that are already available for .NET Dev
How to Unit Test
Introduction to SQL Server Reporting Services – Next Tuesday, August 25 Here’s your chance to sign up for the next virtual class, "Introduction to SQL Server Reporting Services". This "Made Simple" course, taught by Sherri McDonald, a Business intelligence expert from Pragmatic Works, is a great investment for your personal development. If you’re ready to up your game, come on […]