(Venkatakrishnan J) We just had another interesting question today in one of our internal forums. The question was how do we dynamically vary the columns in a Dashboard Prompt based on a selection in another dashboard prompt. Let me explain a bit further. For example, lets assume that we have 2 dash
Other News
SQL Server Checkpoint I/O Behavior
(Linchi Shea) Andrew Kelly in a recent post here advised visiting/revisiting the SQL Server I/O basics, and I completely agree. A firm grasp of the basics can make it easy to understand some system behaviors that otherwise may be puzzling at times.
Details on page compression (page-dictionary)
(Sunil Agarwal) In the previous blog, I described column-prefix compression that is done as part of PAGE compression. The other component of PAGE compression is the page-dictionary. As the name indicates, this dictionary is specific to a page and the page can be data page or a leaf-index page. The n
How secure is your SQL Server network design?
(Kevin Beaver) No matter how you’ve hardened your SQL Server systems, a weak network design can still undermine the best of database security controls. It’s easy to assume that all’s well inside the network perimeter. The external firewall is all-protecting — at least that’s the common belief. (R)
SQL Server 2008 Delays and Reality of the Cycles
Featured Article(s) What To Do When you need to compare databases. Databases commonly, have their own tools with pre-made queries that make a comparison by making table crossing. However, sometimes the interfaces are not as comfortable as a spreadsheet software like MSExcel TM. With a couple of formulas and graphic help you could do a better job and your life […]
Slippery Slope – Arguing Open Source v. Proprietary Software
Featured Article(s) Understanding Authentication, Authorization and Impersonation in ASP.NET (Part I) Authentication, Authorization and Impersonation are three of the most important concepts that are related to ASP.NET Security. This series of two articles present these concepts in detail with code examples to illustrate the concepts covered. SelectViews SQL Server Show [Watch Now] A SQL Server problem triage plan and approach, […]
Running XQuery from the Command Line with JRuby
(Matthew) During daylight hours, I work on a CMS. We use XQuery to transform a lot of our display-agnostic XML content to be more UI-friendly. We use XOM as our XML parser and Nux as a bridge between XOM and Saxon’s XQuery support.
Loading XML data in Flash using ActionScript
(Blue_Chi) XML can be used to load external data in Flash to provide an easy method for structuring content so that it is easy to understand, process, and update. This tutorial will teach you the basics on how to create a Flash-friendly XML file and how to load and process this XML file in Flash usi
DB2 9 System Parameter Changes for Application Development
(Troy Coleman) Last week I discussed a quick way to create a list of system parameter changes by comparing the source macros found in SDSNMACS library. Some of these parameters impact your application developers while others impact your database programmers and how DB2 manages memory and resources.
Data binding with Castor, Part 3: Map between schemas
(Brett D. McLaughlin, Sr.) After reading Parts 1 and 2 in this series, you should be comfortable using Castor to convert from XML to Java, and then back again. In this article, you’ll learn to add flexibility to your functionality, through Castor mapping files. You’ll no longer be constrained by the