SQL was designed to be a third-generation language, expressed in syntax close to real language, because it was designed to be easy for untrained people to use. Even so, there are ways of expressing SQL Queries and data manipulation in ways that make it easier for the database engine to turn into efficient action. and easier for your colleagues to understand. Robert Sheldon homes in on data querying and manipulation and makes suggestions for team standards in SQL Coding.

The Downsides of AI

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones looks at some of the problems we might have with AI in the future.

Data Migration : Step by Step

by Chris Kempster

SQLServerCentral.com

This article by Chris Kempster covers a wide variety of areas concerned with data migration. Primarily, it focuses on process, standards and some of the many issues to consider when undertaking this role.

Portable DTS Packages

by Kevin Feit

SQLServerCentral.com

Have you ever faced the situation where you have needed to move a DTS package you needed to move a DTS package from one server to another, say from development to production? In this article by Kevin Feit, he shows you how to make a DTS package portable and save time.

Use More Pull Requests

by Steve Jones

SQLServerCentral.com

Editorial

Treat your database code like code.

Using Exotic Joins in SQL Part 1

by Chris Cubley

SQLServerCentral.com

T-SQL

When most developers think of joins, they think of a.SomethingID = b.SomethingID. This type of join, the equijoin, is vitally important to SQL programming; however, it only scratches the surface of the power of the SQL join. This is the first in a series of articles that will look at several different types of exotic joins in SQL. This article will focus on using the BETWEEN operator in joins when dealing with range-based data.