Islander’s Analog life….

.. In a digital ocean

Islander’s Analog life…. header image 1

Back to English English to German English to Spanish English to French English to Italian English to Portuguese English to Dutch English to Greek English to Russian English to Swedish English to Norwegian English to Afrikaans English to Brazilian Portuguese English to Bahasa Indonesia English to Nippon English to Korean English to Simplified Chinese English to Traditional Chinese

Save is not permitted in SQL Server 2008

May 16th, 2009 · No Comments

In SQL Server 2008, you might have gotten this message when trying to change the columns in some tables, add columns or change nullity conditions. “Save is not permitted” tables have to be dropped and re-created.  The only choice you have is to click cancel, or to choose to save the message to a text file, which is, i think, not very useful .
Here is the solution:
Tools -> Options -> Designers, and unchecked the option “Prevent saving changes that require table re-creation”.

→ No CommentsTags: Microsoft Sql Server 2008 · technology

Back to English English to German English to Spanish English to French English to Italian English to Portuguese English to Dutch English to Greek English to Russian English to Swedish English to Norwegian English to Afrikaans English to Brazilian Portuguese English to Bahasa Indonesia English to Nippon English to Korean English to Simplified Chinese English to Traditional Chinese

New Stock Market Math

February 27th, 2009 · No Comments

If you had purchased $1000 of shares in Delta Airlines

one year ago, you will have $49.00 today.

If you had purchased $1000 of shares in AIG

one year ago, you will have $33.00 today.

If you had purchased $1000 of shares in Lehman Brothers

one year ago, you will have $0.00 today.

But—- if you had purchased $1000 worth of beer

one year ago, drank all the beer,

then turned in the aluminum cans for recycling refund,

you will have received $214.00.

Based on the above, the best current investment plan

is to drink heavily & recycle.

It’s called the  401-Keg.

→ No CommentsTags: Life · Wealth · finance

Back to English English to German English to Spanish English to French English to Italian English to Portuguese English to Dutch English to Greek English to Russian English to Swedish English to Norwegian English to Afrikaans English to Brazilian Portuguese English to Bahasa Indonesia English to Nippon English to Korean English to Simplified Chinese English to Traditional Chinese

New Stock Market Terms

February 27th, 2009 · No Comments

CEO – Chief Embezzlement Officer

CFO -  Corporate Fraud Officer

BULL MARKET – A random market movement causing an investor to mistake himself for a financial genius

BEAR MARKET – a 6 to 18 month period when the kids get no allowance, the wife gets no jewelry, and the husband gets no sex.

VALUE INVESTING – The art of buying low and selling lower.

P/E RATIO – The percentage of investors wetting their pants as the market keeps crashing.

BROKER – What my financial planner has made me.

STANDARD & POOR – Your life in a nutshell.

STOCK ANALYST – Idiot who just downgraded your stock.

STOCK SPLIT – When your ex-wife and her lawyer split your assets equally between themselves.

MARKET CORRECTION – The day after you buy stocks.

CASH FLOW – The movement your money makes as it disappears down the toilet.

YAHOO – What you yell after selling it to some poor sucker for $240 per share.

WINDOWS – What you jump out of when you’re the sucker who bought Yahoo at $240 per share.

INSTITUTIONAL INVESTOR – Past year investor who’s now locked up in a nuthouse.

PROFIT – an archaic word no longer in use.

→ No CommentsTags: Life · Wealth · finance

Back to English English to German English to Spanish English to French English to Italian English to Portuguese English to Dutch English to Greek English to Russian English to Swedish English to Norwegian English to Afrikaans English to Brazilian Portuguese English to Bahasa Indonesia English to Nippon English to Korean English to Simplified Chinese English to Traditional Chinese

SQL Server Native Client 10.0

June 19th, 2008 · No Comments

The new SQL Server Native Client 10.0 app appears not to return the password back when using Delphi’s ADO PromptDataSource

Update: 6/20/2008
There is definitely a bug in the Dialog not in the PrompDataSource.  The solution is posted at the end of the article.

Microsoft SQL Server 2008 installs a new OLE DB Provider called: “SQL Server Native Client 10.0” Here is the Data Link Properties image:

datalinkproperties_b.JPG

Bringing up the ADO Connection Dialog:

CS  := PromptDataSource( Handle, "");

One change I can see is that using Delphi’s PrompDataSource function, it returns a different string than previous providers.  The Password field seems to be missing:

'Provider=SQLNCLI10.1;Integrated Security="";Persist Security Info=False;User ID=sa;Initial Catalog=XIMS;Data Source=(local);Initial File Name="";Server SPN=""'

Here is the output from PrompDataSource using Microsoft OLE DB  Provider for SQL Server:

'Provider=SQLOLEDB.1;Password=1234;Persist Security Info=True;User ID=sa;Initial Catalog=Rome;Data Source=(local)’

Here is an image of the old Data Link Properties editor:

datalinkproperties_d.JPG

The new Dialog has three key differences :

  1. You can used mix mode authentication (nothing new here) but also use Windows NT Integrated Security and specify a Server SPN(service principal name).  This is quite flexible.  For more info click here
  2. Be able to attache a database file as a database Name - I am guessing this is here due to all the enhancements SQL Server 2008 offers in regards to backing up, restore, compression and encryption database files.
  3. Be able to Change the database password directly from this page.

If you find out how to retrieve the “whole” string let me know.

Solution: go into the ALL tab and make sure you set Persist Security Info to TRUE the default (today) is FALSE (thanks Ken!)

datalinkproperties_e.JPG

You might be interested in finding out what’s new in SQL Server 2008

→ No CommentsTags: ADO.NET · Delphi · Microsoft Sql Server 2008 · technology

Back to English English to German English to Spanish English to French English to Italian English to Portuguese English to Dutch English to Greek English to Russian English to Swedish English to Norwegian English to Afrikaans English to Brazilian Portuguese English to Bahasa Indonesia English to Nippon English to Korean English to Simplified Chinese English to Traditional Chinese

401(k): Saving enough?

June 16th, 2008 · No Comments

One in ten workers…

According to the June 14th, 2008 edition of The Wall Street Journal, fewer than one in ten workers save the maximum amount allowed in a 401k plan.

Giving away free money

More disturbing one-third of 401k participants are not saving enough to qualify for the full matching contribution from their employer.

→ No CommentsTags: Life · Wealth · finance

Back to English English to German English to Spanish English to French English to Italian English to Portuguese English to Dutch English to Greek English to Russian English to Swedish English to Norwegian English to Afrikaans English to Brazilian Portuguese English to Bahasa Indonesia English to Nippon English to Korean English to Simplified Chinese English to Traditional Chinese

ADO.NET Entity Framework 101

June 15th, 2008 · No Comments

Note: To use the ADO.NET Entity Framework you are going to need Visual Studio 2008 + SP1

What is it?

Basically it allows you to create a model of your database and map objects to relational data (classes).  It marries classes to tables.  Using LINQ you can easily query the classes auto generated by the model.

Quick Sample

Step #1

Add New Item to your project “ADO.NET Entity Data Model ” (generates edmx file)

addnewitem.jpg

[Read more →]

→ No CommentsTags: ADO.NET · LINQ · Visual Studio 2008 · science · technology