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 80

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 113

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.

SQL 87

SQL Injection Attacks Are Rampant: How to Stop Your Next Hack Attack

Inc Startups

The latest security report from Ponemon Institute says an SQL attack is your biggest enemy, and most businesses don''t know what one is

SQL 52

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 33

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 52

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 27

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 46

The Best Programming Languages for Digital Marketers

ConversionXL

For a newcomer, there are four programming languages worth learning: SQL*. Technically, SQL is a “declarative language,” not a programming language, but it has the “ functionality of a mature programming language.”. Python, SQL, JavaScript, and Bash are good at different things.

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 207

Rimini Street: 50 shades of grey

deal architect

Rimini Street has announced general availability of support for a wide range of database platforms, including IBM DB2, Microsoft SQL Server, the SAP Sybase family. They have previously supported Oracle and SAP HANA databases and a wide range of applications. Enterprise Software (IBM, Microsoft, Oracle, SAP

SQL 54

Storage worries

TechEmpower

The commonplace language for structuring, storing, finding, and fetching data-SQL-has been with us a very long time. The objectives of each NoSQL implementation vary, but generally, the appeal to developers (like us) comes from these common advantages versus traditional SQL: Thank goodness, there is no SQL language to deal with. Systems with anticipated but undefined analytical needs are generally better served by SQL.

SQL 218

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!

Product Manager, Take your next step in #media #jobs

The Product Guy

Senior Product Manager @ MillerCang Agency (recruitment firm) (New York) Keywords: Media, SQL, TV, USER TESTING [link]. If you are a great product person looking for a great product job, or vice versa, check out our job board. Thousands of employers across all areas of product, from management to design, from digital to physical, are looking to fill positions from our community. Each week we highlight some of the recently posted openings. Check out this week’s newest, below….

SQL 43

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.

Weekend Favs November 11

Duct Tape Marketing

Analysts get the simplicity of SQL they need. Weekend Favs November 11 written by John Jantsch read more at Duct Tape Marketing. My weekend blog post routine includes posting links to a handful of tools or great content I ran across during the week.

SQL 53

This Week’s Featured Product Management Job

The Product Guy

Product Manager @ Birchbox (New York, NY) Keywords: e-commerce, HTML, Product Manager, SQL, startup [link] Filed under: product jobs Tagged: product management. If you are a great product person looking for a great product job, or vice versa, check out our job board. Thousands of employers across all areas of product, from management to design, from digital to physical, are looking to fill positions from our community. Each week we highlight some of the recently posted openings.

SQL 40

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.

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.

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.

Being Hacker-Centric

Force of Good: a blog by Lance Weatherby

We are sitting around the kitchen counter eating breakfast when the Kokomo Kid asks "You know anything about SQL?" "A little, why" was my cautious reply. Who is the best SQL expert? So my wife, who is the part time controller, is reading SQL code and trying to determine the output of a command string. She could not determine how to treat them as different versions of SQL treat null values in different ways.

SQL 44

How to persuade your boss to buy you an iPad

Business of Software Blog

When we kicked off our SQL Response 2 project last June, we decided to rewrite the product from scratch. Oh, and you’d be able to monitor your SQL Servers from your mobile phone. Yours sincerely, [put your name here] “ SQL Response 2 could be the killer app for the sysadmin’s iPad.

SQL 71

"There’s so much focus on acquiring customers and delivering products and services that security is."

Mark Birch

There were plenty of times that I saw basic SQL injection scripts bypass the leaky (or often completely absent) security measures of startup websites. ““There’s so much focus on acquiring customers and delivering products and services that security is not top of mind,” said Tripp Jones, a partner at August Capital, a Silicon Valley venture capital firm. Half-joking, he added: “For many companies, a security breach would almost be a nice problem to have in some cases.

SQL 40

Google Cloud Platform gets new storage options, 20% price cut, more European datacenter support

The Next Web

The news comes just under three weeks after the company gave its Cloud SQL service a big update. Google on Monday announced new Cloud Platform features, including new storage and compute capabilities, lower prices, and more European Datacenter support.

SQL 79

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.

What does it mean to be “technical”?

Launching Tech Ventures

If your company uses MS SQL Server (which is unlikely, as it’s a paid product in a sea of open source competitors), check out the Excel Data Mining Add Ins – these provide a simple Excel interface to some quite powerful data mining algorithms that leverage the power of the database engine. DON’T “LEARN TO CODE”, LEARN SQL “Learn to code” is a popular mantra trotted out as sage advice for MBAs wanting to work in software companies, particularly startups.

SQL 38

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 280

This Week’s Featured Product Management Jobs (Week of June 15, 2013)

The Product Guy

Product Manager @ Fab.com (New York, NY) Keywords: acquisition marketing, entrepreneurial, product design, sql [link]. Business Analyst / Project Manager @ Data Mash (Seattle, WA) Keywords: cms, design, maintain, websites [link]. Revitas- Business Analyst @ Resolvit, LLC (Durham, NC) Keywords: CARS, IT, Pharmaceutical [link]. Product Manager Sr Staff @ Juniper Networks (San Francisco, CA) Keywords: ethernet, networking [link].

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.

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 248

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 166

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.

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 110

MongoDB Impressions

charliecrystle.com

Mongo is a document database that makes it very simple to work with data–it’s basically object oriented vs SQL’s rigid table structure. I’ve spent the past three days diving into MongoDB and jQuery. Smarter people than I can tell you about its flexibility and built-in scalability. I’m attracted to it because I have a [.].

SQL 26

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.

Mangling JSON numbers

TechEmpower

Auto-incrementing primary keys in a SQL database. If we have a long (64-bit integer) that we serialize into JSON, we might be in trouble if JavaScript consumes that JSON. JavaScript has the equivalent of double (64-bit floating point) for its numbers, and double cannot represent the same set of numbers as long. If we are not careful, our long is mangled in transit. Consider 2 53 + 1. We can store that number in a long but not a double.

Java 211

5 expert tips to strengthen your APM strategy with SaaS

The Next Web

Consider SQL response times. Isolation of an application or database tier means you get answers quickly, and your solution should also offer insight to the code and SQL levels for even greater context. Andy Wild is the president of OpTier.

SQL 80

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 67

4 Great Jobs That Don’t Require Experience

YoungUpstarts

For graduates with a general IT degree, the role of an applications developer allows IT-minded individuals to gain experience in building applications in a wide array of “popular environments like Windows,NET, Linux and SQL.”

SQL 52

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 73

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 80

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 440

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.