(William Pearson) While it is quite common to sort the attribute members of our Analysis Services 2005 cubes based upon either their name or key values (perhaps even a composite member key), many of us encounter situations where we need to accomplish a different sort order – a sort order that is bas
Other News
Partitioning to Perfection
(Arup Nanda) “Divide and conquer”—that figurative principle has never been better illustrated than by Oracle Database’s partitioning features. Since version 8, you can partition a table or index into multiple segments and then place them in different tablespaces. The table is still addressed as a lo
SQL Server Show Posted, SQL Server Ongoing Maintenance
Latest SQL Server Weekly Show Posted Check out SelectViews – the weekly SQL Server program from SSWUG.org. In this week’s show, you’ll find: IT vs. Management and Big Ideas, a SQL Server Challenge. Using Variables with SPs, Upcoming Events, Tips and Tricks and Much More. The show is a bit longer this week because we’re testing two segments. A SQL […]
(81) SelectViews: IT vs. Management and Big Ideas, a SQL Server Challenge.
Video Programming for IT Professionals
SQL Server Merge Replication, SQL Server Maintenance and More
Featured Article(s) Tips for using SQL Server 2005 Merge Replication (Part 4) Here are some helpful tips to performance tune and optimize SQL Server 2005 Merge Replication. Looking for the Best SQL Server Technical Conference Going? Check out SQL Connections. We’ll be there with our SSWUG track, and you’ll find technical tracks on everything from administration to new features in […]
XQuery your office documents
(Marc Van Cappellen) With the introduction of the Office Open XML in Microsoft Office 2007 and OpenDocument Format used by OpenOffice applications, your office documents like spreadsheets and word processing documents, become consumable with XQuery.
Hierarchical storage management for database growth, part 1
(John Stouffer and Geordie Coates) With today’s growing need to retain every little bit of data, be it to meet regulatory requirements, support end-user needs, feed business intelligence and trend analysis, accommodate overall business growth or just support the consolidation of data from various sy
Create an ASP.NET Rounded Panel WebControl
(UsualDosage) There are perhaps hundreds of ideas on the internet regarding how to make those sleek rounded “Web 2.0” panels (as depicted above) that can be seen on millions of websites these days. Undoubtedly, there are many server controls that do the same thing. I’ve seen some good, and most bad.
Book excerpt: An introduction to ADO.NET 2.0
(Anne Boehm) ADO.NET is the primary API for data access within the .NET Framework. The set of classes that are used for data access did not change much in the upgrade from ADO.NET 1.0 to v2.0; what did change, though, was the process for database application development. (R, pdf)
XML-Enabled Applications
(Yuli Vasiliev) Both PHP and Oracle provide comprehensive support for XML and XML-related technologies. Practically, this means you can perform any XML processing either with PHP or inside an Oracle database. While PHP allows you to construct and transform XML by using either PHP’s XML extensions or