(Dan Winn) If you’re a Web developer with some basic SQL Server skills, this session will take you to the next level. Delve into the database service model and database security. Learn how you can use Trace to debug T-SQL code, and use caching and adding indexes to improve site performance. Discover
Author: SSWUG Research
What tools assist with your .NET development?
(Tony Patton) A client recently moved its user community to a standard desktop configuration with enhanced security to reduce the installation of non-standard applications. The development staff was agitated when confronted with the details of the migration since the organization deemed many of thei
Data Security Beyond Regulatory Compliance
(Ulf Mattsson) In increasingly complex technical and business environments, no one security approach can deal with all the new and innovative intrusions. But the lack of a security silver bullet doesn’t mean data security is impossible. It simply means that businesses have to take a multi-pronged ap
Using New Tools to Maintain Legacy Apps
(Joe Pluta) The default situation for buying an application development tool is when you are building a system from the ground up. Nothing out there suits your business, so you need to write your own from scratch. Hello, Google! Another is when you have to add a new application, one whose featur
IBM TV – you have to check this out
(Willie Favero) Yup, IBM has its own internet television station, sort of.. It has a website that gives you access to some professionally done videos; some funny, some serious, but all very informative in there own special way. You really need to stop by and check a few of these videos out at http:/
Use of join buffer is now visible in EXPLAIN
(Sergey Petrunia) Starting from 5.1.18, EXPLAIN output may show “Using join cache”, like in this example:
Using Thread Pool Threads
(Jim Mischel) Thread pool threads are ideal for performing relatively short compute-bound operations that you want to execute in the background. For example, computing the cells in a spreadsheet, grammar- or spell-checking a document, and other such activities should be done in the background to pre
JDeveloper 11g: Contextually Linking the Stacked Bar Chart to an ADF Data Table – synchronize data component when clicking on chart
(Lucas Jellema) One of the powerful features for creating rich pages, including dashboards, is the ability to refresh and synchronize data components on a page by clicking an element in a chart. With the description of the stacked bar chart in Getting those Rich Charts going – Introducing the ADF Fa
The Baker’s Dozen: 13 Steps for Building an ASP.NET Database Lookup Page
(Kevin S. Goff) Lookup and navigation screens initially seem like no-brainers, when compared to other parts of an application—yet by the time a developer has met all the user requirements and requests, he/she has expended much more time than expected.
CLR Triggers for SQL Server 2005
(Soyuj Kumar Sahoo) As I discussed in my previous articles, now Microsoft SQL Server 2005 is integrated with Microsoft .NET Framework Common Language Runtime (CLR), so we can use any .NET Framework language to create database objects. The CLR provides the execution environment for all the server sid