Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Posted Dec 23, 2002

Gregory A. Larsen

By DatabaseJournal.com Staff


Gregory A. Larsen is a DBA at Washington State Department of Health (DOH). Greg is responsible for maintaining SQL Server and other database management software. Greg works with customers and developers to design and implement database changes, and solve database/application related problems. Greg builds homegrown solutions to simplify and streamline common database management tasks, such as capacity management.

Greg has been working with computers since the late 1970's and has a Bachelors of Science Degree in Computer Science, with a minor area of study in Mathematics. Greg's background in DBA work goes back to the mid 1980's. Gregory has been a DBA for a number of different organizations within the State of Washington. This has given him a broad perspective on how organizations manage databases and applications. During Greg's DBA career, he has managed databases on Windows, UNIX, and IBM mainframes. Greg remembers the days when DBAs frequently had to recover from hard disk crashes, as the normal course of business. Greg is currently a PASS chapter leader.

Prior to becoming a DBA, Greg developed and maintained applications. Greg has written a number of articles for different web publishing sites, as well as SQL Server Magazine. Greg also maintains a website ( http://www.sqlserverexamples.com) that contains a number of SQL Server examples to common DBA and SQL developer issues. Greg currently holds a MCITP: Database Administrator and MCITP: Database Developer certificates, and is a SQL Server MVP.

Series Articles

T-SQL Best Practices

Working with SQL Server Date/Time Variables

Current Articles:

Become More Efficient at Writing TSQL by Creating Code Snippets
What Is a TSQL Code Snippet, How Would You It, and Why?
Ten Favorite Keyboard Shortcuts in SQL Server Management Studio
Improving the Performance of a Table Variable using Optimizer Hint RECOMPILE
Filtering Object Explorer Detailed Information in SSMS
Displaying the Object Explorer Details Pane in SQL Server Management Studio
Finding the Source of Your SQL Server Database I/O
Color Coding Your SQL Server Connections
Automatically Capturing SQL Server Performance Metrics
Top 10 SQL Server Counters for Monitoring SQL Server Performance
Obtaining Identity Column Values in SQL Server
Generating Surrogate Keys Using an Identity Column in SQL Server
SQL Server: Natural Key Verses Surrogate Key
Improve Database Allocations through Instant File Initialization
Collecting Performance Metrics Using SQL Server DMV
Tips for Using Common Table Expressions
Top 10 Mistakes When Building and Maintaining a Database
Introduction to Common Table Expressions
Nine Steps to Troubleshooting SQL Server problems
Using Dynamic Management Objects to Monitor I/Os Against an Instance of SQL Server
How to Automate Report Deployment Using SSRS Web Service
Encryption Primer for SQL Server Data
Efficient SQL Server Indexing by Design
Proactive Database Index Creation
SQL Server Column Considerations and Column Placement
The Dos and Don'ts of Database Indexing
Getting Acquainted with SQL Server 2008's Resource Governor
Database Indexing Development Lifecycle...Say What?
Final Keynotes of Pass Summit 2009
PASSion Award and Tom Casey's Keynote Address - Pass Summit 2009
Bob Muglia & Ted Kummert Keynote Address: Pass Summit 2009
Pass Summit 2009 - Volunteer Meetings, Welcome Reception and Quiz Bowl
T-SQL Best Practices - Don't Use Scalar Value Functions in Column List or WHERE Clauses
T-SQL Best Practices - Parameter Sniffing
Parameterized Queries
Building Code that Promotes Plan Re-usage
T-SQL Best Practices - Part 2
T-SQL Best Practices
Calling a Web Service from within SQL Server
10 New SQL Server 2008 Features
Using Check Constraints to Validate Data in SQL Server
Finding the Worst Performing T-SQL Statements on an Instance
Creating Your Own Custom Data Collections
Kilimanjaro, Gemini and Madison - Get the lowdown
A SQL Monitor by Red-Gate Software
Reports for SQL Server 2008 System Data Collections
SQL Server 2008 Data Collections and the Management Data Warehouse
What Kind of DBA Are You?
SQL Server 2008 MERGE Statement
SQL Server 2008 Date Functions, Part 2
New Date Data Types with SQL Server 2008
Connection Strategy for Multiple Database Environments
Exam 70-443 Practice Test from uCertify.com
SQL Server DBA Dashboard
Building Custom Reporting Services Reports for SQL Server Management Studio
Disk Space Usage and SQL Server Performance
SQL Server Security Model
How to Build a Profile Script to Monitor SQL Server off Hours
Preparing for the M70-444 Exam
Setting Up Delegation for Linked Servers
Setting up a Linked Server for a Remote SQL Server Instance
Using Non-Standard Port for SQL Server
Monitoring Stored Procedure Usage
Monitoring Changes to your Database Schema
How Useful Are Those Indexes
Scripting the Installation of SQL Server 2005
Using and Managing Database Mail
New Ranking Functions within SQL Server 2005
Dealing With Upper and Lower Case Data
Calculating Days of the Week and Accounting Months 5-4-4
Creative Ways to Use the TOP Clause
The Five W's of Database Restores
Automatically Stopping and Restarting SQL Server
Working with Comma Separated Data - Part 2
Dealing with Comma Delimited Strings
SQL Server 2005 Large Value Data Types
Copying Database Backups to an Alternative Location
Monitoring SQL Servers Availability
Apply Operator
Dynamic Management Views and Functions
Quest Capacity Manager Review
SQL Server 2005 Upgrade Advisor
Try/Catch Block in SQL Server 2005
Cycling the ERRORLOG file and Deleting Backup History Information
SQL Server 2005 Import / Export Wizard
Finding Database Object Dependencies
Using SQL Server 2005 sqlcmd Utility
Setting DTS Package Properties at Runtime
Automatically Running a Process When SQL Server or SQL Agent Starts
Point in Time Recovery
Index Tuning Wizard
Implementing the Equivalent of a FULL OUTER JOIN in Microsoft Access
Transferring Data from One Table to Another
Identifying Long Running SQL Server Agent Jobs
Detecting The State of a SQL Server Agent Job
Using a Correlated Subquery in a T-SQL Statement
Using a Subquery in a T-SQL Statement
SQL Server: Updating Integer Status Columns
SQL Server Undocumented Stored Procedures sp_MSforeachtable and sp_MSforeachdb
Submitting A Stored Procedure Asynchronously
Gathering Space Usage Statistics
Working With Columns That Contain Null Values
How To Get Output Into SQL Server Table
Using xp_cmdshell
Storing Multiple Statuses Using an Integer Column
SQL MAIL and SQL Agent Mail using POP3 and SMTP
Web Data Administration Tool from Microsoft
Microsoft SQL Server Survival Guide
Benchmarking Performance of a Query - Part 2 CPU and I/O
Benchmarking Performance of a Query - Part 1 Elapsed Time
T-SQL Programming Part 5 - Using the CASE Function
T-SQL Programming Part 4 - Setting Variables in Calling T-SQL Code While Using sp_executesql
SQL Server: Calculating Running Totals, Subtotals and Grand Total Without a Cursor
T-SQL Programming Part 3 - Processing Sequentially Through a Set of Records
T-SQL Programming Part 2 - Building a T-SQL Loop
T-SQL Programming Part 1 - Defining Variables, and IF...ELSE logic
Using xp_fixeddrives to Monitor Free Space
Examples of how to Calculate Different SQL Server Dates
Migrating a Maintenance Plan from One SQL Server to Another
Sequential Numbering/Counting of Records with SQL Server
Dealing with MS SQL Tables that contain Duplicate Rows
Migrating Logins from One SQL Server to Another
Padding, Rounding, Truncating and Removing Trailing Zeroes
Working with SQL Server Date/Time Variables: Part Four - Date Math and Universal Time
Working with SQL Server Date/Time Variables: Part Three - Searching for Particular Date Values and Ranges
Working with SQL Server Date/Time Variables: Part Two - Displaying Dates and Times in Different Formats
Working with SQL Server Date/Time Variables
Streamlining the Database Server Recovery Process on SQL Server
Nightly Failed Jobs Report
Beware of Mixing Collations: Part 2- Converting Collations
Beware of Mixing Collation with SQL Server 2000 - Part 1
Removing Orphan Users from All databases on SQL Server
Beware of the System Generated Constraint Name
Using and Building Query Analyzer Templates