|
|
|
|
|
Total Hits: 24 | Today: 0
|
Author: Alexander Kojevnikov
|
Rating:
|
|
I wrote this tiny tool to compensate the limitations of the otherwise perfect iTunes player in reports generation. The program exports your iTunes library data to a Microsoft SQL Server (hence the name – sqlTunes) database which can then be queried using T-SQL. I am going to quickly review the underlying data structure of the iTunes library and then I will list some of the reports you can run on it....
|
|
|
|
Total Hits: 27 | Today: 0
|
Author: rafael_p.
|
Rating:
|
|
Three-tier is a client-server architecture in which the user interface, functional process logic ("business rules"), and data storage and data access are developed and maintained as independent modules, most often on separate platforms. In this article, I want to show one of many design solutions of how to build a robust middle-tier that will be easy to maintain and easy to make modifications without reflecting other tiers....
|
|
|
|
Total Hits: 66 | Today: 0
|
Author: Louis Duc Nguyen
|
Rating:
|
|
In this article, I’ll demonstrate how to give web users the ability to search and group data via web reporting pages –- using good old web scripting and SQL Server. No ETL/OLAP tool needed. Before we begin, I need to explain data warehousing. In general, as raw transaction level data accumulates, we summarize the data into a different table. We create an “on-line analytical processing cube”. Web users can then query against this cube, w/o interfering with your actual data feed. Also, the cube co...
|
|
|
|
Total Hits: 63 | Today: 0
|
Author: Irena Kennedy
|
Rating:
|
|
If you just open SQL Server Management Studio and expand the System Databases node, you’ll see four databases – master, model, msdb and tempdb (just like in SQL 2000).
However, SQL Server 2005 has a new system database called the ‘Resource’ database, which contains all the system objects (see select * from sys.objects), which appear in the INFORMATION_SCHEMA of each database but are actually stored in the Resource database. No user data or user metadata is stored in the Resource database....
|
|
|
|
Total Hits: 34 | Today: 0
|
Author: easerve
|
Rating:
|
|
Deleting records from SQL Server 2000 database using ADO.NET a fairly strait forward process, much like deleting records from Access Database.
First, you will need to import the System.Data.SqlClient namespace at the top of your page....
|
|
|
|
Total Hits: 16 | Today: 0
|
Author: Brian Noyes
|
Rating:
|
|
SQL Server 2005 Compact Edition (SSCE) provides a powerful yet lightweight data storage engine for building a variety of application types. This paper introduces data storage concerns for client applications and small-scale server applications. It discusses the feature set of SSCE and how that feature set addresses data storage concerns. It covers different application architectures where SSCE might be a good fit, highlighting the attributes of the application types and how SSCE can meet the req...
|
|
|
|
Total Hits: 25 | Today: 0
|
Author: Igor Krupitsky
|
Rating:
|
|
This application will let you script table data into a file. It will create an INSERT statement for each row in your table....
|
|
|
|
Total Hits: 31 | Today: 0
|
Author: Scott Mitchell
|
Rating:
|
|
In the preceding tutorial we examined how to add inserting, updating, and deleting capabilities to the SqlDataSource control. In short, to provide these features we needed to specify the corresponding INSERT, UPDATE, or DELETE SQL statement in the control’s InsertCommand, UpdateCommand, or DeleteCommand properties, along with the appropriate parameters in the InsertParameters, UpdateParameters, and DeleteParameters collections. While these properties and collections can be specified manually, th...
|
|
|
|
Total Hits: 108 | Today: 0
|
Author: Scott Guthrie
|
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....
|
|
|
|
Total Hits: 42 | Today: 0
|
Author: Eric Landes
|
Rating:
|
|
Eric walks the user through comgining different data sources including Web Services into a Crystal Report. To do this Eric utilizes Business objects Business View Manager to combine this and in Part 1 he demonstrates how to set up the web Service for View Manager....
|
|
|
|
Total Hits: 68 | Today: 0
|
Author: Habiburahman Khaled.
|
Rating:
|
|
This article will show you how to insert one Parent and Multiple child records into a MySQL Database with transaction at once. It also examines how to use MySQL 5.0, MySQL .Net Connector 5.0.7, and ASP.NET/C# with the 3-Layer application design architecture....
|
|
|
|
Total Hits: 27 | Today: 0
|
Author: Alexander Chigrik
|
Rating:
|
|
The backing up and restoring databases and transaction logs is a way that SQL Server provides to protect from data loss. The backup operation creates a copy of a database. This copy can be used to restore the database if the media failure occurs or if the database is somehow damaged (for example, from the user errors)....
|
|
|
|
Total Hits: 14 | Today: 0
|
Author: Alexander Chigrik
|
Rating:
|
|
Choosing an appropriate data type is very important, because the errors made in a tables design can result in large performance degradation. You can find these problems many times later when a large amount of data is inserted. In this article, I want to tell you about built-in and user-defined data types, how SQL Server 2000 stores data on a data page, and show some general tips to choose an appropriate data type....
|
|
|
|
Total Hits: 59 | Today: 0
|
Author: Edgewood Solutions Engineers
|
Rating:
|
|
When setting up replication there are many things to think about and many options you can choose from when setting up your publications and subscriptions. In most cases replication is an after thought and not part of the original database or application design, so there may be some required changes that need to be done when replication is setup. The most important part is that the table has a primary key. All tables should have a primary key when they are created, but sometimes this is not ad...
|
|
|
|
Total Hits: 27 | Today: 0
|
Author: Narayana Vyas Kondreddi
|
Rating:
|
|
In this article, I will discuss the pros and cons of using the SQL Server graphical administration tools versus the T-SQL administrative commands and I will support my views with specific examples. After reading this article, if you agree or disagree with specific points, feel free to email me, and I will update this article with your thoughts, if relevant.
You must have read in many places that real Database Administrators (DBA) and system administrators use command line and only novices and...
|
|
|
|
Total Hits: 76 | Today: 0
|
Author: Narayana Vyas Kondreddi
|
Rating:
|
|
While browsing the SQL Server newsgroups, every once in a while, I see a request for a script that can search all the columns of all the tables in a given database for a specific keyword. I never took such posts seriously. But then recently, one of my network administrators was troubleshooting a problem with Microsoft Operations Manager (MOM). MOM uses SQL Server for storing all the computer, alert and performance related information. He narrowed the problem down to something specific, and neede...
|
|
|
|
Total Hits: 8 | Today: 0
|
Author: Bryan Kowalchuk
|
Rating:
|
|
In my first article, Telephone Numbers in SQL Server 2005: Part 1 – The Datatype, I discussed various ways of persisting a simple telephone number in SQL Server. Simply displaying the raw data stored in SQL Server would not be suitable for human consumption so some form of data formatting must be done. Data formatting is usually performed in the user interface layer, for example by the ASPX page or the Winforms application. Often it is convenient to have SQL Server format the data in a view to b...
|
|
|
|
Total Hits: 9 | Today: 0
|
Author: Chulliyan
|
Rating:
|
|
SQLite is a powerful, free, open source database. It has an excellent implementation of the B-Tree, which is fast and small. SQLite is not copyrighted and therefore you can is it freely in any commercial projects. This project uses the SQLite’s B-Tree extensively to index text files. Each text document is scanned and the content is tokenized to build a dictionary in the SQLite database. Later searches are conducted against the dictionary and related map tables to retrieve the file names containi...
|
|
|
|
Total Hits: 12 | Today: 0
|
Author: Nitinpatel
|
Rating:
|
|
Here is the script to generate the HTML document of your SQL server 2000/2005 database. It is reverse engineering after database is created. I hope it will be useful to many of you....
|
|
|
|
Total Hits: 28 | Today: 0
|
Author: easerve
|
Rating:
|
|
First, you will need to import the System.Data.SqlClient name space at the top of your page.
Next, we write the actual code to connect to SQL Server and count the records. We do this with a Count SQL command against the Customers table. We specify the UID (Unique ID) column as the column to count. To execute the Count command we simply call ExecuteScalar to produce the count. As seen below we can simply apply this to the .Text property of the lbCount Label control....
|
|
|
|
|
|
