(Kenneth Fisher) I was reading through Stackoverflow today and saw an interesting question. SQL inner join vs subquery. The user was comparing 3 queries and wondered why the first took significantly longer than the other 2.
Author: SSWUG Research
OPTIMIZE/CHECK/REPAIR/ANALYZE TABLE InnoDB Edition
(morgan tocker) I find a good interview question for a MySQL DBA position is to ask what the following commands actually do in InnoDB, which has been the default storage engine since MySQL 5.5. From my perspective there is a lot of miss-understanding what still applies.
How to Parse Nested XML using Sencha Touch 2 – Part1
(Suresh Kumar) Sencha Touch 2 supports Parsing Nested XML using associations (hasMany, belongsTo). XML is used to exchange data between client Browser and Server. Today, we will take the below Nested XML as our reference as parse it using Sencha Touch 2.
Auditing with Microsoft Assessment and Planning (MAP) Toolkit 5.0 – Part 2
(Sadequl Hussain) When you start MAP, the application prompts you for a database name (see figure below). At the very beginning there will be no database to hold MAP inventory information, so you will need to specify a new database name. You can name it anything, but for our purpose, I have chosen t
http://www.absolutewebservices.com/technology-2/miami-web-3-0-design-and-the-semantic-web/
Business claiming to be Miami web 3.0 design firms reference the web, web 2.0, and web 3.0 consistently. Somewhat vague labels makes navigating the history of the web and these terms difficult.
Create an Association Between Related Entities with FAST for SharePoint 2010 or SharePoint 2013 Search
(Johnny Tordgeman) For the purpose of the tutorial I created a simple database with two tables: Products and Customers. The tables are connected by the ProductId foreign key. Each product has a one-to-many relation to customers.
Reading XML in Silverlight
(Neelesh Vishwakarma) In the last article we saw how to create XML. Now take my words, that was all you need. It takes a hell lot a deal to create XML, but when we talk about reading it, it all goes like rather easy and simple.
Accelerate the path to PCI DSS data compliance using InfoSphere Guardium
(Kathryn Zeidenstein and Shengyan Sun) This article gives you a step-by-step overview of using the Payment Card Industry (PCI) Data Security Standard (DSS) accelerator that is included with the standard InfoSphere Guardium data security and protection solution.
The DB2Night Show #109: ATTACK of the BLOB! with guest Michael Krafick
(Scott Hayes) 100% of our studio audience learned something! During this unique episode of The DB2Night Show, Michael Krafick, Sr. DB2 LUW DBA, DB2 comic, and database obedience trainer shared with us his “school of hard knocks” lessons learned about achieving maximum, remarkable, awesome performanc
Explaining the unexplainable – part 2
(depesz) Last time I wrote about what explain output shows. Now I’d like to talk more about various types of “nodes" / operations that you might see in explain plans.