Gregory A. Larsen

Monday Dec 23rd 2002 by DatabaseJournal.com Staff

Gregory Larsen's Articles


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

Mobile Site | Full Site