(Gary Myers) There’s been some mentions of this feature on Oracle-base and elsewhere, but here’s an example of what excites me.
Author: SSWUG Research
How to change the open mode of all pluggable databases
(Marco V.) When you need to modify the open mode of all your PDBs at the same time (look at this post if you want to change the open mode of only a specific pluggable database) you can use ALTER PLUGGABLE DATABASE command and the ALL option.
InnoDB Full-text Search in MySQL 5.6: Part 3, Performance
(Ernie Souhrada) This is part 3 of a 3 part series covering the new InnoDB full-text search features in MySQL 5.6. To catch up on the previous parts, see part 1 or part 2
Geek City: sp_cacheobjects for SQL Server 2012
(Kalen Delaney) In a post about 4 1/2 years ago, I gave you my version of a replacement for the old pre-2005 pseudotable syscacheobjects. I called it sp_cacheobjects and created it as a view in the master database. With the sp_ prefix, the view can be accessed from any database.
What’s New with SQL Server 2014
(Greg Larsen) I know you have been waiting for the next release of SQL Server. Well you don’t have to wait any longer. On June 25th Microsoft released the first community technical preview (CTP1) for the next version of SQL Server.
Reuse Of Empty Index Leaf Blocks (Free Four)
(Richard Foote) A recent question by Stalin Subbiah has prompted me to write a quick post on the reuse of empty leaf blocks. In part, the question asked:
Unit and Integration Testing of SSIS Packages
(Pavle Guduric) I worked on a project where we built extract, transform and load (ETL) processes with more than 150 packages. Many of them contained complex transformations and business logic, thus were not simple “move data from point A to point B” packages.
COPYTOCOPY: The Forgotten Little DB2 Utility?
(Craig S. Mullins) The COPYTOCOPY utility was introduced some time ago now, way back in DB2 for z/OS Version 7. The purpose of the COPYTOCOPY utility is to make additional image copies of currently existing image copy data sets.
Streamlining DB2 for z/OS Database Administration with the DB2 Administration Solution Pack for z/OS
(Paolo Bruni, Tom Crocker, Elaine Morelli and Richard Schaufuss) IBM DB2 Tools for z/OS support and exploit the most current versions of DB2 for z/OS. These tools are integral for the administration of the DB2 for z/OS environment and optimization of data performance.
Content Validation in ASP.NET Web API – Back to Basics
(Suprotim Agarwal) My colleague and DNC author Sumit was recently consulting for a project where devs were a little confused on how exactly Model Validation was working.