Computers blog postings
|Earliest: June 12, 2003||Latest: April 29, 2017||Total: 101|
|August 12, 2011|
Common T-SQL Functions
There are some of the most used Date/Time functions in SQL Server 2008:
- GetDate() - Current system date and time
- DateAdd() - A date produced by adding date parts to another date
- DatePart() - Part of a datetime or smalldatetime value (for example, the month) as an integer
- DateDiff() - The amount of time between the second and first of two dates, converted to the specified date part (for example, months, days, hours)
- DateName() - Part of a datetime or smalldatetime value as an ASCII string
- Day() - Displays the day in a datetime field
- Month() - Displays the month in a datetime field
- Year() - Displays the year in a datetime field
This is the most commonly use Date Query. It returns the current date in the following format: August 12, 2011
SELECT CONVERT(VARCHAR(12), GETDATE(), 107) AS [Mon DD, YYYY]
|February 25, 2011|
FTP On The Go
If you are looking at the iPhone/iPad application called "FTP On The Go" you should check out the protocol that your FTP server supports before getting the App.
Note: "FTP On The Go" does not support sftp, which is more common format that ftps. They do support the ftps protocol.
|February 9, 2011|
Looks like there's more trouble brewing at Real Networks, I really need to make a decision about my Real Audio page. Hmm, maybe I should buy the company and have exclusive rights to their technology.
Streaming media specialist RealNetworks, which earlier this year rolled out a revamped media player targeted at the mobile video market, said it's cutting its workforce by about 10 percent, or 130 jobs, in an effort to simplify and restructure its operations as it tries to reduce costs.
|December 20, 2010|
Today is my 10 year anniversary for joining FreeLotto. I don't think I have visited the site once in the past 9 years:
You are receiving this message because you joined FreeLotto on 2000-12-20 16:28:24, from IP Address 220.127.116.11. When you registered you agreed to receive messages from FreeLotto. FreeLotto NEVER sends JUNK or SPAM messages. We never send mail to anyone unless they requested it when they registered. If you somehow didn't understand that you were agreeing to receive messages from us at the time you joined PLEASE CLICK HERE TO BE PERMANENTLY REMOVED FROM OUR LIST. In doing so you will also cancel your FreeLotto membership and you will no longer be eligible to play FreeLotto or receive up to $11,000,000.00 in daily prizes. We regret any inconvenience.
FreeLotto Member Services
I wonder if they will even let me know that it has been ten years. Maybe I should unsubscribe now?
|December 16, 2010|
SQL Server Date Query
Here are some simple mssql queries if you need to change the current date in a query. That is if you need to find information in the past and don't want to hard code in values.
SELECT GETDATE(), DATEADD(day, -1, GETDATE());
Seven Days ago:
SELECT GETDATE(), DATEADD(day, -7, GETDATE());
SELECT GETDATE(), DATEADD(year, -1, GETDATE());
SELECT GETDATE(), DATEADD(hour, -1, GETDATE());
More specifically you would do something like this:
Show all sales within the past hour:
Select * from orders where
salesdate > DATEADD(hour, -1, GETDATE())
|October 20, 2010|
WebAii Validate Current URL
Using Webaii, Use this code snip to validate the URL of the current page:
// Validate URL
// URL Does Not Contain
|October 19, 2010|
Using WebAii and this code snip to search the HTML source of a page for some data:
// Check for value of a InnerMarkup
StringAssert.Contains(TextString, "Company Name");
|October 18, 2010|
Webaii Finding Images
Using Webaii, here's how to validate that an image is loading correctly on a page:
// Validate Image on Page
Assert.IsNotNull(Find.ByAttributes<HtmlImage>("src=~logo.gif"), "Logo Image is not on the page");
Very useful to have as a code snip.
|October 4, 2010|
Found this online, guess its someone sick of answering people computer assignment, pretty funny:
CS 107 Assignment 106x: In this assignment, you will have to program a general purpose parse table that can store pointers to pointers to pointers to function optimization algorithms and perform holistic evaluation functions on each element. It utilizes the polymorphic parse table ADT that you worked on back in assignment zero. You will have to perform your own bug checking. A worthless test program is included to help you lick any bugs you might have. As you might have guessed, this assignment is very worthwhile, so start early. Due tomorrow at 2:00 in the morning. Submit the assignment telepathically to your section leader's former roommate.
|September 27, 2010|
If you are running Fiddler you'll probably see the following host sites appearing in the log:
The best bet is to update your Virus protection software and restart your computer. According to McAfee this Trojan isn't very harmful. However, in a corporate environment it can cause a network slow down, if there are many computers infected.
If you are unable to update your virus program, save your corporate network by adding host entries for poetuteywetw.com and pphwarofgodsiiewyt.com. If you don't know anything about updating your host file, then you shouldn't mess around with it.