(Muthusamy Anantha Kumar) SQL Server 2005 is packed with many new features. One of the new features that I would like to discuss in this article is Database Snapshots, which are read only static views of a database. SQL Server 2005 allows you to create multiple snapshots on a database. In this artic

(Arthur Fuller) In a time-tracking database that I worked on recently, the table of interest contained the columns displayed in Listing A. You can make several criticisms of this table design. Most obvious is the use of NULLable columns—this data makes no sense if any of the values are null. (There

(William Pearson) In this lesson, we will expose another popular function in the MDX toolset, the .Name function. The general purpose of the .Name function is, unsurprisingly, to return the name of the object to which it is appended. It can be used with hierarchies, dimensions, levels, and membe

(Ron Talmage) Deadlocks are unavoidable artifacts of today’s RDBMS architecture–and all too common in high-volume OLTP environments. But thanks to .NET’s Common Language Runtime (CLR), SQL Server 2005 provides developers with a new way to deal with error handling. In this month’s column, Ron Talmage

(Jesse Smith) In part 1 of this series, I explained how to use C# scripts to get your web site’s images into your SQL Server database. In this article, I show you how to win the second half of the battle by retrieving images from SQL Server and displaying them in a web page.

(Arthur Fuller) A reader sent me a question recently in which he wanted to know how to display currency amounts in the format we commonly refer to as currency. (I realize how geo-centric this is, so I will attempt to be world-centric in my response to the reader’s question.)

(Serdar Yegulalp) You’ll find a slew of undocumented functions in SQL Server 7.0 and 2000, most of them used by Microsoft to perform internal tasks that might change from version to version of the product. (R)

(Gregory A. Larsen) There are a number of wizards in SQL Server 2000. One of these wizards is known as the index tuning wizard. The index tuning wizard is used for exactly what it sounds like; it is used for tuning indexes. This article will introduce you to the index tuning wizard and will explain

Microsoft SQL Server 2000 may intermittently appear to stop responding (hang) during a scheduled maintenance DBCC DBREINDEX operation. If you are running SQL Server 2000 in a clustered environment, the clustered SQL Server 2000 resource may go offline because the IsAlive functionality determines tha

(Srinivas Sampath) Today we will talk about another such functionality that is enabled by CLR Integration. CLR Integration allows you to consume results from webservice calls. As you might already know, there are three permission buckets in CLR Integration – SAFE, EXTERNAL ACCESS and UNSAFE. Cal