Default image for blog posts - purely decorative

Creating a SQL Database Project for Isolated Development

Rusty Divine .NET, Articles, Databases, Development Technologies & Tools, SQL, Tutorial 2 Comments

In this article you see how to create a database project that will let you quickly and consistently deploy a database to your local environment. This approach can help to solve some issues from team members interfering with each other’s work on a shared development database.

Then, in an upcoming article, we will show you how to take the next step to include this database project in your continuous integration process and deploy it to each environment up the chain to production so that you can eliminate the need for any direct interaction with database updates.

data sanitization

Sanitize: Good for Beer, Good for Data

Jeremy Gard Articles, Databases, Design, JavaScript, Programming Leave a Comment

When it comes to brewing, one of the most critical considerations is sanitization. The same fact can be said for development. In brewing you can introduce unintended flavors, create a lesser end product, or completely ruin your hard work. With development, you can introduce inaccuracies or bad data, errors can be caused or exposed to attack, and security holes can be created.

With best practices in sanitization, we can all enjoy better applications and better beer. In this blog, I discuss the importance of data sanitization in development (with tips for success), with parallels to sanitization in brewing.

Keyhole To Sponsor SQL Saturday Kansas City

Lauren Fournier Bogner Articles, Community, Company News, Educational Event, SQL Leave a Comment

Attention: This article was published over 10 years ago, and the information provided may be aged or outdated. While some topics are evergreen, technology moves fast, so please keep that in mind as you read the post.We are pleased to announce that Keyhole Software is a sponsor of the 2016 SQL Saturday Kansas City. SQL Saturday is a one-day, free training opportunity …

Default image for blog posts - purely decorative

SQL for Application Developers

Mark Adelsberger Articles, Databases, Development Technologies & Tools, Programming, SQL 3 Comments

Attention: This article was published over 10 years ago, and the information provided may be aged or outdated. While some topics are evergreen, technology moves fast, so please keep that in mind as you read the post.“SQL? Isn’t that just something my ORM tools use?” Often application developers can and should remain at least one level removed from SQL. JPA …

Rethinkdb

Real-Time Applications With RethinkDB

John Hoestje Articles, Databases, Development Technologies & Tools, JavaScript, Microservices, Node.js 1 Comment

Attention: This article was published over 11 years ago, and the information provided may be aged or outdated. While some topics are evergreen, technology moves fast, so please keep that in mind as you read the post.In the last several years, there have been new requirements and expectations placed on enterprise applications that have dramatically increased application code complexity. Users …