FetchMyTip

This missive records my trials and tribulations as I code my way through projects. Fix the problem once and reuse the solution!

Thursday, April 5, 2018

SQL Script to display non-printable ASCII values in a varchar string

I had an issue trying to match a field with hidden characters. I needed to see what non-printable chars were present. This script helped...

Thursday, March 29, 2018

Extracting BLOB data to files

Trying to get a file out of a BLOB field and came up with this script to do it. --Execute this once before running the following scrip...

Powershell in SSMS

I had a restored database of about 300GB and wanted to monitor its progress. The Stats argument on the RESTORE command will give you some l...

SQL restores

Had to do some SQL Admin work and wanted to put this into my tip list. The UI in SMSS will generate the script for you but I wanted it for ...

Monday, August 28, 2017

Open Oracle dmp file and export to SQL DDL file

Problem: Working a project to migrate a system off of Oracle and onto SQL Server. The current host responded to my request for DDL with a...

Monday, August 21, 2017

ADFS 2.0 Token based Authentication Token Expiry

Token based Authentication Token Expiry Tokens issued by AD FS 2.0 expire after a default time of 60 minutes. This requi...

Working with MVC5 and bootstrap DateTimePicker (eonasdan)

Issue: Install-Package Bootstrap.v3.Datetimepicker.CSS bundles.Add(new ScriptBundle("~/bundles/bootstrap").Include( ...

View web version

About Me

Cyberschwob: This blog is meant to capture helpful tips as I do my job.

View my complete profile

Powered by Blogger.