(Tom O’Neill) Learn the basics of writing SQL Server stored procedures. (R)

By Lisa Vaas – Both Oracle Corp. and Microsoft Corp. have discovered new vulnerabilities in their databases, the two companies reported.

By Alexander Chigrik – 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. Fr

This article describes how to pass a variable to a linked server query. When you query a linked server, you frequently perform a pass-through query that uses the OPENQUERY, OPENROWSET, or OPENDATASOURCE statement.

This example from Transact-SQL Language Reference Guide will show you how list the subdirectories and their subdirectories for a given path.

Join best-selling Microsoft Press author Rick Dobson for his annual development seminar where you will get in-depth coverage with one day of training and hand-on labs on each technology.

By Brian Moran – Developing a complex business intelligence and data-warehousing solution isn’t easy, but if you’re dying to dabble with BI and don’t know where to start, you might want to investigate SQL Server Accelerator for BI.

By Mark Joseph Edwards – Microsoft released three security bulletins regarding three problems in Windows platforms, one of which Microsoft considers critical; the other two are considered important. The remote procedure call (RPC) interface contains an unchecked buffer that could let intruder

by Roman Rehak – One of the more useful newer features SQL Server 2000 offers is the ability to create user-defined functions (UDFs). A SQL Server UDF encapsulates a piece of SQL code and makes it easy to reuse in other database objects. I’ll provide you with guidelines and recommendations for using

by Brad M. McGehee – 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