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

Home >Search > SQL
What's New - What's Hot
Listings for Applications Applications (161)
Listings for Articles & Samples Articles & Samples (5027)
Listings for Bugs and Fixes Bugs and Fixes (94)
Listings for Developer Sites Developer Sites (13)
Listings for Downloads Downloads (54)
Listings for Introduction Introduction (29)
Listings for Knowledge Base Knowledge Base (289)
Listings for Sample Chapters Sample Chapters (24)
Listings for Training Training (23)
Listings for WebCasts WebCasts (21)

SQL Server Integration Services (SSIS) – Part 4 – Import Data using Wizard  Version: 0.00     Price: $0.00  
Total Hits: 21  |  Today: 0Author: Karthikanbarasan      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article we will see on how to Import 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 Import data from SQL server to Excel using the Wizard.You can look into Part 1, Part 2 and Part 3 of my SSIS articles at the below urls...

Designing and implementing a Data Warehouse: Part 3  Version: 0.00     Price: $0.00  
Total Hits: 19  |  Today: 0Author: John Charles Olamendy      Rating:  
Read Reviews | Write Review |  Your 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...

Data Warehouse Partition Strategies  Version: 0.00     Price: $0.00  
Total Hits: 15  |  Today: 0Author: Paulo Condeca      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft put a great deal of effort into SQL Server 2005 and 2008 to ensure that that the platform it is a real Enterprise class product. I’m not going to write about all the new features in the OLTP Engine, in this article I will focus on Database Partitioning and provide a real world scenario. This article will cover the following points:

I. Benefits and Limitations of Partitioning (HEAPS/CLUSTERED/NONCLUSTERED).
II. Implementation Methodology....

Introduction to WTL OLE DB Database Applications  Version: 0.00     Price: $0.00  
Total Hits: 22  |  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 ...

Export data from SQL Server to MS Access  Version: 0.00     Price: $0.00  
Total Hits: 64  |  Today: 0Author: Muhammad Shahid Farooq.      Rating:  
Read Reviews | Write Review |  Your 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....

Database Mirroring Automating Failover for Multiple SQL Server Databases With No Witness     
Total Hits: 136  |  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?...

Setting Date Format in SQL Server     
Total Hits: 136  |  Today: 0Author: sri sri      Rating:  
Read Reviews | Write Review |  Your 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...

Using DBCC PAGE to Examine SQL Server Table and Index Data     
Total Hits: 189  |  Today: 0Author: Armando Prato      Rating:  
Read Reviews | Write Review |  Your Rating: 

I've read a lot of articles that talk about database pages and how they're used to store table data and index data. Is there some way I can actually look at this information? One of the worst kept secrets in the SQL Server community is the undocumented DBCC PAGE command which allows you to examine the contents of data and index pages. Some of this information is a bit cryptic and your favorite search engine is a good place to start to find a lot of the meanings behind the output it displays. How...

Handling Weeks that Overlap Years in a Date Dimension in a SQL Server Data Warehouse     
Total Hits: 259  |  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...

Microsoft's Contribution to the Data Warehousing Industry     
Total Hits: 153  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your 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...

The Microsoft Data Warehousing Strategy     
Total Hits: 150  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

Making better business decisions quickly is the key to succeeding in today's competitive marketplace. Understandably, organizations seeking to improve their decision-making can be overwhelmed by the sheer volume and complexity of data available from their varied operational and production systems. Making this data available to a wide audience of business users is one of the most significant challenges for today's information technology professionals. In response, many organizations choose to bui...

Best Practices for Business Intelligence Using the Microsoft Data Warehousing Framework     
Total Hits: 255  |  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....

Embedding SQL Server Express into Custom Applications     
Total Hits: 287  |  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....

Dynamically Bind Your Data Layer to Stored Procedures and SQL Commands Using .NET Metadata and Reflection     
Total Hits: 264  |  Today: 0Author: Atif Aziz      Rating:  
Read Reviews | Write Review |  Your 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...

Database Storage with SQL Server – Part I     
Total Hits: 254  |  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: 201  |  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: 255  |  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...

Dimensional Databases: Building A Data Warehouse     
Total Hits: 645  |  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: 947  |  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: 4421  |  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-2016