Subscribe: DevX: Latest Database Content
http://services.devx.com/outgoing/databasefeed.xml
Added By: Feedage Forager Feedage Grade B rated
Language: English
Tags:
build  data  docker  expertise intermediate  expertise  intermediate  language sql  language  set based  set  sql expertise  sql 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: DevX: Latest Database Content

DevX: Latest Database Content



www.DevX.com



Published: Wed, 07 Dec 2016 06:55:10 -0800

Last Build Date: Wed, 07 Dec 2016 06:55:10 -0800

 



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.