(Sergey Petrunia) Valeriy has mentioned that MySQL manual has no documentation about EXPLAIN FORMAT=JSON feature. There was a bug filed for this since September, 2012. I had spent some time looking at EXPLAIN FORMAT=JSON, so I thought I would share my findings.
Author: SSWUG Research
SQL Developer v4 Quick Hit: Split Worksheets
(Jeff Smith) One of the cooler features SQL Developer offers is the ‘split document.’ If you don’t know what I’m talking about, please take 90 seconds and read this short post first.
Two common mistakes using METHOD_OPT in DBMS_STATS
(Carlos Sierra) When gathering Cost-based Optimizer (CBO) statistics for a Table, most probably you use DBMS_STATS directly (unless your application is EBS, PSFT or Siebel). There are a couple of common mistakes we see around the use of the METHOD_OPT parameter on GATHER APIs out of this DBMS_STATS
Selecting into Variables in Transact-SQL
(Richard Carr) Variables are essential to the operation of many stored procedures, as they allow the temporary storage of values calculated using the operators and functions provided by Transact-SQL. Assigning variable values from query results is a common technique.
How to change the open mode of listed PDBs
(Marco V.) The clauses of the ALTER PLUGGABLE DATABASE statement that modify the mode of a PDB are:
How to Secure Microsoft SQL Server
(Hemantgiri Goswami) Security! This is a top-of-mind word for every concerned person when it comes to storing, accessing, and sharing data, databases, or database servers.
Big Data: Ten Criteria for Evaluating Analytics Reporting Tools (Part 1)
(Dave Beulke) Last week I talked about how to get involved in the latest conversations about Big Data analytics. When working with the Big Data analytics, the end business users reporting tools are critical. Your older tools may not be up to today’s Big Data analytics capabilities, such as deliver
Compression Becoming More Important in the Age of Big Data
(Craig S. Mullins) DBAs and database professionals have been aware of the pros and cons of compressing data for years. The traditional argument goes something like this: with compression you can store more data in less space, but at the cost of incurring CPU to compress the data upon insertion (and
Managing Mediocre Employees
Mediocre employees are the most frustrating because they’re the ones who aren’t bad enough to reprimand, but they’re far from being superstars either. There are some simple ways to encourage high performance and eliminate ‘mediocre employees’.
Remove a Bad Web Part in SharePoint
(Mai Omar Desouki) When we develop a web part, we definitely face errors. Unfortunately these errors may prevent you from loading the page. Instead, all you can see is an error! Helpful, I know!