36 Chambers – The Legendary Journeys: Execution to the max!

July 30, 2009

Quick Database Hits

Filed under: Programming & Work — Kevin Feasel @ 10:50 pm

- Here’s an article on unit testing databases that is on my agenda.  I’d like to start building some unit tests for more difficult stored procedures, and one of the things I will be responsible for as a DBA is making sure that stored procs don’t destroy the server, so I would like to take an active role in writing good tests for these procedures.

- I really need to spend some time learning what DMVs are available.  In the meantime, here are a few DMV queries that look helpful.

- Finally, I’m looking at doing some processing to discover the number of transactions per minute per database.  It looks like there are some methods, but I don’t know that I feel comfortable running Profiler or a trace for quite a while, and I’m also not sure that querying sys.dm_tran_database_transactions will give me exactly what I want.  Admittedly, I haven’t looked at it yet, but that’s an assignment for the near future and not right now…

July 29, 2009

Solving All The Problems Of The World

Filed under: Curmudgeonliness, General Stupidity — Kevin Feasel @ 5:45 pm

With poll tests being unconstitutional, land ownership doesn’t sound like a bad pre-requisite for voting if it means that she can’t vote anymore.

July 28, 2009

Notes

Filed under: Chicagoland, Curmudgeonliness, Economics — Kevin Feasel @ 6:41 pm

- The “stimulus” wasn’t supposed to provide a “jolt,” says Joltin’ Joe Biden.  Ignore what he said before. After all, everybody else does.

- Guys like this are the fundamental problem with reforming government. The government makes dependent constituencies and you can’t get rid of the program afterward.

- How a bill becomes a law, Chicago-style. This is Hopenchange.

July 26, 2009

In The Papers: The Red Flag Of Revolution

Filed under: Curmudgeonliness, Economics, In The Papers — Kevin Feasel @ 10:58 am

I am a Burkean conservative.  As an implication of this, I hate the French Revolution with a passion.  It was a disaster which afflicted Europe ever since, and was a direct influence of one of the twin evils of the 20th century.

I came into Daron Acemoglu, et al’s The Consequences of Radical Reform:  The French Revolution with that mindset.

Abstract:

The French Revolution of 1789 had a momentous impact on neighboring countries. The French Revolutionary armies during the 1790s and later under Napoleon invaded and controlled large parts of Europe. Together with invasion came various radical institutional changes. French invasion removed the legal and economic barriers that had protected the nobility, clergy, guilds, and urban oligarchies and established the principle of equality before the law. The evidence suggests that areas that were occupied by the French and that underwent radical institutional reform experienced more rapid urbanization and economic growth, especially after 1850. There is no evidence of a negative effect of French invasion. Our interpretation is that the Revolution destroyed (the institutional underpinnings of) the power of oligarchies and elites opposed to economic change; combined with the arrival of new economic and industrial opportunities in the second half of the 19th century, this helped pave the way for future economic growth. The evidence does not provide any support for several other views, most notably, that evolved institutions are inherently superior to those ‘designed’; that institutions must be ‘appropriate’ and cannot be ‘transplanted’; and that the civil code and other French institutions have adverse economic effects.

To be honest, I think that the final sentence in the abstract is taking things quite a bit too far.  For the paper to show that “evolved institutions are not inherently superior to those ‘designed,’” the “evolved” institutions that did so much worse have to be, well, evolved.  The problem here, however, is that 1790s Prussia, Russia, and Austro-Hungary were far from spontaneous orders—rather, they were quite authoritarian given their technological constraints.  When Thaddeus Kosciuszko tried to free Poland as he had helped to do in America a decade and a half earlier, the Prussians in particular were livid, as they knew that a free Poland would draw serfs (who could become citizens) and allow Poland to become the central European industrial power that Prussia wanted to become.  So instead of freeing the serfs or opening up additional avenues to spontaneous order, the Prussians clamped down and helped destroy the Polish revolution.

The work that Acemoglu, et al, have done does show that French economic institutions were superior to serfdom, at least in the long run.  There is value in that, and they point out several times that they are not making a stand on the French Revolution as a whole, but instead are investigating the economic results of policy changes.  The problem, however, is that I see a problem in the comparison.  Basically, we’re comparing the states and principalities around Europe during the French Revolution (excluding France), and seeing how they did afterwards.  That’s a reasonable thing to do, and based on that comparison, one result of the French Revolution was that French-occupied territories tended to have better economic development a half-century or so later than those with relatively less French influence.  One major exception here is Great Britain, though they were still included in the data set, so the results include this outlier.

But there’s an alternative which I think would have been greatly superior to both setups as they were:  what the British and Americans accomplished and what the Polish tried to do:  develop government-limiting institutions, free their populaces, and promote liberty and order as opposed to Terror and Napoleon.  That would have been significantly better than what did happen.

July 25, 2009

In The Papers: Offsetting Behavior

Filed under: Economics, In The Papers — Kevin Feasel @ 10:34 pm

While in Germany this year, I wandered into the economics library one day and decided to grab some journals and find interesting articles.  One of the journals I grabbed was the Southern Economic Journal, and specifically, the 2008 edition.  In there, I found an article entitled Automobile Safety Regulation and the Incentive to Drive Recklessly:  Evidence From NASCAR.

Abstract:

When safety regulation makes automobiles safer, drivers may drive more recklessly, creating partially or completely offsetting effects on the overall level of safety. Evidence of these offsetting effects has been hard to find, however, primarily because of the aggregate nature of accident data. In this paper we explore how changes in the safety of automobiles used in NASCAR has altered the incentive of drivers to drive recklessly. This unique data set allows more accurate and objective measurement of the necessary variables to test for these effects at a micro-level. Our results strongly support the presence of these offsetting behavioral effects.

This was a rather interesting article, indicating that NASCAR drivers really do seem to engage in offsetting behavior.  Cited in this article, however, were a couple of articles co-authored by my favorite economics professor back at Dayton.

The first is The Effectiveness of Vehicle Safety Inspections:  An Analysis Using Panel Data (SEJ, 1999, 65(3) pp 571-583).  In this article, the authors look at state-by-state vehicle inspection laws, which are written under the assumption that states which mandate vehicle safety checks are more likely to have safer drivers, as there will be less of a chance of encountering a dangerous car on the road.  The idea of offsetting behavior, however, is that people have an inherent amount of risk that they are willing to bear.  By decreasing the risk (with seatbelt laws, safety inspections, airbags, etc.), people are more willing to make stupid decisions while driving, as the cost of a stupid decision is lower.  People chat on cell phones, put on makeup or shave, drink coffee, and generally don’t pay attention to the road.  Thus, individual behavior will offset legal mandates.  In this article, the authors find that this is potentially the case:  states which mandate safety inspections do not have fewer fatalities or injuries than states which do not.  They point out in the conclusion that this would be due to several potential effects—offsetting behavior, the inability of safety inspections to do their job appropriately, people going to mechanics who pass all cars, and individuals internalizing the costs of damage to their cars so that they already replace the dangerous parts.

So, a few years later, Poitras and Sutter (two of the original authors) come back with Policy Ineffectiveness or Offsetting Behavior?  An Analysis of Vehicle Safety Inspections.  In this paper, the authors decide that offsetting behavior is, in fact, not the best reason for the observation that safety inspections don’t work.  Rather, they argue that the policy itself is ineffective—that people purposefully go to mechanics who will pass them off with a cursory inspection or will find other ways around dealing with the hassle of inspections.

So we can see that offsetting behavior can play a reasonable role in risk-taking activity, but there are other reasons why safety policies might fail rather than the individuals in a regime purposefully scaling up their risky behavior to reach the equilibrium—these policies simply don’t do the job that they’re supposed to on paper.

July 24, 2009

Yet More Notes

Filed under: Curmudgeonliness, Economics — Kevin Feasel @ 5:21 pm

- Note to politicians:  things are not going well when your constituents laugh at you.  And I would like an answer to that last question:  if ObamaCare will be so great, why isn’t Congress forced to take it as well?  Oh, that’s right:  they’re privileged enough that they’ll actually get health care.  It’s the British system all over again:  government officials and wealthy elites get the care that other people lose.

- The black market for tobacco is waxing.  This is a critique of the “legalize, tax, and regulate” argument for drugs.

- We need free markets, not crony capitalism.  Unfortunately, “too big to fail” implies the latter, as failure is an important part of free markets.

- Political Calculations has a good post on the problems of “getting off of oil dependency.” In short, we use oil because oil is extremely efficient for what we need.  Any other energy source has to be more economically efficient, which is some combination of technical efficiency and low-price.  Then, just to humiliate the rest of us, they pile on with a second great point within the same article—this time on the differences in incentives between a private system and a government-run system.

- Ignore the higher budget deficits.  These are not the droids you are looking for.

July 23, 2009

Walter Williams On Good Intentions

Filed under: Economics — Kevin Feasel @ 8:55 pm

Here is an old documentary from 1982. Walter Williams remains as awesome as ever.  Special note:  Charles Murray wins the “Geekiest Guy In The Documentary” award, though he faced some very tough competition.

July 22, 2009

Budgetary Notes

Filed under: Curmudgeonliness, Economics — Kevin Feasel @ 8:24 pm

- The US budget is so lean that they can’t even find $100 million to strip out.  Hey, Obama administration:  I can strip out $1 trillion without breaking a sweat.  Probably $2 trillion or so.  For $10 million, I’ll gladly do that for you.

- I’m honestly pretty amazed at how Ohio did its budgeting process.  I didn’t like how they snuck in gambling revenues that voters didn’t want, but the GRF expenditures are actually lower for SFY 2010 than 2009.  Here is the link for 2010-2011, and you can switch the years in the link to 0809 or 0607 for older references.  From that, we get the following (non-inflation-adjusted) dollar amounts, in billions:
SFY 05 – $24.830
SFY 06 – $25.302
SFY 07 – $25.953
SFY 08 – $25.669
SFY 09 – $27.222
SFY 10 – $26.069
SFY 11 – $28.628

Inflation-adjusting the SFY 05 $24.830 billion, you would get with no increase in real budget, according to the Bureau of Labor Statistics inflation calculator (and I’m using the year before, so SFY05 is using the 2004 inflation rate):
SFY 05 – $24.830 (actual budget = 100% of inflation-adjusted SFY 05 budget)
SFY 06 – $25.671 (actual budget = 98.6% of inflation-adjusted SFY 05 budget)
SFY 07 – $26.499 (actual budget = 97.9% of inflation-adjusted SFY 05 budget)
SFY 08 – $27.254 (actual budget = 94.2% of inflation-adjusted SFY 05 budget)
SFY 09 – $28.301 (actual budget = 96.2% of inflation-adjusted SFY 05 budget)
SFY 10 – $28.352 (actual budget = 91.9% of inflation-adjusted SFY 05 budget)
SFY 11 – ?????

SFY 11 will more than likely reverse the recent trend of decreased government spending, but all in all, I’m actually surprised that Taft and Strickland have done a pretty good job of limiting GRF expenditures they way they have.  Economic circumstances didn’t help, but I will say that Ted Strickland could be a lot worse as a governor.  I’ll more than likely vote for John Kasich when the next gubernatorial election comes around, but against an establishment Republican (like the aforementioned Taft), I probably would vote for Strickland, as long as Republicans keep control of the state Senate (and ideally, gain control of the House).

July 21, 2009

We Hate Production Anyhow

Filed under: Programming & Work — Kevin Feasel @ 8:56 pm

I ran a query today which brought down the production and development servers simultaneously.  It had so many linked connections that it hurt development performance, killed my SQL Server Management Studio instance, and locked up production.  I was quite proud of myself…

In addition, there was some water damage in the server room over the weekend.  That killed a couple of servers, but we figured that production was okay because it didn’t show any problems.  This morning, though, the server shut down twice, complaining about its connection to the SAN.  While the network staff is trying to keep it alive, we’re also working on a “warm swap” server where, if production goes down, we can move the data over to this server and have it up and running within a few hours, rather than having to wait several days.  In the meantime, we’ve also been looking to do a long-term change, moving the production server to a new blade, and this might move their schedule ahead a little bit.

July 20, 2009

Rationing: The Rational Choice

Filed under: Curmudgeonliness — Kevin Feasel @ 7:40 pm

I can see this wonderful video appearing in Fallout 4.  Also check out the neat-o Health Administration Bureau webpage!

Older Posts »

The Silver is the New Black Theme. Create a free website or blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 75 other followers