(Lyudmila Fokina) The data of partitioned tables and indexes is divided into units that can be spread across more than one filegroup in a database. The data is partitioned horizontally, so that groups of rows are mapped into individual partitions. The table or index is treated as a single logical en
Author: SSWUG Research
Building the ListBoxesFT_C ASP.NET Web User Control in Visual Studio 2005: Part III
(Michael Livshitz) We have finished the “server” side (part 1, part 2) and are ready to write the “client” side of our control.
Practical Business Intelligence with SQL Server 2005: Data Mining
(John C. Hancock and Roger Toren) As you have seen, Analysis Services enables you to build powerful Business Intelligence (BI) solutions that enable users to really understand the business. However, many business problems rely on the ability to spot patterns and trends across data sets that are far
MySQL wants to build ‘database in the sky’
(Juan Carlos Perez) MySQL AB wants to launch a global project to build a massive, distributed repository containing all of the world’s data now stored in structured databases, the company’s chief executive officer said.
An Introduction to Simple Object Access Protocol
(Joydip Kanjilal) Simple Object Oriented Protocol or SOAP is a simple, light weight, XML based protocol that can be used for exchange of data in a de-centralized, distributed environment. It is making headlines these days within the enterprise development community and promises to revolutionize Web
Speeding-Up Oracle Export/Import Migration
(Shakir Sadikali) We’ve already established that I like broccoli. I get the taste from my dad who takes it with a glob a salad dressing and munches on it. It beats munching on Doritos. He and I both also do this with cucumbers. I don’t get it, but it tastes good and I know I’ll get a real kick out […]
Scripting permissions using catalog views in SQL Server 2005
(Narayana Vyas Kondreddi) Have you ever been asked to copy or clone the database permissions of one user to another database user? Or how about creating a new database role based on an existing database role? Basically, there isn’t a direct command or interface for duplicating the permissions of a u
Actions in Analysis Services 2005: The Drillthrough Action
(William Pearson) In Actions in Analysis Services 2005: An Introduction we overviewed the general types of Actions with which we, as Analysis Services developers, can support information consumers. We discussed examples of consumer needs that might be classified within each of the general Action typ
Can’t start up database without error ORA-01110
(Brian Peasland) I can’t get our database to start up correctly. I keep getting the following error. I have tried copying CONTROL02 to CONTROL01 and from CONTROL01 to CONTROL02 but it just always results in another error (ORA-01110). Our database is not in a live environment as we are in a testing p
I can always learn something new: today it’s IFCID 225
(Willie Favero) Since IFCID 225 (storage usage details) was introduced to DB2, it has been recognized as a critical tool in managing a DB2 subsystem’s storage. We have been telling customers to insure they have class 6 included when they start up their Statistics and/or included in their list of sta