Saturday, December 13, 2008

Samuel Kenneth Finzer Update 2

This is update 2. Scroll down for previous updates.

Samuel did much better this afternoon. He was put on an additional sedative which allowed him to relax and better accept the oxygen from the oscillating ventilator. He was weaned from 100% oxygen back down to 76% oxygen. This is great news.

Also, I was able to see his eyes today. They are brown and similar to Leyla's. Thank you for praying.

Samuel Kenneth Finzer Update 1


All,


It has been a rough couple of days.

Samuel Kenneth Finzer was born on Thursday December 11th at around 6:45PM. He was 7 lbs 9 ounces and 20 ¼ inches long at Riverside Methodist Hospital.

Right after birth Samuel was not breathing and he turned blue. A small army of nurses filled the delivery room. They were able to give him 100% oxygen to preserve his life. He was immediately taken to NICU and had a chest X-Ray. The first chest X-Ray was completely white. Indicating he had no lungs or his lungs were collapsed. They drained his left lung of fluid and put him on a ventilator.

The second X-Ray revealed that Samuel was born with a Diaphragmatic hernia on the right side. We were told on Thursday evening by the doctor at Riverside that he would not make it through the night. The NICU team at Riverside was able to stabilize him. He was then transported to Children's Hospital that same night.

Explanation of a Diaphragmatic hernia:
http://www.nlm.nih.gov/MEDLINEPLUS/ency/article/001135.htm
http://www.cdhsupport.org/cdh/overview.php

During early Friday morning he became worse and had to be switched from a regular ventilator to an oscillating ventilator. All day Friday he responded well to the oscillating ventilator. He was slowly being weaned off the 100% oxygen. He went from 100% oxygen to 78% oxygen on Friday night.

Early Saturday morning his Oxygen level deteriorated and he had to be put back at 100% oxygen. Saturday afternoon he started doing better again. He is extremely sensitive to light and sound.

We so much appreciate each and every one of you that are praying. We can feel your prayers. We went from thinking about having to pick out a funeral home and a casket to having Samuel being fairly stable. Good is so good. Thank God for protecting my mom and dad. They came up to help a day early, before the freezing rain. Last night their brakes went out on the car. That also could have happened on the drive up.

As I have been saying to everyone that I come in contact with; God has a plan. My wife and I did not pick the conception. With my two girls I thought that I only made girls. God chose the baby to be a boy. God gave my wife the name for Samuel. God has a plan for the recovery of Samuel. We give him all the glory.

I will have more information later today.

Tuesday, December 2, 2008

Unable to attach to application 'WebDev.WebServer.EXE'







Unable to attach to application 'WebDev.WebServer.EXE' is one of the worst errors that I've encountered recently.


There are three work arounds for this error:

1. Reboot your machine.
2. Add paths to Norton Anti-Virus.
3. If you have a copy of two web projects in the same solution change the port and the file name.

Our solution contained a copy of two web projects. Both web projects were configured to use a specific port. We have a test harness that posts XML to a web page that required a specific port. Somewhere along the line, Visual Studio was confused; when one project was run, it actually tried to debug the old project.

Hopefully this information helps someone.

Friday, October 17, 2008

Does Miller's experiment prove evolution?

After reading this link about Miller's experiment, I decided to respond to it:
Miller's Experiment

In Miller's experiment the earth's atmosphere was assumed to be without oxygen. The problem is with no oxygen, there is no shield from harmful UV rays. This would have killed the "soup". Has anyone come up with a solution to this problem?

In the experiment both L and D stereotype amino acids were formed. Life only uses L stereotype amino acids. Does anyone know why that is?

What process combined the amino acids into DNA strands in the proper sequence? Does anyone know?

What process created the cell micro-machines that perform the translation of sections of DNA into messenger RNA? Does anyone know?

What process created the cellular protein regulation process? Does anyone know?

Some microbiologists spend their entire lives trying to understand the complex processes and information of cells. In the past, scientists believed that the cell was as simple as gelatin. The current understanding of the inner workings of a single cell is that it is equivalent to the complexity of the factories of General Motors and all of its part manufacturers. We still don't understand the main control process of the cell (when the cell is told to start making a protein and to stop making a protein). This is equivalent to the the inventory department at GM deciding to create more Chevy Cobalt Cars because those are in demand and stopping Chevy Suburban SUV production. What is staggering is the amount of information contained in the RNA to make a single protein. Similarly the design plans for a single General Motors car and the processes to create one are overwhelmingly complex.

To think that all the factories and processes of General Motors could be created accidentally is utter nonsense. In the Miller experiment essentially what they have created in General Motors terms is raw steel. Steel by itself doesn't create the design blueprint for the car (equivalent to an RNA section for a specific protein). Steel by itself doesn't create processes to build assembly line robots that build cars (equivalent to cell micro machines). Steel by itself doesn't create the transformers that convert the AC into DC to power the robots (cell glucose conversion into energy). Steel by itself can't create the process to create a new assembly plant (cellular mitosis; cell division).

Just as it is obvious that someone designed and built that car you are driving; it is obvious that someone designed and built proteins. Just as it is obvious that someone designed and created the processes of General Motors, it is obvious that someone designed and created the processes of cells. Each cell in your body has a specific purpose and works together with other cells. Doctor's still don't understand how everything works in the human body because it is so complex. There are around 300 cell categories. At this level, imagine a company 300 times the size and complexity of General Motors all working together. There is an estimated 10 million species on earth. At this level imagine a company 3 trillion times the size and complexity of General Motors.

Consider the biological process complexity. The processes and interactions between the processes are incomprehensible. Consider your job. Whether you flip burgers or are Joe the Plumber; processes don't happen by accident. At any level, you had some kind of training or education to do your job. Processes are designed.

But couldn't over millions of years the amino acids combine to create the DNA chains? Couldn't the processes be created by accident by the environment? Let's take that same argument to our GM example. Over millions of years, couldn't the raw steel create blueprints to create assembly line robots? Couldn't the raw steel create the assembly line robots? Couldn't the raw steel create the hardware programs and processes for the robots to create the cars? As silly as that sounds, the equivalent comparison is what evolutionists are claiming about amino acids. By itself, raw steel does nothing. By itself, amino acids do nothing.

Someone had to make the banana so you could eat it. Someone had to create the processes in your body to digest it. Someone had to make the bacteria in your intestine to break it down.

That someone is God.

Tuesday, October 7, 2008

Search & Replace SQL Characters

Here is how to replace m-dash characters with a dash character:


UPDATE Customer
SET CompanyName= REPLACE(CompanyName,CHAR(150),CHAR(45))
WHERE CompanyName Like '%' + CHAR(150) + '%'

Friday, August 8, 2008

SQL Server Object Dependencies

Paul Montgomery was kind enough to pass this one on. This is great for seeing what function or stored procedure is used by.


SELECT DISTINCT
o.name AS UsedBy
FROM Sys.sysdepends j
JOIN sys.objects o on o.object_id = j.id
JOIN sys.objects d on d.object_id = j.depid
WHERE d.name = 'MyFunctionOrStoredProcedureName'

Friday, August 1, 2008

Stored Proc that Runs Slow The 2nd Time

Recently we had a weird situation where we had a stored procedure that was being called twice with the same parameters. The first time, it executed in 3 seconds. The second time it actually timed out the ADO.NET connection because it took longer than 30 seconds. We were very puzzled by this and it took a long time to solve so I wanted to pass this information on.

Here is what was happening. SQL Server stores an execution plan for each combination of SET commands. We had the command SET ARITHABORT ON inside the stored procedure. The default for ARITHABORT is off for SQL Server. Basically when the connection logged in, the ARITHABORT was turned off. When the stored procedure ran, it was switched on. This switching forced SQL Server to use a different execution plan which was super slow.

The fix was to set the ARITHABORT on for the application user. You can set the ARITHABORT for the user or the database but not in a connection string. You can also set it right before the sproc is called.

Example:
SET ARITHABORT ON exec dbo.[MyGiantSproc]

See these other links for more information:
Set Database Options
Query Execution Plan Problems