|
|
|
|
|
| | Total Hits: 227 | Today: 0 | Author: Microsoft Corporation | Rating:  |
| | 
Discover best practices and suggestions for working with Microsoft SQL Server and Microsoft Analysis Services for analytic applications. These practices and suggestions have been compiled from answers to questions submitted by developers and customers, and cover topics ranging from dimensional modeling to designing OLAP cubes and writing MDX expressions. This is not an introductory paper... |
| | Total Hits: 192 | Today: 0 | Author: Dave Browning and Joy Mundy | Rating: |
| |
Data warehousing is one of the more powerful tools available to support a business enterprise. Learn how to design and implement a data warehouse database with Microsoft SQL Server 2000.
Data warehouses support business decisions by collecting, consolidating, and organizing data for reporting and analysis with tools such as online analytical processing (OLAP) and data mining. Although data warehouses are built on relational database technology, the design of a data warehouse database differs ... |
| | Total Hits: 148 | Today: 0 | Author: Joy Mundy | Rating: |
| |
This document describes how the Microsoft SQL Server 2000 Data Warehouse technologies map to the twenty criteria for a Dimensionally Friendly System, as characterized by Ralph Kimball.This paper maps features and functionality of the Microsoft® SQL Server™ 2000 Data Warehousing Framework to the twenty characteristics of a "dimensionally friendly system" identified by Ralph Kimball (1). These characteristics were introduced in order to provide "good metrics for what makes a system more dimensiona... |
| | Total Hits: 712 | Today: 0 | Author: Scott Robinson | Rating: |
| |
In the first part of this data warehousing series, I noted the structure of database storage for a data warehouse is very different from that of a conventional online transaction processing system (OLTP). The reason? OLTPs have many users and typically handle distinct data objects in any given session, whereas online analytical processing systems (OLAP) have fewer users pulling in much larger amounts of data. Therefore, from a design standpoint, it’s important to create structures that put relat... |
| | Total Hits: 9 | Today: 0 | Author: Sumit Garg From Chandigarh | Rating:  |
| |
This article basically illustrates the concept of Data type synonyms which are included in SQL Server 2005 for SQL-92 compatibility.... |
| | Total Hits: 5 | Today: 0 | Author: Karthikanbarasan | Rating: |
| |
In this article we will see on how to export the data from SQL server using the wizard which is provide with the SSMS (SQL server Management Studio). Using SSMS we can perform many tasks like copying data from one server to the other or from one data source to the other in variety of formats. Here our task is to do a transform of data from SQL server to Excel using the Wizard. You can look into Part 1 and Part 2 of my SSIS articles at the below urls... |
| | Total Hits: 6 | Today: 0 | Author: John Charles Olamendy | Rating: |
| |
Business Intelligence has become a buzzword in recent years as a support to decision making. Today we can find several database systems which include data warehousing, online analytical processing (OLAP), and data mining technologies. Data warehousing provides an efficient storage, maintenance, and retrieval of data. OLAP is a service that provides a way to create ad hoc queries against the data warehouse in order to answer important business questions. Data mining is a disciple comprising of se... |
| | Total Hits: 13 | Today: 0 | Author: Ed Gadziemski | Rating: |
| |
This article describes using an ATL wizard-generated OLE DB consumer with WTL's CWinDataExchange (DDX) to create a basic WTL database application. The sample project is a standard WTL dialog-based application that uses edit controls to display the data. It acquires data from a Microsoft Access 97/2000 database via the OLE DB for Jet 4.0 provider. The sample project demonstrates inserting, deleting, and saving rows as well as forward and reverse navigation through the rowset. It also shows basic ... |
| | Total Hits: 55 | Today: 0 | Author: Muhammad Shahid Farooq. | Rating: |
| |
Exporting data from SQL Server to MS Access can be achieved in a variety of ways. The purpose of this article is to provide a fast but easy way to export data from SQL Server to Access.... |
| | Total Hits: 126 | Today: 0 | Author: Moustafar | Rating: |
| |
In this article I will explain how to use MS SQL Management Objects (SMO) to create a MS SQL database from C# code. In this sample will
1. Enumerate all the SQL servers in the network and fill a list box where the user can select one of the servers.
2. The user will enter the Database Name to create.
3. The user will enter an AD account to grant right to.
4. When the user click "Create Database" the system will check for the existence of the database.... |
| | Total Hits: 115 | Today: 0 | Author: sri sri | Rating: |
| |
Try the below SQL command to find the default language setting and date format used. select name ,alias, dateformat from syslanguages where langid = (select value from master..sysconfigures where comment = 'default language') the Result will be as name alias dateformat ----------- ----------- ---------- us_english English mdy... |
| | Total Hits: 118 | Today: 0 | Author: Atif Shehzad | Rating: |
| |
Recently while creating an archival job I noticed that job was taking way too long to complete. To help troubleshoot I executed the stored procedure directly and it was also taking a long time to fetch the rows from the view that I was using. Based on the query plan it looked like creating an index on the view may help the issue, so I first looked to see if any indexes were in place for the views, but none were found. The next step was to create an index on the view, but I was presented with ... |
| | Total Hits: 428 | Today: 0 | Author: Nidal Arabi | Rating: |
| |
Now it is time to go practical in our business intelligence project as we have provided enough concepts. The first step in creating BI projects is to provide data sources to build your model out of. In this article, Nidal examines the different aspects of creating data source views using SQL Server 2008. After providing a short introduction, he outlines the procedure involved in a series of steps with the help of relevant screenshots.... |
| | Total Hits: 209 | Today: 0 | Author: Ray Barley | Rating: |
| |
Our business users want to report on some fact data aggregated by week. They define a week as beginning on Sunday and ending on Saturday without regard to the year. An example query would be how many employees were hired in each of the previous four weeks? While SQL Server has the DATEPART function which has an option to give the week number in the year for any given date, the week number resets to 1 when the year changes. Can your think of an easy way to implement this type of functionali... |
| | Total Hits: 87 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
Data warehousing has become one of the most dynamic, interesting, and fast-growing segments of the information technology industry. Microsoft Corporation is contributing to the rapid growth of data warehousing for decision support. A combination of products from Microsoft, and from an alliance of independent software and service providers, enables customers to operate powerful, yet affordable, data warehouse systems. Microsoft® SQL Server™ database, implemented as a data warehouse storage engine... |
| | Total Hits: 161 | Today: 0 | Author: Atif Aziz | Rating: |
| |
One major inconvenience of using SQL stored procedures from code is having to match type information. You have to write long wrapper functions around the procedures just to expose the data types. In the .NET Framework, however, the reflection services of the System.Reflection namespace allow you to query rich metadata that describe data types. This article explains how to use reflection in .NET to end your stored procedure nightmares. The author creates four custom classes, including one that ge... |
| | Total Hits: 140 | Today: 0 | Author: Joy Mundy | Rating: |
| |
This article describes how to use partitions to improve the manageability, query performance, and load speed of data warehouses in SQL Server 2000 Enterprise Edition. Horizontal partitioning of dimensional schema, both in the relational database and in Analysis Services cubes, is addressed.... |
| | Total Hits: 528 | Today: 0 | | Rating: |
| |
Data Quality is as important as data integrity for most every application. This article examines how data quality can be improved in a data warehouse through the use of Meta Data.
... |
|
|
|
|
|
|
|
|
|
|
|
|
|