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,067 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,857 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

442 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,979 reads

Blogs

Understanding Azure Geo-Redundant Storage

By

While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery...

Prompt in ADS

By

Ever since VS Code and Azure Data Studio came out, people have been asking...

When Too Much is Not a Good Thing

By

Explore how to avoid unwanted results that oft occur due to lack of attention...

Read the latest Blogs

Forums

Azure DB newbie trying to locate existing Azure DBs

By tarr94

Hello, I've been tasked with trying to learn more about existing Azure DBs that...

BAckup history not showing into MSDB

By pdsqsql

Hello, We had an strange issue that our sql server 2012 Sharepoint Databases backup...

Pivot or convert column to rows

By sqltester1

Hi All, I have table which stores all in single column, I want to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers