Parse a String in SQL and Return Data After Last Occurrence
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 just the filename as a column. I couldn’t use a […]
Year: 2014
States / Provinces Lookup Table
I recently needed a lookup table of all 50 US states (and Washington DC) and the provinces / territories in Canada. The script below will create a table (tbl_LUState) and will populate the table with […]
NetTrax Removable Media Audit
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 and a half. The delivery of the digital images will […]
Checklist to allow remote connection to SQL Server
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 via SSMS. 1. SQL Server Properties: check “Allow remote […]
Excel Personal Macro Workbook
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 mode and copy/paste the macro into the spreadsheet. Save it […]
Dymo® Labels: Changing the label type without losing label objects
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 the Dymo® software would allow me to change the label […]
How to Avoid Errors When Importing to Access Database
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 the correct order, and that the column headers matched my […]
Renaming a SQL Server database’s logical name
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 logical name: Using the following SQL script the logical name […]
Keyword searching using Full-Text Indexing (Getting Started)
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 catalogs: Each catalog is assigned to a table and columns […]
SQL Server Reporting Services – SMTP Authentication Workaround
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 don’t have our own internal SMTP server in our domain […]