(Sourav Kayal) This article provides an example showing the DELETE HTTP verb and how to generate a delete request using the jQuery ajax() function.
Author: SSWUG Research
Compare Durandal to Angular, Not Knockout to Angular
(John Papa) Odds are you have been asked recently: “How does KnockoutJS compare to AngularJS?” There seems to be a lot of attempts to compare these two awesome libraries. We can certainly compare them, but will this really get you where you want to go?
SQL Plan Management – 12C dumb feature
(Neil Chandler) In Oracle 11G, Oracle introduced SQL Plan Management (SPM). It is excellent (I love it to bits). It allows you to create Baselines against SQL which lock-down the SQL execution plan. No more plan flips. More consistency. Perfect.
Do you see a ‘Congested’ State for HADR while Performing Reorgs?
(Ember Crooks) I monitor HADR closely, and want to be paged out if HADR goes down. Why? Because any subsequent failure would then be a serious problem. Once HADR has a problem, I suddenly have a single point of failure. That said, for some clients we have to tell our monitoring tools not to alert on
SHOW EXPLAIN in MariaDB 10.0 vs EXPLAIN FOR CONNECTION in MySQL 5.7
(Sergey Petrunia) MariaDB 10.0 has SHOW EXPLAIN feature. It was coded by yours truly and first introduced about a year ago. Last release of MySQL 5.7 introduced EXPLAIN FOR CONNECTION, which looks rather similar to MariaDB’s SHOW EXPLAIN. I was wondering how these two compare.
Using jQuery to Embed a Slideshow in a Tumblr Blog
(Accusoft) Tumblr is a microblogging platform and social networking website that is probably best known for funny pictures, videos, animated GIFs, and of course, NSFW content. Tumblr does a great job of letting all types of people express themselves using all forms of media–except one. You can’t pu
Revisiting How to Avoid Referential Integrity Errors
(Chandra Sekhar Pathivada) Most of the time, DBAs need to deal with archiving, deleting, inserting, and masking data in relational tables. One major challenge that’s common to all these activities is to mitigate the problems with references (i.e., foreign keys), where one table refers to other table
SSWUGtv: 12 steps to take in advance of your next holiday or vacation to make sure you can make the most of your time away, hopefully without
Video Programming for IT Professionals
How to read the SQL Server Database Transaction Log
(Manvendra Singh) Have you ever wondered how SQL Server logs track transactions and what information SQL Server captures in the transaction log file? In this tip we will take a look at a SQL Server function that you can use to read the transaction log to see what entries are made for database trans
Designing a Lossless Information System with a Proof Of Concept in ASP.NET, Entity Framework and Ninject
(Sumit Maitra) This article introduces a database design pattern with a POC in ASP.NET, Ninject and Entity Framework that ensures data once inserted into the database is never lost, a must have for financial systems.