Register Here
  Call For Papers
  Power Panels
Untitled Document
2018 Platinum Sponsor

2018 Gold Sponsor

2018 Tech Sponsor

2018 Partners

2018 Exhibitors

Untitled Document
2018 Media Sponsors

Untitled Document
2017 West
Premium Sponsors



Untitled Document
2017 West
Keynote Sponsor

Untitled Document
2017 West Exhibitors


Untitled Document
2017 West JETRO ×
Six Prefectures
of Japan
Pavilion Exhibitors

Untitled Document
2017 West Media Sponsors

Untitled Document
2017 East
Premium Sponsors





Untitled Document
2017 East Exhibitors

Untitled Document
2017 East Media Sponsors

Untitled Document
  Think Big – Now Think Even Bigger
  Join Us at Internet of Things at Cloud Expo, November 11-13,
at the Javits Center!

The Internet of Things (IoT) is the most profound change in personal and enterprise IT since the creation of the Worldwide Web more than 20 years ago.

All major researchers estimate there will be tens of billions devices - computers, smartphones, tablets, and sensors - connected to the Internet by 2020. This number will continue to grow at a rapid pace for the next several decades.

With major technology companies and startups seriously embracing IoT strategies, now is the perfect time to attend Internet of Things at Cloud Expo in New York City. Learn what is going on, contribute to the discussions, and ensure that your enterprise is as "IoT-Ready" as it can be!

Delegates to Internet of Things at Cloud Expo will be able to attend eight separate, information-packed tracks:

  • Enterprise Cloud
  • Digital Transformation
  • The API Enterprise | Mobility & Security
  • DevOps | Containers & Microservices
  • Cognitive Computing | AI, ML, DL
  • Big Data | Analytics
  • IoT | IIoT | Smart Cities
  • Hot Topics | FinTech | WebRTC

There are 120 breakout sessions in all, with Keynotes, General Sessions, and Power Panels adding to three days of incredibly rich presentations and content.

We'll see you in New York!

Day 3 Keynote at @ThingsExpo | Chris Matthieu, CTO of Octoblu
In his keynote at @ThingsExpo, Chris Matthieu, Director of IoT Engineering at Citrix and co-founder and CTO of Octoblu, focused on building an IoT platform and company. He provided a behind-the-scenes look at Octoblu's platform, business, and pivots along the way (including the Citrix acquisition of Octoblu).
  Themes & Topics to Be Discussed

Consumer IoT
• Wearables
• Smart Appliances
• Smart Cars
• Smartphones 2.0
• Automation
• Smart Travel
• Personal Fitness
• Health Care
• Personalized Marketing
• Customized Shopping
• Personal Finance
• The Digital Divide
• Mobile Cash & Markets
• Games & The IoT
• The Future of Education
• Virtual Reality

Enterprise IoT
• The Business Case for
x IoT
• Smart Grids
• Smart Cities
• Smart Transportation
• The Smart Home
• M2M
• Authentication/Security
• Wiring the IoT
• The Internet of
x Everything
• Digital Transformation
x of Enterprise IT
• Agriculture
• Transportation
• Manufacturing
• Local & State
x Government
• Federal Government

IoT Developers | WebRTC Summit
• Eclipse Foundation
• Cloud Foundry
• Linux Containers
• Node-Red
• Open Source Hardware
• Ajax and the IoT
• Leveraging SOA
• Multi-Cloud IoT
• Evolving Standards
• WebSockets
• Security & Privacy
x Protocols
• GPS & Proximity
x Services
• Bluetooth/RFID/etc
• Nest Labs

The Top Keynotes, the Best Sessions, a Rock Star Faculty and the Most Qualified Delegates of ANY Internet of Things Event!

The future of computing lies in these things. As computing takes a much more active role in our lives it will at the same time become much more invisible. Internet of Things Expo will address the challenges in getting from where we are today to this future.
The high-energy event is a must-attend for senior technologists from CEOs on down – including CIOs, CTOs, directors of infrastructure, VPs of technology, IT directors and managers, network and storage managers, network engineers, enterprise architects, and communications and networking specialists.

@ThingsExpo Power Panel | The World's Many IoTs: Which Are the Most Important?
The Internet of Things is clearly many things: data collection and analytics, wearables, Smart Grids and Smart Cities, the Industrial Internet, and more. Cool platforms like Arduino, Raspberry Pi, Intel's Galileo and Edison, and a diverse world of sensors are making the IoT a great toy box for developers in all these areas. In this Power Panel at @ThingsExpo, panelists discussed what things are the most important, which will have the most profound effect on the world, and what should we expect to see over the next couple of years.
Benefits of Attending the Three-Day Technical Program
  LEARNexactly why Internet of Things is relevant today from an economic, business and technology standpoint.
  HEAR first-hand from industry experts the common issues and requirements for creating a platform for the Internet of Things.
  SEE what new tools and approaches the Internet of Things requires.
  DISCOVER how to drive a distributed approach to the Internet of Things, where applications move to the data.
  FIND OUThow the vast volumes of new data produced by the Internet of Things provides a valuable new source of business insight through advanced analytical techniques.
  MASTER how the ongoing development of smart cities, cars, and houses will enhance connectivity infrastructure.
Lunch Power Panel | Microservices & IoT- Moderated by Jason Bloomberg
In this Power Panel at @DevOpsSummit, moderated by Jason Bloomberg, president of Intellyx, panelists Roberto Medrano, Executive Vice President at Akana; Lori MacVittie, Evangelist for F5 Networks; and Troy Topnik, ActiveState's Technical Product Manager; and Otis Gospodnetic, founder of Sematext; peeled away the buzz and discuss the important architectural principles behind implementing IoT solutions for the enterprise. As remote IoT devices and sensors become increasingly intelligent, they become part of our distributed cloud environment, and we must architect and code accordingly. At the very least, you'll have no problem filling in your buzzword bingo cards.

Querying Queries
Querying Queries

This month I'd like to continue exploring ColdFusion 5 - this time concentrating on a radical new feature known as Query of Queries - a feature that lets you treat query results as if they were database tables. Intrigued? Read on.

Querying Queries
You've probably run into this one before - you retrieve data from a database, and then find that you need the same data again, just sorted differently. Or how about this one - you load an entire product catalog into the APPLICATION scope so as to avoid unnecessary database access, and then need a subset of that data which requires that you make another call to the database. In both examples, you're performing additional database operations to access data that you already have. In fact, the only reason you're going back to the database is to perform sorting or filtering, not because you actually need new data.

With Query of Queries you now have a new way to perform these operations, without having to make additional round-trips to the database server. And the best way to explain it is to look at some code:

<!--- Get all movies and expenses --->
<CFQUERY DATASOURCE="ows" NAME="MovieExpenses">
SELECT MovieTitle, SUM(ExpenseAmount) AS Expense
FROM Films, Expenses
WHERE Films.FilmID=Expenses.FilmID
GROUP BY MovieTitle
ORDER BY MovieTitle

<!--- Sort by expense --->
<CFQUERY NAME="MoviesByExpense" DBTYPE="query">
FROM MovieExpenses
ORDER BY Expense

The first query is a simple <CFQUERY>. It retrieves a list of movies from a table, along with the total expenses from a second table (using a join and an aggregate function). The results are sorted by MovieTitle, and returned as query MovieExpenses.

The second query is the interesting one. It has a DBTYPE of "query", and no DATASOURCE. When DBTYPE= "query", ColdFusion executes the query against another query, instead of against an actual data source. The SQL statement itself simply retrieves all data from a table named Movie-Expenses, and sorts the results by Expense. What is MovieExpenses if there is no DATASOURCE being used? It's the name of the first query - the second query is querying the first query instead of a database.

And all this is being processed by ColdFusion itself, not by a database. The second query is processed in ColdFusion, and ColdFusion returns the results itself.

Reusing Queries
And what about the second example above? This first query loads a movie list into a query in the APPLICATION scope:

<!--- Load movies in APPLICATION scope --->
FROM Films
Now how would you execute a search to find the movies that match user specified search text? Look at this next query:
<!--- Find matching movies --->
<CFQUERY NAME="MovieSearch" DBTYPE="query">
SELECT FilmID, MovieTitle
WHERE MovieTitle LIKE ''
Again, the DBTYPE here is "query", and no DATASOURCE is used. The SELECT statement retrieves data from the APPLICATION.Movies query and uses a WHERE clause to extract just the movies matching The result? A brand new query without ever having hit the database.

Working With Multiple Data Sources
Impressed? You should be. But wait, it gets better.

The previous examples all demonstrated code that eliminates unnecessary database calls. And as valuable as that is, this feature really shines in allowing you to perform queries that could not be performed at all with regular queries.

For example, suppose you had data in both Oracle and SQL Server, and wanted to combine the results. How would you do that? Well, prior to ColdFusion 5 you wouldn't have - there really was no way to query multiple data sources. And in ColdFusion 5? Well, look at this code:

<!--- Retrieve movies from SQL Server --->
SELECT FilmID, MovieTitle
FROM Films

<!--- Retrieve reviews from Oracle --->
SELECT FilmID, Review
FROM FilmReviews

<!--- Combine the results --->
<CFQUERY NAME="combined" DBTYPE="query">
SELECT MovieTitle, Review
FROM Movies, Reviews
WHERE Movies.FilmID=Reviews.FilmID
ORDER BY MovieTitle

There are three queries used in this operation - the first queries SQL Server, the second queries Oracle, and the third uses DBTYPE="query" to join the two prior queries into a single result set. The result? A combined query derived from data from disparate data sources.

Simple. And you can't do that with straight SQL.

And Not Just Database Queries Either
As you've seen, in ColdFusion 5, queries may be used as tables. And while all the examples used here have involved database queries, in fact, any queries may be used. Consider these possibilities:

  • Join a <CFLDAP> query and a <CFPOP> query so as to be able to loop through received e-mail along with information about the sender or the recipient.
  • Query a database using <CF-QUERY>, and then perform a Verity search using <CFSEARCH>, and join the results to simplify full text searching.
  • Retrieve messages with <CFPOP>, and join them to a database query based on sender, recipient, or an ID in the subject field.
Regardless of how queries are created (by any tag, or even manually using the Query functions), ColdFusion can execute queries against them. And like any other queries, Queries of Queries may be cached, put into scopes, and even be queried against, again.

Why Query Queries?
So, why bother querying queries? There are several reasons (and no, individual query performance may not be one of them):

  • Joining different data sources
  • Executing SQL statements against nondatabase data
  • Reducing database load (by executing SQL statements in memory instead of hitting the database server)
  • Reducing network traffic (again, by not sending data back and forth unnecessarily)
And as for performance? Don't expect ColdFusion to process queries faster than a database server could. After all, database servers are finely tuned applications designed to do nothing but manipulate data; ColdFusion will never manipulate data as fast as a database server could. But having said that, by helping lower database load and network traffic, querying queries can indeed help overall system performance.

The ability to query queries is a radical and novel concept - and one that many ColdFusion developers have wanted (often without actually knowing what it is they really wanted). Used properly, this feature opens the doors to all sorts of new coding opportunities, and without having to learn any new tags or technologies at all.

About Ben Forta
Ben Forta is Adobe's Senior Technical Evangelist. In that capacity he spends a considerable amount of time talking and writing about Adobe products (with an emphasis on ColdFusion and Flex), and providing feedback to help shape the future direction of the products. By the way, if you are not yet a ColdFusion user, you should be. It is an incredible product, and is truly deserving of all the praise it has been receiving. In a prior life he was a ColdFusion customer (he wrote one of the first large high visibility web sites using the product) and was so impressed he ended up working for the company that created it (Allaire). Ben is also the author of books on ColdFusion, SQL, Windows 2000, JSP, WAP, Regular Expressions, and more. Before joining Adobe (well, Allaire actually, and then Macromedia and Allaire merged, and then Adobe bought Macromedia) he helped found a company called which provides automotive services (buy a car, sell a car, etc) over the Web. (including Stoneage) is one of the largest automotive web sites out there, was written entirely in ColdFusion, and is now owned by Auto-By-Tel.

In order to post a comment you need to be registered and logged in.

Register | Sign-in

Reader Feedback: Page 1 of 1


I display all the records of a table in a form with input, drop down list, radio buttons, etc. I want the users to be able to make changes to several of the rows, then click "save" and all rows would be updated. I know how to update one row at a time, but multiple rows? How's about records from multiple related tables? Please help me.



When I use: select sum((IIF([M1]='Yes',1,0))) AS quest1

in a regular query, it works. But when I use the same code in a query of queries, it bombs. Do QofQ not work the same way that regular queries do?

Jon Woodroof
University of Tennessee

Hi. Can someone clear why the sql in QoQ is case sensitive? Even datetime comparison fails without uppercasing both sides of the equation. Why?? Just curious....


I have some troubles using the SQL statement SELECT ... WHERE ... NOT IN (SELECT ....) with Coldfusion 4.0. The second SELECT returns an error. My intention with the statement is finding the difference between 2 query's, there are a few number of records in query 1 which query 2 does not include. These are the records I want to work with. I've tried nested loops (doesn't work), Javascript (doesn't work), using the DELETE statement (is not supported). Please help me, thanks

Wim Maes

Ben could you please help with this..

My intention is to retrieve all worked hours for a user that they have worked and exclude the ones placed against a particular work type called flex leave.
I have the following:


select * from timesheet
where user_id = #session.user_id#


SELECT SUM(hours) as worked_hours
FROM get_user_timesheet
where work_type <> 1

Notes: work_type = 1 is specified as a flex leave

The query of query ignores the where clause and gives a total of the number of hours for the user
regardless of the type.

Please help

Presentation Slides
Traditional on-premises data centers have long been the domain of modern data platforms like Apache Hadoop, meaning companies who build thei...
Using new techniques of information modeling, indexing, and processing, new cloud-based systems can support cloud-based workloads previously...
IoT & Smart Cities Stories
Dynatrace is an application performance management software company with products for the information technology departments and digital business owners of medium and large businesses. Building the Future of Monitoring with Artificial Intelligence. Today we can collect lots and lots of performance data. We build beautiful dashboards and even have fancy query languages to access and transform the data. Still performance data is a secret language only a couple of people understand. The more busine...
The challenges of aggregating data from consumer-oriented devices, such as wearable technologies and smart thermostats, are fairly well-understood. However, there are a new set of challenges for IoT devices that generate megabytes or gigabytes of data per second. Certainly, the infrastructure will have to change, as those volumes of data will likely overwhelm the available bandwidth for aggregating the data into a central repository. Ochandarena discusses a whole new way to think about your next...
CloudEXPO | DevOpsSUMMIT | DXWorldEXPO are the world's most influential, independent events where Cloud Computing was coined and where technology buyers and vendors meet to experience and discuss the big picture of Digital Transformation and all of the strategies, tactics, and tools they need to realize their goals. Sponsors of DXWorldEXPO | CloudEXPO benefit from unmatched branding, profile building and lead generation opportunities.
All in Mobile is a place where we continually maximize their impact by fostering understanding, empathy, insights, creativity and joy. They believe that a truly useful and desirable mobile app doesn't need the brightest idea or the most advanced technology. A great product begins with understanding people. It's easy to think that customers will love your app, but can you justify it? They make sure your final app is something that users truly want and need. The only way to do this is by ...
Digital Transformation and Disruption, Amazon Style - What You Can Learn. Chris Kocher is a co-founder of Grey Heron, a management and strategic marketing consulting firm. He has 25+ years in both strategic and hands-on operating experience helping executives and investors build revenues and shareholder value. He has consulted with over 130 companies on innovating with new business models, product strategies and monetization. Chris has held management positions at HP and Symantec in addition to ...
DXWorldEXPO LLC announced today that Big Data Federation to Exhibit at the 22nd International CloudEXPO, colocated with DevOpsSUMMIT and DXWorldEXPO, November 12-13, 2018 in New York City. Big Data Federation, Inc. develops and applies artificial intelligence to predict financial and economic events that matter. The company uncovers patterns and precise drivers of performance and outcomes with the aid of machine-learning algorithms, big data, and fundamental analysis. Their products are deployed...
Cell networks have the advantage of long-range communications, reaching an estimated 90% of the world. But cell networks such as 2G, 3G and LTE consume lots of power and were designed for connecting people. They are not optimized for low- or battery-powered devices or for IoT applications with infrequently transmitted data. Cell IoT modules that support narrow-band IoT and 4G cell networks will enable cell connectivity, device management, and app enablement for low-power wide-area network IoT. B...
The hierarchical architecture that distributes "compute" within the network specially at the edge can enable new services by harnessing emerging technologies. But Edge-Compute comes at increased cost that needs to be managed and potentially augmented by creative architecture solutions as there will always a catching-up with the capacity demands. Processing power in smartphones has enhanced YoY and there is increasingly spare compute capacity that can be potentially pooled. Uber has successfully ...
SYS-CON Events announced today that has been named “Media Sponsor” of SYS-CON's 22nd International Cloud Expo, which will take place on June 5–7, 2018, at the Javits Center in New York City, NY. is a transparent online platform for determining which products and services are the best based on the opinion of the crowd. The crowd consists of Internet users that have experienced products and services first-hand and have an interest in letting other potential buye...
When talking IoT we often focus on the devices, the sensors, the hardware itself. The new smart appliances, the new smart or self-driving cars (which are amalgamations of many ‘things'). When we are looking at the world of IoT, we should take a step back, look at the big picture. What value are these devices providing. IoT is not about the devices, its about the data consumed and generated. The devices are tools, mechanisms, conduits. This paper discusses the considerations when dealing with the...

2016 | 2015 | 2014 | 2013 | 2012
This week I had the pleasure of delivering the opening keynote at Cloud Expo New York. It was amazing to be back in the great city of New York with thousands of cloud enthusiasts eager to learn about the next step on their journey to embracing a cloud-first worldl."
How does Cloud Expo do it every year? Another INCREDIBLE show - our heads are spinning - so fun and informative."
Thank you @ThingsExpo for such a great event. All of the people we met over the past three days makes us confident IoT has a bright future."
One of the best conferences we have attended in a while. Great job, Cloud Expo team! Keep it going."


Who Should Attend?
Senior Technologists including CIOs, CTOs & Vps of Technology, Chief Systems Engineers, IT Directors and Managers, Network and Storage Managers, Enterprise Architects, Communications and Networking Specialists, Directors of Infrastructure.

Business Executives including CEOs, CMOs, & CIOs , Presidents & SVPs, Directors of Business Development , Directors of IT Operations, Product and Purchasing Managers, IT Managers.

Join Us as a Media Partner - Together We Can Enable the Digital Transformation!
SYS-CON Media has a flourishing Media Partner program in which mutually beneficial promotion and benefits are arranged between our own leading Enterprise IT portals and events and those of our partners.

If you would like to participate, please provide us with details of your website/s and event/s or your organization and please include basic audience demographics as well as relevant metrics such as ave. page views per month.

To get involved, email

@ThingsExpo Blogs
Having been in the web hosting industry since 2002, dhosting has gained a great deal of experience while working on a wide range of projects. This experience has enabled the company to develop our amazing new product, which they are now excited to present! Among dHosting's greatest achievements, they can include the development of their own hosting panel, the building of their fully redundant server system, and the creation of dhHosting's unique product, Dynamic Edge.
This session will provide an introduction to Cloud driven quality and transformation and highlight the key features that comprise it. A perspective on the cloud transformation lifecycle, transformation levers, and transformation framework will be shared. At Cognizant, we have developed a transformation strategy to enable the migration of business critical workloads to cloud environments. The strategy encompasses a set of transformation levers across the cloud transformation lifecycle to enhance process quality, compliance with organizational policies and implementation of information security ...
CloudEXPO New York 2018, colocated with DevOpsSUMMIT and DXWorldEXPO New York 2018 will be held November 12-13, 2018, in New York City and will bring together Cloud Computing, FinTech and Blockchain, Digital Transformation, Big Data, Internet of Things, DevOps, AI and Machine Learning to one location.
Digital Transformation Blogs
Today’s AI cannot create an algorithm that satisfies a human’s intent in all but the simplest cases. What we do have is AI that can divine insights from patterns in large data sets. If we can boil down algorithms into such data sets, then we can make some headway. For example, if an AI-based application has access to a vast number of human-created workflows, then it can make a pretty good guess as to the next step in a workflow you might be working on at the moment. In other words, we now have autocomplete for algorithms – what we call ‘next best action.’ We may still have to give our so...
Dynatrace is an application performance management software company with products for the information technology departments and digital business owners of medium and large businesses. Building the Future of Monitoring with Artificial Intelligence. Today we can collect lots and lots of performance data. We build beautiful dashboards and even have fancy query languages to access and transform the data. Still performance data is a secret language only a couple of people understand. The more business becomes digital the more stakeholders are interested in this data including how it relates to bus...
Having been in the web hosting industry since 2002, dhosting has gained a great deal of experience while working on a wide range of projects. This experience has enabled the company to develop our amazing new product, which they are now excited to present! Among dHosting's greatest achievements, they can include the development of their own hosting panel, the building of their fully redundant server system, and the creation of dhHosting's unique product, Dynamic Edge.
"Calligo is a cloud service provider with data privacy at the heart of what we do. We are a typical Infrastructure as a Service cloud provider but it's been des...
Discussions of cloud computing have evolved in recent years from a focus on specific types of cloud, to a world of hybrid cloud, and to a world dominated by the...