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 > Articles & Samples > SQL Server > Data Provider

What's New - What's Hot
SQL Server Analysis Services - Manipulating Data Source Views     
Total Hits: 109  |  Today: 0Author: Nidal Arabi      Rating:  
Read Reviews | Write Review |  Your Rating: 

Data Source View is a very important feature that SSAS count on. We have previously explained how to create one. In this article we will explain how to do day-to-day tasks with it. It is important here to note that that DSV's can be used to enhance your physical data model and to repeat the fact that changes made to DSV do not impact your underlying data sources. My previous article, SQL Server Analysis Services - Creating Data Source Views, is a definite prerequisite for this article....

Simple Query Tool to Extract Data from Database     
Total Hits: 187  |  Today: 0Author: Mohammad Hamed Akhter      Rating:  
Read Reviews | Write Review |  Your Rating: 

The are various ways to design a UI that helps users to extract specific information from the database. This tool whose UI design is similar to the queries windows in TFS helps users to extract specific data by helping the user to create or form a query. This idea is similar to the query tools available in SQL server and TFS, but it is customized to the user's needs....

Parameter Discovery on Microsoft Access With XML option. Using Microsoft Patterns and Practices     
Total Hits: 191  |  Today: 0Author: Patrickquinn1212      Rating:  
Read Reviews | Write Review |  Your Rating: 

This project contacts the Microsoft Access Jet 4.0 Database and gathers schema information that is used to build command parameters for stored procedures and SQL query commands. "Generics.cs" , which is the class that Data.dll uses for Microsoft Access, throws an exception if you try to discover parameters since this cannot be done. I added my schema collection classes to this method thereby enabling the main abstract class to continue. It adds command parameters to the internal cache (at next u...

LINQ to SQL (Part 5 - Binding UI using the ASP:LinqDataSource Control)     
Total Hits: 265  |  Today: 0Author: Scott Guthrie      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article, scott examines the usage of LinqDataSource Control with the help of an example.
Over the last few weeks I've been writing a series of blog posts that cover LINQ to SQL. LINQ to SQL is a built-in O/RM (object relational mapper) that ships in the .NET Framework 3.5 release, and which enables you to easily model relational databases using .NET classes. You can use LINQ expressions to query the database with them, as well as update/insert/delete data....

SQL Server Analysis Services - Creating Data Source Views     
Total Hits: 462  |  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....

Different forms to select data using SQL and .NET     
Total Hits: 154  |  Today: 0Author: Luis Ramirez.      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article I will show you different development tools that you can use to retrieve data from a database server using SQL and .NET. As it is a very common task for .NET data applications I think is good to know the alternatives available to make our job easier.

The examples contained in this article are very simple. I will give you a brief illustration of each development tool. If you want further details you can go to the respective web sites. For the following examples I will assum...

SQL: Select Birthdays in a Date Range     
Total Hits: 138  |  Today: 0Author: Steven A Smith      Rating:  
Read Reviews | Write Review |  Your Rating: 

While working on an events calendar for, I needed to take birth dates stored in my columnist database and figure out which columnists had birthdays that fell within a particular date range. I also wanted to retrieve the columnist's age, although I'm not sure if I'll end up displaying that in the final version of the events calendar. The query also works for anniversary dates.

Basically, the query I came up with has 8 parts that it checks for:

1. Is the dob (dat...

Introducing the SQL Server 2005 Data Mining Add-ins for Office 2007     
Total Hits: 179  |  Today: 0Author: sqlserverdatamining      Rating:  
Read Reviews | Write Review |  Your Rating: 

The SQL Server 2005 Data Mining Add-ins for Office 2007 allow you to uncover hidden patterns and relationships in your data and then put them to work to enhance the quality of your analysis. To use the Microsoft SQL Server 2005 Data Mining Add-Ins for Office 2007, you must be connected to a SQL Server 2005 Analysis Services database. However, you don’t need to have prior experience with any SQL Server 2005 Analysis Services components....

Create Date Dimension Tables in SQL Server 2000/2005     
Total Hits: 200  |  Today: 0Author: Keith Rull      Rating:  
Read Reviews | Write Review |  Your Rating: 

I was writing an application today that needed a date dimension table and this was the script that i built. I don't know if this going to be useful to anybody.. anyway, my main purpose of putting it in my blog is so that i can just go to my site and do a copy-and-paste when the time comes that I need to use this script again.

First we need to build our table schema. My table schema required an ID column, a Date column, a Year column, a Month column and a Day column. All fields where of in...

How To Build a Cube Without a Data Source Using SQL Server Analysis Services     
Total Hits: 135  |  Today: 0Author: Ray Barley      Rating:  
Read Reviews | Write Review |  Your Rating: 

We are new to SSAS and are struggling with how to get started. We don't yet have a relational data warehouse that we can use to populate a cube. When you go to build a cube there is an option to build the cube without a data source. Can you provide us with the details on how to go about doing this? There are two ways to build a cube using Business Intelligence Developer Studio (BIDS). If you have existing relational data source(s) you can create a Data Source View (DSV) then proceed to build...

SQL Server Data Mining Programmability     
Total Hits: 137  |  Today: 0Author: Bogdan Crivat      Rating:  
Read Reviews | Write Review |  Your Rating: 

With Microsoft SQL Server 2005, the collection of statistics techniques and machine learning algorithms generically known as data mining is brought up to a new level. The most important change is that, in SQL Server 2005, data mining changes its target audience. Besides being a scientific lab instrument, addressing a limited number of highly skilled individuals, SQL Server Data Mining now gains ubiquity as a handy tool for developers, ready to be used in a wide range of applications. Most applic...

SQL Server 2005 Compact Edition Data Access with the SqlCeResultSet and Visual C#.NET     
Total Hits: 213  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this tutorial, you will learn how to use the SqlCeResultSet, a powerful cursor-based data-access implementation, to access data from SQL Server 2005 Compact Edition. In this tutorial, you will use Visual C#.NET. There is another tutorial that shows how to use Visual Basic.NET to do the same thing....

Displaying Images from Server Folder and SQL Server 2000 Database     
Total Hits: 170  |  Today: 0Author: AzamSharp      Rating:  
Read Reviews | Write Review |  Your Rating: 

In the last article Uploading Images to Server Folder and SQL SERVER 2000 Database we saw that you we can upload an image to the server's folder as well as the save the image in the SQL SERVER 2000 Database. In this article we will see how we can read images from the server's folder as well as database and display it on the screen....

Dynamically Bind Your Data Layer to Stored Procedures and SQL Commands Using .NET Metadata and Reflection     
Total Hits: 272  |  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...

Date and Time User-Defined Functions     
Total Hits: 118  |  Today: 0Author: Alexander Chigrik      Rating:  
Read Reviews | Write Review |  Your Rating: 

I would like to write the series of articles about useful User-Defined Functions grouped by the following categories:

# Date and Time User-Defined Functions
# Mathematical User-Defined Functions
# Metadata User-Defined Functions
# Security User-Defined Functions
# String User-Defined Functions
# System User-Defined Functions
# Text and Image User-Defined Functions...

Understanding SQL: SELECT The Data You Want     
Total Hits: 98  |  Today: 0Author: Timothy Khouri      Rating:  
Read Reviews | Write Review |  Your Rating: 

Many articles about SQL are spread too thin with "the basics" of a SELECT, INSERT, UPDATE and a DELETE. By the time your done, you know a little about everything, and nothing useful. This article will focus on the meat of SQL, getting the data you want. We'll start off with the simple, and move to the more advanced and creative....

Importing Data into SQL Server     
Total Hits: 220  |  Today: 0Author: William R. Vaughn      Rating:  
Read Reviews | Write Review |  Your Rating: 

I can't count the number of times I've answered questions in the newsgroups, forums, and from the attendees at the tech conferences that imply that developers think ADO.NET (or any of the data access interfaces) are designed to handle "bulk" operations. The question often sounds like:

"Ah, I've got this 6 million rows of data that I need to get from X (an external data source of some kind), process at the client, and send up to my SQL Server production table. I can't seem to get it al...

Query Analyzer - Sql Server Database Indexes and Execution Plans     
Total Hits: 122  |  Today: 0Author: DavidHayden      Rating:  
Read Reviews | Write Review |  Your Rating: 

If you haven't been tuned to my blog, I am doing a series of posts on High Performance ASP.NET Websites Made Easy after my recent attendance to the Tampa Code Camp. I am talking about the basics, but in my opinion, developing high performance ASP.NET websites is nothing more than leveraging some of the easiest and effortless parts of ASP.NET. Much of the information provided in this series is trivial, but important items you need to do in each and every project to make it successful....

SQL Data Provider VB.NET Class - The Class     
Total Hits: 241  |  Today: 0Author: Mulish Mehdi      Rating:  
Read Reviews | Write Review |  Your Rating: 

This class is for simplifying and accelerating working with SQL, using this class is very simple; there is a sample below for this class, which I hope is useful. You can report bugs, opinions and suggestions to me....

Methods for Moving a Database     
Total Hits: 341  |  Today: 0Author: Ron Talmage      Rating:  
Read Reviews | Write Review |  Your Rating: 

Moving a SQL Server database from one server to another is simple-initially. But there are various methods for moving a database, and some have more advantages than others. Investigating the types of moves ahead of time can make planning for a database migration easier.

It takes essentially three steps to move a database from one server to another: take the database out of production, copy it to another server, and then bring the copy back into production. While you can choose from many m...

Disclaimer - Privacy
© 2002-2017