DRI (Declarative Referential Integrity) does a lot of busy work for you we used to have to do ourselves when it wasn’t available. At one time, referential integrity had to be manually coded through the use of triggers. You can still do this today if you have a need. In the trigger for a child table you would test for […]
Other News
DB2 Geek Highlights of 2014
(DB2 Geek) Well, it’s been another busy year for the DB2 Geeks. We take a look at some of our favourite DB2 experiences and blogs over the past 12 months.
Developing a Simple Twitter App with Visual Basic and Windows 8.1
(Hannes Du Preez) It seems as if I have a fetish for social media apps this month… Probably. Twitter is basically a short message service system for the internet. I have always felt a bit limited with only 140 characters, but I guess Facebook makes up for it.
Cross domain RESTful API calls?
(MVukoje) Maybe you started moving more of your web app logic to client and relying on RESTful services for client-server communication knowing that someday other people will be able to reuse these services as remote API to you app.
Excessive commits?
(savvinov) Let’s consider a hypothetical scenario. Suppose you have a process A that you want to run faster. This process doesn’t commit (much), so it doesn’t wait on log file sync.
Everything about MySQL Users and Logins You Didn’t Know and Were Afraid to Ask
(Georgi Kodinov) Logging into a MySQL server is generally dead simple—supply a username, a password, and you’re all set!
Modify SQL Server Reporting Services Rendering Format In SharePoint-Integrated Mode
(Edwin Sarmiento) In a previous tip on Making Adjustments to SQL Server Reporting Services Configuration Files, we’ve seen how we can modify the rendering format of a Reporting Services report by making changes to the RSReportServer.config file. However, this does not work when Reporting Services is
Analyzing Historical Performance Data – More Reports, Tuning Tactics
(Lockwood Lyon) This report allows the DBA to drill down into plan/package details. It gives extremely detailed information about Plans and Packages. It is typically used after the DBA has referenced the Accounting Short Report and determined that there may be a performance issue.
WPF Shapes – Polygon
(Richard Carr) The one hundred and twenty-second part of the Windows Presentation Foundation Fundamentals tutorial continues the examination of the WPF shapes. This article considers the Polygon class, which creates a closed shape from a series of points.
Data Validation Using JavaScript
(Joginder Banger) This article shows how to do validation of textbox, dropdownlist and fileuploader in JavaScript.