Daily news, white papers, tutorials and articles on databases.

The links below take you to the DevX: Latest Database Content web site. This is a free off site content service. We're not responsible for the linked content. If nothing displays below, the DevX: Latest Database Content blog or news channel is currently unavailable, please try again later.

DevX: Latest Database Content


Container Wars: Docker vs. Rkt

Tue, 18 Oct 2016 15:23:00 -0700 · It will be very interesting to see how the container landscape evolves. Are developers going to stick with the incumbent, yet quickly innovating, Docker or are they going to flock to the supposedly superior newcomer?

Using the @@rowcount Global Variable in SQL

Fri, 14 Oct 2016 02:29:00 -0700 · Language: SQL||Expertise: Intermediate

Automating Web Site Deployment

Tue, 11 Oct 2016 12:45:00 -0700 · Examine a few of the approaches and tools that can help standardize and automate Web site deployment to a certain level.

Skip Weekends SQL Function

Thu, 22 Sep 2016 08:28:00 -0700 · Language: SQL||Expertise: Intermediate

Perform Data Audits in SQL Azure Using Temporal Tables

Tue, 13 Sep 2016 07:54:00 -0700 · Learn why Temporal Tables are a powerful feature to help you tailor your auditing needs without having to write any code.

Obtaining the Next Number in a Sequence Using a Stored Procedure and an Output Parameter

Fri, 09 Sep 2016 02:15:00 -0700 · Language: SQL||Expertise: Beginner

Find out Whether a Value Exists in a List of Values

Fri, 26 Aug 2016 02:08:00 -0700 · You can use a normal SELECT query joined with a bunch of AND statements to determine if a certain value exists, but this can become cumbersome and tedious. Language: SQL||Expertise: Beginner

Agile Build Environments Require Testing

Tue, 23 Aug 2016 09:53:00 -0700 · To follow Agile principles and allow an individual developer to have a quick build cycle of edit-built-test requires significant effort. In most cases it is worth it. There are two representative cases: small and large

Doing Upserts with the Help of MERGE

Tue, 16 Aug 2016 02:57:00 -0700 · Language: SQL||Expertise: Intermediate

Eventual Consistency

Thu, 11 Aug 2016 02:45:00 -0700 · In general, distributed systems that are designed for eventual consistency typically still provision enough capacity and redundancy to be pretty consistent under normal operating conditions.

Get All Tables and Views Inside a Database

Tue, 02 Aug 2016 11:02:00 -0700 · Language: SQL||Expertise: Intermediate

Build an Intuitive View-Driven Data Stack for Your Modern Apps Using Apollo

Fri, 29 Jul 2016 10:47:00 -0700 · The Apollo data stack builds on the power of GraphQL and provides a set of client and server side components that contain easy-to-use boilerplate templates for setting up a data service for modern UI driven apps.

Backup and Restore Using Amazon S3 API

Tue, 26 Jul 2016 12:02:00 -0700 · Learn how to integrate Amazon Services with your Web application so that you can completely automate the backup process.

Getting All Stored Procedures Inside a Database

Mon, 25 Jul 2016 11:04:00 -0700 · Language: SQL||Expertise: Intermediate

Distributed Transaction Management in a Microservices Architecture

Fri, 22 Jul 2016 21:54:00 -0700 · Distributed transaction management is a key architectural consideration that needs to be addressed whenever you are proposing a microservices deployment model to a customer. Learn how to keep up with today's world where focus is on modular, self-contained APIs.

PIVOTing Data in SQL

Tue, 19 Jul 2016 11:06:00 -0700 · Language: SQL||Expertise: Advanced

Working with Triangular Joins

Mon, 11 Jul 2016 02:47:00 -0700 · Set-based solutions are always faster than loops in SQL, right? Usually that is true but not always. You should generally take a set-based solution first, performance test it (at scale!) and start investigating loops only if you find your set-based approach, for some reason, fails to scale up.

Explore Advanced Vagrant Features

Thu, 30 Jun 2016 02:18:00 -0700 · Learn about Vagrant's complex features, such as synced folders, provisioning scripts and running multiple virtual machines at the same time.

Stored Procedures Do Not Protect from SQL Injection Attacks

Thu, 23 Jun 2016 02:25:00 -0700 · People often say that using stored procedures protects you against SQL injection attacks.  This is incorrect. Learn how to secure your data the right way.

Examine the Strategic Value of APIs

Fri, 17 Jun 2016 14:52:00 -0700 · Learn why providing a great API can allow you to really focus all your resources on the secret sauce and not worry about visual user interface.

Building Agility into Your Stack

Thu, 09 Jun 2016 02:33:00 -0700 · In order to benefit from new technologies, you need to build agility right into your stack.

Determine who and what Caused a Deadlock in one of your Database Objects

Tue, 07 Jun 2016 04:13:00 -0700 · Language: SQL||Expertise: Intermediate

Architecting Stable Systems and Solid Code

Tue, 31 May 2016 12:44:00 -0700 · Solid code does what the developers intended it to do and can gracefully handle anything you throw at it. Learn more about how to make your code solid.

Analyze Complex Problems with EventStorming

Thu, 28 Apr 2016 11:09:00 -0700 · Learn more about this Domain Driven Design workshop approach to analyzing complex business problems.

Introduction to Graph Databases

Wed, 27 Apr 2016 10:44:00 -0700 · In recent years the database scene has been boiling. New databases for special purposes seem to emerge every day and for a good reason. Learn more about the importance of graph databases.

· Home

· Databases

· DevX

· Web Links

· Link to us

· Contact

· What's new

· Site map

· Get Help

Most popular:

· Site Feeds

· Database Design Guide

· Google Sitemaps

· smartDataPump

· Spider Support

· How To Link Properly

Free Tools:

· Sitemap Validator

· Simple Sitemaps

· Spider Spoofer

· Ad & Click Tracking

Search Google
Web Site

Add to My Yahoo!
Syndicate our Content via RSS FeedSyndicate our Content via RSS Feed

To eliminate unwanted email from ALL sources use SpamArrest!

Digg this · Add to del.icio.us · Add to Furl · We Can Help You!

Home · Categories · Articles & Tutorials · Syndicated News, Blogs & Knowledge Bases · Web Log Archives

Top of page

No Ads

Copyright © 2004, 2005 by Smart IT Consulting · Reprinting except quotes along with a link to this site is prohibited · Contact · Privacy