|
|
|
|
|
Total Hits: 68 | 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: 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: 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: 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: 54 | Today: 0
|
Author: Merrill Aldrich
|
Rating:
|
|
Recently in my own practice, I was abruptly reminded of the value of SQL Server's Update Statistics with Full Scan: to make a long story short, we had a system that was getting a bad query plan that would consistently peg one of the CPUs for hours at a time. If multiple requests for the same data came in, more CPUs would be taken up, eventually using 100% of all processors. The query was a simple one, and we were stumped by this issue for a time. It turned out that the maintenance on the databas...
|
|
|
|
Total Hits: 13 | Today: 0
|
Author: Andy Searls
|
Rating:
|
|
SharePoint lists are stored in a SQL Server database, so you would think that connecting SQL Reporting Services to a SharePoint 2007 list would be trivial, but it’s not. There are a number of pitfalls to be avoided that are not entirely clear and do not provide clear error messages. In this white paper, I’ll outline one approach to attach a report to a list. I’ll include common mistakes and ways to avoid them as well as tips for determining causes of problems you might find along the way....
|
|
|
|
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: 13 | 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: 25 | 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: 54 | 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: 39 | 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: 76 | 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: 58 | Today: 0
|
Author: Dinesh Asanka
|
Rating:
|
|
Security has become extremely important in today's fiercely completive business environment. Industry standards require you to implement firm techniques to secure your data. In SQL Server 2005, security has improved for authentication, authorization, and encryption. Encryption is so much improved that it is almost a new feature in SQL Server 2005.
Encryption is the last barrier against a hacker. Technically, authentication and authorization methods should be strong enough to stop hackers befo...
|
|
|
|
Total Hits: 52 | Today: 0
|
Author: Dinesh Asanka
|
Rating:
|
|
In this article, we are going to discuss the Service Broker, another new feature in SQL Server 2005. In simple terms, Service Broker is a distributed messaging framework, or MSMQ (Microsoft Message Queue), in SQL Server 2005. Using this new feature, you will be able to add reliable, scalable, asynchronous functionality to your database applications.
This article will focus on the benefits of this new feature and basic configuration for applications....
|
|
|
|
Total Hits: 118 | 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: 37 | 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: 29 | 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: 13 | 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: 42 | 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: 29 | 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....
|
|
|
|
|
|
