|
|
|
|
|
Total Hits: 2 | Today: 2
|
Author: Bheema Shankar Maruvada
|
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....
|
|
|
|
Total Hits: 1 | Today: 1
|
Author: hong_wei_li@yahoo.com
|
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...
|
|
|
|
Total Hits: 2 | Today: 1
|
Author: Shivprasad koirala
|
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....
|
|
|
|
Total Hits: 2 | Today: 1
|
Author: Haiyan Du
|
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....
|
|
|
|
Total Hits: 2 | Today: 1
|
Author: Dogu Tumerdem
|
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 ....
|
|
|
|
Total Hits: 2 | Today: 1
|
Author: Pinal Dave
|
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...
|
|
|
|
Total Hits: 3 | Today: 1
|
Author: hong_wei_li@yahoo.com
|
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....
|
|
|
|
Total Hits: 3 | Today: 1
|
Author: Iyad Abu Abdu
|
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....
|
|
|
|
Total Hits: 3 | Today: 1
|
Author: Soshan Fernandes
|
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....
|
|
|
|
Total Hits: 3 | Today: 1
|
Author: pinaldave
|
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...
|
|
|
|
Total Hits: 2 | Today: 1
|
Author: Asif Sayed
|
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....
|
|
|
|
Total Hits: 4 | Today: 1
|
Author: Shivprasad koirala
|
Rating:
|
|
There are many ways of doing an audit trail and in one of my previous articles, I had discussed how we can implement audit trail using prototype pattern. In this session, we will discuss how we can implement audit trailing using trigger. We will take up a simple customer table, create a simple audit table and then we will write a generic trigger by which we can audit any kind of table structure data in the audit table....
|
|
|
|
|
|
