Skip to content

TechRepublic

Trending Now

Businessman holds the model of business, made from wood blocks. Alternative risk concept, business plan and business strategy. Insurance concept.
Image: Michail Petrov/Adobe Stock
Article

Managing the element of risk in projects

Ransomware infects a computer's system.
Credit: Adobe
Article

How traditional security tools fail to protect companies against ransomware

featuremicrosoft461682196.jpg

Image: Microsoft News

Article

Tech News You May Have Missed: June 23-30

project team collaboration.jpg
Article

Collaborating across IT operations for a stronger enterprise environment

  • Top Products Lists
  • Developer
  • 5G
  • Security
  • Cloud
  • Artificial Intelligence
  • Tech & Work
  • Mobility
  • Big Data
  • Innovation
  • Cheat Sheets
  • TechRepublic Academy
  • CES
  • TechRepublic Premium
  • Top Products Lists
  • Developer
  • 5G
  • Security
  • Cloud
  • Artificial Intelligence
  • Tech & Work
  • Mobility
  • Big Data
  • Innovation
  • Cheat Sheets
  • TechRepublic Academy
  • CES
  • See All Topics
  • Sponsored
  • Newsletters
  • Forums
  • Resource Library
TechRepublic Premium

Account Information

Join or sign in

Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below.

Use Facebook
Use Linkedin

Join or sign in

We recently updated our Terms and Conditions for TechRepublic Premium. By clicking continue, you agree to these updated terms.

Welcome back!

Invalid email/username and password combination supplied.

Reset password

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

Welcome to TechRepublic!

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).

Loading
Image of arthurfuller

arthurfuller

Send arthurfuller an email

Latest from arthurfuller

  • Iterating through tables and databases in SQL Server
    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, ...

    arthurfuller
    Published:  June 11, 2007, 3:54 AM PDT Modified:  June 11, 2007, 3:54 AM PDT Read More See more Data Management
  • Resolving loose relationships in SQL
    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.

    arthurfuller
    Published:  May 21, 2007, 5:34 PM PDT Modified:  June 8, 2007, 10:11 AM PDT Read More See more Banking
  • Creative uses for COALESCE() in SQL Server
    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.

    arthurfuller
    Published:  May 14, 2007, 12:00 AM PDT Modified:  June 8, 2007, 10:11 AM PDT Read More See more Data Management
  • Two approaches to recording shift work in SQL Server
    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.

    arthurfuller
    Published:  May 7, 2007, 12:00 AM PDT Modified:  June 8, 2007, 10:11 AM PDT Read More See more Data Management
  • Dealing with case and accents in SQL Server
    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.

    arthurfuller
    Published:  April 30, 2007, 12:00 AM PDT Modified:  June 8, 2007, 10:10 AM PDT Read More See more Data Management
  • Mixing the bill of materials formula with SQL Server
    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.

    arthurfuller
    Published:  April 23, 2007, 12:00 AM PDT Modified:  June 8, 2007, 10:11 AM PDT Read More See more Data Management
  • Exploring the window functions in SQL Server 2005
    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.

    arthurfuller
    Published:  March 19, 2007, 8:40 AM PDT Modified:  June 8, 2007, 10:10 AM PDT Read More See more Data Management
  • Resolving SQL Server data in different databases
    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.

    arthurfuller
    Published:  March 5, 2007, 12:00 AM PST Modified:  June 8, 2007, 10:10 AM PDT Read More See more Data Management
  • Finding the highest value in several SQL Server columns
    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.

    arthurfuller
    Published:  February 26, 2007, 10:28 AM PST Modified:  June 8, 2007, 10:10 AM PDT Read More See more Data Management
  • Running totals in SQL Server queries
    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.

    arthurfuller
    Published:  February 12, 2007, 11:41 AM PST Modified:  June 8, 2007, 10:09 AM PDT Read More See more Data Management
  • 1
  • 2
  • 3
  • 4
  • 5
  • Next
87 results

TechRepublic Premium

  • TechRepublic Premium

    Industrial Internet of Things: Software comparison tool

    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 ...

    Downloads
    Published:  May 26, 2022, 5:00 PM PDT Modified:  May 28, 2022, 8:00 AM PDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    How to recruit and hire an Operations Research Analyst

    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 ...

    Downloads
    Published:  May 19, 2022, 5:00 PM PDT Modified:  May 21, 2022, 12:00 PM PDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    Quick glossary: Industrial Internet of Things

    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 ...

    Downloads
    Published:  May 19, 2022, 5:00 PM PDT Modified:  May 21, 2022, 12:00 PM PDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    Software Procurement Policy

    Procuring software packages for an organization is a complicated process that involves more than just technological knowledge. There are financial and support aspects to consider, proof of concepts to evaluate and vendor negotiations to handle. Navigating through the details of an RFP alone can be challenging, so use TechRepublic Premium’s Software Procurement Policy to establish ...

    Published:  April 14, 2022, 5:00 PM PDT Modified:  April 16, 2022, 1:00 PM PDT Read More See more TechRepublic Premium

Services

  • About Us
  • Newsletters
  • RSS Feeds
  • Site Map
  • Site Help & Feedback
  • FAQ
  • Advertise
  • Do Not Sell My Information

Explore

  • Downloads
  • TechRepublic Forums
  • Meet the Team
  • TechRepublic Academy
  • TechRepublic Premium
  • Resource Library
  • Photos
  • Videos
  • TechRepublic
  • TechRepublic on Twitter
  • TechRepublic on Facebook
  • TechRepublic on LinkedIn
  • TechRepublic on Flipboard
© 2022 TechnologyAdvice. All rights reserved.
  • Privacy Policy
  • Terms of Use
  • Property of TechnologyAdvice