(Mudita Rathore) This article explains the Representational State Transfer (REST) services with the attribute routing. REST is based on the client/server architecture in which both communicate with each other.
Author: SSWUG Research
Linking Breakpoints in Visual Studio
(Richard Carr) Breakpoints are useful tools for debugging code. They allow the code to be halted at a specific position so that variables can be examined. Visual Studio does not provide a way to make one breakpoint dependent upon another but this is possible.
Overly Complex Views, Procedures And Functions
(Michael J. Swart) I define a metric which indicates a code-smell for overly complex views, procedures and functions: “FROM” count.
How To Get The TableDiff Utility
(Kendal Van Dyke) Tablediff is a command line utility that comes with SQL Server to compare the data and schema in two tables for differences and generate a T-SQL script to synchronize them.
Is SSMS Taking Longer To Start?
(Shaun J Stuart) Lately, I noticed that SSMS was taking longer and longer to start. When I started at my company a couple years ago, SSMS would come up fairly quickly. Now, it was taking about 3 minutes to start up.
ADO.NET: Sorting data with the ORDER BY clause
(Ged Mead) When you fetch data from the database, SQL Server decides how your query will be run, so that your query is actioned in the most effective and fastest way. Most times, this means that the data fetched will be ordered by a primary key or index that SQL Server chooses. Often you won’t
Build option use case – experiments
(Scott Wesley) I find build options as nifty tools to not only categorise components for the very purpose build options are documented for, but to help inform developers & testers of applications.
Recursive Subquery Factoring to the Rescue
(Galo Balda) Recursive subquery factoring (AKA Recursive Common Table Expressions) has been available in Oracle since version 11g R2 was launched sometime around 2009. I always thought of it as a replacement for the connect by clause and just another way to write hierarchical queries, so I never rea
Understanding JDBC Connection Strings for WebLogic
(Christian Screen) Java web-based applications leverage a Java Database Connectivity (JDBC) connection in order to provide a common syntax for connecting JEE applications with the world’s most common databases. The databases can vary but if you are using a Java application and connecting to a databa
Configuring WebSphere Adapter for Enterprise Content Management for IBM Content Management V8
(Abhishek Rohira and Sowmya Murthy) WebSphere Adapter for Enterprise Content Management (ECM) allows you to exchange information with content management systems such as Content Management V8. The adapter uses Web Service of the Content Management Interoperability Services to interact with the target