Home

Previous 20

Sep. 2nd, 2009

with battery, child, sleepy, childhood

The accidental DBA

Posted via email from apoorvs's posterous

with battery, child, sleepy, childhood

FriendFeed IM down

Posted via email from apoorvs's posterous

Aug. 31st, 2009

with battery, child, sleepy, childhood

Truck parked partly on pavement

I captured this en-route to work a few weeks ago

Posted via email from apoorvs's posterous

Sep. 15th, 2008

with battery, child, sleepy, childhood

Cool tip: finding all FKs to disable them for a bulk load

SELECT

C,C,KCU,C2,C2,C2,KCU2,RC,RC,C,C2

C.TABLE_CATALOG [PKTABLE_QUALIFIER], .TABLE_SCHEMA [PKTABLE_OWNER], .TABLE_NAME [PKTABLE_NAME], .COLUMN_NAME [PKCOLUMN_NAME], .TABLE_CATALOG [FKTABLE_QUALIFIER], .TABLE_SCHEMA [FKTABLE_OWNER], .TABLE_NAME [FKTABLE_NAME], .COLUMN_NAME [FKCOLUMN_NAME], .UPDATE_RULE, .DELETE_RULE, .CONSTRAINT_NAME [FK_NAME], .CONSTRAINT_NAME [PK_NAME], CAST(7 AS SMALLINT) [DEFERRABILITY]

FROM

 INFORMATION_SCHEMA

.TABLE_CONSTRAINTS C INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE KCU ON C.CONSTRAINT_SCHEMA = KCU.CONSTRAINT_SCHEMA AND C.CONSTRAINT_NAME = KCU.CONSTRAINT_NAME INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS RC ON C.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND C.CONSTRAINT_NAME = RC.CONSTRAINT_NAME INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS C2 ON RC.UNIQUE_CONSTRAINT_SCHEMA = C2.CONSTRAINT_SCHEMA AND RC.UNIQUE_CONSTRAINT_NAME = C2.CONSTRAINT_NAME INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE KCU2 ON C2.CONSTRAINT_SCHEMA = KCU2.CONSTRAINT_SCHEMA AND C2.CONSTRAINT_NAME = KCU2.CONSTRAINT_NAME AND KCU.ORDINAL_POSITION = KCU2.ORDINAL_POSITION

WHERE

C.CONSTRAINT_TYPE = 'FOREIGN KEY'

from: http://www.mssqltips.com/tip.asp?tip=1151
with battery, child, sleepy, childhood

No schema compare!





Also, https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=365718

Oct. 20th, 2007

with battery, child, sleepy, childhood

Trying CouchDB: Day 1

http://localhost:8888/$utils/peek.html

Create DB: A database must be named with all lowercase characters (a-z), digits (0-9), or any of these characters `_$()+-/` and must end with a slash in the URL.

1> [info] [<0.152.0>] HTTP Request: PUT /try1/ HTTP/1.1
Header:[{"cache-control","no-cache"},
        {"connection","Keep-Alive"},
        {"content-length","0"},
        {"host","localhost:8888"},
        {"user-agent",
         "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0
.50727; .NET CLR 3.0.04506; .NET CLR 1.1.4322; MS-RTC LM 8)"},
        {"accept-encoding","gzip, deflate"},
        {"ua-cpu","x86"},
        {"referer","http://localhost:8888/$utils/peek.html"},
        {"accept-language","en-us"},
        {"accept","*/*"}]
1> [info] [<0.152.0>] HTTP Response Code:201

Create document:

1> [info] [<0.165.0>] HTTP Request: POST /try1/ HTTP/1.1
Header:[{"cache-control","no-cache"},
        {"connection","Keep-Alive"},
        {"content-length","142"},
        {"host","localhost:8888"},
        {"user-agent",
         "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0
.50727; .NET CLR 3.0.04506; .NET CLR 1.1.4322; MS-RTC LM 8)"},
        {"accept-encoding","gzip, deflate"},
        {"ua-cpu","x86"},
        {"content-type","text/xml; charset=UTF-8"},
        {"referer","http://localhost:8888/$utils/peek.html"},
        {"accept-language","en-us"},
        {"accept","*/*"}]
1> [info] [<0.165.0>] HTTP Response Code:201

  <?xml version="1.0" ?>
- <doc id="60CF2C862F0EB074646574E28DD71919" rev="D4BA5040" xmlns="http://couchdb.org/doc">
- <field name="FirstName">
  <text>Apoorv</text>
  </field>
- <field name="LastName">
  <text>Shrivastava</text>
  </field>
  </doc>

Create table:

/* Tables are just special documents, but don't forget to give them unique names! */

* Set the table statement. You can use the fabric language for that.
     * Note that every field has to start with $table_ !
     */
select statement: select *

Oops!

  <?xml version="1.0" ?>
- <doc id="1" rev="F2CD1E07" xmlns="http://couchdb.org/doc">
- <field name="$table_$table_1">
  <text>select *</text>
  </field>
  </doc>

now:

Table id : 60CF2C862F0EB074646574E28DD71919
Table name : keeda_tablewithidsameasanotherexistingdocument
Select Statement : select *

1> [info] [<0.214.0>] HTTP Request: POST /try1/ HTTP/1.1
Header:[{"cache-control","no-cache"},
        {"connection","Keep-Alive"},
        {"content-length","171"},
        {"host","localhost:8888"},
        {"user-agent",
         "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0
.50727; .NET CLR 3.0.04506; .NET CLR 1.1.4322; MS-RTC LM 8)"},
        {"accept-encoding","gzip, deflate"},
        {"ua-cpu","x86"},
        {"content-type","text/xml; charset=UTF-8"},
        {"referer","http://localhost:8888/$utils/peek.html"},
        {"accept-language","en-us"},
        {"accept","*/*"}]
1> [info] [<0.214.0>] -HTTP Error-
        Response Code: 409.
        Error id: conflict
        Error message: conflict
1> [info] [<0.214.0>] HTTP Response Code:409

Oct. 1st, 2007

with battery, child, sleepy, childhood

Haiku Operating System

 

Haiku Operating System rocks! Absolutely!!

Always wanted to try the BeOS ... read a lot, couldn't touch it. Great work!

with battery, child, sleepy, childhood

Interesting timeline

 

Share This : Timeline — Google, Yahoo!, Microsoft, & Amazon

Sep. 20th, 2007

with battery, child, sleepy, childhood

Orkut's new limit on album size

OrkutNewAlbumSize 

Orkut has increase the maximum number of photos in an album from 12 to 25.

Sep. 10th, 2007

with battery, child, sleepy, childhood

Looks like Mariners can only win over the Tigers!

Mariners score 13 runs in first 4 innings against Tigers and cruise to 14-7 win

with battery, child, sleepy, childhood

I, Simpsonized

I, Simpsonized

with battery, child, sleepy, childhood

Nerd Test 2 details

Your Score Summary

For Science/Math:

4% scored higher,
0% scored the same, and
96% scored lower.

For Computers/Technology:

1% scored higher,
1% scored the same, and
98% scored lower.

For Sci-Fi/Comic:

44% scored higher,
5% scored the same, and
51% scored lower.

For History/Literature:

24% scored higher,
4% scored the same, and
72% scored lower.

For Dumb/Dork/Awkwardness:

54% scored higher,
15% scored the same, and
31% scored lower.

with battery, child, sleepy, childhood

Nerd Test 2

NerdTests.com says I'm a Nerd God.  What are you?  Click here!
with battery, child, sleepy, childhood

Nerd test 1

I am nerdier than 90% of all people. Are you a nerd? Click here to find out!

Sep. 9th, 2007

with battery, child, sleepy, childhood

Vista blocks IE

 

Vista blocks IE

Aug. 9th, 2007

with battery, child, sleepy, childhood

Jabra BT620s - Stereo Bluetooth headset for music phones and iPod, MP3 players

 

My 

Jabra BT620s - Stereo Bluetooth headset for music phones and iPod, MP3 players

rocks :-)

Jul. 28th, 2007

with battery, child, sleepy, childhood

Saw "Star Trek: Nemesis" today

 

Star Trek: Nemesis - Wikipedia, the free encyclopedia

Quotable quotes:

Data: I will always be puzzled by the human predilection for piloting vehicles at unsafe velocities.

Jean-Luc Picard: [while being shot at during a car chase] I think it's time to try some unsafe velocities!

Data: I must deactivate you.
B-4: For how long?
Data: Indefinitely.
B-4: How long is that--
Data: A long time, brother.

Jul. 26th, 2007

with battery, child, sleepy, childhood

Radio is good

 

http://66.238.65.109/bollywood

Windows Media Audio V2
16 kbps, 16 kHz, stereo

Jul. 17th, 2007

with battery, child, sleepy, childhood

Zen TV Experiment

 

A good read ...

Some nice observations:

  1. When you turn the TV on, in effect, you turn the world off. The TV is only two feet high or so, yet we are fooled into thinking we are watching life-sized things. How is it that everything on it appears real and life-like?
  2. To watch TV programs is to be lifeless and unresisting. This is the state that allows the commercials to take full effect and operate our minds for us.
  3. As one formula puts it, Media Power = Political Power Squared The TV has shown us that politicians can't be trusted but TV can. That is, according to Joshua Meyrowitz in No Sense of Place, implicit in showing us this about politicians is the message, "We who are showing you this, the TV, can be trusted." We can trust TV, and the institution of TV, to reveal how politicians and the institution of politics can't be trusted.
  4. In the words of Mat Maxwell, "Television becomes the world for people... . The world becomes television."

Is the future of video games too? In particular, the parallels?

Zen TV Experiment

Jul. 16th, 2007

with battery, child, sleepy, childhood

Slow down and enjoy the Vista animations

 

Slow down and enjoy the Vista animations

Slow down and enjoy Vista ... and I thought I was the only one thinking about how Vista Animations slow you down!

Previous 20

with battery, child, sleepy, childhood

September 2009

S M T W T F S
  12345
6789101112
13141516171819
20212223242526
27282930   

Advertisement

Syndicate

RSS Atom
Powered by LiveJournal.com