arthurfuller, Author at TechRepublic

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.

PURPOSE Recruiting a community engagement manager with the right combination of experience and communication skills will require a comprehensive screening process. This hiring kit from TechRepublic Premium provides a flexible framework your business can use to find, recruit and ultimately hire the right person for the job. From the hiring kit: DETERMINING FACTORS, DESIRABLE PERSONALITY ...

PURPOSE Successful chief experience officers combine excellent communications skills with an intimate knowledge of customer expectations, company operations and industry standards. This hiring kit from TechRepublic Premium provides a workable framework you can use to find, recruit and ultimately hire the best candidate for CXO of your organization. From the hiring kit: DUTIES AND RESPONSIBILITIES ...

PURPOSE Recruiting an automation specialist with the right combination of technical expertise and experience will require a comprehensive screening process. This Hiring Kit from TechRepublic Premium provides a flexible framework your business can use to find, recruit and ultimately hire the right person for the job. From the hiring kit: DETERMINING FACTORS, DESIRABLE PERSONALITY TRAITS ...

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

Hiring kit: Community engagement manager

Hiring kit: Chief experience officer

Hiring kit: Automation specialist

Hiring kit: Cybersecurity engineer