(Richard Carr) Judging the maintainability of an application’s source code objectively during code reviews can be difficult. To help, some Visual Studio editions can calculate code metrics, such as cyclomatic complexity, depth of inheritance and lines of code.
Author: SSWUG Research
Discover, Diagnose, and Document ALL Your SQL Servers On Your Coffee Break
(Kendal Van Dyke) We all know that we should document our SQL Servers, right? RIGHT?
SQL Server Security Audit (Part 2): Scripts to help you or where can you find more information
(Svetlana Golovko) The first article (“Part 1”) listed some of the checks for the database security audit. In this tip we look at many different security settings and configuration settings that you should be aware of. There are several scripts that you can run to know if there are any potential se
Mega Menus for SharePoint – Part 2 of 3
(Heather Solomon and Dustin Miller) This is the second part of a three part series where Heather Solomon and Dustin Miller are exploring the ever-popular “Mega Menu”, and how to create a powerful, styled and functional mega menu for use on your SharePoint sites.
Tuning the Oracle Connector performance in IBM InfoSphere DataStage, Part 1: Overview of the connector tuning process and optimization of fetch, lookup and DML operations
(Predrag Maksimovic) The Oracle Connector is a connectivity component in IBM InfoSphere Information Server. It is utilized by IBM InfoSphere DataStage and other products in the Information Server suite to perform extract, lookup, load, and metadata import operations on Oracle databases.
What it Does (SET TRANSACTION READ ONLY – Part 4)
(Andrew Reid) This was tested on Oracle 11.2. So far, I have not explained what SET TRANSACTION READ ONLY does. To illustrate this, I first need to show what happens normally, i.e. when you are not in a READ ONLY transaction.
SQL SERVER – Fix : Error: 217 Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query.
(Pinal Dave) Just a day before I was working on some query and faced this error. As soon as I receive this, I realized that what I had done wrong and what I needed to fix. The suggestion demonstrated in the error message is to the point and accurate.
Capitalizing on Big Data with System z
(Mark Simmonds) For many organizations, the IBM System z platform holds the mission-critical information that forms the basis of key decisions. It might not be surprising, then, that more and more organizations that use System z are moving analytics and decision engines closer to the rich source of
Does it matter if your SQL is bad?
(Tony Baer) The title of this post is a paraphrase of a question raised, by IDC analyst Carl Olofson at an IBM Big Data analyst event earlier this week.
Use jQuery to call ASP.NET Web Service the right way!
(TaiseerJoudeh) Recently I was revising an application created long time ago which uses AJAX and jQuery extensively, and I found myself doing a common mistake which many articles and forums fall into it. The mistake is Normal Serialization for service methods responds than deserializing the JSON str