(Venkata Suresh Raavi) Today morning when I was working on a huge database containing lots of LOB data, I was required to know what tables have LOB data, and the list of LOB columns by table name along with the data type.
Author: SSWUG Research
ASP.NET MVC Tracking User Activity
We can use filter attributes to mark any action method or controller. If the attribute marks a controller, the filter applies to all action methods in that controller.
12c Indexing Extended Data Types Part I (A Big Hurt)
(Richard Foote) The maximum size for VARCHAR2, NVARCHAR and RAW columns has been extended to 32767 bytes with the Oracle 12c Database. However, indexing such columns with standard indexes comes with some challenges.
Function to compute SQL_ID out of SQL_TEXT
(Carlos Sierra) Ric Van Dyke from Hotsos asked me yesterday if I knew of a PL/SQL function that inputs a SQL_TEXT and outputs a SQL_ID. I kind of remembered Tanel Poder had written something on this regard. And I also recalled seen an API under DBMS_UTILITY that would provide the SQL_ID given a SQL_
Tightening Security with SELECT ANY DICTIONARY in Oracle 12c
(Steve Ries) Developers and users sometimes request the SELECT ANY DICTIONARY system privilege to enable them to view various data dictionary tables. This may be fine for querying DBA_TABLES, etc, but the Oracle data dictionary contains a LOT of information.
Animate to Hide and Slide Content with jQuery [Tutorial]
Over the past few years I have seen dozens of various portfolio website layouts. There are so many different techniques you can use on such a typical user interface. And even with larger design firms or agencies, many of the same UI aesthetics will work great.
SQL Server 2012 DB Engine Group Problem
I was checking out some reports on the SQL Server MP as I had installed the new 6.4.0.0 version in a test system but still had 6.3.173.1 in production. When looking at group membership I noticed that there were a few SQL servers missing from the SQL Server 2012 DB Engine Group but that they were all
SSWUGtv: Most people hate their jobs because they feel that they do not have any control. What do you do if you feel like you hate your job?
Video Programming for IT Professionals Career management advice, coaching and much more. We discuss making the best of your professional development, provide specific tips and ideas for advancing your career and even answer questions from field.
Using JSON in WebSphere Cast Iron, Part 3: Designing JSON-based REST APIs
(Rajath Ramesh and Manjunatha D) IBM WebSphere Cast Iron introduced two activities, Read JSON and Write JSON to work with JSON data. Part 1 of this 3-part series showed how to configure JSON handling activities to invoke JSON-based REST APIs and to create your own JSON-based REST APIs. Part 2 showed
How to launch an SSRS report in a browser window from a .NET application
(Ray Barley) I am working on a .NET application where we have built many reports using SQL Server Reporting Services (SSRS). A common complaint from the business users is that they don’t want to open their browser and navigate to the Report Manager (or a SharePoint document library) in order to run