(Ged Mead) Aggregate functions are used to get summary outputs from queries – things like the total count of elements, summed values, average values, minimum and maximum values. It also includes the All function that will return a Boolean true or false value depending on whether all elements in a c
Other News
MarkLogic: Sending and Receiving XML Content over HTTP
(Alex Bleasdale) A fairly common requirement for an application built on MarkLogic Server could be to:
LINQ To SharePoint: Performing CRUD operation on Cascade Lists
(Pravinkumar Dabade) In this article, we will see how to perform LINQ queries on SharePoint cascade lists. We will also see how to perform CRUD (Select, Insert, Update and Delete) operations using LINQ to SQL.
ESCAPE to Find That Special Character
(Troy Coleman) Have you ever found yourself trying to search a string by finding characters like percent (%) or underscore (_)? I’m occasionally asked about this, so I figured it would be a good topic for discussion.
Flexviews – part 3 – improving query performance using materialized views
(Justin Swanhart) In my first post in this series, I described materialized views (MVs). An MV is essentially a cached result set at one point in time. The contents of the MV will become incorrect (out of sync) when the underlying data changes.
SQL Server: First and Last Day of Year, Quarter, Month and Week
(Suprotim Agarwal) With so many questions floating around calculating the first and last day of a given duration in SQL Server, here’s a post that explains the technique of calculating the first and last day of a given duration. We will cover the following:
Practical SQL: Calling RPG from SQL, Part I
(Joe Pluta) SQL and RPG are powerful and complementary tools. SQL does things well that are difficult or nearly impossible in RPG and vice versa. The trick is to develop programming strategies that take advantage of both.
Leverage your Oracle 11g skills to learn DB2 9.7 for Linux, UNIX and Windows
(Suita Gupta, Allan Tham, Raul Chong and Alain Fisher) If you’re a database specialist interested in growing your DB2 9 skills, there’s a good chance that you’ve already developed database skills with another relational database product somewhere along the way.
How to easily test your ADO.NET connections
(David Thielen) If you are having trouble connecting to a database using a program that uses an ADO.NET connector (which is pretty much every C# and .NET app), this program is a great way to test it step by step. There is no license for this code – do anything you want with it.
Why the radio silence with this data breach?
Why the radio silence with this data breach? I’m confused. "The cloud is the answer" to so many things from scalability to security and performance. Sure, it’s not the be-all, end-all, but it is touted as a rational extension to your systems. I get it, and I agree… but I’ve been concerned about security from the get-go. I also think […]