Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Articles & Samples > SQL Server
Search:
What's New - What's Hot
Listings for Administration Administration (84)
Listings for Backup and Restore Backup and Restore (107)
Listings for Cache Cache (34)
Listings for Data Provider Data Provider (29)
Listings for Data Warehousing Data Warehousing (38)
Listings for Database Design Database Design (614)
Listings for Debugging Debugging (32)
Listings for DSN DSN (5)
Listings for DTS Package DTS Package (55)
Listings for Encryption Encryption (11)
Listings for Error Handling Error Handling (30)
Listings for Functions Functions (103)
Listings for Images Images (15)
Listings for Import & Export Import & Export (22)
Listings for Installation Installation (39)
Listings for Jobs & Tasks Jobs & Tasks (2)
Listings for Migration to SQL Server 2000 Migration to SQL Server 2000 (96)
Listings for Miscellaneous Miscellaneous (730)
Listings for Performance Tuning Performance Tuning (293)
Listings for Queries Queries (235)
Listings for Reports Reports (269)
Listings for Samples & Scripts Samples & Scripts (67)
Listings for Security Security (82)
Listings for Server Management Server Management (91)
Listings for SQL DMO SQL DMO (13)
Listings for SQL Mail SQL Mail (15)
Listings for SQL Server FAQ SQL Server FAQ (35)
More Categories for SQL Sever 2005 SQL Sever 2005 (887)
Listings for SQLXML SQLXML (104)
Listings for Stored Procedures Stored Procedures (337)
Listings for T-SQL T-SQL (155)
Listings for Tips & Tricks Tips & Tricks (341)
Listings for Triggers Triggers (56)
Listings for Virtual Instance Virtual Instance (1)


Introduction to WTL OLE DB Database Applications  Version: 0.00     Price: $0.00  
Total Hits: 24  |  Today: 0Author: Ed Gadziemski      Rating:  
Read Reviews | Write Review |  Your 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 ...

Database Mirroring Automating Failover for Multiple SQL Server Databases With No Witness     
Total Hits: 138  |  Today: 0Author: Edwin Sarmiento      Rating:  
Read Reviews | Write Review |  Your Rating: 

In a previous tip on Database Mirroring Automating Failover for Multiple SQL Server Databases, you've seen how you can failover all of the databases in a mirroring session if one database fails over. However, what happens if you don't have a witness server and your principal server goes, how do you make your mirror server the principal and bring all your databases online?...

SQL Server Analysis Services - Creating Data Source Views     
Total Hits: 460  |  Today: 0Author: Nidal Arabi      Rating:  
Read Reviews | Write Review |  Your 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....

SQL Server Log Shipping     
Total Hits: 184  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

There has been a lot written about SQL Server Log Shipping as well as several scripts and techniques for implementing this process. Basically Log Shipping is the process of backing up your database and restoring these backups to another server for failover. To keep the data current and to minimize risk of data loss the process involves using SQL Server transaction log backups. By using transaction log backups the size of the backups are much smaller than full backups and the restore process ca...

SQL Server System Objects in User Defined Databases     
Total Hits: 172  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

With the recent tips on data modeling (SQL Server 2005 Exposed = Data Modeling Tools and SQL Server Data Modeling Tools), a natural question that arose is: where are all of the underlying objects stored in SQL Server? As such, in this tip we will outline where the user defined objects in user defined databases for both SQL Server 2000 and 2005....

Handling Weeks that Overlap Years in a Date Dimension in a SQL Server Data Warehouse     
Total Hits: 262  |  Today: 0Author: Ray Barley      Rating:  
Read Reviews | Write Review |  Your 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...

Using the Built-In Time Dimension and Time Intelligence in SQL Server Analysis     
Total Hits: 194  |  Today: 0Author: Ray Barley      Rating:  
Read Reviews | Write Review |  Your Rating: 

We are building an Analysis Services cube and trying to understand how to create a time dimension and take advantage of the built-in time intelligence features that provide many useful calculations such as period-to-date, period-over-period growth, etc. Can you provide a detailed explanation of how it all works? Getting the time dimension configured correctly is a necessary first step in order to take advantage of the Time Intelligence features in SSAS which support the various queries that you...

Embedding SQL Server Express into Custom Applications     
Total Hits: 291  |  Today: 0Author: Robert Walters      Rating:  
Read Reviews | Write Review |  Your Rating: 

This white paper discusses how to integrate and deploy Microsoft SQL Server Express-based applications by using configuration files and the ClickOnce deployment technology in Microsoft Visual Studio....

Database Storage with SQL Server – Part I     
Total Hits: 256  |  Today: 0Author: extremeexperts      Rating:  
Read Reviews | Write Review |  Your Rating: 

Database storage is one of the primary failure point in the database environment. Hence, making the storage architecture consistent and at the same time giving it maximum redundancy must be embedded within the design itself. When I call redundancy, I don’t specifically say implementing anything specific to RAID or SAN or other mechanisms. Redundancy must be achieved given your hardware and budget currently in hand – if it even means making just multiple backup copies at the simplest level....

MySQL Data Loading with Lookup Tables     
Total Hits: 203  |  Today: 0Author: Ernest Bonat      Rating:  
Read Reviews | Write Review |  Your Rating: 

Lookup tables contain, in general, a fixed list of data. This data doesn’t change very often in database business applications. Examples of this data could be a product list, category type, supplier list, state name, zip code, phone area code, etc. In Windows and Internet web business applications, most of these lookup tables are graphically implemented by using ComboBox, ListBox or CheckListBox read-only controls. These controls are loaded with data using two main columns, ID and Name. For exam...

Automating Database maintenance in SQL 2005 Express Edition Part I     
Total Hits: 258  |  Today: 0Author: Jasper Smith      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this series of articles, I'll demonstrate a couple of different approaches to writing a maintenance utility that mimics some of the behavior of the sqlmaint utility that is included with SQL Server 2000. SQL Server 2005 Express Edition does not include such a utility, so these articles will show how we can easily create one ourselves using either TSQL or SMO (SQL Management Objects - the successor to SQL-DMO). Rather than dive into the code, these articles will demonstrate how to use these ut...

Database Restore Verification     
Total Hits: 449  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

I have over night processes on a few different SQL Servers in my environment that are backup and restore related. I have used the scripts on MSSQLTips.com to check if the SQL Server Agent Jobs\Job Steps have run as well as the backup verification code. Some of the backup and restore processes I have written and others I have inherited. Some of the processes seem to be very reliable and others are not. I need a way to validate the restore processes have completed properly just like the SQL Se...

Best Practices for Business Intelligence Using the Microsoft Data Warehousing Framework     
Total Hits: 334  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your 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...

Data Warehouse Design Considerations     
Total Hits: 299  |  Today: 0Author: Dave Browning and Joy Mundy      Rating:  
Read Reviews | Write Review |  Your 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 ...

Microsoft SQL Server 2000 as a Dimensionally Friendly System     
Total Hits: 263  |  Today: 0Author: Joy Mundy      Rating:  
Read Reviews | Write Review |  Your 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...

Using Partitions in a Microsoft SQL Server 2000 Data Warehouse     
Total Hits: 247  |  Today: 0Author: Joy Mundy      Rating:  
Read Reviews | Write Review |  Your 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....

Use data cubes for efficient data warehousing in SQL Server 2000     
Total Hits: 847  |  Today: 0Author: Scott Robinson      Rating:  
Read Reviews | Write Review |  Your 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...

Dimensional Databases: Building A Data Warehouse     
Total Hits: 647  |  Today: 0Author: Baya Pavliashvili.      Rating:  
Read Reviews | Write Review |  Your Rating: 

Building a data warehouse involves several complicated steps (some of which I described in my previous articles for InformIT). After the data warehousing architect locates all data elements necessary to support the data warehouse, it is time to build a dimensional model. As data change in transactional systems, the data warehouse needs to have a way of tracking and reflecting such changes. Populating fact and dimension tables can take considerable amount of time if the population routines aren't...

Data Mining For Database Developers - 1Rule     
Total Hits: 950  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

A Data Mining application for Relational Databases (RDBMS) including Microsoft® Access®, Microsoft SQL Server® , Oracle® and Sybase ® databases. The attached articles in HTML and Microsoft Word gives a detailed step by step guide to the development of a Data Mining application....

HOWTO: Access and Modify SQL Server BLOB Data by Using the ADO Stream Object (Q258038)     
Total Hits: 4425  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

The Stream object introduced in ActiveX Data Objects (ADO) 2.5 can be used to greatly simplify the code that needs to be written to access and modify Binary Large Object (BLOB) data in a SQL Server Database. The previous versions of ADO [ 2.0, 2.1, and 2.1 SP2 ] required careful usage of the GetChunk and AppendChunk methods of the Field Object to read and write BLOB data in fixed-size chunks from and to a BLOB column. An alternative to this method now exists with the advent of ADO 2.5. This arti...



Disclaimer - Privacy
© 2002-2017 DevASP.net