(Marco V.) The SYSBACKUP is a new privilege introduced in the Oracle Database 12c release that allows a user to perform any backup or recovery operations.
Other News
Join Conditions in Power Query, Part 2: Events-In-Progress, Performance and Query Folding
(Chris Webb) In my last post you saw how to join two tables together using conditions other than the built-in inner, outer and anti join conditions. However, as I mentioned, you need to be aware of some of the performance implications of using this technique – and that is the subject I’ll be looking
Ten Tips to Get the Maximum out of Visual Studio 2013
(Vipul Patel) As developers targeting the Microsoft platform, it has always been considered a “requirement” to use Visual Studio, and most developers do use it. However, not everyone who uses Visual Studio uses all of the features available in a particular version. In the fall of 2013, Microsoft rel
Foreign Keys and MySQL
(Dave Stokes) Foreign Keys are often a mystery to new DBAs in the MySQL world. Hopefully this blog will clear some of this up.
Why is DB2 Rewriting my SQL?
(Troy Coleman) The EXPLAIN statement provides a view into what DB2 determines is the optimum access path for accessing the data. The valid statements that can be processed by the EXPLAIN statement are SELECT, MERGE and INSERT, as well as search forms of UPDATE and DELETE.
RMAN Copy Adds Hidden Parameters
(Andrew Reid) Some testers had a problem with an application running against an Oracle 11.2.0.1.0 database. It kept failing with ORA-03114 and/or ORA-24909 messages. The only clues were that production was copied into test around 6 weeks ago, production was OK but test was not.
Configuration Management with PowerShell and XML
(Konrad Lukasik) For the rapid delivery of any software application, there must be an effective configuration management system that is scripted. As the application increases in size it becomes more important that configuration information is kept in one place, without repetition, in version control
SQL SERVER – Repair a SQL Server Database Using a Transaction Log Explorer
(Pinal Dave) In this blog, I’ll show how to use ApexSQL Log, a SQL Server transaction log viewer. You can download it for free, install, and play along.
Creating A Pixel-Based Version Of ngStyle In AngularJS
(Ben Nadel) Most of the time, when I used the ngStyle directive in AngularJS, I’m using it to set some kind of offset property (ex, height, width, left, right, bottom, top, ex.). This isn’t always the case; but, I’d hazzard a guess that these kinds of CSS properties account for 80% of my ngStyle usa
How Can Remote Employees Connect with Co-Workers?
How Can Remote Employees Connect with Co-Workers? Hello, this is Laura Lee Rose. I am a speaker and author. My background is in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even if they don’t have time to...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here