As I've mentioned a number of times, while I've spent the last decade mostly in DB2/LUW, I've done some work with SQL Server, and hang out at the Simple-Talk site. They have an editorial every now and again, which generates comments on RDBMS generally (usually) rather than SQL Server specific bells and whistles. The current one is "Passion" (yeah, that's right), and I was moved to comment. Shown here for your amusement.
I've been hanging around here for a few years, and I sure do view databases (even SQL Server) as a "calling" which is sorta, kinda like a "passion". All of the places I've managed to find employment have been in spite of this calling, alas. Perhaps it's different on the other side of the Pond, or with SQL Server centric venues (my main database has been DB2/LUW for some while), but "passion" isn't what's rewarded.
Certainly, the advent of multi-core/processor SSD machines will have a profound impact on how RDBMS applications are built. The transition just isn't happening fast enough to suit me.
The corporate bent of DB2 does seem to make it more hidebound than other databases; which is such a shame, in that the LUW version is so much better than any of the other databases that run on those platforms. IBM is truly squandering a major opportunity.
IFF AI, as currently implemented, can intuit Special Relativity from just a clock tower and a moving tram will I take AI seriously.
Infinite granularity yields infinite complexity.
Leading an Insurrection is now an Official Act
The world is not linear.
-- Dr. McElhone/1974
Well, I'm going to do it, whether the women like it or not. I'm going to protect them.
-- The Orange Shitgibbon©anon./2024 [y'all get burkhas]
Scientists aren't vocal enough about science. There are large groups of people who think scientists are all frauds and who don't
believe in science, and they're being cultured by some of our far right-wing politicians, religious leaders and community leaders. -- Dr. McElhone/1974
Well, I'm going to do it, whether the women like it or not. I'm going to protect them.
-- The Orange Shitgibbon©anon./2024 [y'all get burkhas]
-- Drew Weissman/2022
To date, Microsoft is stating that organizations testing In-Memory OLTP have
seen transaction speeds improve by up to 30 times compared to past
performance, with the best performance gains achieved when the business
logic resides in the database and not in the applications.
-- Jonathan Watts/2015 [my emphasis]
-- Jonathan Watts/2015 [my emphasis]
I have had to explain and re-explain and re-explain and re-explain, you know, how relational databases work, what is an eigenvector,
what is dimensionality reduction.
-- Christopher Wylie/2018
... but Flash-based storage has such a different performance profile from rotating media, that I suspect that it will end up having
a large impact on filesystem design. Right now, most filesystems tend to be designed with the latencies of rotating media in mind.
-- Linus Torvalds/2007
-- Chris Date/2009
Election day's thought
Democracy is the theory that the common people know what they want, and deserve to get it good and hard. -- H. L. Menken/1915 [
See you next week in a brand new show©Heckle and Jeckle
In a time of SSD, multi-core/processor, two terabyte memory and Optane App Direct Mode machines, there is no reason not to
build from BCNF data. Time to do what Dr. Codd demonstrated. Technology has finally caught up with the maths.
About
- Robert Young
- Been doing databases, both relational and others, as well as operations research since Hector was a Pup.
Shameless Plug
I know a little something about SQL, DB2 (preferably LUW, z/OS if the money's right), Oracle, SQL Server, Postgres, and database design in general. Mentoring/teaching/consulting on a short term basis, too. And a bit of stat analysis if it's R.
gnuoytr at rcn dot com.
gnuoytr at rcn dot com.
No comments:
Post a Comment