(Jeff Smith) When you start working with 12c, if you want to freak out (sorry, GRAB the attention of) your co-workers or folks attending your presentation, try this:
Other News
ORA-19599 block corruption when filesystemio_options=SETALL on ext4 file system using Linux
(Marko Sutic) Few days ago I experienced strange issue in my development environment running on OEL 5.8 with EXT4 filesystem. Note – EXT4 filesystem is supported from OEL 5.6 version.
Reading Oracle memory dumps
(Frits Hoogland) Every DBA working with the Oracle database must have seen memory dumps in tracefiles. It is present in ORA-600 (internal error) ORA-7445 (operating system error), system state dumps, process state dumps and a lot of other dumps.
Build Bluemix applications for WebSphere Commerce
(Marco Deluca, David Finn and Octavio Roscioli) Create your own widget ecosystem on IBM Bluemix. This article focuses on building Bluemix widgets, the developers creating them, and how they can deliver new tools to line-of-business users. It briefly describes the dynamism between experience creato
Cryptography: Client-side AES Encryption Using Google Javascript Crypto Library
(The Operator) Use JavaScript to write AES encryption and decryption methods
[SQL Snacks Video] Performance Tuning 102 – Files, FileGroups, and TempDB
(Ayman El-Ghazali) Finally the arrival of Part 2 of my SQL Snack Pack on Performance Tuning! The series is dedicated to help beginners understand how to start performance tuning with SQL Server.
Finding a common AD group for a set of users.
(Kenneth Fisher) I work for a large organization that over the last few years has been doing a LOT of reorgs. And what comes with reorgs? Lots of security requests. I’m always working to find easier ways to deal with them and I’ve gotten pretty good at it over time.
Capturing Database(s) and Table Usage stats – sp_spaceused simulation using DMVs
(prashanthjayaram) sp_spaceused is one of the system stored procedure used frequently by many DBA’s that reveals amount of space used by database/tables. This procedure can be executed either by passing parameters or no parameters.
SQL SERVER – List the Name of the Months Between Date Ranges – Part 2
(Pinal Dave) Last week I wrote a blog post about SQL SERVER – List the Name of the Months Between Date Ranges. It was written in the response to the question – How to list the name of the months between two date ranges? In the original blog post, I made a small error, hence I corrected that in the […]
But Developers Write Poorly-Performing SQL!
(Lockwood Lyon) This is an unfortunate but very common truth. Best practices and SQL implementation standards are the DBA’s friends in this environment. Perhaps you can convince developers that “Expert SQL developers code like this!”, and give them examples of good-performing SQL, or even bad exampl