• Skip to main content
  • Skip to header right navigation
  • Skip to site footer
Foster Solutions (FSI)

Foster Solutions (FSI)

The Solution is in the Process

  • Home
  • What We Do
    • Websites / Hosting
      • Author’s Sites
      • Boutique Websites
      • Corporate Websites
      • Open Source CMS
      • Quick and Dirty Websites
    • SQL Databases / VBA Automation
    • GIS / Market Research
    • Government/Planning
  • Case Studies
    • Databases/Automation Case Studies
    • GIS/Market Research Case Studies
    • Local Government Case Studies
    • FSI – crosspollination – examples
  • Clients
  • Articles
  • Contact Us

linkedin

You are here: Home / Archives for linkedin

Excel Function to reduce Cell Formats

If you build large Excel workbooks, you may have come across a weird error suddenly when you edited your file.  You get an error that says “Too many different cell formats”.  This will happen particularly with a large file that you have copy and pasted a lot of information from external sources. The following vba …

Read moreExcel Function to reduce Cell Formats

SQL Server – Deleting Dupes with no Unique Key

There is an easy way to remove duplicate rows from a SQL Server 2008 table, by using an undocumented feature called %%physloc%%. This pseudo column shows the physical location of a row. Please keep in mind that this is an undocumented feature and unsupported….    Use at your own risk! [crayon-6045e2eb930f3388536047/]    

Read moreSQL Server – Deleting Dupes with no Unique Key

SQL Tricks: helping functions-use your temp tables

When I first found out about functions in SQL Server, I thought it would be a silver bullet to modularize my code. In the end, I realized a strategy was necessary to prevent performance degradation. One helpful approach is to use temp tables.

Read moreSQL Tricks: helping functions-use your temp tables
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Interim pages omitted …
  • Go to page 5
  • Next →

Ready to get started?

Client Survey

Please take this survey if you are interested in a new or modified website. We will assess and get back with you as soon as possible.

Finding Solutions

We work with you to make things faster, easier and better.

Sites

  • Home
  • Blog
  • About
  • Features
  • Contact
  • Marketing

Features

  • Home
  • Blog
  • About
  • Features
  • Contact
  • Marketing

Support

  • Home
  • Blog
  • About
  • Features
  • Contact
  • Marketing

Copyright © 2021 · Foster Solutions (FSI) · All Rights Reserved

Back to top