Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Introduction > SQL Server


Search:
What's New - What's Hot
Introducing the Boomerang Framework  Version: 0.00     Price: $0.00  
Total Hits: 113  |  Today: 0Author: psined      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article I will introduce you to Boomerang Framework and show how it can help you build notification/communication solutions.

Boomerang is a notification framework for professional developers and integrators providing rock solid service oriented infrastructure and rapid development interface....

An Introduction to SQL Server Clustering  Version: 0.00     Price: $0.00  
Total Hits: 122  |  Today: 0Author: Brad McGehee      Rating:  
Read Reviews | Write Review |  Your Rating: 

If your mission-critical SQL Server should experience a motherboard failure, how long will it be down? One hour, four hours, a day, or longer? How much will this cost your business in lost sales or productivity? And perhaps even more important to you, what will it do to your stress level?...

Pivot and UnPivot with SSIS  Version: 0.00     Price: $0.00  
Total Hits: 130  |  Today: 0Author: Dinesh Asanka      Rating:  
Read Reviews | Write Review |  Your Rating: 

The presentation of your data is required for easy analysis. Turning columns into rows and rows into columns is another way of presenting your data so that end-users can understand it easily. Other than presentation purposes, you need to transform your data within your data warehouse application into different data formats. This process can be referred to as ‘Pivoting’, and the reversing of this process can be referred to as ‘UnPivoting’....

Introduction to SQL Server 2008 Profiler     
Total Hits: 127  |  Today: 0Author: Pinal Dave      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Server Profiler is a powerful tool that is available with SQL Server since a long time; however, it has mostly been underutilized by DBAs. SQL Server Profiler can perform various significant functions such as tracing what is running under the SQL Server Engine’s hood, and finding out how queries are resolved internally and what scripts are running to accomplish any T-SQL command. The major functions this tool can perform have been listed below:
* Creating trace
* Watching tra...

Microsoft SQL Server 2005 Express Edition with Advanced Services     
Total Hits: 658  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft SQL Server 2005 Express Edition with Advanced Services is a new, free, easy-to use version of SQL Server Express that includes more features and makes it easier than ever to start developing powerful data-driven applications for web or local desktop development....

Introduction to SQL     
Total Hits: 1068  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL is an ANSI (American National Standards Institute) standard computer language for accessing and manipulating database systems. SQL statements are used to retrieve and update data in a database. SQL works with database programs like MS Access, DB2, Informix, MS SQL Server, Oracle, Sybase, etc. Unfortunately, there are many different versions of the SQL language, but to be in compliance with the ANSI standard, they must support the same major keywords in a similar manner (such as SELECT, UPDAT...

Sql-Course with offline-Interface   Price: Free / Free Trial  
Total Hits: 840  |  Today: 0Author: Juergen Auer      Rating:  
Read Reviews | Write Review |  Your Rating: 

The tutorial uses a sample in all lessons and shows not only simple, but also more complex queries like subqueries and Group By, combined with Joins. An Offline-Interface, written in NET, allows to execute Sql-Commands directly, no additional program is required....

Creating Our First Cube      
Total Hits: 1710  |  Today: 0Author: William Pearson      Rating:  
Read Reviews | Write Review |  Your Rating: 

Introduction to MSSQL Server 2000 Analysis Services, which I hope will help new users get up to speed quickly on this exciting functionality.The series is designed to provide hands-on application of the fundamentals of MS SQL Server 2000 Analysis Services (to which I will refer in many cases as simply "Analysis Services" to save time and space); our primary focus will be the creation of simple multi-dimensional OLAP cubes, with each installment progressively adding more features designed to meet...

Introduction to SQL Server 2000 Analysis Services: Working with Dimensions      
Total Hits: 1558  |  Today: 0Author: William Pearson      Rating:  
Read Reviews | Write Review |  Your Rating: 

the Dimension Wizard is a helpful tool for rapid cube design,we often come across scenarios where we have to take more direct control of the dimension design process. We accomplish this through the use of the Dimension Editor, which exposes numerous properties of a dimension that are not accessible to us through the use of the Dimension Wizard....

An Introduction to SQL     
Total Hits: 1882  |  Today: 0Author: Alex Campbell      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL (structured query language) is the language of databases. In this article, I am not going to conform to convention and waste ink entertaining the fantasy that SQL is standard. There is an ANSI SQL standard, yes. But neither of the major SQL database servers - MS SQL Server and Oracle - conforms to it, and for the purposes of this document, the SQL will be of the Microsoft SQL Server variety....

SQL Server 2000 Books Online Download     
Total Hits: 2523  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Get easy access to complete SQL Server 2000 documentation by downloading this HTML Help file to your desktop....

SQL In Simple English - Part II     
Total Hits: 1655  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This is the second article in this series. This article mainly deals with SQL Joins and SQL subqueries. Both of these are extremely useful SQL constructs and should be learnt by all beginners....

A Gentle Introduction to SQL     
Total Hits: 1741  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

An interactive SQL tutorial. Including online access to SQL engines running MySQL, SQL Server, Oracle and Access....

Interactive/On-line SQL Tutorial with SQL Interpreter & live practice database     
Total Hits: 2128  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This unique introductory SQL tutorial not only provides easy-to-understand SQL instructions, but it allows you to practice what you learn using the on-line SQL interpreter. You will receive immediate results after submitting your SQL commands. You will be able to create your own unique tables as well as perform selects, inserts, updates, deletes, and drops on your tables. This SQL tutorial currently supports a subset of ANSI SQL. The basics of each SQL command will be covered in this introductor...

Introduction to SQL Injection  Version: 0.00     Price: $0.00  
Total Hits: 84  |  Today: 0Author: Vuyiswa Maseko      Rating:  
Read Reviews | Write Review |  Your Rating: 

Every time I get involved in a new project that I happen to inherit, I always come across SQL code in web pages and input that is not trapped. Well, some of these applications are used internally and some go to clients externally. A programmer argued about how dangerous it is to write your SQL statement in web pages. In this short article, I am going explain the reasons why it is not a good programming practice or dangerous to your users if you don’t trap the input or if you write your SQL on yo...

Introduction about SQL Transaction  Version: 0.00     Price: $0.00  
Total Hits: 105  |  Today: 0Author: Gomathi Palaniswamy      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article explains about the SQL Transaction and need of this transaction. The SQL transaction is used to control the database access. The namespace of SQL transaction is System.Data.SqlClient....

An Introduction to SQL Server Scalar UDFs  Version: 0.00     Price: $0.00  
Total Hits: 108  |  Today: 0Author: Navneeth Diwaker Naik      Rating:  
Read Reviews | Write Review |  Your Rating: 

One of the best features of SQL Server 2000 is its user-defined functions (UDFs). UDFs offer many of the benefits of both views and stored procedures, and more.

Unlike views, UDFs can take zero or more input parameters and return a scalar value, or can even return a table. Unlike stored procedures, the output of an UDF can be used in a SELECT statement, which is really beneficial. UDFs are compiled and optimized in the same way as a stored procedure....

SQL Server Integration Services an Introduction - Part 1  Version: 0.00     Price: $0.00  
Total Hits: 106  |  Today: 0Author: Arshad Ali      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Server Integration Services (SSIS) is a platform for building high performance data integration and workflow solutions. It allows creation of packages or SSIS packages which are made up of tasks that can move data from source to destination and alter it if required....

Introduction to Cloud Computing     
Total Hits: 95  |  Today: 0Author: Pinal Dave      Rating:  
Read Reviews | Write Review |  Your Rating: 

"Cloud Computing," to put it simply, means "Internet Computing." The Internet is commonly visualized as clouds; hence the term “cloud computing” for computation done through the Internet. With Cloud Computing users can access database resources via the Internet from anywhere, for as long as they need, without worrying about any maintenance or management of actual resources. Besides, databases in cloud are very dynamic and scalable. Cloud computing is unlike grid computing, utility computing, or ...

Introduction to LINQ, Part 1: LINQ to Objects     
Total Hits: 197  |  Today: 0Author: Marius Bancila      Rating:  
Read Reviews | Write Review |  Your Rating: 

Perhaps the most important new feature to the next version of Visual Studio, for now code-named 'Orcas,' is the release of LINQ, which stands for Language INtegrated Queries. LINQ is actually a set of operators, called standard query operators, that allow the querying of any .NET sequence. LINQ comes in three sub-sets:
* LINQ to ADO.NET, which includes the following:
o LINQ to Entities, for querying EDM entities
o LINQ to DataSet, for querying objects in the Data...



Disclaimer - Privacy
© 2002-2017 DevASP.net