Last Good Quote: Son's are the seasoning on our lives. - Someone on Facebook

Wednesday, August 27

MSSQL - When does data move from Memory to Disk

So I had to ponder this question (I had a vague idea but wanted to get a firm understanding)

Question: We know SQL stores data objects in RAM as it needs, at what point does the changes that are made in RAM get written to the disk?

In layman's terms: In the background the server monitors it's memory. When a particular object has not been used "in a while" that object is moved to disc. It is at this point that the disc and memory are syncronised. This is also done on a proper shutdown of the SQL Server.

Side Note: If memory is full of objects that are frequently used, SQL Server will read directly from disk. This can negatively impact performance in a substantial way.

From Wikipedia (link):

SQL Server buffers pages in RAM to minimize disc I/O. Any 8 KB page can be buffered in-memory, and the set of all pages currently buffered is called the buffer cache. The amount of memory available to SQL Server decides how many pages will be cached in memory. The buffer cache is managed by the Buffer Manager. Either reading from or writing to any page copies it to the buffer cache. Subsequent reads or writes are redirected to the in-memory copy, rather than the on-disc version. The page is updated on the disc by the Buffer Manager only if the in-memory cache has not been referenced for some time. While writing pages back to disc, asynchronous I/O is used whereby the I/O operation is done in a background thread so that other operations do not have to wait for the I/O operation to complete. Each page is written along with its checksumwhen it is written. When reading the page back, its checksum is computed again and matched with the stored version to ensure the page has not been damaged or tampered with in the meantime.[58]

Saturday, June 28

Review of a Stock Trader

From time to time, I find a guy giving trading advice/posts online. I like to do my own due diligence on them. Here is another one.

A review of EasyDollars, a StockTwits user.

Comparison of close the day after twit was sent (Some rounding being done)

Stock                          on 6/19/2014                  10 days after post
05/02 - SWKS                +14%                     +3%
05/12 - ORCL                 +2%                       +2%
05/14 - IWM                   +5%                       +2%
05/20 - IWM                   +7%                       +2%
05/28 - PCRX                 +10%                      +7%
05/28 - KNDI                  +8%                        -1%
05/29 - HZN                    +9%                        +1%
02/06 - FEYE                   -51%                      +9%(he did say it could go either way)
02/06 -JRJC                     -32%                       +15%
02/13 -CSIQ                   +26%                        +5.2%
12/18 -FAS                     +22%                        +10%

This guy is magic when it comes to predicting stocks. Of course I added him to my favorites.


Tuesday, June 24

Awesome Desktops

Just click the links fool...

https://www.flickr.com/photos/saadbaig/3168489281/in/pool-lifehacker-desktop-showandtell/

  • The hex background
  • The white and black theme
  • Side menu is neat
  • Side Menus and all around look
  • I like the blue outline around the menu



Saturday, June 21

Bookmarked Links

http://cybermap.kaspersky.com/ - Very Cool

http://buysellads.com/ - Advertising space

https://pickcrew.com/how-it-works/ - Freelance talent, I like how they do things.

http://www.justinmind.com/ - Design Mobile Apps (good for prototyping)

http://proto.io/en/examples/ - Another mobile prototyping site, check out the Kitchen Sink Demo at the bottom.

https://revenue.com/ - another advertisment space...like the site, never used them though.

Friday, June 20

Quotes on Starting a Business

“Chase the vision, not the money; the money will end up following you.” -Tony Hsieh, Zappos CEO

“An entrepreneur is someone who has a vision for something and a want to create.” -David Karp, Tumblr founder and CEO
“A ‘startup’ is a company that is confused about three things: (1.) What its product is. (2.) Who its customers are. (3.) How to make money.” – Dave McClure, 500Startups co-founder

Saturday, June 14

On Creating a Startup

Repost: http://onstartups.com/tabid/3339/bid/43774/The-5-Minute-Guide-To-Cheap-Startup-Advertising.aspx

I recently advertised my developer's guide to launching a startup on StumbleUpon. The plus side of StumbleUpon is that all clicks are 5 cents. The downside is the bounce rate is high since people are basically channel surfing. I achieved a 96.88% bounce rate in my experiment, with an average stay of 2 seconds. I wonder if it was something I said? In my test, only 25 visitors stayed longer than 5 seconds. I paid $50 for 1000 clicks, but since only 25 of them stayed long enough to read anything, I effectively paid $2 per click. Your mileage may vary, but through this and other experiments I've gathered the following tips for advertising on StumbleUpon:
  • Your #1 goal is to get stumblers to stay longer than 5 seconds. Your #2 goal is to get them to up-vote your page. Paying $50 for 1000 clicks is one thing. Having it go viral and receiving 10,000 clicks for the same price is another.
  • Don't send StumbleUpon traffic to a landing page that asks for an email address. StumbleUpon users are notoriously fickle about providing their email.
  • People stumble to be entertained, so if your page doesn't have the potential to go viral or turn into linkbait, you will not likely fare well.
  • Blog-like content and videos seem to work best. Anything that resembles a traditional landing page will bomb.


In 24 hours, my listing was shown 26,050 times (to 3,187 unique visitors). The link in my ad was clicked 419 times, resulting in a unique click through rate of 13.15%. Not bad – that’s about $0.09 per click.


Timing of your email and Tweets
Timing is also a very important aspect for getting you covered. The best days for traffic for getting coverage of your story I have learnt are Tuesday, Wednesday and Thursday. Monday is way too fast to get you written up, the inboxes of reporters are full it's just not a great day.
At the same time, I learnt that, whilst Fridays aren't as good for traffic, the news is slower. So your chances of getting covered on that day can be higher. With a recent story about Buffer on Mashable, I took advantage of this. I followed up on a story I had pitched earlier in the week. Since it was extremely busy, I wouldn't get a response, yet a quick follow up email on Friday would receive an immediate response.

Monday, June 9

Are you secure

If you ever wondered what could be traced on your person....check out this site.

Click on the little dots in the picture to learn more.

http://www.spiegel.de/international/world/a-941262.html

Saturday, June 7

Random Interesting Links


RobinHood.com - 100% Free Stock Trades - no commission....no way, could this be true?

http://www.techhive.com/ - Interesting

http://thewirecutter.com/ - Tech Product Reviews, make sure you buy the good stuff for the right price

https://haveibeenpwned.com/ - See if you have been hit by the Heart Bleed Virus

Friday, June 6

Click Through Rates and Google Ad-Words

http://www.wordstream.com/blog/ws/2014/02/11/average-click-through-rate#.
A must read on click through rates and google ad-words, this made a lot of things click for me

Saturday, May 31

Kill a Patent

If your wanting to kill some time, try this. Took me about 10 or 15 min to find a good one.

Ask Patents puts out recent software patents for the public to dispute. You think of an existing software or website that does what the patent says and submit it as prior art.

Poof - The patent is dismissed.

Awesomeness.

http://www.joelonsoftware.com/items/2013/07/22.html
How to Read a Patent in 60 Seconds

Followers