(Rob Gravelle) For most applications, MySQL’s Round() function is more than adequate. It uses Half Away From ZERO rounding, whereby numbers whose last digit is 5 or greater are rounded up to the next significant digit away from zero. The problem with that – and many other rounding algorithms – is th
Author: SSWUG Research
Geek City: Did You Know … that not everything you know is actually true!
(Kalen Delaney) Software changes, new versions not only add new features, they also change internal behavior of old features, and not all the changes are documented! And how often, after a software upgrade, do you go through and test everything you knew was true, to make sure it is STILL true afte
Result Cache Latch and PDBs
(Alex Fatkulin) One interesting aspect of Oracle 12cR1 database when it comes to PDBs is how latching is done. For example, if all PDBs have to work under the same latch then contention in one PDB can easily affect users in other PDBs too.
Integrating With Fusion Application Using Services (PLSQL: APEX_WEB_SERVICE)
(Jani Rautiainen) Fusion Applications provides Web services that allow external systems to integrate with Fusion Applications. There are two types of services: ADF services and composite services. ADF services are created for a logical business object and provide functionality to access and manipula
Inside a RAC 12c GNS cluster
(Martin Bach) Based on some reader feedback I started looking at GNS again, but this time it will be for RAC 12c. According to the documentation GNS has been enhanced so that you can use it without subdomain delegation. I decided to try the “old fashioned” way though: DHCP for VIPs, SCAN IPs, subdom
Visual Studio Online Monaco Code Editor Walk-through – Part 1
(Abhimanyu Kumar Vatsa) In this post series I will show you how we can take advantage of Visual Studio Online “Monaco” to edit codes (HTML, CSS, C#, JavaScript etc) in the browser out of the box.
SQL SERVER – How to Script Statistics from SSMS? – Scripting Statistics is Disabled in SSMS
(Pinal Dave) Here is a very interesting question, I have received after reading yesterday’s blog post SQL SERVER – Statistics for Read-Only Database are in TempDB.
Finding active DTS packages
(Kenneth Fisher) DTS is dead, long live SSIS. Way back when SQL 2005 was announced then released DTS was pronounced DOA. SSIS was the wave of the future. Everyone was so thrilled that posts like SSIS’ 15 faults and Why I hate SSIS: Part N+1 were all over the place, and I was right there with them. M
Parsing Current Cost XML Data and Storing it in a MongoDB Collection
Well, I’ve moved house again, and once again I’ve set up my electricity meter, and once again I can’t find the code I was using to log the data the previous time. So, I’ve ended up re-writing code to log my current cost data, which I thought I’d blog about if only for the fact that next time I’ll kn
Using PowerShell in SharePoint 2013
(Pravinkumar Dabade) Microsoft introduced PowerShell in 2003 as an advanced automation-script language which replaces legacy DOS batch files. Since PowerShell is built on top of the .NET Framework and makes use of programming concepts from C#/VB.NET, it becomes easier for a .NET professional to writ