Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Gregory Larsen

SQLServerCentral.com profile

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.

<< Newer    Items 21 to 31 of 31   
 

Stairway to T-SQL DML Level 1: The Basic SELECT Statement

There are lots of different aspects of managing data in a SQL Server database. Before you can get into the complex management issues associated with managing application data you need to start with the basic of retrieving data from a table. To return data from a SQL Server table you use a SELECT statement. In this level I will be cover the components of the basic SELECT statement and how you can use it to retrieve data from a single SQL Server table.  Read more...
By Gregory Larsen 2011/10/07 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 15,213 reads

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.   Read more...
By Gregory Larsen 2004/11/23 | Source: SQLServerCentral.com | Category: sqlmail
Rating: |  Discuss |   Briefcase | 19,898 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.   Read more...
By Gregory Larsen 2003/12/05 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 10,793 reads

Migrating Logins To Another Server

Migrating your logins can be done the easy way or the hard way. Greg shows you one way - care to guess which way?!   Read more...
By Gregory Larsen 2003/09/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 16,375 reads

Using Query Analyzer Templates

Greg returns with an article based on some practical experience using QA templates to save time and work. Good examples, good work through, good idea!   Read more...
By Gregory Larsen 2003/04/28 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,568 reads

Beware of Mixing Collations: Converting Collations

With SQL Server 2000 you are able to create databases or columns with a different collating setting than the server. This article will explain a couple of methods Greg has used to successfully change collation settings.   Read more...
By Gregory Larsen 2002/12/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,588 reads

Beware of Mixing Collations - Part 1

A few months ago Greg Larsen ran across a big problem with SQL Server collation when querying. He shares his bruises in this quick article.   Read more...
By Gregory Larsen 2002/12/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,020 reads

Removing Orphan Users from All Databases on Server

In this article by Greg Larsen, he shows you how to remove those pesky orphaned users that can be a security risk after restoring to a new server.   Read more...
By Gregory Larsen 2002/11/18 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 15,099 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.   Read more...
By Gregory Larsen 2002/11/05 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 8,955 reads

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.   Read more...
By Gregory Larsen 2002/09/17 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 11,567 reads

Beware to the System Generated Constraint Name

New columnist Gregory Larsen used to not care what his objects were called until recently when he began to become concerned with the system generated constraint names. This short article tells you why.   Read more...
By Gregory Larsen 2002/08/16 | Source: SQLServerCentral.com | Category: naming standards
Rating: |  Discuss |   Briefcase | 7,056 reads
<< Newer    Items 21 to 31 of 31