|
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
|
|
|
|
|
|
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
|
|
|
|
|
|
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
|
|
|
|
|
|
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
|
|
|
|
|
|
|
|
|
|
|
|
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
|
|
|
|
|
|
|
|
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
|
|
|
|
|