I had reason today to get the number of the day of the week, in PureData / Netezza, which I don’t seem to have discussed in previous posts. So, here is a simple script to get the number for the day of week with a couple of flavors, which may prove useful. Basic Format select … Continue reading Netezza / PureData – How to Number for day of week in SQL?
Microsoft Microsoft doesn't provide macro guidance for naming convention, however, sometimes it is useful to have a place to start. Also, there are times when flexibility with naming conventions are necessary. So, here is a quick set of SQL Server naming conventions, which may be helpful if you find yourself working with a customer who doesn't … Continue reading SQL Server – Basic SQL Server Object Naming Convention Guidance