Search - Articles - Dev Forums - Favorites - Member Login  
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Saturday, July 04, 2009

Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 
FREE 12 month online training for ASP.NET & MS Expression Studio and a Free copy of MS Expression Web with Windows Server Purchase

Home > Search > Articles & Samples > SQL Server
Search:
What's New - What's Hot
Listings for Administration Administration (83)
Listings for Backup and Restore Backup and Restore (69)
Listings for Cache Cache (28)
Listings for Data Provider Data Provider (40)
Listings for Data Warehousing Data Warehousing (34)
Listings for Database Design Database Design (391)
Listings for Debugging Debugging (22)
Listings for DSN DSN (4)
Listings for DTS Package DTS Package (31)
Listings for Encryption Encryption (8)
Listings for Error Handling Error Handling (26)
Listings for Functions Functions (88)
Listings for Images Images (17)
Listings for Import & Export Import & Export (22)
Listings for Installation Installation (24)
Listings for Jobs & Tasks Jobs & Tasks (2)
Listings for Migration to SQL Server 2000 Migration to SQL Server 2000 (94)
Listings for Miscellaneous Miscellaneous (269)
Listings for Performance Tuning Performance Tuning (172)
Listings for Queries Queries (151)
Listings for Reports Reports (204)
Listings for Samples & Scripts Samples & Scripts (46)
Listings for Security Security (77)
Listings for Server Management Server Management (68)
Listings for SQL DMO SQL DMO (13)
Listings for SQL Mail SQL Mail (16)
Listings for SQL Server FAQ SQL Server FAQ (31)
More Categories for SQL Sever 2005 SQL Sever 2005 (639)
Listings for SQLXML SQLXML (89)
Listings for Stored Procedures Stored Procedures (245)
Listings for T-SQL T-SQL (103)
Listings for Tips & Tricks Tips & Tricks (216)
Listings for Triggers Triggers (27)
Listings for Virtual Instance Virtual Instance (0)


PLINQO - Supercharged LINQ to SQL        
Total Hits: 3  |  Today: 0 Author: Eric J. Smith and Shannon Davidson       Rating:  
Read Reviews | Write Review |   Your Rating: 

This article is in the Product Showcase section for our sponsors at The Code Project. These reviews are intended to provide you with information on products and services that we consider useful and of value to developers. In the time that LINQ to SQL has been available, we have been identifying ways to make LINQ to SQL better. We have compiled all of those cool tips and tricks including new features into a set of CodeSmith templates. PLINQO opens the LINQ TO SQL black box giving you the ability ...

loop through the SQL Server databases and populate the database names in a listbox        
Total Hits: 3  |  Today: 0 Author: Bheema Shankar Maruvada       Rating:  
Read Reviews | Write Review |   Your Rating: 

This article explains about looping through the SQL server databases and displaying the data in a list box so that user can choose the database as one of inputs....

How to use global variable in Microsoft SSIS (DTS) package        
Total Hits: 2  |  Today: 0 Author: hong_wei_li@yahoo.com       Rating:  
Read Reviews | Write Review |   Your Rating: 

Microsoft SQL Server 2005 Integration Services has new interface about DTS ( data transformation service). It has no many helpful examples for developers to follow. One of sticky things is to how to use global variables. Hopefully the following will save you a lot of frustrations.
the scenario is like this:
(1). I want to dump the data from one table (table1, primary key is theId - int, fields are FirstName - varchar(50), LastName - varchar(50)) in database 1 (db1) to another same structur...

One-Many and One-One relationship using LINQ to SQL        
Total Hits: 3  |  Today: 0 Author: Shivprasad koirala       Rating:  
Read Reviews | Write Review |   Your Rating: 

In this article we will start with a basic LINQ to SQL example and then see how we can implement one-many and one-one relationship using ‘Entityref’ and ‘EntitySet’. We have also attached a source which demonstrates the same in a practical manner....

Move DTS Package from one MS SQL Server to another        
Total Hits: 3  |  Today: 0 Author: Haiyan Du       Rating:  
Read Reviews | Write Review |   Your Rating: 

You developed a DTS package. Now you want to move to live SQL sever. you might wondering what the easiest way is to move DTS from you local SQL Sever to the remove SQL Server.

There are serveral ways to move, but I tell you the easiest one.

1. Save your existing DTS Package as a Structure Storage File, lets assum it is called t.dts

2. Copy t.dts to destination Microsoft SQL Server

3. Open Destination SQL server Enterprise Management....

Active Record Pattern Wrapper Using LINQ-to-SQL        
Total Hits: 3  |  Today: 0 Author: Dogu Tumerdem       Rating:  
Read Reviews | Write Review |   Your Rating: 

Today Entity Data Model (EDM) is becoming more popular because of ADO.NET data services compatibility, but LINQ-to-SQL still is simpler and easy to use. In this article, I will present an approach for LINQ to make it ready for Active Record Pattern. And, there is another project on this approach which you can find at http://www.castleproject.org/activerecord/index.html ....

Future of Business Intelligence        
Total Hits: 3  |  Today: 0 Author: Pinal Dave       Rating:  
Read Reviews | Write Review |   Your Rating: 

Business Intelligence (BI) is slated to play bigger roles in all kinds of businesses in the coming years. This is not surprising as data analysis and smarter decision making has made the use of BI inevitable in all sizes of businesses across all sectors, including Real estate, IT, mobile devices, governmental agencies, scientific and engineering communities and R&D labs, banking and insurance, to name a few. BI can effectively deal with industry-specific constraints, operations and objectives th...

How to use global variable in Microsoft SSIS (DTS) package        
Total Hits: 4  |  Today: 0 Author: hong_wei_li@yahoo.com       Rating:  
Read Reviews | Write Review |   Your Rating: 

Microsoft SQL Server 2005 Integration Services has new interface about DTS ( data transformation service). It has no many helpful examples for developers to follow. One of sticky things is to how to use global variables. Hopefully the following will save you a lot of frustrations....

Using SQLDataReader and SQLDataAdapter        
Total Hits: 4  |  Today: 0 Author: Iyad Abu Abdu       Rating:  
Read Reviews | Write Review |   Your Rating: 

The useability and the interaction for the end users with your web form will reflect the term of the success and the completeness for your work,and especially if most of your web forms get and show data from database. we talk to database via a connection ,so your connection will be in the lightweight and have a short time and this dedicated in using SqlDataReader class and your connection will be more efficient in using SQLDataAdapter class....

Custom Scheduler - SQL Server Reporting Services        
Total Hits: 4  |  Today: 0 Author: Soshan Fernandes       Rating:  
Read Reviews | Write Review |   Your Rating: 

I was currently working for a company name Hermz Software which needed to create reports using SQL Server Reporting Services as it's reporting tool. As far as creation of reports is concerned, I didnt have much problems!! However, the delivery of the reports were to be done based on the following snapshots....

SQL SERVER - 2005 Best Practices Analyzer Tutorial - Sample Example        
Total Hits: 5  |  Today: 0 Author: pinaldave       Rating:  
Read Reviews | Write Review |   Your Rating: 

Yesterday I posted small note about SQL SERVER - 2005 Best Practices Analyzer (July BPA). I received many request about how BPA is used. Some of readers has asked me to provide sample tutorial which can help start using BPA. This utility has many uses for best practice. I have created very simple and initial tutorial. I encourage to follow that and once used it create your own reports in your desired format. Do not hesitate to install this add-on as I have use this previously to tune our product...

Reporting Services 2005 101 using Web Client        
Total Hits: 3  |  Today: 0 Author: Asif Sayed       Rating:  
Read Reviews | Write Review |   Your Rating: 

What is your favorite GUI client? Tuff question right, especially, if we�ve choices as Windows/Web and Mobile to pick from. To stay competitive, software vendors are increasingly under pressure to address every possible client under the sun! As I�ve demonstrated in my pervious article, how to host MS Reporting Services 2005 with Windows Forms; this time, I�ll show the similar technique, however, I�m picking on ASP.NET Web Client....


DevASP.Net - Disclaimer - Privacy
Copyright © 2008 DevASP.net