SQL

...whatever the rationale, the association of BI and SQL is deeply embedded in the minds of most practitioners. So, the question arises--what about NoSQL; how does this relate to BI? Can it be of use in data warehousing?[read more]

Recently, some news of a NASA hack-and-dump passed my twitter deck. I decided after watching a few of my friends re-tweet the news that it might be worth checking out. At least I’d see if I could perform some password analysis on any dumped credentials, or even test out the new Crucialpoint Cloudera Hadoop password cracker on any leftover hashes.[read more]

"Over the past 18 months, almost 10,000 software applications from the government and private sector were submitted to Veracode’s online security testing platform for independent security auditing and 8 out of 10 failed to achieve an acceptable level of security on their first try."[read more]

Despite BI's advances, companies continue to struggle with responding quickly to a continuously evolving information landscape and the need for ease of information access that business users require. And big data technologies address sheer volume, but not the variety, velocity and complexity now referred to as extreme information.The...[read more]

A very informative panel discussion with experts from Google, Alias-i, the New York Times and IBM Research.[read more]

Teradata recently held its Partners User Group meeting (Twitter hashtag #TDPUG11) in San Diego. Analysts were briefed previously on some of the announcements, which I covered in an earlier post. With the benefit of hindsight, I realize that Teradata is at the center of a trend in the information management market toward broader...[read more]

"Now in an apparent reverse of direction various Microsoft blogs have announced the next version of SQL Server will be the last to support OLE-DB with the emphasis returning to ODBC. Why this is the case isn’t entirely clear but various people have tried to answer this, the primary message being that ODBC is an industry standard whereas OLE-DB is Microsoft proprietary."[read more]

"Over the past couple of weeks I have had the chance to attend both Teradata‘s Third Party Influencers event and TDWI. I always enjoy getting updated on the latest technologies and speaking to vendors about what they are doing in relation to expanding their product offerings and providing value to their customers. Here are some of the takeaways from both events."[read more]

"So you breezed (or perhaps stumbled) through your stats classes. Now you’re looking to develop a career in data analytics and business intelligence. A wise and lofty ambition."[read more]

"VoltDB considers themselves at 'The NewSQL database for high velocity applications.' It is an in-memory database, which means it primarily relies on main memory for data storage. Main memory is the memory directly accessible by the CPU, it is not secondary storage like hard disks or offline storage like tapes. Being based in main memory provides many speed benefits, including the fact that main memory is faster. Main memory databases are also faster since internal optimization algorithms are simpler."[read more]

"A chat with Max Schireson, President of 10gen makers of MongoDB (from humongous database), yesterday provided some food for thought on the topic of our assumptions about the best database choices for different applications. Such thinking is particularly relevant for BI at the moment, as the database choices expand rapidly."[read more]

"Today, critical information is created and stored in many formats - data, documents, emails, blogs, and so on. When information a user needs is distributed across more than one type and system, assembling and analyzing the information is a largely manual task that invites errors – errors of omission, of timeliness, of expertise on the part of the person doing the compiling and connecting. "[read more]

Predictive Analytics World, the business-focused event for predictive analytics professionals, managers and commercial practitioners, today announced the speaker line-up for the October 17-21, 2011 conference in New York City, New York[read more]

A SQL injection takes advantage of vulnerabilities in the way that applications that utilize sql handle user input. Applications that create database queries (questions like: search for “something” in my web pages) with user input should ensure that the user input does not contain control characters. This ensures that queries are not modified by user input on the fly, either by accident or on purpose. If a request to the SQL server is not cleaned of dangerous characters, we can end up in a situation where a SQL injection is present.[read more]