Articles

An alternative approach to disaster recovery and backup strategies using PolyBase.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(18)

You rated this post out of 5. Change rating

2017-08-25 (first published: 2015-08-10)

7,252 reads

Discuss

The Basics of Good T-SQL Coding Style – Part 3: Querying and Manipulating Data

by Additional Articles

SimpleTalk

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.

2017-08-25

5,735 reads

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(8)

You rated this post out of 5. Change rating

2017-08-23 (first published: 2004-03-24)

56,885 reads

Discuss

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2017-08-23 (first published: 2003-05-09)

34,022 reads

Discuss

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2017-08-23 (first published: 2003-01-22)

37,999 reads

Discuss

Installing SQL Server Agent on SUSE Linux

by Additional Articles

MSSQLTips.com

SQL Server Agent

Manvendra Singh explains how to install SQL Server Agent on SUSE Linux server, so that you can create SQL Server Jobs to schedule repetitive work.

2017-08-23

3,181 reads

How to Find Out Which Database Object Got Deleted

by Additional Articles

Database Journal

Greg Larsen shows you how to use the Transaction ID value to identify the object_id for a deleted table.

2017-08-22

4,419 reads

Is It Time To Stop Using IsNumeric()?

by Additional Articles

SimpleTalk

ISNUMERIC()

The old system function IsNumeric() often causes exasperation to a developer who is unfamiliar with the quirks of Transact SQL. It seems to think a comma or a number with a 'D' in the midde of it is a number. Phil Factor explains that though IsNumeric has its bugs, it real vice is that it doesn't tell you which of the numeric datatypes the string parameter can be coerced into, and because it doesn't check for overflow. Phil comes to the rescue with a couple of useful alternatives, one of which works whatever version of SQL Server you have, and which tell you what datatype the string can be converted to.

2017-08-21

4,500 reads