For those of you who develop in Dot Net, you should be aware that Microsoft has stopped supporting recent versions of the Dot Net framework. Support for Versions 4.0, 4.5 and 4.5.1 discontinued this week, Tuesday, January 12, 2016. Versions 3.5, 4.5.2, 4.6 and 4.6.1 will continue to be supported. This means any software you are using that uses the […]

So far these posts have been all about the concept of storing more of the raw data. I still think this is the direction things need to go. It’s a bit like cryogenic freezing for your data – you hope that new uses and solutions for that data will be discovered in the future. Or, you at least can see […]

Microsoft is making a bold move with IE 11, by deprecating earlier versions much quicker than in the past. Yesterday, they discontinued support for IE 8, 9, and 10. This is a much earlier lifecycle for discontinuing previous versions of the IE browser. The intention is to reduce the amount of support needed to keep multiple versions running concurrently, reducing […]

I mentioned in the post yesterday that I think it’s getting more and more common and more important to store more information in its “root” or most basic form. If you’re processing information from different sources (flows of information, different data sources, etc.) when you consider the storage costs, it can be far more beneficial to have that information later. […]

A finbonacci sequence is a sequence of numbers that add the two previous numbers to determine the next number in the sequence. So a sequence starting with 0 and 1 would look like… 0,1………..0 + 1 0,1,1………1 + 1 0,1,1,2…….1 + 2 0,1,1,2,3…..2 + 3 0,1,1,2,3,5…3 + 5 etc. I am using a sequence table to determine how many times […]

An interesting issue is showing up as I’ve talked with a couple of different people about their systems, and as we’ve been working with our own data and storage profiles. With Big Data on the scene, the emphasis is on getting information through, processed and reported on – looking for trends, looking for usable information from the raw data. But […]

Stored procedures can be difficult to test. The logic can be quite complex from time to time. So, how do you test them? When I have a complex stored procedure, without respect to the kind of procedure being created (Insert, Update, Delete, Query), there are a few tips I have found that help validate that the procedure is working correctly. […]

Today I’m sharing a couple of programming tips for Stored Procedures I have found to be helpful, but not commonly demonstrated. First, I like to declare local variables in stored procedures, using them like an ENUM in other languages. They do away with magic numbers, or the need to have comments wherever numbers are used. Instead, I declare a variable […]

I wanted to pass along a lesson that we learned deploying a system to the cloud – in this case Amazon Web Services – as it can be a signficant expense surprise if you’re not aware of it. We had deployed an Amazon RDS database instance in a VPC all its own. We wanted to wall it off a bit […]

SSWUG was created from scratch – every line of code built to provide the content management, the searching, the articles and so much more. This all started more than a decade ago. Since then, we’ve been through a few UI changes as we built out different options and capabilities and even as we jumped headlong into the virtual events options […]