Skip to content
  • About NetTrax
  • About Us
  • Blog
  • Contact Us
  • Links
  • Media
  • Privacy Policy
  • References
  • Solutions
  • Support

NetTrax.Net

Tailored and evolving software for your unique business requirements.

  • Home
    • About NetTrax
    • About Us
  • Solutions
    • NetTrax.NET Hosted
    • NetTrax.NET Thick Client
    • NetTrax.NET Thin Client
  • Blog
    • Annoucement
    • Barcode Readers
    • Database
    • Dymo®
    • Enchancement Tracking System (ETS)
    • For Your Information
    • Programming
    • Records Management
    • Releases
    • Solution Spotlight
    • Utilities
  • Media
    • Screenshots
      • NetTrax.NET Thick Client
      • NetTrax.NET Microsoft® SharePoint® WebParts
      • NetTrax.NET Microsoft® Outlook® Add-In
  • Contact Us
    • Support
    • Privacy Policy
  • Links
    • Credits

Year: 2014

  • Home
  • 2014
Database MS SQL Server SQL Code Snippets

Parse a String in SQL and Return Data After Last Occurrence

2014-10-232020-06-14 Brad Arnold

I have a string value in a column in my table. It’s a full path and filename for a .tif image. I needed to get

Read More
Database MS SQL Server SQL Code Snippets

States / Provinces Lookup Table

2014-10-222020-06-14 Brad Arnold

I recently needed a lookup table of all 50 US states (and Washington DC) and the provinces / territories in Canada. The script below will

Read More
NetTrax.NET

NetTrax Removable Media Audit

2014-10-032020-06-15 Brad Arnold

We are working on a special project for an existing client. We’ll be scanning hundreds of thousands of documents over the next year to year

Read More
Database MS SQL Server

Checklist to allow remote connection to SQL Server

2014-09-122020-06-15 Pete Sral

Every time I setup a new SQL Server I always forget one or more of the steps below to allow remote connection from another workstation

Read More
MS Excel

Excel Personal Macro Workbook

2014-08-152020-06-14 Brad Arnold

I have a folder of Macros that I use from time to time. Until recently I would open my new spreadsheet, go into Visual Basic

Read More
Dymo®

Dymo® Labels: Changing the label type without losing label objects

2014-08-062020-06-14 Pete Sral

It looks like you have to recreate a new label if you want to change the label type of an existing Dymo® label.  I thought

Read More
Database

How to Avoid Errors When Importing to Access Database

2014-07-092020-06-15 Brad Arnold

I had a spreadsheet that was in .xlsx format that I needed to import into an Access Database. I made sure the columns were in

Read More
Database MS SQL Server SQL Code Snippets

Renaming a SQL Server database’s logical name

2014-07-072020-06-15 Pete Sral

At times we copy a SQL Server database from one database name to another for testing or development.  One thing that doesn’t change is the

Read More
Database MS SQL Server

Keyword searching using Full-Text Indexing (Getting Started)

2014-07-032020-06-15 Pete Sral

Creating a full-text catalog in SQL Server is easy, I used a tutorial on one of our favorite SQL Server blogs: http://blog.sqlauthority.com/2008/09/05/sql-server-creating-full-text-catalog-and-index/ I created 4

Read More
Database MS SQL Server

SQL Server Reporting Services – SMTP Authentication Workaround

2014-06-062020-06-15 Brad Arnold

We at Bradford use Google Apps for our email. My computer not part of the domain (I don’t’ work from the corporate office) and we

Read More

Posts navigation

1 2 Next

By Category

By Month Year

Recent Posts

  • 5 Ways to Spring Clean Your Security
  • Type conversion in expression CONVERT_IMPLICIT may affect “SeekPlan” in query plan choice.
  • Insert if missing, example of joining tables to exclude duplicates.
  • PDF viewer window caption
  • Datalogic Devices on Windows 10 and issues with Windows Mobile Device Center (WMDC) 6.1

Categories

  • Annoucement (2)
  • Barcode Readers (12)
  • Barcodes (1)
  • Database (28)
  • Datalogic Memor™ (10)
  • Datalogic Skorpio™ (4)
  • DLXfer (1)
  • Dymo® (1)
  • Enchancement Tracking System (ETS) (3)
  • For Your Information (6)
  • Imports (3)
  • Memor™ Collection Program (2)
  • MS Excel (1)
  • MS SQL Server (29)
  • MS Windows™ (7)
  • NetLabels (1)
  • NetTrax.NET (9)
  • Programming (12)
  • Records Management (7)
  • Releases (1)
  • SignalR (3)
  • Software (5)
  • Solution Spotlight (2)
  • Source Code Managment (1)
  • SQL Code Snippets (18)
  • SubVersion (1)
  • Utilities (6)
  • Windows Mobile Device Center (1)
All Rights Reserved 2022.
Proudly powered by WordPress | Theme: Fairy by Candid Themes.