SQL: The Hack Attack You'll Never See Coming

Inc Startups

SQL injection attacks are among the most common security threats businesses face, and they''re on the rise. You may not have the slightest idea what an SQL injection attack is, but that''s okay, you''re in good company. A Growing Problem SQL attacks are on the rise.

SQL 27

Google Cloud SQL hits general availability with data encryption, 99.95% uptime, and databases up to 500GB

The Next Web

Google today announced the general availability of Cloud SQL , which, as its name implies, is a MySQL database that lives in Google’s cloud. First and foremost, Cloud SQL data (database tables and temporary files) is now automatically encrypted.

SQL 34

Trending Sources

Google Cloud SQL hits general availability with data encryption, 99.95% uptime, and databases up to 500GB

The Next Web

Google today announced the general availability of Cloud SQL , which, as its name implies, is a MySQL database that lives in Google’s cloud. First and foremost, Cloud SQL data (database tables and temporary files) is now automatically encrypted.

SQL 25

Google introduces six-month trial for Cloud SQL, ups storage 10x to 100GB, adds EU datacenter

The Next Web

Google today announced a major update to its Cloud SQL, which, as its name implies, is a MySQL database that lives in Google’s cloud. Google has increased the available storage on Cloud SQL from 10GB to 100GB.

Data Corruption To Go: The Perils Of sql_mode = NULL

Code as Craft

Some digging led us to the MySQL variable sql_mode. What is sql_mode anyway? sql_mode is a run-time setting for MySQL and enabling it makes the database much more vocal by changing most WARNINGs to ERRORs. CREATE TABLE `sql_test`. `id` When sql_mode='STRICT_ALL_TABLES' is set though, each of those inserts will fail hard so that you can recover and handle the problem in your application. MySQL sql_mode.

SQL 12

Christine: Similarity Searches in Good Ol SQL

Christine.net

Main | Ning: A Playground of Social Freeware » Similarity Searches in Good Ol SQL This was a very interesting project developed during Googles Summer of Code. SQL implications 1. Put thelearning/classification function into the SQL query analyzer and let itgo. Christine (.net)

SQL 4

Don't Write Off Relational Databases For Big Data Just Yet

readwrite.com

Big Data may be the poster child for NoSQL databases and date warehouses, but one industry veteran isn't giving up on SQL databases for Big Data just yet. Of course, the relational model and SQL dominate todays database landscape. SQL is not going away. Sections. Social.

Ex-Facebookers launch MemSQL to make your database fly

gigaom.com

On Monday, former Facebookers Eric Frenkiel and Nikita Shamgunov (who also spent six years as a senior engineer on Microsoft SQL Server) launched a startup called MemSQL that seeks to speed relational databases by taking a page out of the Facebook playbook. Cloud Computing News. Events. Books.

Framework Benchmarks Round 7

TechEmpower

We also have some SQL Server tests in our i7 environment. Prior to finishing Round 7, that SSD failed, so Round 7 is run with ramdisk-backed databases (excluding SQL Server). Happy Halloween fans of web development frameworks!

#GlueCon 2013 Notes: Processing Big Data In Real-time with a Distributed SQL System – Ankur Goyal, MemSQL

Launch Any

Processing Big Data In Real-time with a Distributed SQL System – Ankur Goyal, MemSQL. “SQL scales, but the technology behind it may not” When you write SQL against a distributed system, there is more to take into account than indexes and other SQL optimizations: how your data is distributed across partitions. Sidenote: Added 90M rows to a SQL database in the first 2-3 minutes of their talk.

The Depressing Day After You Get TechCrunched

Vinicius Vacanti

You run a quick SQL query and the number of users that made it through the sign-up flow: 200. Post loosely based on our experience years ago when TechCrunch covered Yipit’s launch.

SQL 155

5 Tips For Wrapping Your Database With a REST API

Launch Any

These values are then passed into the SQL query to limit the number of results returned for a query. Add pagination into your API, limiting SQL queries to a maximum number of records per request. Never allow SQL to be passed in the URL.

Big Data: It's Not What You Think

Inc Startups

In a nutshell, big data is a catch-all term for data sets that are so large and complex that they necessitate new forms of processing beyond the SQL databases prevalent since the early 1980s. They are all answered using traditional SQL databases. Want to break your SQL database?

SQL 39

Watching Larry Ellison become Larry Ellison — The DNA of a Winner

Steve Blank

The choice of the SQL a way to ask questions (queries) in an easy-to-understand language. In Oracle’s early days Kathryn Gould was the founding VP of Marketing, working there from 1982 to 1984.

SQL 155

When Microsoft Threatened to Sue Us Over the Letter “E”

Steve Blank

software; NT, SQL Server and IIS), with the free and ever present. By 1997 E.piphany was a fast growing startup with customers, revenue and something approaching a repeatable business model. Somewhere that year we decided to professionalize our logo (you should have seen the first one.)

SQL 118

Fractional Hiring

Mike Michalowicz

For example, if your small business computer network has a problem processing SQL queries (cough… an exact problem I had with a, cough-cough, not to be mentioned CRM system. SQL problem fixed – fast, fully and cheaply.

SQL 9

Frameworks Round 5

TechEmpower

And yes, we would like to include Microsoft SQL Server in the future. We have posted Round 5 of our ongoing project measuring the performance of web application frameworks and platforms.

Just Make It Faster

Feld Thoughts

He then dissects a simple SQL query ( DELETE FROM some_table WHERE id = 1234; ) and gives several quick reasons why performance could vary widely when this query is executed. He did a nice job of synthesizing the requirements, wrestling Oracle for the PC to the ground (on a Novell network), and getting all the PL/SQL stuff working.

SQL 66

Moving At The Speed Of ‘What’s Next’: Subscription Business Models Spur Continuous Innovation

YoungUpstarts

by Jason Bissell and Calvin Hoon, Talend. With the immense success of cloud platforms and S oftware – as -a- Service (SaaS) models on one hand and the increase of subscription services on the other, it’s clear that software offered as a subscription is becoming the new standard.

Choosing a Programming Language and Framework for Your Startup

SoCal CTO

We had an interesting presentation at the LA CTO Forum by the CTO of a startup who chose Groovy / Grails as the framework for their startup. t prompted a good discussion around how CTOs go about choosing the programming language and framework for their startup.

Full-Stack Analytics: The Next Wave of Opportunity in Big Data

Hazard Lights

This post orginally appeared on KDnuggets in May of 2014 and came out of a panel discussion at Analytics Week in Boston that was moderated by Gregory Piatetsky of KDnuggets.

Seven Deadly Sins of the VC

Venture Cyclist

Bob Davoli offered me a job at D&N Systems (which became SQL Solutions) in 1989 on the basis of one round of interviews. I have worked for him and with him for at least 10 of the 17 years we have lived in the USA.

SQL 18

Programmer Competency Matrix

www.starling-software.com

Can do basic database administration, performance optimization, index optimization, write advanced select queries, able to replace cursor usage with relational sql, understands how data is stored internally, understands how indexes are stored internally, understands how databases can be mirrored, replicated etc. Programmer Competency Matrix. Note that the knowledge for each level is cumulative; being at level n implies that you also know everything from the levels lower than n.

SQL 45

5 trends that are changing how we do big data

gigaom.com

Large web companies such as Facebook and eBay already use HBase to power transactional applications, and startups such as Drawn to Scale and Splice Machine have used HBase as the foundation for transactional SQL databases. GigaOM. Apple. Cleantech. Cloud. Europe. Mobile. Video.

SQL 62

Everything about Java 8

TechEmpower

There are minor exceptions, such as ZonedDateTime which has no counterpart in SQL. The following post is a comprehensive summary of the developer-facing changes coming in Java 8. This next iteration of the JDK is currently scheduled for general availability in September 2013. At the time of this writing, Java 8 development is still very much in progress. Language features and APIs may still change. I'll do my best to keep this document up to date.

Java 239

Introducing ThoughtSpot – The End of Business Intelligence As we Know It

Lightspeed Venture Partners

Business Intelligence (BI) is the gift that keeps on giving. For years, startups have popped up, promising better insights and faster decision making capabilities, consistently resulting in new waves of highly valued companies.

SQL 36

What Does the Future Hold for Conversion Optimization?

ConversionXL

Trends include: big data tools, data manipulation (SQL and alternatives), languages like Python, and deeper analyses (e.g., Learn advanced data analysis skills and more traditional data science crafts – Python, SQL, R, and other big data skills.

CloudHelix: Understanding and Managing Network Infrastructure

WayTooEarly

This data is also funneled into an open system with an SQL interface, allowing for ad hoc analysis and integration with external tools. I’m thrilled to announce that First Round has led the seed financing round for CloudHelix , which is helping web and network operators to easily and more fully understand and manage their infrastructure. This new, scalable platform allows for the collection, fast visualization and querying of network traffic and performance.

SQL 13

What Would Happen to Your Business If You Lost All of Your Online Data

Duct Tape Marketing

Okay, how about this one – you fire up your WordPress blog and discover that your low cost host has decided to go out of business and take your SQL database (otherwise know as you blog posts) with them. (I

SQL 28

The Accidental API

Launch Any

SQL injection attacks: SQL injection is a technique uses to try to access or modify data by attempting to alter SQL statements executed by the API endpoints, exposing data that was previously not available. How your web or mobile API might be putting your business at risk.

API 17

When You Should Still Use a Relational Database Instead of NoSQL

www.readwriteweb.com

Bye, Bye Waterfall: 5 Steps to Implement Responsive Web Design

www.readwriteweb.com

Silverlight Lives On in New SQL Server 2012 Reporting Tool. ReadWriteHack. ReadWriteWeb. Channels. ReadWriteStart. ReadWriteBiz. ReadWriteEnterprise. ReadWriteCloud. ReadWriteHack. ReadWriteMobile. ReadWriteHack. Archives. Twitter. Facebook.

Web 62

Building It Is Not Enough: 5 Practical Tips On User Acquisition

OnStartups

To test any customer acquisition channel all you typically need is Google Analytics, Excel, and some basic SQL skills. The following is a guest post by Brian Balfour , Co-Founder and CMO of Boundless. You can read more of his writing on his blog at BrianBalfour.com.

MongoDB

A VC : Venture Capital and Technology

Yesterday I saw this poll on Hacker News :   Hacker News is a very specific community and so by no means is this poll representative of the entire software engineering community, but I am so proud to see Mongo up there as the top non-sql datastore.

SQL 2

4 Problem-Solving Analytics Tools

Inc Startups

BIME Analytics Designed for companies of any size, including tiny start-ups, BIME is a dashboard that can read data from multiple sources: Excel spreadsheets, an SQL database, the accounting package you use for all income and expenses.

SQL 19

Scaling lessons learned at Dropbox, part 1

eranki.tumblr.com

We eventually ended up converting everything to SQLAlchemy’s lowest-level language for constructing SQL (one step away from raw SQL). Rajivs blog. RSS Archive. July 12, 2012. Scaling lessons learned at Dropbox, part 1. Rajiv Eranki.

SQL 58

Big Data, Big Money: IT Industry to Increase Spending

Inc Startups

Last week, three big data-focused start-ups received millions in venture capital funding : SQL programming developer Splice Machine, database management provider Mongo HQ and cloud marketing platform Bloomreach

SQL 10

The problem with advice

Business of Software Blog

We explained what we were doing - building software that we hoped people would buy; software that addressed the pains of SQL Server developers; software that people would just download, try and buy. About a year or two after starting Red Gate (this must be about 10 years ago now), Simon and I were chatting to a couple of venture capitalists.

SQL 14

The art of hiring a data scientist

Version One Ventures

Just because most academics work in Matlab or R, this doesn’t mean that they aren’t capable of translating their skills to Python, SQL or MongoDB. Nearly four years ago, I joined the Insight Data Science team and we launched an intensive 7 week post-doctoral training fellowship bridging the gap between academia and data science.

SQL 15

Why We Should Be Teaching Kids the Language of Design

crowdSPRING Blog

They should be studying HTML and CSS and PHP and SQL and Java and Python and C++ and beyond. Let’s face it: the U.S. has been behind the curve when it comes to the study of languages for… well, too long to calculate at this point.

SQL 24