5,819 reputation
1231
bio website mikefal.net
location Colorado
age 41
visits member for 2 years, 9 months
seen 10 hours ago

I am a database administrator in Denver with a passion for playing music and enjoying sake. I have 10+ years of SQL experience, 3+ of Oracle experience, and a music performance degree from CU Boulder. I also play bass trombone in a local jazz band and occasionally sub in for a couple community orchestras.


Dec
17
reviewed Approve can I use many-to-many relation with weak entity
Nov
20
reviewed Approve Need advice on optimizing database on a recurring basis
Nov
20
reviewed Approve Where's my missing Sql Server Express 2005 Database space? Size and space available dont add up to 4G?
Nov
19
reviewed Approve barman tag wiki excerpt
Nov
19
reviewed Approve barman tag wiki
Nov
16
comment What is wrong with this INSERT Statement
Do you have an error message or some output that indicates what is happening?
Oct
23
reviewed Approve Does the SQL Server backup process use a buffer cache?
Oct
14
reviewed Approve How To Remove Leading Characters in SQL
Oct
10
reviewed Approve postgresql-9.4 tag wiki excerpt
Oct
10
reviewed Approve Working out Duplicated Data in a Customer Data Base
Oct
10
reviewed Approve postgresql-9.4 tag wiki
Oct
9
comment Can not re-set [log_reuse_wait] after log back up
Checkpoints happen periodically within the database engine, usually once every minute. They will resolve this, but once transactions happen within the engine, you'll see the same message, because now there will be new transactions in the log. This is just how the engine works. Regarding size, don't focus on how much is in use at a single point in time. Certain actions (ETL, index maintenance, etc) will use more of the log when they run, but you won't see that unless you watch the log at that moment.
Oct
8
reviewed Approve Writing select result to a csv file
Oct
8
revised Cannot shrink transaction log
edited body
Oct
8
answered Can not re-set [log_reuse_wait] after log back up
Sep
17
reviewed Approve memory-optimized-tables tag wiki
Sep
17
reviewed Approve datadir tag wiki excerpt
Sep
17
awarded  Proofreader
Sep
17
reviewed Approve sql-server-core tag wiki
Sep
17
reviewed Approve ibm-netezza-administrator tag wiki excerpt