Archive for category Uncategorized

Clearing the cache on Oracle and SQL Server

To clear the cache on Oracle:

ALTER SYSTEM FLUSH BUFFER_CACHE;
ALTER SYSTEM FLUSH SHARED_POOL;

To clear the cache on SQL Server:

CHECKPOINT;
GO
DBCC DROPCLEANBUFFERS;
GO

,

Leave a comment

SQL Server named instance vs. default instance

When you’re installing SQL Server (2008 R2 in my case) and you are prompted whether you want to create a default instance or a named instance, understand that creating a named instance means that you will be required to add that instance name to the server name when you connect via SQL Server Management Studio (SqlServerName\InstanceName). If you want to be able to connect to your instance without having to specify it explicitly, create a default instance. Then you just connect to SqlServerName and it finds the default instance.

Leave a comment

Life, death, and broken software

In a post titled Life, Death, and Splitting Secrets, Jeff Moser presents a software solution for splitting up a password N ways so your loved ones can put the secrets together and get access to critical information from you after your death, using a computer program.

While this shared secret approach is interesting for certain uses, it is unwise for Moser’s stated use… Read the rest of this entry »

Leave a comment

Easy peasy JPGs to PDF conversion

Our scanner at home is an old flatbed that scans to a .jpg file. When you have several pages that you need to scan and send to someone, a pile of JPGs isn’t very nice—you’d rather have one PDF.

If you’re running Linux (at home I’m currently running Fedora 20 – “Heisenbug”), this is easy peasy: with ImageMagick installed, just use the convert command:

convert 1.jpg 2.jpg 3.jpg 1-2-3.pdf

Leave a comment

Mumps-style “dotted do” notation example

FT                                      # A label (for jumping to)
  NEW X,MSG2
  I $$RDVALS^MISC22()=SUCCESS DO QUIT   # The second space between DO and QUIT is significant
  . S X="DO ACTN5^ACTNS"
  . X X                                 # The two Xs mean different things (Cache' is not a context-free language)
  . S MSG2=MSG_" succeeded."            # Expect MSG to float in from somewhere else
  E DO
  . S ERRMSG=INVALIDREADMSG
  . W 1/0

Leave a comment

Method signature joke

STDMETHODIMP CI3DBTranDataSet::GetReal(), man.

Leave a comment

Gerald M. Weinberg

Today, while looking for the Reasons article about which I just posted, I found out that Jerry Weinberg has recently come out of what was supposed to be terminal cancer. I was moved to write him this letter, which I sent this morning:

June 3, 2010

Gerald Weinberg
c/o Dorset House Publishing Co.
3143 Broadway, Suite 2B
New York, New York 10027 USA

Dear Mr. Weinberg,

As a computer programmer of thirteen years, I have read and benefited from your writing – specifically, Exploring Requirements and Are Your Lights On? Thank you for working to understand what’s wrong with how the people within software development organizations think and articulating what needs to change and how. Your work has made a difference to me.

I went to your website this morning and saw that you have had a battle with cancer. Recently you were declared cancer-free — praise God for that!

Mr. Weinberg, you have had a brush with death, and because I love you I need to warn you of the Day of Judgment that we all will face. On that day, what will you say to the King?

I do not know the state of your soul before God, but I implore you, please do not deny the existence of the King. God who made the heavens and the earth and gave you every breath you’ve ever taken rules in righteouness, and he will call you to account one day. All have sinned and fall short of the glory of God. Only those who repent and believe in Jesus Christ will be saved.

Oh Mr. Weinberg, repent and be saved!

Sincerely and with love,
Daniel S. Meyer

I don’t have a mailing address for Mr. Weinberg, and I don’t know if his publisher will forward it on to him. Even if they do, how likely is Mr. Weinberg to repent? Am I not a fool for doing such a thing — not to mention for advertising it here? Where is my respectability?

Brothers who are in Christ: souls are at stake. Fool or no, I care about Mr. Weinberg’s soul. On Judgment Day I want to be able to look in the eyes of all, knowing I was faithful to warn.  And may God grant repentance to those He has chosen!

Leave a comment

Follow

Get every new post delivered to your Inbox.