Backwards Compatible The following question was posted in the SSWUG group on Linked-In: “How we do deploy a RDL developed using Visual Studio 2008 environment in SQL Server 2005 Reporting server?” This is really a very good question. It is worthy of some discussion should you, our reader, have time to respond with your ideas and experience. The issue for […]
Other News
Dynamic Management Views
Introduction to SQL Server Reporting Services – Tomorrow, August 25 Last chance to sign up for the next virtual class, "Introduction to SQL Server Reporting Services". This "Made Simple" course, taught by Sherri McDonald, a Business intelligence expert from Pragmatic Works, is a great investment for your personal development. If you’re ready to up your game, come on in and […]
Trigger file downloads with a MVC 3 controller action
(Justin Schwartzenberger) Providing file download capability in a web application is not as clear cut as linking to a file in the file system of the application. Web browsers have a mind of their own when it comes to handling files.
How to implement SQL Caching in ASP.NET (Poll based SQL Cache dependency)?
(Sheonarayan) In this article, we are going to learn how to implement SQL Caching in ASP.NET using Poll based SQL Cache dependency. The push based SQL Cache dependency shall be covered in other article.
Adding Exteneral Libraries to an Extension in 11gR2
(John ‘JB’ Brock) I mentioned this recently in a comment response, but it has come up enough times now, that it deserves it’s own topic.
TFS 2010 – Edit Work Item Type Definition using Team Foundation Power Tool
(Subodh Sohoni) We began a series of articles on Customize work item type definition in TFS 2010. In the first part of this series we had seen how to use a tool WitAdmin to export the work item type definition of Bug work item and then import it back in TFS after making a small modification in it, a
NVL versus Coalesce
(Lewis Cunningham) I’m doing some PL/SQL tuning and I’m examining several existing stored procedures to see how I can speed them up. While I won’t share my clients structures or code, I will talk about some of the interesting things I’m doing.
How to generate XML from relational data – with line breaks!
(Matthias Nicola) Generating XML from relational data is not difficult. The SQL standard contains a set of XML construction functions that take column names or other SQL expressions as input and return XML.
Scripting Backups of MySQL with Perl via mysqldump
(Tony Darnell) MySQL provides you with a nice utility for creating a backup of your databases. From the mysqldump documentation page: “The mysqldump client is a backup program originally written by Igor Romanenko.
Adding Common Methods to JAXB-Generated Java Classes (JAXB2 Basics Plugins)
(Dustin Marx) I’ve used Java Architecture for XML Binding (JAXB) successfully for a wide set of problems and generally really like it. However, it is not without its downsides. One down side that occasionally manifests itself as an issue is the lack of toString(), equals(Object), and hashCode() meth