(Morgan Tocker) One interesting feature of MySQL, is that it supports a very large number of integer data types. From the MySQL manual:
Other News
The DB2Night Show #137: IBM CLOUD UPDATE with Leon Katsnelson
(Scott Hayes) 100% of our audience learned something! Awesome! IBM has three pillars of priorities: 1) Cloud, 2) Analytics (big data), and 3) Engagement (including mobile). If you check Leon’s title again (above), LEON IS THE MAN covering two of the three important IBM priorities!
3 Important Big Data Design Points
(Dave Beulke) Mobile phone growth, sensor data recording, and social media updates feed big data into our systems. Whether your company likes it or not, startups and the competition are integrating big data and analytics into every aspect of their marketing, products, and operations.
Integrating IBM Mobile Web Push with WebSphere Commerce
(Bob Balfe) IBM Mobile Web Push extends WebSphere Commerce with the ability to send customized and targeted marketing offers to your mobile web pages. In this article, you will quickly integrate Mobile Web Push with WebSphere Commerce, then build an inbox of offers that can be triggered by specified
Oracle SQL Developer: Single Object Compare
(Jeff Smith) There’s a nasty rumor going around that you can’t compare database objects and/or code in Oracle SQL Developer. So let’s put that to bed right now. First, here’s how to compare:
The LGWR Three Second Rule. Really?
(Craig Shallahamer) I have learned the part of Oracle Database performance tuning is checking if what you have been taught is actually true. What I’m writing about today has been done before in Oracle Database 10g and 11g, but I wanted to document this using 12c.
Taking a Datafile Offline in NOARCHIVELOG Mode
(Andrew Reid) I was reading a colleague’s copy of Oracle RMAN 11g Backup and Recovery by Robert Freeman. It said that you could not take a datafile offline if the database was in NOARCHIVELOG mode.
Trivia about Trivial Plans
(Michael J. Swart) I found an example of a query plan which performs better than the “trivial” query plan.
SSIS Out of Memory/Buffer Manager errors
(Vinoth N Manoharan) Often I get queries from my developers regarding “out of memory exception” or Buffer Manager errors during data flow task, the frequent query they ask is “I am running the package in the SQL server box itself and if the SQL server is granted say 128 GB of memory why are we getti
Three-Byte Integers in SQL Server: Fact or Fiction?
(Bob Pusateri) I’ve been told on two occasions that the absence of the MEDIUMINT datatype is a serious shortcoming of SQL Server. If you’re not familiar with MEDIUMINT, it’s an integer type available in MySQL that consumes 3 Bytes and is capable of storing values ranging from -8,388,608 to 8,388,607