(Dave Stokes) MySQL Triggers are changing in 5.7 in a big way. Triggers have been around since 5.0 and have not changed much up to 5.6 but will gain the ability to have multiple triggers on the same event. Previously you had ONE trigger maximum on a BEFORE UPDATE, for example, and now you can have m
Other News
The DB2Night Show z46: What’s New in DB2 11 SQL Coding and Tuning
(Martin) 99% of our studio audience learned something!Sheryl provided intimate details on performance and SQL coding for DB2 11. Watch the replay…
SQL SERVER – How to Recover SQL Database Data Deleted by Accident
(Pinal Dave) In Repair a SQL Server database using a transaction log explorer, I showed how to use ApexSQL Log, a SQL Server transaction log viewer, to recover a SQL Server database after a disaster. In this blog, I’ll show you how to use another SQL Server disaster recovery tool from ApexSQL in a s
ORA-01031 Creating a View on a Table Accessed via a Role
(Andrew Reid) This example shows that you cannot create a view on a table which you access via a role. It was tested on Oracle 11. First I created a role:
Creating Asynchronous Alerts, Prompts, And Confirms In AngularJS
(Ben Nadel) When you first get into JavaScript, using the native alert(), prompt(), and confirm() methods feels comfortable because they are “blocking” actions. This means that when those methods execute, the world stops and your code pauses until the user responds.
jQuery Interview Question and Answers With Practices: Part 1
(Sachin Kalia) In this article you will learn about jQuery interview questions and answers with practices.
Troubleshooting Database Corruption
(Robert Haas) When your database gets corrupted, one of the most important things to do is figure out why that happened, so that you can try to ensure that it doesn’t happen again. After all, there’s little point in going to a lot of trouble to restore a corrupt database from backup, or in attempti
Oracle #GoldenGate Replicate Apply (Run) Rate
(Bobby Curtis) For a couple of weeks now, I’ve been trying to figure out a way to identify the size of data for transactions that are getting processed over a give period of time with Oracle GoldenGate. When I started to think through the process, I keyed in on the Relative Byte Address (RBA).
Using SQL Stored Procedures with VB.NET
(Hannes DuPreez) A month or so ago, I wrote a few articles introducing you to the world of databases and VB. If you have followed them, you have seen that it is not particularly difficult to use databases properly from VB. Today’s article is no exception. Today I will talk about using stored procedu
Building OData Service using ASP.Net Web API Tutorial – Part 1
(Taiseer Joudeh) In my previous tutorial we’ve covered different aspects of how to Build RESTful service using Asp.NET Web API, in this multi-part series tutorial we’ll be building OData service following the same REST architecture we’ve talked about previously.