(Dave Beulke) Big Data analytics are all in fashion these days, but there are many issues with how analytics are used, and how developing the appropriate analytics takes a correct and thorough data model. As I talked about in my previous Big Lies, Big Damn Lies and Statistics blog post, there are m
Author: SSWUG Research
Flashback query FTS costs
(Alex Fatkulin) In a nutshell, the way optimizer costs full table scans when using flashback query makes it look much more expensive than without. What further complicates the problem is the fact that index access costs remain the same regardless of whether you’re using flashback query or not. As a
SQL Plan Management – how to really utilize and not just implement
(John Hallas) The title of this post is intentionally slightly unclear and hopefully it is intrigued people to view the post and even better, add their comments.
MySQL security top wish list
(Shlomi Noach) Security seems to have no boundaries. I’ve been tightening our database security lately, and it seems like this could go on forever: from app to console to privileges to server, there are so many aspects to managing database security. Unfortunately, this is a field where MySQL is in p
ExpandPath() Works With ColdFusion’s Per-Application Mappings
(Ben Nadel) I don’t use ColdFusion’s expandPath() function very much. Sure, I’ll use it in a demo when I want to just "get it done;" but, I rarely use it in any production code. I don’t completely understand how expandPath() works, which has lead to invalid file paths and broken sites. That said, I’
NuGet 2.7 Package Restore Tips
(jeffhandley) Since the release of NuGet 2.7 with Automatic Package Restore and implicit consent, many developers have adopted the new approach and provided some great feedback on their experiences. Based on that feedback, we have collected a set of tips to help you start using the new restore featu
Forced Override of Virtual Methods
(Richard Carr) Some scenarios require that virtual methods must be overridden in subclasses of a given type, an example being a requirement to override GetHashCode and Equals in data objects. This example describes how to enforce such overriding.
Three Ways Of Attaching Success, Failure And Completion Callbacks To JQuery $.Ajax()
(Bipin Joshi) While using jQuery $.ajax you often need to perform some custom operations upon successful completion of the Ajax request. You may also need to handle errors (if any) that are thrown while issuing the request. To that end jQuery allows you to wire three callback functions as listed bel
Checking SQL permissions on many SQL Server objects
(Steve Endow) I am working with a Dynamics GP client that is having an odd issue with an ISV solution related to SQL server permissions. The ISV solution is designed to only allow one Dynamics GP login to access its tables and stored procedures–so that only one instance of the application is runni
Geek City: How old are my statistics?
(Kalen Delaney) This post is basically to answer a question asked in class this week: How can we get the last statistics update date for ALL user tables in a database?