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 > Developers Training > SQL Server


Search:
What's New - What's Hot
Microsoft Sql Server, Error : 10061  Version: 0.00     Price: $0.00  
Total Hits: 89  |  Today: 0Author: Dhananjay Kumar      Rating:  
Read Reviews | Write Review |  Your Rating: 

This is very common error and can be caused due to many reasons. The way I solved it

1. Go to Start
2. Type Run
3. Type Services.msc
4. Then locate for SQL Server instance you are trying to connect. In my case this is SQL TEST. Right click and select Properties...

SQL Server Techniques for Creating a Web Reporting Page -- Part 2  Version: 0.00     Price: $0.00  
Total Hits: 81  |  Today: 0Author: Louis Duc Nguyen      Rating:  
Read Reviews | Write Review |  Your Rating: 

Our sales manager is happy with our previous work. Now he requests the ability to sort the results, ascending and descending. In the web page, we provide an input select box where he can select which column to sort on. We also provide an input select box where he can select ascending or descending. If he selects descending, we pass “desc”. If he selects ascending, we pass nothing as ascending is the SQL default. We concatenate the values and pass it to a new parameter @orderby. The possible valu...

Exposing API Server Cursors  Version: 0.00     Price: $0.00  
Total Hits: 75  |  Today: 0Author: Sean Robert Fitzgerald      Rating:  
Read Reviews | Write Review |  Your Rating: 

Recently, I was informed that a process which executed a distributed query was running longer than was originally anticipated. Initially, I identified that the distributed query was allocating cpu, but the memory and disk io values were increasing at a much slower pace. In fact, so slowly that the memory and disk io values appeared to be frozen. My initial reaction was that this might be the result of a missing/invalid index, and/or a table scan. Using SQL Server Profiler I was able to expos...

Accessing and Manipulating XML Data in .NET     
Total Hits: 503  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This series of articles shall examine how we can access and manipulate XML data using VB.NET and SQLServer. In particular we shall be looking at the following:...

Developing for SQL Server     
Total Hits: 579  |  Today: 0Author: Kimberly Tripp      Rating:  
Read Reviews | Write Review |  Your Rating: 

Kimberly L. Tripp talks about indexing best practices and what developers should know about SQL Server management. She also discusses stored procedure and parameterized queries caching, the new availability features in SQL Server 2005, and the SQL Server CLR....

SQL Tutorial     
Total Hits: 461  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL is a standard computer language for accessing and manipulating databases. In this tutorial you will learn how to use SQL to access and manipulate data in Oracle, Sybase, SQL Server, DB2, Access, and other database systems....

SQL Server 2000 and Oracle CD-ROMs - Full Course   Price: $95.00  
Total Hits: 683  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 


This 2 CD set provides a technology comparison of Microsoft SQL Server 2000 and Oracle 8i database administration/developer common tasks. This CD set answers the question: "How would I create a database in SQL Server 2000 in comparison to Oracle 8i?"

Product Type: Full Course

Training includes:
  • 2 CD-ROMs
  • Over 2 hours of instruction
Click here to see more detail

Microsoft SQL Server 7.0 CD-ROMs - Level 2   Price: $375.00  
Total Hits: 333  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 


Learn how to create a basic SELECT statement as well as more advanced. Look at stored procedures, triggers, and views. Also learn SQL Server optimization.

Product Type: Level or Part

Training includes:
  • 5 CD-ROMs
  • Over 4 hours of instruction
  • Over 400 pages of courseware
  • Step-by-step hands-on labs
  • Sample code
Click here to see more detail

Microsoft SQL Server 2000 CD-ROMs - Level 3   Price: $445.00  
Total Hits: 353  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 


Learn about the advanced features available to you in SQL Server 2000 for maintaining, analyzing, searching and distributing your data. Integrate your data safely with Internet and cross-platform applications.

Product Type: Level or Part

Training includes:
  • 5 CD-ROMs
  • Over 7 hours of instruction
  • Over 350 pages of courseware
  • Step-by-step hands-on labs
  • Sample code
Click here to see more detail

Microsoft SQL Server 2000 CD-ROMs - Level 2   Price: $445.00  
Total Hits: 357  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 


This course shows you how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL, the language of SQL Server. You'll also learn about tools for maintaining, securing, and tuning your databases.

Product Type: Level or Part

Training includes:
  • 6 CD-ROMs
  • Over 9 hours of instruction
  • Over 400 pages of courseware
  • Step-by-step hands-on labs
  • Sample code
Click here to see more detail

Microsoft SQL Server 2000 CD-ROMs - Level 1   Price: $225.00  
Total Hits: 430  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 


Learn what's available in SQL Server; how to design and create a database; and how to build queries using Transact-SQL, the language of SQL Server. This course teaches you the fundamentals and gives you a taste of the potential of SQL Server 2000.

Product Type: Level or Part

Training includes:
  • 3 CD-ROMs
  • Over 4 hours of instruction
  • Over 250 pages of courseware
  • Step-by-step hands-on labs
  • Sample code
Click here to see more detail

Advanced SQL Server DATE and DATETIME Handling  Version: 0.00     Price: $0.00  
Total Hits: 75  |  Today: 0Author: Daniel Pfaff      Rating:  
Read Reviews | Write Review |  Your Rating: 

There are lot of situations where you need an exact timestamp. For example, you may want to differentiate a recordsets’ creation dates, store technical measurements, or just to see how fast your latest SQL is running. Coding the 4th dimension is another common task, and therefore milliseconds are essential....

Create Local Cubes with Microsoft SQL Server 2000 and Microsoft Office  Version: 0.00     Price: $0.00  
Total Hits: 73  |  Today: 0Author: Shushmul Maheshwari      Rating:  
Read Reviews | Write Review |  Your Rating: 

As the number of people who are conducting business from outside the corporate workplace increases, the need to access corporate databases using devices such as mobile phones and portable computers also increases....

SQL Server Reporting Services     
Total Hits: 562  |  Today: 0Author: Jason Carlson      Rating:  
Read Reviews | Write Review |  Your Rating: 

Jason Carlson talks about SQL Server Reporting Services including how reports are developed and that while the designer is integrated into Visual Studio, that Reporting Services is not a developer only tool. He also discusses features of the products such as the use of XML and it's ability to generate XML as a data source for other processes and the user of user defined types in SQL Server 2005....

XML Applications with SQL Server 2000 CD-ROMs - Full Course   Price: $495.00  
Total Hits: 805  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 


In this course, you'll learn how to retrieve data from SQL Server 2000 as XML, how to use standard XML-based techniques to query and modify data, and how to bulk-load large XML documents into SQL Server tables.

Product Type: Full Course

Training includes:
  • 3 CD-ROMs
  • Over 5 hours of instruction
  • Over 200 pages of courseware
  • Step-by-step hands-on-labs
  • Sample code
Click here to see more detail

SQL Server 2000 - Accelerated Training CD-ROMs - Full Course   Price: $495.00  
Total Hits: 601  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 


In SQL Server 2000 - Accelerated Training, you'll see the new graphical tools, learn how performance and maintainability have been improved, and learn how SQL Server 2000's features position it as a powerful .NET server.

Product Type: Full Course

Training includes:
  • 3 CD-ROMs
  • Over 4 hours of instruction
  • 1 Printed manual
  • Step-by-step hands-on labs
  • Sample code
Click here to see more detail

Microsoft SQL Server 7.0 CD-ROMs - Level 1-2   Price: $495.00  
Total Hits: 389  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 


Master Microsoft SQL Server 7.0 using these easy-to-follow CD-ROMS from AppDev. Bundle includes Levels 1 & 2 on CD.

Product Type: Bundle

Training includes:
  • 7 CD-ROMs
  • Over 5 hours of instruction
  • Over 600 pages of courseware
  • Step-by-step hands-on-labs
  • Sample code
Click here to see more detail

Microsoft SQL Server 7.0 CD-ROMs - Level 1   Price: $150.00  
Total Hits: 337  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 


Level 1 CD-ROMs teach you how to install and configure Microsoft SQL Server 7.0 and design your databases.

Product Type: Level or Part

Training includes:
  • 2 CD-ROMs
  • Over 1 hour of instruction
  • Over 200 pages of courseware
  • Step-by-step hands-on labs
  • Sample code
Click here to see more detail

Microsoft SQL Server 2000 CD-ROMs - Full Course   Price: $995.00  
Total Hits: 387  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 


Master Microsoft SQL Server 2000 with all three levels of this set of 14 CD-ROMs! Includes printed courseware, course samples on CD-ROM, and instruction by experts Mary Chipman and Andy Baron.

Product Type: Full Course

Training includes:
  • 14 CD-ROMs
  • Over 20 hours of instruction
  • Over 1000 pages of courseware
  • Step-by-step hands-on labs
  • Sample code
Click here to see more detail

Sending SQL Server Notifications with CDOSYS  Version: 0.00     Price: $0.00  
Total Hits: 52  |  Today: 0Author: Desiree Harris      Rating:  
Read Reviews | Write Review |  Your Rating: 

While SQL Server has a very mature set of tools, one thing that is lacking is the ability to send a simple email alert based on a pre-defined set of rules. At first glace, it appears that email notifications exist, but what becomes a problem to many people is the requirement for a MAPI subsystem to be present on the server. This means that Outlook, or an equivalent program, has to be installed on the server. Not only that, to properly configure it, the administrator will need to log into the ser...



Disclaimer - Privacy
© 2002-2017 DevASP.net