• [0] Galaxy Book Flex 13.3?:  1.15k., Ice Lake, 63WhLPDDR4x?
  • [2] "HP Elite Dragonfly" 13.3? : 1.14k. (2.5lbs.), 8thGenWiskeyLake, WIFI6nanoSIM, $1150, 24hr. four-cell 56Wh. & 1W FHD (400nits). --Old; HP teased that a refreshed iteration next year may feature 10thGen Ice Lake.
  • [1] "LG gram 14" 2-in-1 (model 14T90N--2020): 1.15k. (2.53lbs.), 10thGen, $1500, 20hr. ?-cell 72Wh, . --?GB of RAM; LTE?, , eSIM?. prnewswire.com/news-releases/new-lg-gram-lineup-proves-that-portability-performance-and-battery-life-can-coexist-300972820.html  "That's not bad going at all, although the use of DDR4 instead of LPDDR4X may raise some eyebrows.   .... it'll only support up to 16GB of RAM, but in exchange, LG reckons it'll last over 20 hours on 1 charge."
  • "HP spectre x360" 13.3 : 1.30/.27k. (2.88lbs.), 22hr. ?Wh,
  • "Fujitsu Lifebook" 14 : . 
pl: allegro.pl/laptopy-uszkodzone-4180,  mediamarkt.pl,  saturn, twenga-solutions.com/en/insights/ecommerce-poland-facts-figures-2016
de: new: idealo.de , used: heinzsoft-shop.de

C: > Users > Owner > My Documents > Visual Studio 2010 > WebSites > WebSite1 


Schema : Religio Proto-Indo-European Est Ab Origine

                          "The New Testament is the gospel of a completely ignoble species of man; its pretensions to the highest values—indeed to all values, is as a matter of fact, revolting even today."  (Nietzsche)  
  • Aborigine European-identity insight :  Proto-Indo-European (3500 B.C.), originally, from the beginning ("est ab origine"), had the same supreme god ("lord god", "father"—as in ancester worship).  Filling the sovereign function over other gods ;  a sovereignity upon which kingship could be built.  All of these 9+ branches of Indo-European languages, etymologically, reference the same oldest supreme, "shinning/daylit/sky"-father, god/deva/dewos/theos/divine—the same proto-IE root stem word meaning "to shine" (deity, wikipedia.org/wiki/Dyeus ;  but English "day" is from a different root) :  Dag-da "day/shining-divinity" (Celtic) | Týr father ᛏ (Teutonic) | Ju-piter (Latin) | Zeû[s] Pater the europa ("wide-eyed" thus all seeing) was the word used to refer to Zeus ;  later used to name the continent and it's aborigines. (Hellenic) | Deivos, later called Rod. (Slavic) | Dievas (Baltic)Tiwaz (Anatolian) | "Dyeus Pita" "the all-seeing god" (Vedic Sanskrit) | Daeva (Avestan Zend).  (Suffix us/os/os/as/az/óss "meaning "god".)      ...All these "daylit" names are dialectical variants of the same word. 
    Or, as the later, Iron Age, Julian the Apostate, the last non-Christian emperor of the Roman Empire (Constantinople), writing on Jupiter allegorically wrote, "...the Sun is the parent of us all... ...[like] 'The One,'... ...the light of the Sun bears the same relation to things visible as Truth does to things intelligible. ...this Whole... ... ...One indeed is the Creator of all things... ... ...the source... ... ...soul... ... ...the 'Invincible Sun,'..."  (tertullian.org/fathers/julian_apostate_1_sun.htmᛋ  
  • In SlavicTeutonic, and Baltic mythologies, the world was represented by a sacred tree, usually an oak.  "True" etymology is "tree" (Celtic, Teutonic, Baltic).  ("The original meaning of the root was doubtless 'to be firm, solid,' and from it is derived not only the family of English TREE but also that of English TRUE. Note that the semantic evolution has here been from the general to the particular, from 'solid' to 'tree' (and even 'oak' in some dialects), and not the other way around.")  In the native religion of Baltic Latvia, the word "faith" means tree (as does the same root for Celtic "druid", tru-wit) ;  their ancient symbol is Austras Koks "sun-tree" (Baltic) (and their other symbol swastika 卍 ).  Akin to the Irmin-sûl (Teutonic) meaning Aryaman(Vedic)-schaft (akin to Yggdrasil) pillars devoted to the supreme daylit-god, ref. Widikund 970 A.D. ;  "Jupiter Columns" (Latin) ;  and Kalpavriksha (Vedic) tree-of-life/"world tree" or the Ashvattha bodhi tree (Rg-Veda and Upanishad) ;  and axis mundi (Latin) meaning pillar of world ;  Maypole (Teutonic, Baltic). 
                 “To the Ancient Egyptians, the Tree of Life represented the hierarchical
    chain of events that brought everything into existence.”
  • Heilbringer/Hælend—healer/holier/savior/son of god (from whole, holy/Hālig, das Heilige (the sacred), heal, heil/hail/wassail/hello/hi, heal, health (Teutonic)) :  Krishna (Vedic), Mitra (Avestan), Óðinn/Wōdan/*Wōðanaz ("lord of frenzy") (Teutonic) stem meaning "raging"wot (god), word, whisper, water, wet, wise, wit, veda, and witch/wicca/wizard are all from this stem ;  related to vātēs (Latin) and fáith (Celtic) both meaning "seer, prophet", Dio-nysus (Hellenic) etymology is "deity of (world-)tree" the axis mundi.  "As a part of the Frazerian 'dying god' myth, it is a symbolic victory of growth over stagnation or dormancy in the cycle of the year, and ultimately a victory of rebirth over death."  "The hero as archetypal scapegoat or eniautos daimon [sun king/year king].") 
    • "The traditional Old English dragon slaying formulas :  wyrm acwealde 'killed the worm'."  (Thor slays serpent.  Indra, the "dragon-slayer", slays serpent.)  Calvert Watkin's singular Indo-European formula, "Hero slays [gwhen] dragon [snake, worm]."  Hero "overcomes" death/"resistance", says Watkins of the Sanskrit word stems.  —The fire-breathing dragon/snake, a three-headed serpent named *Ngʷhi ("serpent" ;  and the Indo-European root for negation), is the world tree/axis mundi/the One/Apeiron (Hellenic)/grund of being/undifferentiated/"the allfather"/Zhuangzi's "obliterating [of pairs of opposites] unity with the Dao".  —Slays the dragon—slays the ego—slays the "thou shalt" (Law) says Nietzsche's Zarathustra—overcoming Eliot's "wasteland" of inauthentic life, a word lifted from Celtic grail legend’s Parsifal hero’s journey.  "When, o Indra, you slew the firstborn of serpents, then did you outtrick the tricks of the tricksters."  (Sigurd understood birds’ speech after eating Fafnir’s heart, and Odin transformed himself into a serpent in order to obtain the mead of poetry, in Norse carvings the snake merges into the tree, etc.  Sigemund.)      
      • Wod, Wut, and Wotan/Óðinn means inspiration, ecstasy (ex-stasis)/fury, rage, madness/insanity.  —"...menos came from the heavens, heroes owe their great deeds to it" :  menos (Hellenic) | manas (Vedic) | mania (Latin), wut (Teutonic).  Virtus, Audacia, Wut, Woths, Ódhr, Furor, Dásacht, Thyás, and Ferg :  the Indo-European sacred fury. The substantial original equivalence of the concept of the Virtus (Vedic) and the Wut (Teutonic), remarked by Roman authors themselves (who deified Virtus as the opener of the gates of divine glory to their military commanders) to describe the magical and sacred charisma venerated in the field of martial arts among the Celtic and Teutonic tribesmen.  Comparing Latin, Hellenic, Teutonic, Celtic, and Vedic terms, the various Indo-European expression of the sacred fury as a driving, transfiguring and mystical force in which the warrior took over human and extra-human traits, etymologically closely related to the invocation of divine light and the "storm" in the warrior sacrifice. 
      • "All Indric religious systems have as their ultimate purpose life-transcendence (moksha) because all assume that sentient existence is a false perception of reality (maya), the facade behind which lies The One (tat ekam), brahman, who, formless, and because formless eternal, is the sole reality." 
    • ātman is the soul attached to the body (Vedic)—to breath (pneuma and psychē—to breath, thymos—to fume (Hellenic), ghost/Geist—to breath (Teutonic), spiritusflame, anima (Latin), soul—"of sea" (Teutonic, Baltic), dúch—to breath (Slavic), Agni, fire (Vedic). ...Ātman is the Kantian "first principle" ;  and is identical with the transcendent self Brahman.  ...Aristotle (384 B.C.) defined the soul, or Psūchê, as the "first actuality" ("Actus Primus") of a naturally organized body, and argued against its separate existence from the physical body.  ...Fukuyama (Hegel as interpreted by Kojève as interpreted by Fukuyama) argues that the desire of identity groups for recognition/dignity/respect (thymos—"the seat of judgments of worth", the “master concept”)—the obsessive particularism of ethnic identification—is the key threat to liberalism.  The soul—thymos, the One, is (the urge to) identity.  ...I/iche/ego is the soul said Kant ;  later, (ground-of-) being, self, identity have been referents to soul.  ...Ancient Egypt (whose most ancient DNA was Anatolian, 2018 cemetery study) god Thoth created the world by the force of his word.  Along with this Thoth concept, most of the Torah stories were "appropriated" from Egypt, Hellenes, Sumer, Parsi, and Canaan by the Judean elites while writing the Torah in Babylon (then, as it is written in the Torah, when they returned from Babylon, they mysteriously found it, the scroll, hidden in the wall of the ruins of the old temple).  (The Moses character and central story, and justification for retaking Canaan, was not written anywhere prior to the Babylonian Captivity.  Moses name and his law was copied from an Egyptian story.  And, Samson, ark/flood, garden/Eden/tree/snake, etc. were copied from other host races.  But not "Abraham, Jacob, Isaac, and other proto-historical Bedouins."  (De Benoist)  Judaism is classed by antrhopologists as a particularistic endogomous ancestor-worship faith tradition.
      • "Note, Soul is a Saxon Heathen word. The Christian words are the Hebrew Ru'ach and the Greek Pneumatos, meaning "spirits", or more specifically breath. God breathed life into Adam in the bible. When someone dies, they have a last breath, where their spirit leaves the body. When a Christian sneezes, people said "God bless you" due to the belief a christian just lost some of their pneumatos (spirit.) The word 'pneumonia' comes from the Greek word for spirit/breath. The word Soul is a word borrowed in the Bible from Germanic Heathenry. A Soul is not in Hebrew thought, this word is in Old English and Old Saxon, and comes into modern English from Old English."  (Sass)  ...Ferah "one's life-spirit ;  tree".  Teutonic :  "Ferah [ātman?, an individual instantiation of brahman] is a part of a person you cannot see, it makes the person alive, and dies when the person dies."  "Gest is a part of a person one cannot see. It doesn't die when the Ferah and person dies. It can leave the body."  "Siola [brahman?, the generalized abstract class of ātman] is a part of a person one cannot see. It never dies."  (Sass) 
      • Dharma (Vedic), darna (Baltic), and harmonia (Hellenic)—all 3 come from the same root word (ar-) meaning "to fit together" ("reconciliation of opposites").  Ur(Teutonic).  The ar- in "Aryan" meant ar- "to fit", read as "allied, friendly, to give, one's ethnic group."  Cognates of which were used for ar-istocrats from Ireland to India. (As well as the ar- in hero, earl, etc...)  (academia.edu/35486756/Iarl_and_Iormun-_Arya-and_Aryaman-_A_Study_in_Indo-European_Comparative_Mythology)
      • Karma from root kwer means to do (Vedic), wyrd (weird) from root wert means to turn or rotate and Örlög meaning ur-law (Teutonic) | logos meaning law/coda/word (Hellenic), dán loaned from Latin don (Celtic), and the Fates/Moreia from root bha means voice (Hellenic).
  • mythos/religio/folklore/ Rita (Vedic), heidinn sidr ("heathen custom/rite").  (Before Christians dominated Rome, Christians were called "athiests" in Rome, rejecting their Roman "ancestor cult" of their fathers.) 
    • Ásatrú (wikipedia.org/wiki/Aesir-Asura_correspondence) is a form of ancestor-worship/"ancestor cult" (as are all Indo-European religions).  (As of 2007, Ásatrú is a religion officially recognized by the governments of Iceland, Norway, Denmark, and Sweden.  (While Romuva is recognized by Lithuania—rom (Baltic) equals ram (Vedic), and Dievturība is recognized in Latvia ;  and numerous pagan Slavic sects in Slavic speaking countries.) : 
      • (Ása-trú refers to) Æsir (Teutonic) is the plural of ássóss "god", or anses "half-gods".  Word-stem from Proto-Indo-European *h₂énsus "life force (cf. Avestan aŋhū "lord, lifetime", ahura "godhood", Vedic ásu "life force".  It is widely accepted that this word is further related to *h₂ens- "to engender" (Hittite hass- "to procreate, give birth", Tocharian B ās- "to produce").  
  • "Indo-Aryans [the earliest Hindus], like the Greeks and Romans, maintained a sacred fire [Latin "altar" means burn platform] in the household that represented the family and was never supposed to be extinguished unless the family [male] line itself was extinguished. In all of these cultures, the fire was worshiped as a deity that represented the health and well-being of the family—not just the living family, but also the family's dead ancestors stretching back over many generations. Religion and kinship are closely connected in tribal societies. Ancestor worship is particularistic... You have duties only to your ancestors... 'The funeral obsequies could be religiously performed only by the nearest [male] relative... They believed that the dead ancestor accepted no offerings save from his own family; he desired no worship save from his own descendants.' Moreover, each individual has a strong interest in having male descendants, since it is only they who will be able to look after one's soul after one's death. As a result, there is a strong imperative to marry and have male children; celibacy in early Greece and Rome was in most circumstances illegal. The result of these beliefs is that an individual is tied both to dead ancestors and to unborn descendants, in addition to his or her living children. As Hugh Baker puts it with regard to Chinese kinship, there is a rope representing the continuum of descent that 'stretches from Infinity to Infinity passing over a razor which is the Present. If the rope is cut, both ends fall away from the middle and the rope is no more. If the man alive now dies without heir, the whole continuum of ancestors and unborn descendants dies with him... His existence as an individual is necessary but insignificant beside his existence as the representative of the whole.' ...Belief in the reality of dead ancestors binds individuals together on a far larger scale than is possible in a family... The 'community' is not only the present members of the lineage, clan, or tribe; it is the whole rope of descent from one's ancestors to one's unborn descendants." (Fukuyama) ᛟ 
    • "A specific character of the most ancient cults of the most ancient Aryan societies was its anti-universalism. Ancient man did not turn to a God in general, a God of all men and all races, but the God of a lineage, in fact, of his gente and his family. And vice versa: only the members of the group that corresponded to them, could legitimately invoke the divinity of the domestic fire and to think that their rites were efficacious."  (Evola) 
    • "...the Bhagavad-Gîtâ, the most authoritative source in everyday Hinduism... Moreover, the Gîtâ itself is explicit enough about the understanding of caste identity as hereditary and implying endogamy. When its hero Arjuna [meaning "white"] shies away from battle and displays a failing in the martial quality (guna) befitting a warrior, his adviser Krshna lhis soul l does not tell him that by guna he clearly isn’t a Kshatriya and hence free from military duty, but instead tells him to overcome his doubts and do his Kshatriya duty, for regardless of his personal traits he just happens (viz. by birth) to be a member of the Kshatriya caste.  ¶  When the two argue opposing positions regarding the justice of waging the fraternal war, they do so with reference to the same concern, viz. the need to avoid varna-sankara, roughly ‘mixing of castes’. Both say that the other’s proposed line of action, viz. fighting c.q. avoiding the war, would lead to the ‘immorality of women’ and thence to breaches of caste endogamy.  When in a society two opposing arguments are based on the same value, you know that that value is deeply entrenched in that society,— i.c. caste as an hereditary communal identity guarded by endogamy." 
      • The origin of the Vedas can be traced back as far as 1500 BCE, when a large group of nomads called Ârya (the descendants of "father Manu" would say the Ârya, not "father Abraham"), coming from Iran (originally from Pontic-Steppe) crossed the Hindu Kush Mountains, invading into the Indian subcontinent.  ...Today the Finnish and Estonian word for slave is orja, from Ârya ;  provinging that even in northern Europe, the first Indo-Europeans called themselves Aryans, not just in Iran and India.
  • Teutsch/Deutsche/Týr/Tíw/Thing/Mannus ᛏ (Teutonic) all cognate to Manu (Vedic).  (Tacitus wrote that Mannus was the son of Tuisto [Týr the sky-god] and the progenitor of the Teutonic tribes—just as the Sanskrit says of "father Manu".)  And Manu's twin/hermaphrodite :  Yemo, Yama (Vedic), Yima (Avestan), Ymir (Norse), Remus (Roman) (< earlier *Yemos (Old Latin)).  
  • "Prom theús originally meant ‘the one who steals’; it has an exact cognate, including the prefix, in the Vedic verb pra math- , which means ‘to steal’ and is used in the Vedic myth of the theft of fire."
  • thunder god :  Thor/Donnar ᚦ uses axe/hammer (Teutonic) | Perun (stem means striker) uses axe (Slavic) | Perkūn-as uses axe (Baltic) | Indra 'the wielder of thunderbolts" uses axe/mace (Vedic).  —Cognates :  Fjörgynn/Thor (Norse), rain god Parjanya (Vedic), Perkūn-as (Baltic), and Perun/Perúnú (Slavic). 
  • Sun goddess (Celtic, Hellenic, Latin, Teutonic, Avestan, Vedic, Hittite).  And Moon god husband (Slavic, Teutonic, Baltic).
  • "horse twins" :  (Baltic, Teutonic, Hellenic, Latin, Ashvins :  sunrise and sunset via chariot Vedic).  (The "solar chariot" is in all the liguistic groups.)  ("Indo-European linguistic connections between Norse Sól, Vedic Surya, Common Brittonic Sulis, Lithuanian Saulė, Latin Sol, and Slavic Tsar Solnitse.") 
  • 3 seasons—3 holi-day feast-days : 
         1.)  Easter (when the Sun that died at Yule is reborn ;  with the "cosmic egg" in all of Europe and the "brahma-egg" in the Vedas)—an Ôstara/Easter fertility goddess :  In three traditions (Vedic, Hellenic, Baltic), the Dawn is the "daughter of heaven", *Dyḗus.  —Dawn goddess :  Uṣás (Rg-Veda Sanskrit), Ušå (Avesta), Eos (Hellenic), Aurora (Roman) is a reflection of Eos (Greek), Ēostre (Anglo-Saxon), Ôstarmânôth (High Deutsch), Aušra (Lithuanian) was still acknowledged in the sixteenth century.  
         2.)  Midsummer solstice. 
         3.)  Maruts (Vedic)/Wild Hunt/Einherjar, Yule ⊕ (Teutonic). 
  • ∴ (therefore) There was a single Proto-Indo-European religion ("faith tradition").  ∵ (because) One clade (Y Haplogroup) conquered and then mixed with the conquered.  —In Europe, Pontic-Steppe R1a/b men (descendants of "Eastern European Hunter-Gatherers"), Aryans ("Yamnaya DNA"), conquered Europe's original I1/I2 men (descendants of "Western European Hunter-Gatherers").  (Note :  "Geneticist David Reich said that the KITLG gene for blonde hair entered continental Europe in a massive population migration from the Eurasian [Pontic] steppe, by a people who had Ancient North Eurasian [Siberia] ancestry."  Not the Western European Hunter-Gatherers.)  
  • Further reading :  othroerirkindred.com/resources/De_Benoist - On_Being_a_Pagan.pdf 
  • "Absence of evidence is not evidence of absence." (proverb)


Average January Temperature

Average January Temperature:
Riga: -5.
Odessa: -1. / Lviv: -4. / Kiev: -5.
Krakow: -3.
Kosice: -2.6 / Bratislava: -0.6
Prague: -1.
Ljubljana: +0.1
Berlin: +0.5 / Freiburg: +2.5
Luxembourg: 0.0 holiday-weather.com/luxembourg/averages/
Brussels: +3.15
Portland: -6.
Lincoln: -6.



feed: http://www.programmabilities.com/feeds/posts/default?orderby=UPDATED

 sitemap: webmasters.stackexchange.com/questions/96421/how-to-add-sitemap-to-my-blogspot-blog :  http://www.programmabilities.com/atom.xml?redirect=false&start-index=1&max-results=500



my quantcast quantified adchoices:




Bucket List:

Bucket List:  (Red living) 

  • England:   Conrad, Woolf, Hobbes, Orwell, Huxley, T.S.Eliot, H.Pinter, Maugham, Boole, Marx, Carlyle (London)L.Carroll,
  • Ireland:     Yeats, Joyce (& France?), 
  • Scotland:  James Clark Maxwell, 
  • Italy:         E.Pound, Machiavelli, Gramsci, 
  • France:     Sartre, Derrida, Louis-FerdinandCéline, Proust, Saussure, Foucault, Alen deBenoise, RanaudCamus
  • Deutcsh:   Frege,
  • USA:        Rosenfels, C.ShannonJ.London, Pierce, Dreiser, Julian.Jaynes, Nabokov, Robinson JeffersD.Reed, HardinMacDonaldLakoff, G.Johnson



  • The 'magnetic pole' of the earth is caused by the rotation of the liquid iron inside the earth.  -- If that iron was solid, then there would be no 'magnetic pole'. 
  • All of earth's water was brought to earth via icy meteors.  This water was created by the explosion of dieing suns (the only time when Hydrogen fuses with Oxygen).



"There was a theory, increasingly well supported, that eating is what killed you. They found that rats on extremely restricted diets, rats who ate very few calories, lived impressively long. They saw the same results with other animals, up to and including chimpanzees. They suspected, but could not prove, the same was true of humans. Every little bite of food was another step towards death."

Read more: digitaljournal.com/article/341150#ixzz2Htq0xcah


ketones via low-carb diet (for example: meat or fish with salad, but no sugar, grains, rice, starchy vegetables)


IIS hosting

  1. From a PC use the Windows Professional's IIS to host an .aspx page that uses SQL Server Express 2005.
    1. boutell.com/newfaq/creating/hostmyown.html
    2. Include some notes & directions howto:
      1. Open up the IIS window on the PC by doing so: >My Computer >Manage >Services and Applications >IIS
      2. >Local Disk E: >Inetpub >ftproot (Go here to check the stuff that gets hosted (Thus FTP to here).)
      3. Then go to http://localhost/ in a browser's address bar to view the test .aspx page
      4. Etc...
  2. Take the dynamic IP of our IIS and put it in the browser's address bar to test. (Ex.
  3. Get a static IP from DynDNS.com and add it to the IP input field in mydomainname.com's GoDaddy dashboard. Thus mydomainname.com with GoDaddy will point to the IP of our IIS server hosting PC.
  4. We are getting an error when our page includes a database stuff: aspspider.com/resources/Resource170.aspx
  5. Add mydomainname.com to here domains.live.com (What this service does, I do not know yet.)
Much later TODO:
  1. Set up a mail-server on the said IIS (or activate it if one is included with it)
  2. Take the DNS settings from Hotmail and add them so email messages to mydomainname.com's domain name get sent to his said domain name (ex. bob@mydomainname.com).
  3. MX (Mail Exchange) records are used in DNS records (or Zone files) to specify how email should be routed.
  1. With IIS7 Rewrite module a website can have a .htaccess file. See hanselman.com/blog/ASPNETMVCAndTheNewIIS7RewriteModule.aspx.


VB: Regular Expressions, etc...

Regex.IsMatch("subject", "regex") ' Checks if the regular expression 
' matches the subject string.

VB: using Controls collection

' Clears textbox controls' content on the form using 
' Controls collection.
Dim intX As Integer
Do While intX < text = "" intx =" intX">


Sub Page_Load()
    If Page.IsPostBack = False Then
        ' Store URL Referrer to return to home page.
        ViewState("UrlReferrer") = Me.Request.UrlReferrer.ToString()
    End If
End Sub

Sub CancelBtn_Click()
    ' Redirect back to the home page.
    Me.Response.Redirect(CType(ViewState("UrlReferrer"), String))
End Sub

ASP confirm

 gt-a-s-p:button id="ConfirmOnClick" runat="server" onclientclick="return
confirm('You\'re sure you want to do this?');" text="Launch Airstrike"> lt/ a-s-p:button> 

ASP .NET set focus to a control (javascript)

body onload="javascript:document.forms[0].txtFirst.focus();"


check for DbNull

Check for DbNull:
<_a s p :Label runat="server" ID="Label6" Text='< % # IIF(Typeof(
Eval("ShippedDate")) IS DbNull,"No Date",Eval("ShippedDate")) % >' />
<_%# ((Convert.IsDBNull ... I am telling ASP to give the picture a height value only if the value in the database is not NULL. I could've done this in the SQL instruction, but I decided to do it inside the Datalist.
<_%# ((Convert.IsDBNull(DataBinder.Eval(Container.DataI tem, "height"))) ? "" : "height = " + DataBinder.Eval(Container.DataItem, "height")) %> 
Or maybe this for NULLs?: <_%# Eval("First", "{0}, ") %_>
Or check for NULL in T-SQL:
ISNULL(check_expression, replacement_value) If 1st is NULL, return 2cnd.


Search Stored Procedures

This searches all the Stored Procedures in 1 SQL Server database for the said string. I tested it in Query Analyzer and it found all the Stored Procedures that had occurrences of my "lq_Campaign" in 1 database:

Here is another way

Below query you can searcg any table, stored procedure or views what ever has that expression as a column or object name.


The query produced all the object names--where ever it finds expression like ‘PRODUC‘.

Model View Controller

  • Primary goal is to separate the things that change from the things that do not.
  • Model is the data representation.
  • View is the presentation of the model.
  • Controller responds to events and modifies the model.
  • Model notifies the views to update the presentation.


SQL Server 2005 Reports: tips

  • Page Header:
    • TextBox via Expression...: =Globals.ReportFolder & Globals.ReportName
  • Page Footer:
    • Page Footer: TextBox via Expression...: =Format(Globals!PageNumber) & " of " & Format(Globals!TotalPages) & " pages"
    • ="Printed by " & User!UserID & " on " & DateTime.Now.ToString()
    • ="Execution Time: " & IIF(System.DateTime.Now.Subtract(Globals!ExecutionTime).TotalSeconds < 1, "0 seconds", ( IIF(System.DateTime.Now.Subtract(Globals!ExecutionTime).Hours > 0, System.DateTime.Now.Subtract(Globals!ExecutionTime).Hours & " hour(s), ", "") & IIf(System.DateTime.Now.Subtract(Globals!ExecutionTime).Minutes > 0, System.DateTime.Now.Subtract(Globals!ExecutionTime).Minutes & " minute(s), ", "") & IIf(System.DateTime.Now.Subtract(Globals!ExecutionTime).Seconds > 0, System.DateTime.Now.Subtract(Globals!ExecutionTime).Seconds & " second(s)", "")) )
  • Body:
    • TextBox via Expression...: =Format(Sum(Fields!Account.Value), "C0") (Works if column is numeric data type.)
    • Alternate rows by adding the following to the row via Properties > BackgroundColor expression of your detail row: =IIF(RowNumber(Nothing) Mod 2, "White", "Gainsboro")


SSIS > VS Export wizard: table to Excel

After using the SSIS > VS Export wizard for table to Excel, you must add DROP TABLE Query to the Event Handlers tab or else it will error the second time it is reRun. SSIS

SSIS > VS Import wizard for Excel to table:

  • Be sure to only checkmark Results$.
  • Be sure to Select Delete table option.
  • Be sure to Change Results$ name to Destination table name.
  • If there is an error, it is often because a row in Excel has a NULL but the table column is NOT NULL (so add a blank to the Excel field).



' Currently this VBScript is set to replace-commas-with-pipes for every file that is 
'in the folder where this VBScript sits:
' Before run it do the following:
' 1. Open VBScript in text editor
' 2. Set the parameters:
'        cFolder_Name = "." ' current directory
'        cOnlyOneFile = False ' set to True if I want to process only one file with name set below
'        cOnlyFileName = "thisfile.csv"
' 3. Place the VBScript into the target folder
' 4. Run it by double-click
' Notes: http://groups.google.com/group/microsoft.public.excel.misc/browse_thread/thread/79ddd204ebb88287/be5d195da9241df9%23be5d195da9241df9
' -------------------------------------------------------
On Error Resume Next

const cFolder_Name = "."  ' current directory
const cOnlyOneFile = False ' False, So all files in the folder.
const cOnlyFileName = "thisfile.csv" ' Uses this if the above was True (only wanted to process 1 file).

Set oFSO = CreateObject("Scripting.FileSystemObject")

' Get folder:
Set oFolder = oFSO.GetFolder(cFolder_Name)
If oFolder Is Nothing Or Err.Number <> 0 Then
  MsgBox "Can't get a folder for search files. " + vbCRLF + "Please check the folder name." + vbCRLF + Err.Description, vbCritical, "Fatal error!" ' I will probably comment this out when this VBScript runs automatically as a scheduled job.
End If

Set oFiles = oFolder.Files
If Err.Number <> 0 Or oFiles Is Nothing Then
  MsgBox "Can't get a list of files of folder." + vbCRLF + "" + vbCRLF + Err.Description, vbCritical, "Fatal error!"                               ' I will probably comment this out when this VBScript runs automatically as a scheduled job.
End If

Cnt = CInt(0)
For Each oFile In oFiles
  If oFSO.GetExtensionName(oFile.Name) = "csv" Then ' Checks for "csv" file extension.
    If (cOnlyOneFile And (oFile.Name = cOnlyFileName)) Or (Not cOnlyOneFile) Then
      Call ReplaceSymbols(oFile.Name) 
      Cnt = Cnt + 1
    End If
  End If


MsgBox "Replacing is done. Total number of files had been processed: " + CStr(Cnt), vbExclamation, "Message..."                                    ' I will probably comment this out when this VBScript runs automatically as a scheduled job.
' cleanup
Set oFiles = Nothing 
Set oFSO = Nothing

' Find-and-replace:
Sub ReplaceSymbols(oFileName) ' AKA "File.Name".
  If oFSO.FileExists(oFileName) Then 
    Set oTextFile = oFSO.OpenTextFile(oFileName, 1, False) 
    sFileContents = oTextFile.ReadAll 

    Set oRegEx = CreateObject("VBScript.RegExp") 
    With oRegEx 
      .Global = True 
      .IgnoreCase = False 
      .Pattern = "," ' Or vbTab or "|" etc...
      sFileContents = .Replace(sFileContents, "|") 
'      .Pattern = "\|"                               ' reverse replacing
'      sFileContents = .Replace(sFileContents, ",") 
    End With 

    Set oNewFile = oFSO.CreateTextFile(oFileName, True) ' Maybe oNewFile is not needed--it just could have been called oTextFile.
    oNewFile.Write sFileContents 
  End If
End Sub

' NOTE: This first way would only work on my PC, not on the other user's PCs; so I must use the second snippet, Senmail(), at the bottom. NOTE: If I made the changes marked "future testing" this might work.
' Send email to Jon Doe. --If the PC this runs on is not set right, this email will not get sent. 
'Set oMessage = CreateObject("CDO.Message") 
'oMessage.From     = "Generated automatically for AWARE " ' NOTE: If future testing: Comment this out.  
'oMessage.To       = "jon.doe@jd.com,jon.doe2@jd.com"       ' NOTE: If future testing: Should be ";".                                      
'oMessage.Subject  = "AWARE: Extracts done."       
'oMessage.Sender   = "jon.doe@jd.com"                       ' NOTE: If future testing: Comment this out.                                               
'oMessage.TextBody = "AWARE: Commas replaced with pipes." 

' NOTE : Is using MS Outlook API to send e-mails. So check If MS Outlook installed on a workstation before a using of this script.
Sub Senmail()
  Set objOutlook = CreateObject("Outlook.Application")
  Set objOutlookMsg = objOutlook.CreateItem(0)
  With objOutlookMsg
' This line caused it not to even popup warning, so leave it off:   .From     = "jon.doe@jd.com "   ' "Generated automatically for AWARE "
     .To = "jon.doe@jd.com; jon.doe2@jd.com; jon.doe3@jd.com; jon.doe4@jd.com"   
     .Subject = "AWARE: Extracts done."
' This line caused it not to even popup warning, so leave it off:   .Sender   = "jon.doe@jd.com"   ' NOTE: jon.doe2's email is automatically inserted here because it is sent from here Outlook.
     .Body = "AWARE: Commas replaced with pipes. [Note: This message was generated and sent automatically.]"
  End With
  Set objOutlookMsg = Nothing
  Set objOutlook = Nothing
End Sub


Create SSIS to copy tables

An SSIS to copy tables from a Source to a Destination. Directions:

  1. From Start, select SQL Server Business Intelligence Development Studio
  2. File
    1. New Project…
      1. Project types: Business Intelligence Projects
      2. Integration Services Project…
      3. Click “OK
  3. Toolbox
    1. Drag "Transfer SQL Server Objects Task" to "Control Flow" tab's pane.
      1. Right-click choose Edit…
        1. Objects
          1. SourceConnection ‹New connection…› = NWDSQL
          2. SourceDatabase = NIS_empl_wage
          3. DestinationConnection ‹New connection…› = TESTSQL
          4. DestinationDatabase = NIS_empl_wage
          5. CopyData = True
          6. ExistingData = Replace (so not append (dup errors))
          7. ObjectsToCopy (expand)
            1. CopyAllTables = True (so not sprocs)
          8. Note: Leave all other options False. Ex., Table Options—Can leave all these False because it will just move data so Destination’s Primary Keys will remain.
      2. Click “OK
  4. Save and Run

Note 1: Your Properties for the Transfer SQL Server Objects Task will now look like this:

  1. CopyAllTables = True (so not sprocs)
  2. CopyData = True
  3. DestinationConnection = TESTSQL
  4. DestinationDatabase = NIS_empl_wage
  5. ExistingData = Replace (so not append (dup errors))
  6. SourceConnection = NWDSQL
  7. SourceDatabase = NIS_empl_wage

Note 2: A DB "restore" by the DBA would nix Destination tables that do not exist in Source tables; but not this technique.


CASE: This way (3) NULLs get put in tbl if data is blank.

command = New SqlCommand("INSERT INTO tblFoo (UIAcctNum, WorkZip, CheckRouteDesc, Agency, Division, RUN, Rpt_Unit_RUNDesc, StartDate,EndDate ,CheckRouteCode, Rpt_Unit_RUNDesc__old,NAICS) " & _ 
" VALUES (@UIAcctNum, @WorkZip, @CheckRouteDesc, @Agency, @Division, @RUN, " & _ 
"CASE WHEN ltrim(@Rpt_Unit_RUNDesc) = '' THEN NULL ELSE @Rpt_Unit_RUNDesc END, " & _ 
"@StartDate, " & _ 
"CASE WHEN ltrim(@EndDate) = '' THEN NULL ELSE @EndDate END, " & _ 
"@CheckRouteCode, " & _ 
"CASE WHEN ltrim(@Rpt_Unit_RUNDesc__old) = '' THEN NULL ELSE @Rpt_Unit_RUNDesc__old END, " & _ 
" CASE WHEN ltrim(@NAICS) = '' THEN NULL ELSE @NAICS END)", connection) ' This way (3) NULLs get put in tbl if data is blank.


SQL notes

  • SELECT DISTINCT * INTO ##temp3 from ##temp2 --Use this if I want to INSERT rows AND create the destination table.
  • WHERE ##temp1.Area <> ##temp2.Area -- The 'WHERE <>' stops a cartesian join.
  • SELECT * INTO ##temp3 FROM (SELECT * FROM ##temp1 UNION SELECT * FROM ##temp2) un
  • strSQL = "IF OBJECT_ID('tblTempNIS_Qtrly_SumByRUN_and_crc', 'U') IS NOT NULL DROP TABLE tblTempNIS_Qtrly_SumByRUN_and_crc" ' This is not really a temp table because no #; so must DROP. It's a helper table. Couldn't use a temp because mData's Clear lose the data for the next query's use of it. ' The ", 'U' " is optional; it just insures that the object is a user table and not, for example, a sproc or other type of object.
  • ' To get all information about the @@Error value that is returned in the output parameter 
    ' From Master database 
    ' SELECT * FROM sysmessages WHERE Error = 2627 ' type value in rdoQy(3) here
  • --NWDSQL.BmrkSource.PendingPublish is empty for 2003-2004. Thus do this to populate it with rows from the other table:
    INSERT INTO BmrkSource.dbo.PendingPublish
    SELECT NEArea,IdentifierCode,EndDate,NumberOfPeople,Week,ItemCodeID,Ratio --Note: Published has 1 extra column at the end so I must list these out.
    FROM NELausData.dbo.Published
    WHERE NELausData.dbo.Published.EndDate LIKE '2004%'
    OR NELausData.dbo.Published.EndDate LIKE '2003%'
  • The INNER JOIN returns all rows from both tables where there is a match. If there are rows in first table that do not have matches in second table, those rows will not be listed.
  • The LEFT JOIN returns all the rows from the first table, even if there are no matches in the second table. If there are rows in first table that do not have matches in second table, those rows also will be listed.
  • The RIGHT JOIN returns all the rows from the second table, even if there are no matches in the first table. If there had been any rows in second table that did not have matches in first table, those rows also would have been listed.
  • SQL Server is phasing out text, ntext, and image. There’s no way to know how long SQL Server will support the older data types. Upgrade legacy applications to varchar, nvarchar, and varbinary.


How to get a DB and send it....

You can backup the DB from the server and then restore it on your local machine with installed MS SQL Server 2000. Then you can change or delete any pruned info from the DB on your local machine. Then you can backup the modified DB again and send that backup file (*.bak file). You can send this file with Gmail. There is about 3Gb available space.

    How to backup...
  1. Open Enterprise Manager
  2. Select source DB
  3. Right click on the selected DB. Select All Tasks->Backup Database... from the popup menu.
  4. Select File and filegroup and add destination file name in the Backup dialog.
  5. Press OK
    How to restore...
  1. Open Enterprise Manager
  2. Select Databases node
  3. Right click on this node. Select All Tasks->Restore Database... from the popup menu.
  4. Type database name in the Restore as database textbox
  5. Select Restore From Device
  6. Press Select Device
  7. Add backup file name
  8. Press OK
  9. In the Options tab check file pathes where your database will be restored.
  10. Press OK
  11. Select File and filegroup and add destination file name in the Backup dialog.
  12. Press OK


Excel: compare two Worksheets

Excel Macro
Compares the 2 Worksheets and pops up a workbook with the differences:
Steps: >Tools > Macro >Macros >Run

Excel Function
Function for comparing data: http://office.microsoft.com/en-us/excel/HP100625641033.aspx?pid=CH100645341033
Here's the Excel formula: =Exact(ColumnRow,ColumnRow)
An example: =EXACT(G5,P5) [First put both worksheets on the same worksheet, side by side.]
If the result is True data matches; if False data does not match

Also, I was told there is a way to recieve as output each row that was different using a "Filter".


SQL compare two tables

Difference in data stored in both tables (compare the difference between two tables)? You can use SQL to see rows which don't have a match in one table or the other:
Select col_a,col_b from table1 
where not exists 
    (select * from table2 
     where table1.col_a = table2.col_a and 
           table1.col_b = table2.col_b)

Repeat for table2.

further notes: --http://windowsitpro.com/Articles/ArticleID/14368/14368.html?Ad=1

Here is a way of comparing 2 tables that I tried at work:

-- DROP my new temp table if exists:
DROP TABLE ##EricsTempUnionOfMonthlyAndBiweekly

-- UNION the monthly & biweekly tbls into a temp table:
SELECT * INTO ##EricsTempUnionOfMonthlyAndBiweekly 
FROM (SELECT * FROM NISTempLowLevelMonthly 
UNION SELECT * FROM NISTempLowLevelBiweekly) un

-- Verify it:
SELECT * FROM ##EricsTempUnionOfMonthlyAndBiweekly --18347rows, yes this was a UNION of monthly & biweekly tables.

-- LEFT OUTER JOIN which means gives me the differences:
SELECT DISTINCT * FROM ##EricsTempUnionOfMonthlyAndBiweekly LEFT OUTER JOIN NISTemp_Qtrly_Detail 
ON NISTemp_Qtrly_Detail.SocSecNumber = ##EricsTempUnionOfMonthlyAndBiweekly.SocSecNumber -- 72573 rows


Debug sproc in VS

In VS at the Sever Explorer pane I right-click on my data connection that I added and select Modify Connection. Then in the Modify Connection dialog I clicked Advanced... and then in the Advanced Properties dialog I changed Pooling from True to False. Now it works. Also, in the configuration file, the Enable SQL Server debugging must be checked. Also, I have to add cmd.CommandTimeout=1800 to the VB's sproc area else it will time-out while clicking thru the sproc in the debugger.

But, when not debugging, in order to get the app to run to completion without crashing with the error Error while executing 'a batch cmd' at line 0 , I have to uncheck Enable SQL Server debugging and set Pooling back to True. --Because not pooling the connections hurts performance.


To export DTS package, do the following:

  1. Open MS SQL Server Enterprise Manager
  2. Go to Local Packages
  3. Open some DTS Package
  4. In the DTS Package window from menu select item Package->Save As...
  5. In the Save DTS Package dialog
    • in the Location field select Structured Storage
    • File
    • in the File Name field set destination path of saved file
  6. Press OK button


Server 2000: Query Analyzer Tips & Tricks

You probably know that SQL Server stores metadata about all of the objects in a database. The system tables contain a wealth of information about column names, data types, identity seeds, and so on. But did you know that you can get that information with a single keystroke via Query Analyzer? Highlight the object name in any SQL statement and press Alt+F1. Figure 1 shows the results for a SQL Server table. If you don't have anything highlighted, Alt+F1 will give you information about the database itself. For an equally neat trick, highlight a SQL keyword and press Shift+F1; you'll go straight to the Books Online page that describes that keyword.


Getting .dll into Registry

  1. Download the file (MSRDO20.zip) to your desktop
  2. Unzip the content of the file (a file called MSRDO20.DLL) to your desktop
  3. Right now you should have a new file called MSRDO20.DLL that resides on your desktop
  4. Copy this file to your Windows System Folder; this folder is usually found inside your 'C:\Windows' folder. It is called 'C:\Windows\System' or 'System32'...
  5. Go to 'Start Menu' and choose 'Run'
  6. A new window titled 'Run' will open; type the line 'regsvr32.exe msrdo20.dll' and hit 'Enter'.
  7. A message will show up stating that the registration was successful.


Visual Studio Short-cuts

Most of the time, you will Step Into or Step Over commands in your stored procedures. The commands below apply to a single T-SQL line:

  • Step Into (F11): Use to single step through your code. (Move the yellow arrow down one statement.)
  • Step Over (F10): Useful if you have lines of code that perhaps modify data or call other procedures that you don't care about while debugging. For example, you may want to skip code that performs auditing.
  • Step Out (SHIFT+F11): Execute the rest of the stored procedure without pause.
  • Run to Cursor (CTRL+F10): Position the cursor to a point in your code and then hit CTRL-F10 to execute all code up to that point.
  • Continue or Start Debug or Run (F5): Start Debug. Or resumes execution until completion or until the next breakpoint.
  • Toggle Bookmark (CTRL+K)
  • Help (F1)

When you provide a summary of the class using XML comments, your class displays documentation about itself in appropriate places within Visual Studio, such as in the List Members box. Open the List Members box by selecting Edit | Intellisense | List Members from the main menu bar or by clicking the Display an Object Member List icon on the Text Editor toolbar.

Command Window debugging: Getting Values

To see the value of your variable whilst in Debug mode, use the "Command Window" (View >Other Windows >Command Window). Enter this: ? myVariableName


SQL: Bulk import

Bulk import (save file.txt as csv): LOAD DATA INFILE 'file.txt' INTO TABLE 'tblFoo' (col1, col2, col3)

BULK LOAD IMPORT ('c:\file.txt') INTO TABLE 'tblFoo' (col1, col2, col3)


SQL Server 2000: make table backup with DTS

  • Right-click the table
    • choose Export Data
  • Choose a destination
    • Server: "nwdsql" and Database: NELausData
  • copy table(s)
  • UserXRef"_bkup" (Destination)

Done, then refresh explorer to view.


Install Google Search API Into Visual Studio

  • Get the Google API and unzip. Import GoogleSearch.wsdl to the Project root.
  • Right-click on the Project root.
    • Add Web Reference
      • Then type in the URL: http://localhost:1574/projectname/GoogleSearch.wsdl or http://foo.com/GoogleSearch.wsdl

Then you should see an App_WebReferences folder in your Project. And then a folder in that called localhost. And then files GoogleSearch.discomap and GoogleSearch.wsdl in that.

Test SQL Injection Attack on ASP

Username: foo
Password: abc' OR 'x' = 'x


Load a Control into Visual Studio

  • Right-click on toolbar and "Choose Items"
  • Then browse and go to your /Controls/ folder
  • Then click on it and open
  • Then click "OK"

Then it will be on your toolbar and there will be a Reference to it in your /Bin/

header adsense code