While researching another issue today I came across a feature of Sql Server that I had not noticed or heard of before: Included columns in non-clustered indexing.
Author: SSWUG Research
Monitor SQL Instance Balance across Windows Cluster Nodes Using PowerShell
(Lin Liu) While hardware is getting cheap these days and people install no more than one SQL Failover Cluster Instance (FCI) per node in a Windows Server Failover Cluster (WSFC), there are still organizations that want to save hardware, space or license cost by stacking multiple SQL FCI over a singl
Adding items in comma-separated string into separate rows in SQL Server
(Amogh Natu) In this post, I’ll show how to insert a items in a comma-separated string into separate rows in a table. Consider for example we have a comma-separated string such as “amogh, anish, anvesh, uday”. After inserting into the table, the output should be like:
Using OAuth: Enabling the OAuth service provider in WebSphere Application Server
(Jeff Hoy, Bill O’Donnell, Shane B. Weeden and Chunlong Liang) OAuth 2.0 service provider support was added as part of IBM WebSphere Application Server versions 7.0.0.25, 8.0.0.5, and 8.5.0.1. This article provides an overview of OAuth support highlighting architecture, new features, and the minimal
Replication in MySQL 5.6: GTIDs benefits and limitations – Part 1
(Stephane Combaudon) Global Transactions Identifiers are one of the new features regarding replication in MySQL 5.6. They open up a lot of opportunities to make the life of DBAs much easier when having to maintain servers under a specific replication topology.
Moving from Partial Views to AJAX Calls
(Patrick Steele) In this article, I’ll take an ASP.NET application that uses partial views and convert it to use AJAX calls and some JavaScript templating. This will give me more options for how I can use the application in the future.
SharePoint 2010 >> Retrieve SharePoint List/Library as XML
(Jay) It’s possible to retrieve a SharePoint Library or List in XML format using a SharePoint URL. This is especially useful when using secondary data sources in InfoPath and even better when used with a view which can filter data before it is pulled in.
Image Prefix changes in Oracle Application Express 4.2.2
(Joel R. Kallman) Most often, patch sets for Oracle Application Express are used to correct defects (i.e., fix bugs) identified in a release. It’s rare for features to be introduced or behavior to change. But in the case of Oracle Application Express 4.2.2 and later, there is a change in behavior
List Exadata Disk Layout and Topology with the exadisktopo scripts
(Tanel Poder) Here are two more Exadata scripts for listing the end-to-end ASM<->Exadata disk topology from V$ASM_ views and from V$CELL_CONFIG. These scripts see both the ASM level layout and the storage cell-level disk topology.
The DB2Night Show #111: What’s New in DB2 LUW 10.5 ‘BLU and More!’
(Scott Hayes) 97% of our studio audience learned something! During this episode of The DB2Night Show, George Baklarz, IBM’s most frequent flier, shared with our audience great information about DB2 BLU Acceleration, pureScale enhancements, Oracle Compatibility Updates, JSON, DB2 Packaging Updates, a