If you have been paying attention, you have noticed RAM prices are out of control Take a look at this order I placed on July 20th, so 4.5 months ago I paid $168.99 for 64GB of RAM. Four weeks ago, it was $297.99 so almost double What is it today? Check it out, here is a link to Amazon so you can see the current price https://amzn.to/43irnfi Today, this is what is listed as the price That's $537!!!…
If you browse LinkedIn these days, you can't escape the fact that a lot of profiles have a green #opentowork badge. I know a bunch of these people personally and know that they are technically very strong. But it's looking bleak at the moment, uncertainty with the tariffs and the overall economy has forced a lot of companies to not even give earnings guidance. These same companies have also…
Here are just some ideas of what I would like to do in 2021, these are all non professional goals if you will Run 800 miles I ran 800.3 miles last year, this should be easily doable, it's about 4 miles 4 times a week Read 50 books Last year I read 60 books.. I assume at some point, I will be back in the office two times a day or so, this will maybe bump it down to 50 books from 60 books Books in…
I am glad 2020 ended and hopefully 2021 will be much better. A couple of items on my list for this year got either postponed or will never happen. I planned to go to the PASS Summit in Texas in 2020, that obviously didn't happen and it looks like it won't happen in the future either. PASS is no more :-( Here are some numbers for 2020 that I put together looking at some sheets and journals 123,116…
This is a post detailing some stuff I did, learned, posted and tweeted this week, I call this TWID (This week in Denis). I am doing this mostly for myself... a kind of an online journal so that I can look back on this later on. Will use the label TWID for these In last week's post I mentioned that the pepper and tomato plants were ready to be planted outside. This was done yesterday and the plants…
This is a post detailing some stuff I did, learned, posted and tweeted this week, I call this TWID (This week in Denis). I am doing this mostly for myself... a kind of an online journal so that I can look back on this later on. Will use the label TWID for these It has been a while since I posted here.. but I decided to bring back the TWID posts again I have been reading a lot lately, since I am…
This came up the other day, someone wanted to know the percentage of NULL values in a column Then I said "I bet you I can run that query without using a NULL in the WHERE clause, as a matter of fact, I can run that query without a WHERE clause at all!!" I created a SQL Server version of this post here: How to count NULLS without using IS NULL in a WHERE clause , this is the PostgreSQL version To…
I took a stroll at the high-line in NYC yesterday and noticed that the Vessel was open to the public The Vessel is a copper-colored steel structure comprises 54 interconnecting flights of stairs, 2,500 steps, and 80 landings, it was designed by Heatherwick Studio's. The Vessel rises to a height of 150 ft (45 m) offering views of the city and the Hudson River. Here is what it looks like Here it is…
This is a post detailing some stuff I did, learned, posted and tweeted this week, I call this TWID (This week in Denis). I am doing this mostly for myself... a kind of an online journal so that I can look back on this later on. Will use the label TWID for these This Week I Learned Tsundoku Tsundoku (積ん読) is acquiring reading materials but letting them pile up in one's home without reading them.…
This is a post detailing some stuff I did, learned, posted and tweeted this week, I call this TWID (This week in Denis). I am doing this mostly for myself... a kind of an online journal so that I can look back on this later on. Will use the label TWID for these Didn't do a TWID post for a couple of weeks, will continue regularly from this week on. Had an issue with my foot... still not sure if I…
This is a post detailing some stuff I did, learned, posted and tweeted this week, I call this TWID (This week in Denis). I am doing this mostly for myself... a kind of an online journal so that I can look back on this later on. Will use the label TWID for these This Week I Learned Finished the Pluralsight course Applying SQL Server 2016 Features to Real-world Data Problems by Ana Voicu Death by…
Our family went to Howell Living History Farm for the tree tapping event 6 years or so ago, the kids were little and didn't really remember the event. We decided to repeat the event this year so that they would remember this. From our home in Princeton it's about a 25 minute drive, not too bad It was a cloudy day, so the pics look a little gloomy but it was not too cold Here you can see some…
This is a post detailing some stuff I did, learned, posted and tweeted this week, I call this TWID (This week in Denis). I am doing this mostly for myself... a kind of an online journal so that I can look back on this later on. Will use the label TWID for these This Week I Learned Almost finished with the book The Annotated Turing: A Guided Tour Through Alan Turing's Historic Paper on…
The other day I was reading something on Hackernews and someone posted a link to a Sexy Primes wikipedia article. I looked at that and then decided to do this in SQL Server because.. why not? Then I decided to see how different this would be to do in PostgreSQL. For the first method to create the prime numbers it's different. For the method with the CTE it is very similar From the Sexy Primes…
This is a post detailing some stuff I did, learned, posted and tweeted this week, I call this TWID (This week in Denis). I am doing this mostly for myself... a kind of an online journal so that I can look back on this later on. Will use the label TWID for these This Week I Learned Continued reading the book The Annotated Turing: A Guided Tour Through Alan Turing's Historic Paper on Computability…
This is a post detailing some stuff I did, learned, posted and tweeted this week, I call this TWID (This week in Denis). I am doing this mostly for myself... a kind of an online journal so that I can look back on this later on. Will use the label TWID for these This Week I Learned Continued reading the book The Annotated Turing: A Guided Tour Through Alan Turing's Historic Paper on Computability…
This is a post detailing some stuff I did, learned, posted and tweeted this week, I call this TWID (This week in Denis). I am doing this mostly for myself... a kind of an online journal so that I can look back on this later on. Will use the label TWID for these This Week I Learned Continued with the Getting Started with Docker Swarm Mode Pluralsight course Started reading the book The Annotated…
This is a post detailing some stuff I did, learned, posted and tweeted this week, I call this TWID (This week in Denis). I am doing this mostly for myself... a kind of an online journal so that I can look back on this later on. Will use the label TWID for these This Week I Learned Continued with the Getting Started with Docker Swarm Mode Pluralsight course Finished A History of Japan by R.H.P. And…
This is a post detailing some stuff I did, learned, posted and tweeted this week, I call this TWID (This week in Denis). I am doing this mostly for myself... a kind of an online journal so that I can look back on this later on. Will use the label TWID for these This Week I Learned Continued with the Getting Started with Docker Swarm Mode Pluralsight course Finished D'Aulaires' Book of Greek Myths…
I got a Bullet Journal as a gift in December and have been messing around with it a little The one thing I like to have in my Bullet Journal is a progress wall or progress grid What a progress wall can do for you is to visually let you know how long you are from your goal. You can make it look neat and pretty or as in my case a little messy I decided to run 750 miles this year and also do 15,000…
This is a post detailing some stuff I did, learned, posted and tweeted this week, I call this TWID (This week in Denis). I am doing this mostly for myself... a kind of an online journal so that I can look back on this later on. Will use the label TWID for these This Week I Learned Finished the Getting Started with Docker Pluralsight course Rules of 3... for survival 3 Minutes for air 3 Days for…
I wanted to do some date calculations in PostgreSQL and was doing some research on if something like the DATEDIFF function that exists in SQL Server is available in PostgreSQL. These notes are mostly for me so I can refer back to them..but maybe they are useful for someone else as well In SQL Server to add dates, minutes and other fractions of a date to a date, you can use the DATEADD function…
Back in the pre windowing function days, if you wanted to do a running count, you either had to run a subquery or you could use a variable. This was slow because for each row the query that did the sum would be executed. With windowing functions in PostgreSQL, this is now running much faster. Let's take a look, first create the following table CREATE Temp TABLE test(Id int ,SomeDate date , Charge…
Image by Jahobr - Own work , CC0 , Link Since today is Fibonacci day I decided to to a short post about how to do generate a Fibonacci sequence in PostgreSQL. But first let's take a look at what a Fibonacci sequence actually is. In mathematics, the Fibonacci numbers are the numbers in the following integer sequence, called the Fibonacci sequence, and characterized by the fact that every number…
The other day I walked past the building in the picture above and I felt a little sad. The reason I felt sad is because I have great memories about this building. When I first came to the US from the Netherlands I was amazed at how big this store was and how they had so many things on display. In Amsterdam where I arrived from, you didn’t really have a store like this. The story was named J&R,…