(William Pearson) In the previous articles of this subseries, Black Belt Administration: Caching Options: Report Session Caching, and Report Execution Caching parts I and II, we discussed the fact that a common attribute of enterprise reporting systems is their provision for unified points of mainte
Other News
Mirrored backup and restore commands in SQL Server 2005
(Serdar Yegulalp) Among the features Microsoft added to SQL Server 2005 were new ways to handle backup and restore operations. Mirrored backup — only available in the Enterprise Edition — allows for backups with an additional layer of reliability. Before the mirrored backups came on the scene, if
Sort Values Ascending But NULLS Last
(Denis Gobo) This is a frequent request in newsgroups and fora. People want to sort the column in ascending order but don’t want the NULLS at the beginning.
Kim Tripp, Paul Randal from SQLSkills on SelectViews Today
Just Posted: SelectViews 86 This show is an interview with Kim Tripp and Paul Randal. We got together at DevConnections in Las Vegas and talked about everything from the famous board game to SQL Server 2008. > Watch Here Featured Article(s) Initiating the Installer Wizard for Failover cluster Setup In this article Vanitha Vaidialingam shows you how to use the […]
Kim Tripp, Paul Randal on SelectViews. What’s coming with SQL Server 2008, what are industry trends and more.
Video Programming for IT Professionals
If You Had a Database Time Machine…
Tomorrow: Kim Tripp and Paul Randal interview from DevConnections. Featured Article(s) Oracle 2-Day DBA in x Days Post 1 We just got started. Follow along as we go through Oracles 2-DBA guide. It should be fun. Cure For The Mysterious SQL Server Slow-Down As a DBA have you ever received that call from the boss asking why the database is […]
DB2 9.5 and IBM Data Studio Part 3: Overview diagrams – the basics
(Paul Zikopoulos) As I’ve been introducing you to the IBM Data Studio integrated development environment (IDE) that’s new with DB2 9.5, I’ve shown you how to set up database connection objects and the actions that you can perform on them. In this article, I want to delve deeper into the overview dia
DB2 9 Mysteries of DB2 Storage Groups
(Troy Coleman) DB2 stores table data in a table space and index data in an index space. The underlying data set holding this data is a VSAM dataset. Let’s examine the three options for creating and managing these datasets: DB2 managed, SMS managed and user managed.
Adding support for styles
(Bipin Joshi) In the previous lesson you learnt to develop a basic control. Your control inherited from the Control base class and emitted some HTML markup by overriding the Render() method of the base class. Though the control worked fine it lacked one important feature – support for formatting pro
Parsing XML Documents-1 (DOM and SAX)
XML files are very useful. Usually they are used to store configuration settings. We can also use XML files to store data so it can be used as a database. A lot of work has been done in this domain and its really very useful working with XML files.