(Mike Pearson) When word of SQL Server Reporting Services (SQLRS) first got out – it caused a huge amount of ‘movement’ in the reporting industry. I have seen reactions to it that range from borderline hysterical to “ho-hum version 1 stuff”. So just how good is it really, and once all the marketing

There are two ways to add an unpublished article to an existing snapshot, to a transactional publication, or to merge publication. You can either use SQL Server Enterprise Manager to add an unpublished article, or you can use the replication system stored procedures that are provided with SQL Server

(Ron Paddock) The next version of SQL Server (code name Yukon) has extensive support for the Common Language Runtime (CLR). Previous versions of SQL Server (2000 and earlier) had a mechanism for creating custom data types. These data types were nothing more than aliases to system data types. In Y

(William E. Pearson III) This is the second article of the series, Optimizing Microsoft SQL Server Analysis Services. The primary focus of this series is the introduction of optimization tools and concepts for Microsoft SQL Server Analysis Services (“MSAS”). The series is designed to provide hands-o

(Ameet Phadnis) Most programmers might have faced the problem about displaying data in Tree View. There are different ways to solve this problem. The best way depends on your environment. As my previous articles I will first explain different approaches and then give you the solution I normally use.

(Michael Otey) All relational databases—including SQL Server, Oracle, IBM DB2, and MySQL—are susceptible to SQL-injection attacks. You can buy products that protect your system from SQL injection, but for most businesses, the defense against SQL-injection attack must be code-based. The opening for S

(Dennis W. Forbes) A commonly modeled database design is the ubiquitous hierarchy: A relationship of items, all but the root having a single “parent”, with each having zero or more child nodes. Such a structure is often referred to as an “inverted tree” due to its visualized similarity to, not surpr

In Microsoft SQL Server 2000, you may not be able to create full-text catalogs. Additionally, when you try to start the Microsoft Search service (Full-Text Service), you may receive an error message. If these problems occur, you must manually reinstall the Microsoft Search service. This article desc

(Sanders Kaufman, Jr.) Database developers who use Microsoft products have often experienced frustration at the disparity of functions between Access and SQL Server. SQL Server, which uses Transact-SQL (T-SQL), is a step behind Access in its range of features, although it is several steps ahead in t

(William Pearson) In this lesson, we will extend our attention from the purely set-related functions upon which we have concentrated in the last several articles; we will focus on a numerical function, Count(), specifically as it is applied to sets. We will discuss the straightforward purpose of the