Home             About Us             Sign Guest Book             Contact Us             Subscribe              RSS  
SQL
Articles
Tools
Code Snippets
Links
Tips & Tricks
FAQ
Resources
.NET
Articles
Code Snippets
Links
FAQ
Resources

Blogs
Saravana Kumar
Vinod Kumar

Newsletter

Click on the image to subscribe to our Monthly Newsletter.

Click here for Archives

Expert Chat
No Chats Available
 
74. Introduction to Database Mirroring in SQL Server - Part II
This is Part II of the series on Database Mirroring that we will continue in this article. What we missed in Database Mirroring Part I is the archietecture, topology and factors that we need to keep in mind when working with Database Mirroring. Database mirroring is a highly flexible high-availability technology that does not need specialized hardware and storage technologies. However, before selecting database mirroring as your high-availability technology, you must consider its implications on your environment. You should also plan and document the approaches you will adopt when configuring security, network infrastructure, hardware, and server configurations for database mirroring.
Posted On : Jul 20, 2009 More... Author : Vinod Kumar
73. Introduction to Database Mirroring in SQL Server
Database mirroring was introduced with Microsoft SQL Server 2005 technology that can be used to design high-availability and high-performance solutions for database redundancy. It is designed to maintain a hot standby server with a transitionally consistent copy of the database. Mirroring is cost-effective, speedy, requires no special hardware, and ensures transactional consistency. This article will describe the different modes of database mirroring and how it is different from other technologies. Here will not get into the specifics of the SQL Server 2008 enhancements but will take a high level tour of SQL Server Mirroring concepts.
Posted On : Jan 6, 2009 More... Author : Vinod Kumar
72. Introduction to Extended Events
Extended Events (xEvents) is something that we introduced with SQL Server 2008 version. This is a complete tracing environment and must NOT be confused with the profiler version. Though the fundamentals of xEvents revolves around a general event-handling and at certain cases can be linked to OS functions via the ETW (Event Tracing for Windows). ETW has been around with the OS for a while now and this detailed view of stack dumps of memory, threads for a given process are quite a revelation to many. Though the number of people who would like this level of sophistication is limited, it is always good to know these features as in highly-transactional production environment systems they can come really handy for troubleshooting or performance tuning if needed. In this article we will get some basics understanding on how to use xEvents with SQL Server 2008.
Posted On : Jan 5, 2009 More... Author : Vinod Kumar
71. Feature additions between SQL 2005 and SQL 2008
This topic in general is available at various locations on the internet and SQL Server Books Online. Here is our attempt to have some of the features from both these versions a.k.a SQL Server 2005 and SQL Server 2008 side by side so that you will understand some of the enhancements that has been introduced in the new version. This is NOT an exhaustive list but just representative list which are categorized for your references only.
Posted On : Dec 26, 2008 More... Author : Vinod Kumar
70. Security in SQL Server 2005 - Part II
In we did try to get into some aspects of security which as an administrator or developer one needs to know. We started with instance security, database security, authentication, authorization etc. Now we will get into aspects that I couldnt cover before like Agent Service security, Object-level security, Execution contexts and many more. We will try to cover as much ground as possible in this article.
Posted On : Aug 27, 2008 More... Author : Vinod Kumar
69. Security in SQL Server 2005 - Part I
I have seen many articles about security and have seen customers get really paranoid when security breaches occur. Obviously, they have a valid reason to do so especially when the concern is about data security. In this digital aided world, everything boils down to just how can we keep our personal or company related data (which can be LOB data) in a secure manner and what are the tips and techniques we have in hand. This article will provides some of the guidelines and considerations for designing instance-level, database-level, and object-level security policies, and for defining security monitoring standards for instances and databases. Though not exhaustive, this will surely be able to form some starting base to work with in SQL Server.
Posted On : May 24, 2008 More... Author : Vinod Kumar
68. Archiving Data with SQL Server 2005
Though HDD prices have fallen well beyond imagination, archiving of data and keeping the database to a manageable size is a concern for all organizations. Storing obsolete data online reduces the performance of a database server. A well-designed archival strategy minimizes the performance problems that are caused by maintaining excess data. When designing an archival strategy, you should first determine how much data can be archived, then choose an appropriate structure for the archival data, and finally create a plan for archiving the data.
Posted On : Jan 2, 2008 More... Author : Vinod Kumar
67. Database Storage with SQL Server - Part II
With Part I as foundation let us take a step closer to other aspects to the storage system like what needs to be taken care when working with physical files, filegroups, transaction log design, SAN / RAID and more. We will cover as much as possible and let me highlight some of the best practices on the same lines.
Posted On : Sep 15, 2007 More... Author : Vinod Kumar
66. Database Storage with SQL Server - Part I
Database storage is one of the primary failure point in the database environment. Hence, making the storage architecture consistent and at the same time giving it maximum redundancy must be embedded within the design itself. When I call redundancy, I dont specifically say implementing anything specific to RAID or SAN or other mechanisms. Redundancy must be achieved given your hardware and budget currently in hand if it even means making just multiple backup copies at the simplest level.
Posted On : Aug 10, 2007 More... Author : Vinod Kumar
65. Understanding - DBCC SHOW_STATISTICS
Most SQL Server internal is undocumented, and even if they are documented there is hardly any information anyone can get out of these. So here is one such attempt where I take the DBCC SHOW_STATISTICS command and try to understand what it is trying to give us as useful information. I have at many occasion used these output to say if our indexing is effective or not.
Posted On : Jul 4, 2006 More... Author : Vinod Kumar
64. SQL Server Management in SQL Server 2005
As more companies try to embrase the new version of SQL Server they will surely have their hands on SQL Server 2000 servers too. When I first saw this new tool I was amazed to see how this new tool tried to give the best of both the worlds as Query Analyzer and Enterprise manager. With due respect there is lots to learn from using this tool and interestingly I would recommend you using this for mnaging SQL Server 2000 machines too. So lets get started with some of the feature available.
Posted On : Apr 16, 2006 More... Author : Vinod Kumar
63. SQL 2005 - TRY-CATCH - A boon to developers
This has been a topic worth taking a second look from a developer point of view. Even though it is such a small feature to dissect from a usage perspective we need to understand why something thing was brought on first place. In this article we will take a step back and look where SQL Server 2000 @@Error failed and why it is all the more reason for us to move towards this new model.
Posted On : Apr 04, 2006 More... Author : Vinod Kumar
62. Reserved Resource Database in SQL Server 2005
Also called as RDB this is a new concept in SQL Server 2005 which I thought was worth taking a look at. In previous version of SQL Server 2000 whenever we had to upgrade a system defined object we had to drop and recreate. And rollback of the same was also something that we as DBAs had to break our heads. All the service packs have a disclaimer that states we backup our databases before we start the installation sequence. Even though I recommend it strongly, let us take a tour of how the new reserved Resource Database improves this current process and how we can captilalize this change.
Posted On : Jan 17, 2006 More... Author : Vinod Kumar
61. Introduction to DMVs and DMFs in SQL Server 2005
Diagnosing problems in SQL Server 2000 has always been a point of concern from both developers and DBAs. More often than not we would have had a need to use undocumented and DBCC commands which are sometimes very difficult to understand too. SQL Server 2005 on the contrary is like a open book, no need to use bit based operations and undocumented column values. Welcome the introduction of Dynamic Management Views and Fuctions a.k.a DMVs and DMFs.
Posted On : Nov 6, 2005 More... Author : Vinod Kumar
60. New Sequence Number in SQL Server 2005
SQL Server 2005 is loaded with features and in this article we will look at yet another function introduced in SQL Server 2005 . This function is called as NEWSEQUENTIALID().
Posted On : Nov 5, 2005 More... Author : Vinod Kumar
59. Making the Most of the CLR
The integration of the common language runtime (CLR) in SQL Server 2005 opens up so many new possibilities that a developer might not know where to start. Here are three ways you can start taking advantage of SQL Server 2005's enhancements.
Posted On : May 02, 2005 More... Author : Vinod Kumar
58. sqlcmd Utility in SQL Server 2005 - Part II
Every new version of software will introduce new tools with its release. And in SQL Server 2005 there is absolutely no dearth of tools to talk on. Even though everyone would like to see and use the graphical user interface for most of the activity, there are sometimes these cool command prompt tools that we miss out. In continuation of that thought, I would take a quick walk through the sqlcmd tool that got introduced in SQL Server 2005.
Posted On : May 02, 2005 More... Author : Vinod Kumar
57. Using CLR features in SQL Server 2005 - Part 1
The next version of SQL Server, code-named Yukon, includes quite a few enhancements and expanded language support. If we were to list some of the key features introduced in this version then the list would run into lengthy pages. But the .NET integration is surely something that captures the imagination of developers. SQL Server 2005 can execute user-defined functions, stored procedures, and triggers written in common language runtime (CLR) targeted languages, including Visual Basic .NET and C#. In this article I will walk through the basic steps in creating our first CLR object.
Posted On : May 02, 2005 More... Author : Vinod Kumar
56. sqlcmd Utility in SQL Server 2005
Out of the many utilities that SQL Server 2005 has come up with I thought to take a sneak preview of the command line tools that got introduced with SQL Server 2005. Yes, sqlcmd Utility. Even though the intend is to use sqlcmd moving forward rather than the conventional osql command, we will take a quick tour of how we can use sqlcmd utility interactively, execute scripts and more.
Posted On : April 19, 2005 More... Author : Vinod Kumar
55. Security for CLR Assemblies in SQL Server 2005
With the support for managed code inside the SQL Server database, Microsoft has developed special security settings to protect the CLR's important new objects, assemblies. Assemblies are basically managed Dynamic Link Libraris (DLLs) that contain metadata and information about dependencies and are used as a deployment unit. Because assemblies are stored in the database, they also get backed up and restored with the database.
Posted On : April 15, 2005 More... Author : Vinod Kumar
54. Deadlock Detection in SQL Server 2005
The amount of features introduced in SQL Server 2005 are numerous. I think we have taken a tour of some T-SQL enhancements, DTS a.k.a. SSIS, XML and others before. But in this article we will take a look at another toolset that is available in SQL Server 2000 world but has been enhanced in this version, the Profiler. In this article we would look into an specific area of profiler enhancements, detecting dead locks in SQL Server 2005.
Posted On : Feb 8, 2005 More... Author : Vinod Kumar
53. Snapshot Isolation in SQL Server 2005
SQL Server uses isolation levels as a means to give us consistent data across multiple user accesses at the same time. There is generally a tradeoff with the fact that as we get higher up the isolation level the consistency of data is high and more is the reliability. But there is a caveat that we will be running low on the concurrency. SQL Server has had four levels prior to SQL Server 2005 namely Read Uncommitted, Read Committed, Repeatable Read and Serializable. I leave it to readers for the exact definition as these are found in SQL Server Books Online (SQL BOL). But in the next version of SQL Server 2005, we have a new Isolation Level called as "Snapshot Isolation level". In this article we will take a preview into the how and what's of this feature.
Posted On : Feb 8, 2005 More... Author : Vinod Kumar
52. EXECUTE AS Option in SQL Server 2005
SQL Server 2005 has introduced loads of features on the lines of security. Infact more implementations have been presented to users using SQL Server 2005. And one such feature is EXECUTE AS option. This option is an extension to what ownership chaining used to be in SQL Server 2000. You can check the BOL for specifics on the ownership chaining. But in this article I will walk through the new variations introduced with EXECUTE AS.
Posted On : Jan 6, 2005 More... Author : Vinod Kumar
51. DDL Triggers in SQL Server 2005
There are loads of features we can explore in SQL Server 2005. Here is one such feature that I personally would call it as the DBA's requirement. Here in this article we will take a snapshot to what DDL triggers are and how it can be extended to our needs. DDL Triggers are new in SQL Server 2005. Fundamentally SQL Server 2005 allows us to existing set of available triggers to the next level. In these trigger we can execute a trigger for all available DDL statements in the system.
Posted On : Dec 14, 2004 More... Author : Vinod Kumar
50. Indexes in SQL Server 2005 - Part II
We had taken a quick tour in our Part I about indexes. But that were some of the cool features that were introduced in SQL Server 2005. But there is more to this topic the more we explore the deeper concepts get. In this article let me take a quick tour to what ONLINE indexing is in SQL Server 2005.
Posted On : Nov 23, 2004 More... Author : Vinod Kumar
49. Try Catch Block in SQL Server 2005
Error handling in T-SQL has been in question for quite sometime now in SQL Server 2000. It has not been user-friendly and more often than not most of the developers have had doubts in the way it used to work. Now the good news is in SQL Server 2005 this new feature of TRY-CATCH is more like the way it works in many programming language. I have to admit this is the new rich error handling capability for T-SQL world.
Posted On : September 28, 2004 More... Author : Vinod Kumar
48. Introduction to DTS in SQL Server 2005 - Part II
One of the key features introduced in SQL Server 2005 is the new DTS platform. With the new release of SQL Server Beta 2, you must be eager to get your hands dirty on this new amazing platform. This product does bring in a new perspective and new thinking the way we used to work with DTS. Most of the DTS architecture has undergone dramatic changes. In this article I will walk through an step-by-step easy uploading of a given datafile into SQL Server. This new version of DTS does go beyond the ETL (Extract, Transform, Load) tools definition. You can orchestrate your code and create an workflow with the same. DTS in Yukon is more manageable, usable and more mature from its previous version.
Posted On : September 27, 2004 More... Author : Vinod Kumar
47. Indexes in SQL Server 2005
The use of indexes in the relational world is magnitude of importance. And nevertheless in SQL Server the usage of Indexes is very important. Understanding the usage being one side, optimizing and using this is the other aspect. In this article my key focus will be on introducing some of the basic enhancements brought into SQL Server 2005 for indexes. In this article we will see two of the enhancements namely Disabling Indexes and Including non-key columns (my favorite).
Posted On : September 7, 2004 More... Author : Vinod Kumar
46. ROW_NUMBER in SQL Server 2005
This is yet another cool feature in SQL Server Yukon.It has been in the SQL Server 2000 wish list for quite sometime. But I am excited to see this T-SQL enhancement make it into the SQL Server 2005 version for sure. What is this requirement? It is to generate a pseudo column as the query optimizer sends the output. This generated column can be used for various requirements and used in the UI layer for some identifier purposes. Lets take a sneak preview to this feature.
Posted On : September 5, 2004 More... Author : Vinod Kumar
45. Introduction to SQL Server 2005 - DTS
DTS has come a long way in SQL Server 2005. The architecture of DTS has changed and transformed to the level where all users have to rethink the way DTS works from its previous versions. Nevertheless a more fresh perspective to understand this new version. I would surely consider that DTS has become more mature. And in this article we will take a quick tour to look at how a simple DTS Package can be created and used. Note: Updates made.
Posted On : September 2, 2004 More... Author : Vinod Kumar
44. Understanding PIVOT and UNPIVOT
There are tons and tons of T-SQL features that have been added into SQL Server that any developer would like to capitalize on. In this article we will look at one such feature that has been under the "dream" feature-set which SQL Server lacked when compared to its small brother Access (TRANSFORM Feature). The feature I am talking is PIVOT. With the release of SQL Server 2005 the frustration caused by this missing feature will come to an end.
Posted On : August 27, 2004 More... Author : Vinod Kumar
43. SQL Server 2005 - Schema Definition
Microsoft's focus lately has been in the areas of security. And security limitation and loopholes from the previous versions are getting addressed in the latest versions of software's. And SQL Server 2005 is no exception. In this article let we just focus on the new concept called Schema and the security implications that revolve around the same.
Posted On : August 13, 2004 More... Author : Vinod Kumar
42. Changing XML Schema in SQL Server 2005
XML has become an first class datatype in SQL Server 2005 . You can check my previous articles for an idea of XML features introduced. In this article we will take a look at how we can alter a XML Schema attached to an Typed XML data. XML's can be caegorized into two categories, typed and un-typed. Any XML that conforms to an XML schema is called as typed. And on the contrary plain XML strings are called as un-typed.
Posted On : July 30, 2004 More... Author : Vinod Kumar
41. Exploring XML in Yukon(SQL Server 2005)
XML (eXtensible Markup Language) as a feature have been hyped around SQL Server 2005 in a big way. XML has become one of the modes of communication for heterogeneous systems that want to share data. And this is the fundamental block of applications like Biztalk Server. Even XMLs figure out in applications like Word, InfoPath and is getting popular day by day. And storing, manipulating and retrieving XMLs from the database will be a great feature to have any day moving forward. XML is considered as a first class datatype and has been given the complete power as normal datatypes.
Posted On : July 19, 2004 More... Author : Vinod Kumar (SSWUG)
40. SQL Server 2005-Managed Execution
The next version of SQL Server named SQL Server 2005 is completely hyped with the integration of CLR into SQL Server. The introduction of CLR into SQL Server allows developers to write stored procedures, triggers, user defined functions, user defined aggregates and user defined types using .NET languages like VB.NET and C#. This introduction has opened up multiple avenues for developers and we need to be careful in maximizing the feature provided.
Posted On : June 9, 2004 More... Author : Vinod Kumar
39. Order By Clause - Insiders Perspective
In this article I will walk through some of the aspects in using Order by from a developers stand point. There are tons of pitfals and advantages in optimizing queries. And more often than not we say the query has got Order by hence cannot be optimized much. Here let me walk through some of the techniques you can adopt to optimize and improve performance even whist using Order by clause.
Posted On : May 17, 2004 More... Author : Vinod Kumar
38. SQL Server 2000 Reporting Services - First look
SQL Server RS is an amazing tool and its capabilities are fantastic. The first release itself is full of promise and in this article I will look at some of the key features and salient points of this tool.
Posted On : May 08, 2004 More... Author : Vinod Kumar
37. Understanding Error Handling
This article will outline some of the error-handling pitfalls. This article will also walk you through some of the common mistakes we make while coding in SQL Server 2000. A must know article for most developers.
Posted On : May 08, 2004 More... Author : Vinod Kumar
36. Exploring Yukon T-SQL - Top Option
This article takes a walk through one of the feature introduced in SQL Server Yukon. The article looks at the TOP option enhancements when compared to the previous version of SQL Server 2000.
Posted On : January 27, 2004 More... Author : Vinod Kumar
35. Auto Growth - Insiders perspective
Most DBAs in various organizations are confronted with this simple little feature during their normal database-monitoring carrier. Most often the effects of the same are not realized unless we see the side effects of the same in the production code machines. This article would take you through some of the optimizing and practices that are followed in various parts of the world. In this article we will look at one such feature of Auto-growth option in SQL Server 2000.
Posted On : December 31, 2003 More... Author : Vinod Kumar
34. Introduction to Caching in SQL Server 2000
SQL Server is configured to use a pool of memory of the server and it will allocate the majority of this memory pool to hold both data pages that have been read and the compiled execution plans for all Transact-SQL statements. In versions prior to SQL Server 2000 these were two distinct entities and we could manage the memory allocated to each of them separately. From SQL 2000, these have been merged into one big unit and SQL Server manages the allocation internally. Learn more about how memory management is achieved in SQL Server 2000.
Posted On : November 27, 2003 More... Author : Vinod Kumar
33. DBCC Commands List
This article lists all the DBCC commands available in SQL Server 2000. Most of the commands listed are undocumented and should be used with great care.
Posted On : November 17, 2003 More... Author : Vinod Kumar
32. Next Generation Databases Part II - Yukon
This is the Part II in the series to explore Yukon. Microsoft is going to begin a new era of database programmability with its introduction of SQL Server Yukon. Yukon has lots of features that make it easy to manage and administer. Sure, it's a world-class relational database management system.
Posted On : November 1, 2003 More... Author : Vinod Kumar
31. Understanding SQL Performance Counters
More often than not DBAs land up in debugging and finding out areas of bottleneck. This article list some of the useful Performance counters that can be used and how we can interpret their value in practical scenarios.
Posted On : October 13, 2003 More... Author : Vinod Kumar
30. Undocumented ODBC Syntaxes
In this article we look into undocumented aspect of using SQL Server functions. These are not system functions. But we look into ODBC escape sequences that many of the datasource drivers support. And SQL Server is no exception. Here are some cool un-documented usages of ODBC syntaxes for some of the date, time and datetime manipulation.
Posted On : October 07, 2003 More... Author : Vinod Kumar
29. Next Generation Databases - Yukon
I know that this is one topic that has raised interest in minds of many database designers. The next generation of SQL Server is full of promises. With the release of Yukon we will be able to do amazing things. What I would try to do here is to enlist some of the public information published on the internet.
Posted On : Sep 27, 2003 More... Author : Vinod Kumar
28. Undocumented DBCC Trace Flags in SQL Server 2000
This article lists some of the un-documented DBCC Trace Flags available in SQL Server 2000. Use Trace flags to turn on or off certain behaviour on SQL Server 2000.
Posted On : Sep 27, 2003 More... Author : Vinod Kumar
27. Top 15 Undocumented Stored Procedures
Most often than not we need to debug some of the SQL Server 2000 internals flow. And we often stumble upon some of the undocumented DBCC commands to do this task. In this article we will look at some of the undocumented stored procedures available in SQL Server 2000 and will try to see their use in practical environments. These stored procedures are internal to SQL Server and are used by Client tools like Query Analyzer and Enterprise Manager.
Posted On : Sep 09, 2003 More... Author : Vinod Kumar
26. Understanding UDF in SQL Server 2000
SQL Server in its previous versions did support built-in functions like getdate(), object_id(), object_name() etc. But they did not expose an powerful feature to create one. Hence, this is relatively cool new feature for SQL Server 2000 users. In this article I would walk you through some of the most common usage of UDFs in SQL Server 2000 context.
Posted On : Sep 04, 2003 More... Author : Vinod Kumar
25. Spell Checker in SQL Server
In this article we will concentrate on how we can build our own SQL Server spell checker mechanism. Just pass the word to the stored procedure and it will tell you a success or failure. We will also walk through the technique used and how we figured out the APIs used for this process. This basically uses the COM automation techniques which can be used in SQL Server 2000.
Posted On : Sep 02, 2003 More... Author : Vinod Kumar
24. Understanding SQL Server Triggers
This article gives a summary of various triggers available and their usage. Triggers are an innovative way to process your business applications in SQL Server. They are basically straight-forward, being essentially just Stored Procedures, written in good old Transact-SQL. Here we walk you through the various triggers available and illustrate them with practical examples.
Posted On : August 26, 2003 More... Author : Vinod Kumar
23. Server-Side Profiling in SQL Server 2000
Profiling applications in real-time applications has been one of the requirements of any organization. In the previous article, I discussed how we can build User-Defined counters from SQL Server 2000. This was just a start to debugging our applications and to build stronger systems. In this article we would look at how profiling can be taken to another level using custom profiling.
Posted On : August 19, 2003 More... Author : Vinod Kumar
22. Reading an XLS from SQL Server 2000
In this article we concentrate on how we can read an XLS file from SQL Server using linked Server techniques. We would also look at both persistent and ad-hoc ways of querying the Excel file from SQL Server. This shows us how handy and useful SQL Server is and the power of using some unexplored SQL Server features.
Posted On : August 19, 2003 More... Author : Vinod Kumar
21. Transfer Data to XLS from SQL Server table
This is an preview to working with DTS (SQL Server Data Transformation Services) to transfer data from SQL Server to a XLS file.
Posted On : August 19, 2003 More... Author : Vinod Kumar
20. Loop through T-SQL Result Set
In this article I would concentrate on the various looping mechanisms available using Transact SQL. I do have mentioned the use of Curosrs as evil in my "Server 2000 Best Practices" article. But the very next question asked to me immediately is, then how do I loop through a resultset without using Cursor. Here are some of the alternatives in your disposal.
Posted On : August 19, 2003 More... Author : Vinod Kumar
19. SQL Server 2000 Best Practices
This article lists some of the better practices you can adopt while coding on SQL Server 2000. These can be used as guidelines for effective coding and coding for performance.
Posted On : July 08, 2003 More... Author : Vinod Kumar
18. Knowing SQL Profiler trace template
As a SQL programmers or DBA s many open and work with profiler as an extensive tool. But what we more often ignore is the standard templates that SQL Server provides with Profiler. This is a nice information to understand and use to make useful analysis out of our profiler traces.
Posted On : August 07, 2003 More... Author : Vinod Kumar
17. Locking Basics
Understand what the basics of locking are in SQL Server 2000. What are the mode and the granularity available in SQL Server 2000. In article takes a closer look into the same.
Posted On : August 06, 2003 More... Author : Vinod Kumar
16. Simple Upload of Comma-Separated Values
In this article learn to upload a simple comma separated file using Bulk Insert operation.
Posted On : August 06, 2003 More... Author : Vinod Kumar
15. Understanding UserDefined Counters
The question asked most of the times is that is there a way to audit or keep track of the process flow happening in my system. I ve called an stored procedure and how can I know what is happening behind the scenes. Learn to use User defined performance counters in SQL Server 2000.
Posted On : August 06, 2003 More... Author : Vinod Kumar
14. Using ADO to access SQLXML capabilities
In this article learn to build client applications or business components that retrieve XML data from SQL Server and return the results as XML format using ADO.
Posted On : July 30, 2003 More... Author : Vinod Kumar
13. SQLXML Updategrams
Learn how to use Updategrams in SQLXML. This extended feature allows you to Insert/Update and Delete records from SQL Server 2000. Learn more about this in this simple article.
Posted On : July 24, 2003 More... Author : Vinod Kumar
12. Generating Template using VS .NET
Here we would see how we can generate Templates using VS .NET IDE.
Posted On : July 23, 2003 More... Author : Vinod Kumar
11. Parametrizing in SQLXML using VB .NET
We will take a closer look at how we can parametrize the various methods used to access XML data from SQLXML APIs.
Posted On : July 23, 2003 More... Author : Vinod Kumar
10. Using XML Bulk Upload in SQLXML
Article oulines a simple XML Bulk Upload process using the SQLXML APIs and VB .NET.
Posted On : July 23, 2003 More... Author : Vinod Kumar
9. Generating Simple XSDs using VS .NET
This is an interesting implementation to generate XSD schemas using the VS .NET IDE.
Posted On : July 23, 2003 More... Author : Vinod Kumar
8. Using Simple XSDs
Take a look at how we can use XSDs in conjunction with SQLXML to retrieve data from SQL Server 2000.
Posted On : July 23, 2003 More... Author : Vinod Kumar
7. Managed SQLXML Classes
In this article we would take a sneak preview of how SQLXML Managed classes can be used.
Posted On : July 21, 2003 More... Author : Vinod Kumar
6. Exploring OPENXML
Understand the basic ways in accessing and using OPENXML to turn XML data into relational data.
Posted On : July 19, 2003 More... Author : Vinod Kumar
5. Exploring FORXML Clause
Understand the basics of getting XML from SQL Server 2000.
Posted On : July 18, 2003 More... Author : Vinod Kumar
4. What is Normalization?
Understand the basics of normalization from this article.
Posted On : July 09, 2003 More... Author : Vinod Kumar
3. Using CASE with Orderby Clause
Dynamically ordering a result set based on the evaluation of a CASE expression is a powerful technique for ordering your data.
Posted On : June 23, 2003 More... Author : Vinod Kumar
2. Exposing Stored Procedures as a Web Service
In this paper we would look at how a SQL Stored Procedure can be exposed to the outside world as a Web Service. This has been a dream for long but no more... Follow these simple steps to expose your stored procedures.
Posted On : May 20, 2003 More... Author : Vinod Kumar
1. Avoiding SP Recompiles in SQL Server 2000
To understand the effect of Recompiles on the database. Understanding and analyzing methods to avoid the same during development.
Posted On : April 01, 2003 More... Author : Vinod Kumar

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


The Microsoft India Community Star is a recognition program that strives to identify dedicated individuals within technical communities who share a passion for technology and the spirit of community.
Free Hit Counters
Free Hit Counters 		Copyright © 2000-2003 ExtremeExperts.com, Terms of Use Best viewed on 1024x768 using Microsoft Internet Explorer 5.5 and later. Hosted on Windows Server 2003/.NET Framework 1.1.