Wrapping process makes PL/SQL source code unreadable. Developers can wrap package specifications, package bodies, functions, procedures, type specifications and type bodies. Unfortunately triggers cannot be wrapped. To wrap the trigger code you need to place your source code to a package or procedur
Other News
Using Deferred Objects As An Asynchronous Script Loader In jQuery 1.5
(Ben Nadel) After playing with Deferred Objects for the first time yesterday, I’ve definitely gotten deferred on the brain. I’ve known about deferred objects for a long time and never really understood them; as such, I’m quite eager to wrap my head around exactly what it is that they are capable of
Using SQL to create SQL (and other usefulness)
(Sarah Novotny) Today, I had a task of modifying a slave to exclude (or if you want to say specifically include) tables. The situation is that this slave need only contain tables used for reporting. The added benefit being that with fewer tables to replicate there will be less replication traffic, l
Database Mirroring Performance Monitoring
(Thomas LaRock) Many people deploy performance monitoring solutions in a “one-size-fits-all” manner. That is, they tend to build a solution that can be easily deployed to multiple servers and capture basic information from each server.
Tip Of the Month
Kalen Delaney Virtual Workshop: SQL Server 2008 Indexes – Internals and Best Practices Feb. 25, 2011 – Along with a good database design I would say that Indexes are a cornerstone to good database performance. There are a lot of other skills you can develop in relational databases; but without these two skills, you’re going to find yourself in a […]
ASP.NET Image to PDF with VB.Net
This tutorial will discuss how to use the PDFSharp library on images. Specifically, it will cover how to do simple JPG to PDF conversion using PDFSharp in VB.NET. This has a lot of applications in ASP.NET implementations, such as converting a document online that contains either a pure image or both
Getting rid of flickering in .NET CF forms with custom drawn controls
(Onkar Singh) .NET Compact Framework doesnt provide builtin double buffering for forms. In case you have multiple custom drawn user controls on a form, loading will mostly show flickr.
Use PowerShell to Simplify Working with XML Data
(ScriptingGuy1) Hey, Scripting Guy! How can I use Windows PowerShell to work with XML?
Parsing space-delimited strings to columns
(Bob) I learned a new technique recently for shredding delimited strings. It uses the xsd list type and SQL Server’s xml data type and is quite powerful. It’s a bit different to most shredding techniques in that it allows easy shredding to columns (instead of rows).
Focusing and Selecting the Text in ASP.NET TextBox Controls
(Scott Mitchell) When a browser displays the HTML sent from a web server it parses the received markup into a Document Object Model, or DOM, which models the markup as a hierarchical structure. Each element in the markup – the element, elements, elements, elements, and so on