371 reputation
15
bio website
location Virginia
age 33
visits member for 2 years, 3 months
seen Jul 10 at 16:35

I am a passionate programmer, that's even more passionate about teaching. By answering questions on Stack Overflow I learn too! You see, when you teach something, that's when you really learn it.

Open Source Projects

DapperPoco Find it on GitHub Find it on GitHub Find it on NuGet Find it on NuGet

DapperPoco is a reflection driven SQL generator that wraps the popular Dapper ORM framework. With DapperPoco you just create your POCO objects, decorate them, and use them; no writing SQL statements unless absolutely necessary.

Email: mperren@gmail.com


Jan
13
comment What is happening with locks in my database?
Is there a trigger running on UPDATE?
Sep
4
awarded  Nice Answer
Jul
23
awarded  Yearling
May
14
awarded  Caucus
Mar
29
comment SQL Server Change Tracking
@bluefeet, I worked with a man that had a college degree and he worked as the DBA. I asked him to use the data centers restore application to get me yesterdays backup of a database and place it on a new database so I can fix something that somebody messed up in the database (oh and they had a college degree too) and he overwrote the LIVE database!
Mar
29
answered SQL Server Change Tracking
Mar
29
comment SQL Server Change Tracking
@TropicThunder, wrong! I've been writing software for more than a decade, 13 years to be exact, and three years ago while trying to get something done for a customer I got interrupted and didn't highlight the WHERE clause I wrote in Management Studio. A college degree means NOTHING! Life happens my friend, and if you do this, you will pay.
Mar
20
comment sp_testlinkedserver taking long time to time-out
I think you're experiencing a timeout that exists on the network adapter. Take note to the fact that you're not really comparing apples and oranges since you're literally changing the environment and now dealing with the fail overs that exist for the hardware.
Dec
8
awarded  Supporter
Dec
8
answered Moving database file locations in SQL Server 2008
Dec
8
comment Moving database file locations in SQL Server 2008
Is the master database still available in SSMS when connecting to the server?
Oct
16
awarded  Autobiographer
Sep
17
comment Shrinking MDF File
@TimLehner, thanks for the additional example!
Sep
17
answered Shrinking MDF File
Aug
6
answered Does having an index on a VARCHAR column with a lot of very similar starting values have bad performance
Aug
3
answered SQL - Need some advices for building a large db
Jul
23
awarded  Teacher
Jul
23
answered Used Memory not freed up after a SQL BULK Insert / BCP Export