admin on May 16th, 2009
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”.
admin on February 27th, 2009

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.

admin on February 27th, 2009

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.

admin on June 19th, 2008

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

Tags: , , , , ,

admin on June 16th, 2008

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.

Tags: , ,

admin on June 15th, 2008

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 the rest of this entry »

Tags: , ,

RSS
Copyright © 2010 Islander’s Analog life…. All rights reserved. Amazing Grace theme by Vladimir Prelovac.