(Abhay Shanker) This article explains how to do insert, update and delete operations in a XML file using C#.
Other News
SQL Server Analysis Services Perspectives
(Scott Murray) What are SQL Server Analysis Services Perspectives? What do they do and how can they be used? Check out this tip to learn more.
Tips to Managing Two Jobs for One Paycheck
Tips to Managing Two Jobs for One Paycheck 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...
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
How to identify and cure MySQL replication slave lag
(Muhammad Irfan) Here on the Percona MySQL Support team, we often see issues where a customer is complaining about replication delays – and many times the problem ends up being tied to MySQL replication slave lag.
Adaptive Form with Dynamic ADF Attribute Value Binding
(Andrejus Baranovskis) You can implement adaptive forms, generated on runtime using ADF Dynamic Form component in 11g R1 or 11g R2 (keep in mind – ADF Dynamic Form component is not supported with Facelets). In 12c you could use new ADF Dynamic Component to generate adaptive forms.
Escaping from a runaway Logon trigger
(Kenneth Fisher) Most people know that logon triggers can be dangerous if you aren’t careful. And if you didn’t know, well, logon triggers can be dangerous if you aren’t careful. They can be really useful and are a great tool, but if you mess up you can REALLY mess up.
Database Backup Encryption with SQL Server 2014
(Rohit Garg) A brand new & long awaited feature “Backup Encryption” along with SQL Server 2014. Microsoft reveled this upcoming feature in PASS summit & from then users are waiting for this. Currently backup encryption supporting four encryption algorithms: AES 128, AES 192, AES 256, and Triple DES
TSQL User-Defined Functions: Ten Questions You Were Too Shy To Ask
(Robert Sheldon) SQL Server User-Defined Functions are good to use in most circumstances, but there just a few questions that rarely get asked on the forums. It is a shame, because the answers to them tend to clear up some ingrained misconceptions about functions that can lead to problems, particula
SQL SERVER – CTE can be Updated
(Pinal Dave) Today I have received a fantastic email from Matthew Spieth. SQL Server expert from Ohio. He recently had a great conversation with his colleagues in the office and wanted to make sure that everybody who reads this blog knows about this little feature which is commonly confused.
Partitions and Segments and Data Objects
(Hemant K Chitale) Have you ever wondered about how Partitions are mapped to Segments ? How does Oracle identify the “data object” (as different from the logical object) that maps to the Segment for an Object ?