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

Home >Search > Knowledge Base > SQL Server > SQL Server 2005

What's New - What's Hot
Review: Beginning SQL Server 2005 Programming     
Total Hits: 325  |  Today: 0Author: Robert Vieira      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Server 2005 is another big release for SQL Server. It contains many new enhancements and additions. If you are targeting software development with .NET framework (or any MS technology) then you should have solid understanding of SQL Server. This book is intended for beginners and gives good understanding about RDBMS basics, various flavors SQL statements, stored procedures, functions and triggers. I found the writing style of the author a bit verbose at places but that's not a major issue....

How to identify your SQL Server version and edition     
Total Hits: 330  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article describes how to identify your current Microsoft SQL Server version number and the corresponding product or service pack (SP) level. It also describes how to identify the specific edition if you are using Microsoft SQL Server 2000 or Microsoft SQL Server 7.0....

Eyeing Visual Studio 2005, SQL Server 2005     
Total Hits: 552  |  Today: 0Author: Mario Morejon      Rating:  
Read Reviews | Write Review |  Your Rating: 

Changes featured in Microsoft Visual Studio 2005 focus heavily on aiding developer productivity in the face of the increasing complexity of the .Net framework and the tool’s diverse feature set.To speed development, Visual Studio now has additional code refactoring capabilities, including IntelliSense code snippets and intelligent helpers. Hundreds of components and classes inside the .Net framework have been added to the palette. The code snippet library includes more than 400 reusable sections...

FIX: No table headers appear in the Excel report when you use SQL Server 2005 Reporting Services to export information to Excel     
Total Hits: 239  |  Today: 0Author: Microsoft©      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft distributes Microsoft SQL Server 2005 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2005 fix release. This article describes the following about this hotfix release: The issues that are fixed by the hotfix package,
The prerequisites for installing the hotfix package, Whether you must restart the computer after you install the hotfix package, Whet...

How To Use SQL Server Reporting Services     
Total Hits: 105  |  Today: 0Author: Bean Software      Rating:  
Read Reviews | Write Review |  Your Rating: 

Business development often requires analysis and data mining. Determining trends with which Customers and other stake holders deal with a business are of sole importance to the business. In fact, helping a businessman to grow his business has contributed a lot in rapid growth of IT industry. Microsoft SQL Server Reporting services provide a solution to those tasked in finding business trends. Briefly speaking:
1. Reporting services lets you create rich reports and format them based on your...

SQL Server 2005 Query Notifications Tell .NET 2.0 Apps When Critical Data Changes     
Total Hits: 326  |  Today: 0Author: Julia Lerman      Rating:  
Read Reviews | Write Review |  Your Rating: 

One of the classic problems with database applications is refreshing stale data.

Imagine a typical e-commerce site with products and categories. A vendor's product list most likely does not change very often and their category list changes even less frequently. However, those same lists must be queried from the database over and over again every time a user browses to that Web site. This is an annoyingly inefficient use of resources and developers and architects have been stuck playing ca...

How to verify and change the system administrator password in MSDE or SQL Server 2005 Express Edition     
Total Hits: 367  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article discusses the steps you can use to change the SQL Server sa (system administrator) password. You can configure Microsoft SQL Server 2005 Express, Microsoft SQL Server Desktop Engine (MSDE) versions 2000, or earlier versions of Microsoft SQL Server to run in Mixed Authentication mode. The sa account is created during the installation process and the sa account has full rights in the SQL Server environment. By default, the sa password is blank (NULL), unless you change th...

How to make sure that you are using Kerberos authentication when you create a remote connection to an instance of SQL Server 2005     
Total Hits: 536  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article describes how to make sure that you are using Kerberos authentication as a Microsoft Windows authentication method when you create a remote connection to an instance of Microsoft SQL Server 2005. SQL Server 2005 supports Kerberos authentication indirectly through the Windows Security Support Provider Interface (SSPI) when you are using Windows integrated authentication instead of SQL authentication. However, SQL Server will only use Kerberos authentication under certain circumstance...

Disclaimer - Privacy
© 2002-2018