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

Guest Columnist: Randy Dyess

SQLServerCentral.com profile

I have been working with SQL Server for over 5 years as both a development and production DBA. Before SQL Server I spent time as both a Visual Basic developer and Microsoft Access developer. Numerous projects upsizing Access to SQL Server lead me to become a full-time SQL Server DBA. Currently I have the privilege of working on one of the world's largest SQL Server "read-world" production installations at Verizon Communications for Verizon's billing project. We have 11 main databases totaling over 9 Terabytes of data with the largest single database over 2.2 Terabytes. My current position is as a development DBA, developing new Transact-SQL code and enhancing existing code. Before working at Verizon, I worked at one of the largest advertising firms in America: Rapp Collins. There I supported up to 60 SQL Server web databases at a time, with some Oracle thrown in, doubling as both a development DBA and production DBA. Clients before Rapp Collins include: Auto One (a leading auto loan lender), Realpage, Inc. (leader in multi-housing management software) and BlueCross BlueShield of Texas (a large insurance company). You can find out more about me and my works by visiting my website.

   Items 1 to 15 of 15   
 

Bookmark Lookups

Building high performance applications with SQL Server can be a challenge if you do not understand how the query processor works and how the server uses indexes. SQL Server expert Randy Dyess brings a look at how bookmark lookups are used when satisfying a query and how this can impact the performance of your query.   Read more...
By Randy Dyess 2008/07/18 (first published: 2005/05/30) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 37,017 reads

Obtaining Query Execution Plans Through SQL Profiler Traces

Did you know that you can obtain the execution plans for your SQL Server 2000 queries using Profiler? It is an interesting concept, especially when you need to troubleshoot the queries on a system that you did not develop and cannot obtain source code for. SQL Server guru andy Dyess brings us the technique you can use to find those queries and execution plans.   Read more...
By Randy Dyess 2005/04/18 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 15,964 reads

Optimizer Join Methods

Understanding the different types of joins used by the optimizer will help developers and DBAs understand how the optimizer is routing their queries. Developers often create queries without knowing that it would only take a few tweaks to produce an execution plan that utilizes one optimizer join method over another. These small tweaks can have dramatic effects on the optimization of the query and the ultimate satisfaction of the query by the end-users.   Read more...
By Randy Dyess 2005/02/09 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 20,808 reads

Yukon Passwords

Some good info on password changes in Yukon (SQL 2005). Based on the beta, but worth taking a look at.   Read more...
By Randy Dyess 2004/03/19 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 8,796 reads

SQL Injection - Part 1

Randy says that the biggest reason we have so many injection vulnerabilities is that all the asp books use inline sql for their examples! We STILL encounter developers who don't understand injection. Read and pass on to your dev team.   Read more...
By Randy Dyess 2004/02/24 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 15,155 reads

Displaying Execution Plans

Randy starts a multiple part series on tuning queries. We've asked Randy to really start from scratch and walk through the process. This week he takes a look at viewing query plans in Query Analyzer.   Read more...
By Randy Dyess 2003/08/19 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 20,592 reads

Managing Jobs Using TSQL

We've had a good run of jobs about job management lately, Randy sent us another one that looks at the job of job management and shows us how he tackled the problem.   Read more...
By Randy Dyess 2003/04/02 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 23,686 reads

Manage Multiple SQL Server Installations and Databases with OSQL

This article explains how to use a simple batch file and script file to manage multiple databases on multiple servers.   Read more...
By Randy Dyess 2002/10/24 | Source: SQLServerCentral.com | Category: configuring
Rating: |  Discuss |   Briefcase | 9,804 reads

Interact with SQL Server's Data and Procedure Cache

This article briefly discusses SQL Server's data and procedure cache and shows you the common Transact-SQL statements/command and system tables that you can use to interact with the cache through Transact-SQL.   Read more...
By Randy Dyess 2002/08/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 13,801 reads

Documented and Undocumented Trace Flags for SQL Server 2000 and 7.0

This article contains descriptions of 65 documented and undocumented trace flags currently available in SQL Server 7.0 and 2000.   Read more...
By Randy Dyess 2002/07/24 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 13,810 reads

Auditing Your SQL Server Environment Part II Auditing Your SQL Server

In this article by Randy Dyess he shares with you the script on how he audits his environment and outputs reports of the permissions that users have.  Read more...
By Randy Dyess 2002/05/30 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 9,534 reads

SQL Server 2000 Table Hints

As you advance in your skills as a Transact-SQL developer or SQL Server database administrator there will come a time when you need to override SQL Server's locking scheme and force a particular range of locks on a table. This article by Randy Dyess shows you how to optimize your queries using table hints.   Read more...
By Randy Dyess 2002/04/15 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 21,228 reads

Optimizing Stored Procedures To Avoid Recompiles

One of the most overlooked areas in optimizing SQL Server and Transact-SQL is the recompilations of stored procedures. A database getting thousands of recompiles an hour will suffer in performance and show short term blocking that will affect the database users. This article by Randy Dyess shows you some of the ways you can avoid stored procedure recompiles.   Read more...
By Randy Dyess 2002/02/26 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 20,899 reads

Is a Temporary Table Really Necessary?

In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries.   Read more...
By Randy Dyess 2008/05/30 (first published: 2002/04/09) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 65,488 reads

Auditing Your SQL Server Environment Part I

Ever been placed into a new environment and couldn't find an ounce of documentation? This article is the first in a series that will help you make an audit of your new environment and determine if any SQL Server login does not have a password, has a password the same as the login name or a password that is only one character long.  Read more...
By Randy Dyess 2002/04/02 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 10,367 reads
   Items 1 to 15 of 15