Home About Us SQL Interview Book Contact Us RSS
Articles
Tools
Code Snippets
Links
Tips & Tricks
FAQ
Resources
Articles
Code Snippets
Links
FAQ
Resources

Saravana Kumar
Vinod Kumar


 
53. HOW TO: Pass a Variable to a Linked Server Query
Demonstrates to how a pass a variable to a linked server query
Posted On : November 23, 2004 More... Author : Microsoft

52. Microsoft SQL Server 2000 Resource Kit: Chapter 2 - New Features in SQL Server 2000
Microsoft SQL Server 2000 extends the performance, reliability, quality, and ease-of-use of Microsoft SQL Server version 7.0. Microsoft SQL Server 2000 includes several new features that make it an excellent database platform for large-scale online transactional processing (OLTP), data warehousing, and e-commerce applications.
Posted On : November 23, 2004 More... Author : Microsoft

51. LockwoodTech Software Offers SQLDiff to Compare and Synchronize SQL Server Databases
If you are in anyway involved in database development, you will invariably run into instances where you need to compare two similar databases and find out how they are different (both database objects or data stored in tables). This is especially the case if you don't use change management software and there are two or more developers writing and modifying database design, code, or test data. Along this same line, if you do find differences between two databases' objects, sometimes you have the need to synchronize the two databases so that they are the same.
Posted On : November 23, 2004 More... Author : Brad M. McGehee

50. Achieving Massive Scalability with SQL Server
Learn the basics of how to scale your SQL Server databases.
Posted On : November 23, 2004 More... Author :

49. Reinstalling SQL Server on a Failed Node
SQL Server 2000 Enterprise Edition installs SQL Server executables and program files on both of my clustered servers simultaneously. If one of my servers goes down, how can I rebuild the server and reinstall SQL Server on that node?
Posted On : November 23, 2004 More... Author : Microsoft

48. BLOB Access Technologies
By Michael Otey - Microsoft provides several tools for working with BLOB objects. Here are seven of the most important BLOB access technologies.
Posted On : November 23, 2004 More... Author : Michael Otey

47. All About Nothing
By Russ Whitney - OLAP cubes are notorious for having lots of empty (or null) cells. Including these empty cells in your result sets can bog down your analysis applications. But you can use these tricks to eliminate empties.
Posted On : November 23, 2004 More... Author : Russ Whitney

46. Reinstalling SQL Server on a Failed Node
SQL Server 2000 Enterprise Edition installs SQL Server executables and program files on both of my clustered servers simultaneously. If one of my servers goes down, how can I rebuild the server and reinstall SQL Server on that node?
Posted On : May 8, 2004 More... Author : Microsoft

45. Achieving Massive Scalability with SQL Server
Learn the basics of how to scale your SQL Server databases.
Posted On : May 8, 2004 More... Author : Unknown

44. Microsoft SQL Server 2000 Resource Kit: Chapter 2 - New Features in SQL Server 2000
Microsoft SQL Server 2000 extends the performance, reliability, quality, and ease-of-use of Microsoft SQL Server version 7.0. Microsoft SQL Server 2000 includes several new features that make it an excellent database platform for large-scale online transactional processing (OLTP), data warehousing, and e-commerce applications.
Posted On : May 8, 2004 More... Author : Microsoft

43. LockwoodTech Software Offers SQLDiff to Compare and Synchronize SQL Server Databases
If you are in anyway involved in database development, you will invariably run into instances where you need to compare two similar databases and find out how they are different (both database objects or data stored in tables). This is especially the case if you dont use change management software and there are two or more developers writing and modifying database design, code, or test data. Along this same line, if you do find differences between two databases objects, sometimes you have the need to synchronize the two databases so that they are the same.
Posted On : May 8, 2004 More... Author : Brad M. McGehee

42. Reducing SQL Server Index Fragmentation
When you perform any data modification operations (INSERT, UPDATE, or DELETE statements) table fragmentation can occur. When changes are made to the data that affect the index, index fragmentation can occur and the information in the index can get scattered in the database. Fragmented data can cause SQL Server to perform unnecessary data reads, so a queries performance against a heavy fragmented table can be very poor. If you want to determine the level of fragmentation, you can use the DBCC SHOWCONTIG statement.
Posted On : May 8, 2004 More... Author : Unknown

41. SQL Server Notification Services Developer Overview
Webcast Summary: SQL Server Notification Services is a new powerful notification application platform. The platform helps developers build centralized publish-subscribe (pub-sub) applications and deploy them on a large scale. These applications are often used to send notification messages to end-users, hence the names - notification application and Notification Services.
Posted On : Jan 03, 2004 More... Author : Unknown

40. How to Buy SQL Server 2000
This link can help you select and purchase the right SQL Server edition for your business. Pricing and licensing information is also available.
Posted On : Jan 03, 2004 More... Author : Microsoft Support

39. INF: How to Write a Variance Query in SQL Server
When you need to make a comparison between a value and the average for that value in the same category, you can execute a variance query. For example, you may want to use a variance query when you want to compare the salary of an employee against the salary of other employees who hold the same title, or when you want a comparison between the price of a book and the price of all the other books of the same category.
Posted On : Jan 03, 2004 More... Author : Microsoft Support

38. Application Incompatibilities Complicate Migration to Windows Server 2003
The migration must encompass major architectural changes to the portal software itself, including a move onto SQL Server from the old Web Storage System on the database side.
Posted On : November 11, 2003 More... Author : Barbara Darrow

37. Backing Up and Restoring SQL Server Databases and Transaction Logs
SQL Server provides several methods to protect against data loss. Alexander Chigrik explains of the various methods in this article.
Posted On : November 11, 2003 More... Author : Alexander Chigrik

36. INF: How to Set Up SQL Server 2000 to Listen on Multiple Static TCP Ports
This article describes how to enable a SQL Server 2000 default instance to listen on multiple TCP ports.
Posted On : October 30 2003 More... Author : Microsoft Support

35. HOW TO: Manually Remove a MSDE 2000 Instance
This step-by-step article describes how you manually remove a Microsoft SQL Server 2000 Desktop Engine (also known as MSDE 2000) instance. If you experience a problem when you try to remove an MSDE 2000 instance by using Add/Remove Programs in Control Panel, you can manually remove the instance instead. To manually remove MSDE 2000, follow the steps in the "More Information" section of this article
Posted On : October 30 2003 More... Author : Microsoft Support

34. Microsoft SQL Server 7.0 Performance Tuning Guide
Provides database administrators and developers with valuable information on Microsoft SQL Server 7.0 index selection, disk I/O subsystem tuning, and SQL Server 7.0 performance tuning tools
Posted On : October 30 2003 More... Author : Henry Lau, Microsoft

33. International Features in Microsoft SQL Server 2000
Learn all that takes to write international applications in SQL Server 2000. This articles takes you from the basics to the end about SQL Server Internationalization.
Posted On : October 18, 2003 More... Author : Microsoft MSDN - Kaplan

32. Backing Up and Restoring SQL Server Databases and Transaction Logs
SQL Server provides several methods to protect against data loss. Alexander Chigrik explains of the various methods.
Posted On : October 18, 2003 More... Author : Alexander Chigrik

31. TOP N Clause vs. SET ROWCOUNT N
This tips and tricks section on Microsoft SQL Server site explains, Is using the TOP N clause faster than using SET ROWCOUNT N to return a specific number of rows from a query.
Posted On : October 18, 2003 More... Author : Microsoft

30. SQL Server CE Relay
This white paper contains the instructions for setting up connectivity between Microsoft SQL Server 2000 Windows CE Edition (SQL Server CE) and SQL Server by using SQL Server CE Relay. SQL Server CE Relay is used to share data with mobile Windows CE based devices when there is no integrated network capability. SQL Server CE Relay functionality does not require a network card in the Windows CE based device because it uses a desktop computer s network connection.
Posted On : October 18, 2003 More... Author : Microsoft Support

29. SQLISAPI and XML Client-Side Processing
XML and SQL series with a look at client-side XML processing with SQLXML 2.0 (and later). Interesting writeup. This is the Part 10 of the complete series.
Posted On : September 27, 2003 More... Author : Marcin Policht

28. INF: SQL Server and Striped Backups
With striping, you can back up a database to different disks either to increase backup throughput or to distribute space usage across different disks. However, the files may or may not be evenly distributed.
Posted On : September 27, 2003 More... Author : Microsoft Support

27. Migrating from Sybase to SQL Server
This article shows Sybase database administrators (DBAs) and managers the steps that should be followed to migrate from a Sybase database to an MS SQL Server 2000 database.
Posted On : September 19, 2003 More... Author : Sayed Geneidy

26. Populating IE TreeView Web Control using SQL Server and XML Explicit
Microsoft has made available the Internet Explorer Web Controls which are not included in the Framework by default. The assembly includes several controls one of which is the TreeView Control which is discussed in this article.
Posted On : September 19, 2003 More... Author : Simon Segal

25. New Features in SP3a
What are the features of the new SQL Server service pack SP3a. Read this article to find out about why this service pack is useful.
Posted On : August 26, 2003 More... Author : SQL Server Magazine

24. Basics of Data Transformation Services (DTS)
Many organizations have various islands of data that would need to be integrated. DTS provides a set of tools that allow the consolidation and transformation of data from various sources (governed by DTS connectivity) into single or multiple destinations. This article explores the basic features of DTS and also looks a couple of sample programs.
Posted On : August 26, 2003 More... Author : Srinivas Sampath

23. SQL Server Undocumented Stored Procedures
This link contains a nice list of all undocumented SQL Server stored procedures.
Posted On : August 26, 2003 More... Author : Database Journal

22. Understanding and Using SQLNS
SQL-NS is a great extension tool from Microsoft that allows applications to tap into SQL Server 2000 Enterprise Manager user interfaces. Bundled along with SQL Server 2000, SQL-NS can be used to display dialog boxes, wizards and property sheets of SQL Server Enterprise Manager through custom applications (for example, the database creation dialog box). This can provide a great deal of flexibility to applications and to users. This article looks at the basic building blocks of SQL-NS and also explores a set of samples that exemplify the features of SQL-NS.
Posted On : August 26, 2003 More... Author : Srinivas Sampath

21. Using SQL Server Application Roles
Often applications that connect to SQL Server authenticate users by using a user-name and password. It is also an often practise that these users are created in SQL Server as logins and have varying degree of permissions on the database and its objects. Other than this default access mechanism, it might be sometimes required by your application to uniformly provide security to a set of objects for the application to all users, irrespective of the security that they inherit by virtue of logging into the application. This article looks at the usage of application roles along with some samples.
Posted On : August 26, 2003 More... Author : Srinivas Sampath

20. DTS on the move
This article is very useful for people writing DTS packages and want to make them portable across servers. The article discusses 7 best-practices for DTS package programming.
Posted On : August 26, 2003 More... Author : SQL Server Magazine

19. SQL Server Extended Properties
Introduced in SQL Server 2000, extended properties allow a database architect to attach information to schema objects like tables, views etc. that be used by all applications. For example, you can use extended properties to attach descriptions about tables and their columns, which can then be used to construct a data dictionary. Alternatively, you can also store display information about columns as extended properties, so that all applications using the column can display it in the same manner. This article explores how extended properties can be used and shows a small sample application too.
Posted On : August 26, 2003 More... Author : Srinivas Sampath

< >

Bangalore .NET User Group (BDotNet), India's Biggest and Active .Net User Group



The MVP Award is given in recognition of a recipient's technical expertise, spirit of community, and their willingness to help their peers by providing reliable and accurate answers to technical questions about Microsoft products & technologies