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

Guest Columnist: Robert Marda

SQLServerCentral.com profile

I have worked for bigdough.com since 18 May 2000 as an SQL Programmer. My duties include backup management for all our SQL Servers, mentoring junior SQL Programmers, and serving as DBA while our DBA is on vacation. I develop, test, and deploy stored procedures and DTS packages as well as manage most major SQL projects. Our offices are located in Bethesda, Maryland. Before working for bigdough, I worked for Telos Corporation in Ashburn, Virginia. I started learning T-SQL and using SQL Server 7.0 on 22 March 1999. In April 1999 I was given the position of Senior Database Analyst/Administrator at Telos Corporation. I have been married to Leoncia Guzman since 23 Jul 1994. We met in the Dominican Republic where I lived for about 2 years as a missionary. We have 4 children, Willem (age 8), Adonis (age 6), Liem (age 4 and a half), and Sharleen (age 3 and a half). My hobbies include spending time with our 4 children (we play chess, dominos, mancala, and video or computer games together), keeping tropical freshwater fish, breeding and training parakeets, coin collecting (US and foreign), and geneology. I have a 55 gallon tank and 20 gallon tank. I have many kinds of fish (such as a pleco, tiger barbs, mollies, cichlids, tetras, and guppies) I also have a small aquatic turtle. I last updated my bio 30 Mar 2004.

<< Newer    Items 21 to 25 of 25   
 

Dynamic SQL vs. Static SQL Part 1 - Security

Sooner or later everyone who works with SQL Server hears that it is better to avoid dynamic SQL at all cost. Dynamic SQL will force you to give out more permissions than static SQL. This article by Robert Marda shows you some of the security issues with dynamic SQL.   Read more...
By Robert Marda 2002/02/27 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 11,307 reads

Exploring Deadlocks

In this article by Robert Marda, he shows you how to detect and correct deadlocks.   Read more...
By Robert Marda 2002/02/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,161 reads

When to Use Dynamic SQL

Most DBAs and developers prefer not to use dynamic SQL for a number of reasons. There are some reasons to use this query type though. This article covers a few of those.   Read more...
By Robert Marda 2002/02/12 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 14,034 reads

Uses For Derived Tables

In this article by Robert Marda, he shows you how to use derived tables to solve some of SQL's problems.   Read more...
By Robert Marda 2004/02/06 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 17,010 reads

Auditing Through Triggers

In this article by Robert Marda, he shows you how to setup a simple auditing system through triggers.   Read more...
By Robert Marda 2004/01/16 | Source: SQLServerCentral.com | Category: triggers
Rating: |  Discuss |   Briefcase | 16,499 reads
<< Newer    Items 21 to 25 of 25