Gregory Larsen

Currently a SQL Server DBA. I've been working with SQL Server since 1999. I'm an old-time mainframe DBA. My DBA career started in 1985. Currently studying to obtaining MCDBA.

Technical Article

Converting Binary data to a Hex Character String

Occassionally you might want to convert a binary number into some printable string.   This would allow you display some meaning fully numbers hex characters, instead of just some unreadable garbage.  This script takes a binary field, of basically any length, and converts it, character by character, to a character string.  The character string will contain […]

2002-11-07

447 reads

SQLServerCentral Article

Streamlining the Database Server Recovery Process

Are you tired of manually restoring each database on a new server when the original server has a melt down? Does the manual process seem slow, and prone to keystoke and mouse click errors? Would you like to have those restore scripts automatically built, so you only have to fire them off? Well this article will show you one possible method for speeding up and reducing errors will trying to perform a restore of all databases on a server.

5 (2)

2002-11-05

9,001 reads

Blogs

Daily Coping 26 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Microsoft Build event announcements

By

There were a number of data platform announcements at Microsoft Build yesterday that I...

Data is not immutable

By

Information — in the form of data — usually stored as binary 1s and...

Read the latest Blogs

Forums

Selecting distinct values from dupes based on latest date

By DaveBriCam

I have a table of patients that has often multiple occurrences of a patient...

How to set parameters on an output file?

By Stamey

My pipeline pulls records from SQL tables and put them into files in a...

SQLserver Resource Governor - How to set multiple users to the same work group

By caz100

HI Just wondering how to set up multiple users to the same work group...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers