|
|
|
|
|
Total Hits: 156 | Today: 0
|
Author: Mohammad Hamed Akhter
|
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....
|
|
|
|
Total Hits: 148 | Today: 0
|
Author: sqlserverdatamining
|
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....
|
|
|
|
Total Hits: 230 | 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: 105 | Today: 0
|
Author: Bogdan Crivat
|
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...
|
|
|
|
Total Hits: 173 | Today: 0
|
Author: Microsoft Corporation
|
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....
|
|
|
|
Total Hits: 124 | Today: 0
|
Author: Luis Ramirez.
|
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...
|
|
|
|
Total Hits: 82 | Today: 0
|
Author: Alexander Chigrik
|
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...
|
|
|
|
Total Hits: 193 | Today: 0
|
Author: William R. Vaughn
|
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...
|
|
|
|
Total Hits: 110 | Today: 0
|
Author: Steven A Smith
|
Rating:
|
|
While working on an events calendar for ASPAlliance.com, 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...
|
|
|
|
Total Hits: 185 | Today: 0
|
Author: Ron Talmage
|
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...
|
|
|
|
Total Hits: 172 | Today: 0
|
Author: Keith Rull
|
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...
|
|
|
|
Total Hits: 80 | 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: 63 | Today: 0
|
Author: Alexander Chigrik
|
Rating:
|
|
SQL Server 2000 supports User-Defined Functions (UDFs) - one or more Transact-SQL statements that can be used to encapsulate code for reuse. User-defined functions cannot make a permanent changes to the data or modify database tables. UDF can change only local objects for this UDF, such as local cursors or variables....
|
|
|
|
Total Hits: 113 | Today: 0
|
Author: DavidHayden
|
Rating:
|
|
So my Database Explorer and Code Generator now displays database views separate from database tables and shows stored procedures in the database, too. This is all pretty trivial, but fun to build. The image below shows the stored procedures from the Northwind Database....
|
|
|
|
Total Hits: 93 | Today: 0
|
Author: DavidHayden
|
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....
|
|
|
|
Total Hits: 206 | Today: 0
|
Author: Mulish Mehdi
|
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....
|
|
|
|
Total Hits: 228 | Today: 0
|
Author: Edgewood Solutions Engineers
|
Rating:
|
|
I am running very low on storage to support my SQL Server 2000 user defined databases on a number of my production SQL Server instances. We have made the decision to invest in some sort of NAS\SAN or direct attached storage solution. Independent of which technology, vendor and RAID sets we select, I need to plan for my database storage for the next 18 to 24 months and beyond. I have seen your script for capacity planning at a table level (Easing the Capacity Planning Burden), but how can I ro...
|
|
|
|
Total Hits: 143 | Today: 0
|
Author: AzamSharp
|
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....
|
|
|
|
Total Hits: 109 | Today: 0
|
Author: Atif Aziz
|
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...
|
|
|
|
Total Hits: 75 | Today: 0
|
Author: Timothy Khouri
|
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....
|
|
|
|
|
|
