arthurfuller, Author at TechRepublic

Account Information

Reset password

An email has been sent to you with instructions on how to reset your password.

Back to TechRepublic

Welcome to TechRepublic!

By registering, you agree to the Terms of Use and acknowledge the data practices outlined in the Privacy Policy.

You will also receive a complimentary subscription to TechRepublic's News and Special Offers newsletter and the Top Story of the Day newsletter. You may unsubscribe from these newsletters at any time.

All fields are required. Username must be unique. Password must be a minimum of 6 characters and have any 3 of the 4 items: a number (0 through 9), a special character (such as !, $, #, %), an uppercase character (A through Z) or a lowercase (a through z) character (no spaces).

arthurfuller

Latest from arthurfuller

Data Management

Iterating through tables and databases in SQL Server

This tip presents two very useful stored procedures that live in the master database but are not mentioned in SQL Server Books Online. These system procedures come in very handy for jobs such as determining the space used, the number of rows, the indexes on the user tables, and so on. The first procedure, sp_MSForEachDB, ...

Banking

Resolving loose relationships in SQL

In this SQL Server tip, Arthur Fuller shows how to "equate" charges with payments and provides a model for resolving similar business problems.

Data Management

Creative uses for COALESCE() in SQL Server

Arthur Fuller shows you two unusual uses of the COALESCE() function in SQL Server. For instance, you can generalize its use, as well optimize its performance and make its results constantly available.

Data Management

Two approaches to recording shift work in SQL Server

If you want to list employees' time sheet records in SQL Server by the shift, you should assume that an employee could begin work at any time between the start and stop times of the shift. Learn two ways to preserve the correct groupings in your list.

Data Management

Dealing with case and accents in SQL Server

Collation describes the code page, case sensitivity, accent sensitivity, and language or alphabet in use. This SQL Server tip illustrates how you can force the use of any specific collation.

Data Management

Mixing the bill of materials formula with SQL Server

Question: What do you get when you combine SQL Server, bill of materials, and cooking? Answer: A useful tip for figuring out what recipes you can make based on the ingredients you have on hand.

Data Management

Exploring the window functions in SQL Server 2005

SQL Server 2005's window functions allow you to look at different levels of aggregation all at one time. Here's how to use the OVER(…) clause to gather a collection of statistics.

Data Management

Resolving SQL Server data in different databases

One all-too-common problem that data modelers and DBAs face is how to resolve SQL data in different databases. Arthur Fuller walks you through a sound approach for addressing this problem.

Data Management

Finding the highest value in several SQL Server columns

If your task is to return the maximum value contained on a row from n columns, you may want to program defensively, anticipating that some new column(s) might be added. See why Arthur Fuller says this approach can leave you with useful functions.

Data Management

Running totals in SQL Server queries

Arthur Fuller demonstrates how running totals are simple to create in SQL Server queries once you understand the requirements.

IIoT software assists manufacturers and other industrial operations with configuring, managing and monitoring connected devices. A good IoT solution requires capabilities ranging from designing and delivering connected products to collecting and analyzing system data once in the field. Each IIoT use case has its own diverse set of requirements, but there are key capabilities and ...

Recruiting an Operations Research Analyst with the right combination of technical expertise and experience will require a comprehensive screening process. This Hiring Kit provides an adjustable framework your business can use to find, recruit and ultimately hire the right person for the job.This hiring kit from TechRepublic Premium includes a job description, sample interview questions ...

The digital transformation required by implementing the industrial Internet of Things (IIoT) is a radical change from business as usual. This quick glossary of 30 terms and concepts relating to IIoT will help you get a handle on what IIoT is and what it can do for your business.. From the glossary’s introduction: While the ...

arthurfuller

Iterating through tables and databases in SQL Server

Resolving loose relationships in SQL

Creative uses for COALESCE() in SQL Server

Two approaches to recording shift work in SQL Server

Dealing with case and accents in SQL Server

Mixing the bill of materials formula with SQL Server

Exploring the window functions in SQL Server 2005

Resolving SQL Server data in different databases

Finding the highest value in several SQL Server columns

Running totals in SQL Server queries

Industrial Internet of Things: Software comparison tool

How to recruit and hire an Operations Research Analyst

Quick glossary: Industrial Internet of Things

Software Procurement Policy