Subscribe: DevX: Latest Database Content
Preview: DevX: Latest Database Content

DevX: Latest Database Content

Published: Sun, 23 Oct 2016 07:36:29 -0700

Last Build Date: Sun, 23 Oct 2016 07:36:29 -0700


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.