(Jennifer McGinn and Stephanie Hazlewood) You are an IT manager. Your business liaison in marketing wants information on inquiries that come in through the web so the marketing team can market to prospects and increase customer acquisition rates. Once you get your head around that request, the compl
Author: SSWUG Research
Visual Studio Tip: Configure Code Analysis in Visual Studio
(Peter Vogel) I like well-written code, and I especially like it when I’ve written it. But I don’t always live up to my own expectations. So I’ve used various tools (FxCop, CodeRush, ReSharper) to give me some objective feedback on the quality of my code.
Invoking Overloaded Methods Using Reflection
(Richard Carr) Static and instance methods can be invoked via reflection by obtaining a MethodInfo object for the desired member and calling the Type class’s Invoke method. When invoking overloaded methods, the call to obtain the method information must be modified.
Swart’s Ten Percent Rule
(Michael J. Swart) “Just because you can, doesn’t mean you should.” SQL Server has a number of limits and restrictions (many of the limits are described here). Most of the time these restrictions don’t feel restrictive at all.
xp_cmdshell for Non-System Admin Individuals
(Greg Larsen) There is a system extended store procedure called “xp_cmdshell” that can be used to issue shell commands using TSQL code. Being able to do this can be quite useful for a number of different situations.
Warm up serialization
(isralev) The XML Serializer Generator creates an XML serialization assembly for types in a specified assembly in order to improve the startup performance of a XmlSerializer when it serializes or deserializes objects of the specified types.
How to transform XML into HTML5 using XSLT.
In this article I’ll show you how you can make an XML to HTML5 transformation by using the XSLT language.
How to translate and use Apex text messages inside javascript code and other considerations about shortcuts
(Flavio Casetta) For a long time I thought that whenever I had to display a translatable message inside JavaScript the only way forward was to create an Apex shortcut containing plain text.
Migrating single instance Oracle 11g database to Oracle 11gR2 RAC and ASM
(Ben Prusinski) Recently over the past few years, I’ve been involved with customer engagements to migrate legacy single instance environmnents to Oracle 11gR2 RAC and ASM.
Bug 10013177 running Aggregation on Expression indexed by an FBI
(Hemant K Chitale) I noticed an interesting Bug on MOS today. When running an Aggregation against an Expression that has a Function Based Index, results may be truncated.