(Nikolay Savvinov) Two most popular causes for log file sync waits are redo filesystem I/O and CPU (or CPU scheduling). I’d like to share an example of a third scenario.
Other News
BBED Block Browser EDitor for Oracle 11g
(Gokhan Atil) BBED (Block Browser Editor) is a tool for Oracle internal use, and it helps you to read and manipulate data at the Oracle Database block level. No need to say that it’s very powerful and also extremely dangerous because you can corrupt data/header blocks.
To Skip, Or Not To Skip
(David Fitzjarrell) An interesting issue presented itself just recently with a logical standby database I manage. The database is used for generating reports and the client wanted to skip all DML activity for a given schema as it wasn’t necessary for reporting purposes.
Correctly handling Linked Server objects in SSDT
(Arvind Shyamsundar) Recently I had spoken at the SQL Bangalore User Group about using SSDT and Visual Studio Online to have an efficient and agile development process for the cloud-first world. After my talk meeting, an attendee had asked me about correctly handling four-part names (objects referen
Dynamic authentication for connectors in WebSphere Cast Iron, Part 1: Authenticating SAP and HTTP connectors dynamically
(Madhavi Kota and Aparna Srinivasan) This article series shows you how to enable dynamic authentication connectors in WebSphere Cast Iron Studio. Part 1 shows you how to dynamically provide the connection parameters and connection pool options for authentication in WebSphere Cast Iron for SAP and HT
How to Get REST Data and Display it in a DataGridView (or not) using JSON.NET
(B. Clay Shannon) This tip is related to this one, which shows how to easily call a REST method that returns a scalar value.
Rule Of Thumb: Always Define And Consume An ArgumentCollection Map In A Single Context
(Ben Nadel) ColdFusion has the awesome ability to programmatically define function arguments before a given function is invoked. Depending on how this gets used, this can be awesome; or, it can be a frustrating debugging nightmare for you or the next developer.
Protect Confidential SQL Server Data Q and A
(Tim Smith) Following the webcast on protecting confidential data, a few viewers asked excellent questions unrelated to RegEx and the below provide some approaches as answers to these questions.
Fix the Symptoms, Not the Cause
Too many times when things don’t work the way we want them to we “Fix the Symptoms, not the cause”. Usually the symptom is slow performance. Today I’ll share a few war stories. One application I designed was used to manage funds and the fund distributions. The database was nicely normalized. I had a user that wanted to see everything […]
SQL Server 2014 Reporting Services Optimization Tips
SQL Server 2014 Reporting Services Optimization Tips Consider using the Google Chrome browser to run the Reporting Services native mode Report Manager. SQL Server 2014 release of Reporting Services adds support for the Google Chrome browser. So, you can use the Google Chrome browser to run the Reporting Services native mode Report Manager to manage reports and the report server....
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