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 […]
Category: MS SQL Server
Microsoft SQL Server Databases
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 […]
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 […]
Finding the average number of documents in folders
I found an example that used syntax where I could find the average based on a group count. In this case, the group by is the folder’s tracking id (ParentTracking_ID) assigned to the document. SELECT […]
How to Loop Through Audit Records
Recently I needed a way to essentially ‘loop’ through all the records in our NetTrax.NET Audit History for the given record and return back the one that is that entries ‘check in’… So, what I […]
Database Index Checker
Often we send a database to a client and then later on find out that a key got dropped or an index removed along the way… Well, now we can easily test this! Open up […]
Generate Sequential Data Padded With 0
We frequently have to generate location or item codes for clients. This is typically a sequential number that has multiple levels in the code. For example, there are 4 carousels; each carousel has either 23 […]
Windows 8 User Account Types and SQL Server
My computer is not part of a domain., but rather a member of a workgroup. You can still use Windows Authentication for things like file sharing and accessing Microsoft SQL Server instances. All you have […]