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.

SQLServerCentral Article

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.

You rated this post out of 5. Change rating

2004-11-23

21,055 reads

SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2003-12-05

11,042 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)

You rated this post out of 5. Change rating

2002-11-05

9,010 reads

SQLServerCentral Article

Nightly Failed Jobs Report

Do you get tired of reviewing each SQL Agent notifications nightly to determine which SQL Agent jobs failed? Is there a significant number of SQL Agent job notifications that it takes a while to review each? Here is an alternative that allows you to have a single email report of all job failures.

5 (4)

You rated this post out of 5. Change rating

2002-09-17

11,722 reads

Blogs

What do client diagnostics in Cosmos DB mean?

By

This topic keeps coming up with my customers so the purpose of this blog...

Adding Row Numbers to a Query: #SQLNewBlogger

By

I realized that I hadn’t done much blogging on Window functions in T-SQL, and...

Adding Row Numbers to a Query: #SQLNewBlogger

By

I realized that I hadn’t done much blogging on Window functions in T-SQL, and...

Read the latest Blogs

Forums

FIFO and manufacturing ... how do I get the current cost?

By pietlinden

Sorry, more bakery stuff. Say I buy ingredients over time and I want to...

Linked server and trouble between manager and agent

By msimone

Hello, I have a problem and i don´t understand it. After to link a...

Starting to Estimate Disk Storage for Memory-Optimized Tables

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Starting to Estimate Disk Storage...

Visit the forum

Question of the Day

Starting to Estimate Disk Storage for Memory-Optimized Tables

If I have durable memory-optimized tables, what is the starting point for estimating storage space?

See possible answers