Derek Downey

9,882 reputation

42256

bio	website	orange-pants.com
	location	Knoxville, TN
	age	30
visits	member for	2 years, 4 months
	seen	7 hours ago
stats	profile views	643

I started my professional career as a PHP application developer. A few years later, as the company I worked for grew, I started migrating into the server world. Now I find myself as the DBA and beginner Server Admin.

	9,882 reputation	bio	website	orange-pants.com	visits	member for	2 years, 4 months
42256 badges		location	Knoxville, TN		seen	7 hours ago

summary answers questions tags badges favorites bounties reputation activity

35 Favorites

added views newest activity votes

votes

answers

kviews

Where are some useful SQL puzzles to teach SQL in a workplace?

sql

oct 2 '11 at 17:58 Lazer 975

votes

answers

kviews

How can a group track database schema changes?

may 6 '11 at 2:34 Dori 101

votes

answers

kviews

Do stored procedures prevent SQL injection?

postgresql security sql-injection

aug 28 at 8:22 Ilia Rostovtsev 151

votes

answers

kviews

How can I optimize a mysqldump of a large database?

mysql performance innodb mysql-5 mysqldump

sep 9 '11 at 16:45 RolandoMySQLDBA 41.8k

votes

answers

802

views

Is there a “best-practices” type process for developers to follow for database changes?

sql-server-2008 process source-control

jan 11 '11 at 15:11 Community♦ 1

votes

answers

kviews

What are some ways to implement a many-to-many relationship in a data warehouse?

database-design data-warehouse

feb 7 '12 at 14:50 ConcernedOfTunbridgeWells 10.4k

votes

answers

kviews

Possible to make MySQL use more than one core?

mysql performance innodb tuning

may 2 at 17:10 Neil McGuigan 949

votes

answers

834

views

As a DBA, how would I go about transitioning from Oracle to SQL Server?

sql-server oracle

may 9 '12 at 13:34 MiMo 186

votes

answers

kviews

Find highest level of a hierarchical field: with vs without CTEs

mysql postgresql query hierarchical

mar 21 at 13:24 evan smith 1

votes

answer

688

views

MySQL : Why are there “test” entries in mysql.db?

mysql security

oct 26 at 19:22 RolandoMySQLDBA 41.8k

votes

answers

kviews

How do I properly perform a MySQL bake-off?

mysql performance performance-testing mariadb percona

oct 12 '11 at 18:17 RolandoMySQLDBA 41.8k

votes

answers

kviews

When should I rebuild indexes?

index maintenance

sep 16 '11 at 18:08 Nick Chammas 5,920

votes

answers

kviews

Storing IP address

mysql database-design datatypes

mar 16 '11 at 20:10 rvs 226

votes

answers

995

views

Why won't some DBMS's allow rollback for certain DDL statements?

ddl feature-comparison rollback database-agnostic

dec 28 at 14:15 Leigh Riffel 13.8k

votes

answers

kviews

Code to simulate deadlock

sql-server deadlock

aug 19 '11 at 12:56 Richard 2,660

votes

answer

617

views

In Google App Engine, what is the most effective many-to-many join model?

performance google-app-engine

aug 16 '11 at 5:05 RolandoMySQLDBA 41.8k

votes

answers

kviews

Is MySQL Replication Affected by a High-Latency Interconnect?

mysql replication

feb 28 at 20:26 Community♦ 1

votes

answers

440

views

Data Warehouse Creation

sql-server-2008 data-warehouse hierarchical

apr 28 '11 at 10:42 Gaius 7,197

votes

answers

491

views

Is there a standard language/interface for programmatic ETL in SQL Server?

sql-server etl

apr 19 '12 at 17:21 Jon of All Trades 793

votes

answers

kviews

MySQL Sharding vs MySQL Cluster

mysql ndbcluster

dec 9 '11 at 19:28 Liran Zelkha 1

votes

answer

kviews

Dump only the Stored Procedures in MySQL

mysql stored-procedures mysqldump dump

jul 28 '11 at 19:08 RolandoMySQLDBA 41.8k

votes

answers

kviews

Performance of a Trigger vs Stored Procedure in MySQL

mysql performance stored-procedures triggers

jan 13 '12 at 19:41 RolandoMySQLDBA 41.8k

votes

answer

236

views

DBA's Scope in datawarehousing Projects

oracle sql plsql data-warehouse

sep 9 '11 at 15:52 Brent Ozar 4,691

votes

answers

435

views

Is there a way to measure replication lag in MySQL with a resolution less than 1 second?

mysql replication

aug 11 '11 at 17:02 Baron Schwartz 657

votes

answers

218

views

Database replication with ability to revert to previous states

mysql replication

may 16 '11 at 12:37 Coder Hawk 2,160

votes

answer

224

views

What is “SAP on Oracle”

oracle sap

apr 27 at 12:31 Mat 3,340

votes

answer

kviews

MySQL high availability, failover and replication with Latency

mysql replication clustering architecture

mar 30 '11 at 20:42 RolandoMySQLDBA 41.8k

votes

answers

378

views

Scalable table structure for periodically updated stats that get aggregated over time

database-design

oct 21 '11 at 9:36 Dave Rix 765

votes

answers

596

views

MySQL tables/databases into different disks

mysql innodb myisam scaling scalability

feb 8 '12 at 13:50 Community♦ 1

votes

answers

616

views

Log MySQL DB changing queries and users

mysql logs

nov 18 '11 at 6:07 IcarusNM 166