Gregory Larsen

SQL MAIL Using POP3 and SMTP

SQL Server has a great build in messaging system with SQLMail. Unfortunately it requires Outlook and Exchange to work properly. Some people don't like this or do not run Exchange and have issues getting it to work. Gregory Larsen takes a look at how you can use SMTP to send email from SQL Server.

2004-11-23

20,011 reads

Sequential Numbering

Needing to number rows with a sequential id is a pretty common request. Sometimes it's because the user hasn't made the transition to 'set based' thinking, sometimes it really is a valid request (more or less!). Greg provides several different techniques to help you achieve sequential numbering.

5 (1)

2003-12-05

10,844 reads

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

440 reads

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

8,973 reads

Blogs

Kubernetes Pipelines

By

This post continues looking at some of the Kubernetes concepts I’ve been learning with...

Top Modern Data Warehouse questions

By

Below are the top 15 questions I am seeing from customers looking to build...

Importance of Testing

By

I’ve always said if you’re running a script for the first time in a...

Read the latest Blogs

Forums

Azure Elastic jobs

By Evgeny Garaev

Comments posted to this topic are about the item Azure Elastic jobs

Data Challenges and Travel

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Data Challenges and Travel

Multi column histograms

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multi column histograms

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers