(Mike Gold) This article describes how you can leverage .NET and XSL as a powerful and flexible means to rendering database reports into your Web Browser.
Other News
LOGGING and LOBs
(Kubilay Çilkara) Oracle LOBs are great data types to store unstructured data like pictures, audio files and movies. LOBs can also store semistructured data like XML and Word documents. A single LOB column in a table can store data up to 8 Terrabytes in Oracle 10g and up to 128 Terrabytes in Oracle
Decimal math is fast in MySQL5
(Mark Callaghan) Decimal is the default numeric data type in MySQL5. By this I mean that Decimal is the type for most numeric literals, is much improved over the implementation in MySQL4, and is the numeric type preferred by just about anyone who has to explain the semantics of decimal to binary flo
Oracle BI EE 10.1.3.3/2 – Calling BI Publisher Java APIs from iBots – Storing reports in File System Using Delivers and BI Publisher Scheduler
(Venkatakrishnan J) If you had gone through my previous blog entry here i would have talked about the means of storing BI EE reports on a periodic basis using Java Scripts. But one of the main problems with this is that it would not work in an Unix environment. So, now lets look at an approach to st
PowerShell, SQL Server and Large Resultsets
(Allen White) Last week I posted about using PowerShell and SQL Server together, and I used a SQLDataAdapter and populated a DataTable with the results. This approach is fine if what you’re doing returns a reasonably small resultset, but what if you’re returning millions of rows. In this case a Data
Parameter Support Objects, Pt II: Support OLAP Parameter Defaults with Datasets
(William Pearson) In the first half of this article, Customize Automatically Created Parameter Support Objects Pt. I, we reviewed type-in and picklist parameters in general, and then concentrated our focus, once again, upon picklist parameters, which we noted to be a frequent choice among informatio
Oracle 11g: WHEN OTHERS THEN NULL
As most of you know, we can enable compile time warnings to make programs more robust and to avoid run time error(s) later on. These warnings do not prevent the routines from compiling but it gives compile time warnings. This is just to alert an end user that there could be a potential problem. We
Search Engine Q&A #13: Difference between database version and database compatibility level
(Paul S. Randal) This has been causing some problems on the various groups and forums over the last few days so I thought I’d repost this from my old Storage Engine blog. The questions have been around attaching 2005 databases to 2000 servers – even databases that are in 80 compat mode – and it does
SQL Server Best Practices Review
The SSWUG SQL Server Virtual Conference starts Tuesday Register here – All about getting started with SQL Server – technical sessions, how-to information and other goodies for real-world people that work with databases. TSQL 101, Backups, Restores, Database Options, Replication Basics… All sorts of great information. Also, our special report on 21 great SQL Server tips, backup and recovery planning […]
Best Practices with SQL Server – Do You Review?
The Virtual Conference is NEXT WEEK! Have you registered yet? Don’t forget too, we have group rates available, just drop me a note. Curious about what it’s all about? Check out this quick video (30 seconds, wmv) then head to the conference site. Featured Article(s) Outsourcing and Improving Productivity I recall having a discussion with a Vice President of a […]