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

www.DevX.com

Using FOR XML PATH and STUFF SQL String Concatenation

Tue, 06 Dec 2016 02:23:00 -0800 · Language: SQL||Expertise: Intermediate

Convert Oracle Queries into Microsoft SQL Format

Fri, 02 Dec 2016 02:52:00 -0800 · Language: SQL||Expertise: Intermediate

Container Orchestration with Docker Swarm

Fri, 25 Nov 2016 11:10:00 -0800 · The power of containers shines brightest when you build large systems made up of many machines running lots of interacting containers. That's were Docker Swarm comes -- arguably the simplest orchestration solution for Docker containers and it is built into the Docker engine itself.

Renaming an SQL Server Database

Tue, 22 Nov 2016 02:22:00 -0800 ·

Working with Cloud-Based Development Environments

Tue, 15 Nov 2016 12:52:00 -0800 · Big data belongs in the cloud and has become much more reasonable to run the applications that manage, sift and display the data in the cloud as well.

The SQL Intersect Operator

Fri, 11 Nov 2016 00:31:00 -0800 · Language: SQL||Expertise: Intermediate

Vagrant Provisioning with Puppet

Thu, 10 Nov 2016 09:03:00 -0800 · Automating software installations is an important part of deploying virtual machines with Vagrant. This process is called provisioning and can be integrated with DevOps tools, such as Puppet. Let's see how to do that.

Using the SQL MINUS Operator

Tue, 01 Nov 2016 00:31:00 -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.


· 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