(Lonneke Dikmans) Security is a very important aspect of applications. Users need to be authenticated, and data needs to be protected against unauthorized access. Oracle provides an out-of-the-box solution for row-level security in the database: Oracle Label Security. By using the open-source Oracle
Other News
Protect ‘Data at Rest’ Using DB2 on Linux, UNIX or Windows
(Rebecca Bond) When we think about security, we often mention the term “security in depth.” Layer after layer, we build our security architecture attempting to achieve a robust defense mechanism. We put in firewalls, build access control lists, devise elaborate intrusion detection schemes, enforce
Automatically return nested records from ADF List of Values – for example allocate all subordinates on project along with manager
(Lucas Jellema) In a previous post I was telling you about an ADF project we are discussing for a chain of interior decorating shops. One challenge we encountered in the functional specifications is that whenever a salesman is discussing a possible decoration – wallpaper, curtain, carpet etc. – for
Nested fact joins
(Jag Singh) In the absence of other advanced techniques for star join optimization, nested fact join with dimensions ensuring indexes are used for each dimension join delivers reasonable performance.
SQL Server Version Insights
Special SelectViews Edition Today’s show is a special – Getting Started with Reporting Services. We’ll be presenting information on how you get it going, how to get your first reports up and going and much more. > Watch Here Featured Article(s) How I hire a DBA (when it comes to the interview) As I sit down and answer questions that […]
(72) SelectViews: (Special Edition) – The show this week is all about getting started with Reporting Services.
Video Programming for IT Professionals
Storing Massive Amounts of Data
Don’t Forget to Watch The Latest SelectViews New show posts tomorrow – a special how-to show. – Watch the current show here Business Intelligence Can’t Be Smart if it Doesn’t Deliver Once you’ve built the perfect reports, done the great queries, figured out the things you need to watch for your company, you need a way to reliably get that […]
The Evolution Of LINQ And Its Impact On The Design Of C#
(Anson Horton) I was a huge fan of the Connections series, hosted by James Burke, when it aired on the Discovery Channel. Its basic premise: how seemingly unrelated discoveries influenced other discoveries, which ultimately led to some modern-day convenience. The moral, if you will, is that no advan
Load a Spreadsheet from a DB2/400 Database: Part 2
(Michael Sansoterra) Ted Holt’s tip on loading database data into Excel was great. I’d like to offer a few potential enhancements to the VBA code that was offered in the tip.
Know your options for developing with SharePoint 2007
(Tony Patton) As the popularity of Microsoft SharePoint continues to grow, the demand for SharePoint developers also increases. If you find yourself developing solutions with SharePoint 2007, this overview will help you sort out the differences between the two available editions, learn what tools ar