This article describes how to plot data on a chart as a bar graph that has a trend line by using Report Designer. You must have two sets of data to plot a bar graph that has a trend line. This article discusses two methods to plot data based on the complexity of the query that is used to retrieve […]

(Steve Jones) All programmers test their code, right? Everyone I know writes code that works and the only bugs that we find are due to differences in interpretations in the business rules. By the time code is complete from the developer, it is ready for prime time. Ready for the real world, ready fo

This series of papers provides dozens of identity and access management concepts, techniques, and solutions for use in heterogeneous IT environments. Identity and access management combines processes, technologies, and policies to manage digital identities and specify how they are used to access

(Nigel Rivett) Whenever a data update is made entries are added to the transaction log. It is not possible to prevent this as it is part of the way sql server maintains integrity – particularly during recovery. The transaction log is a circular file i.e. when the end is reached any free entries

Microsoft Windows XP Service Pack 2 (SP2) includes Windows Firewall. Windows Firewall is an enhanced version of Internet Connection Firewall (ICF). By default, Windows Firewall is enabled on computers that are running Windows XP Service Pack 2. Windows Firewall will block some network connections th

(Brian Moran) My company wants to charge application owners usage fees based on consumption of database resources, such as memory, CPU, I/O, the number of queries executed, and so on. Several third-party tools have this capability, but their data is based on sampling. We have many applications t

(William Pearson) In this article, we will introduce the details of another option within the Managing phase of the reporting lifecycle, the Data-Driven Subscription. To examine the steps involved in creating a Data-Driven Subscription effectively, we will need to create an environment that will sup

When you try to deny access to a dimension member by defining a custom rule in a cube role in Microsoft SQL Server 2000 Analysis Services, you may receive an error message that is similar to the following: Dimension security syntax error: Set name xxxxx.xx is not valid. Do you still want to use

(Brian Kelley) With the recent slate of “virus” attacks plaguing us, a question that has come up fairly often is how to handle anti-virus programs running on the same system as SQL Server. If you tried to do an Internet search on SQL Server and anti-virus best practices you’ve probably been left

(William Pearson) In this article, we will explore a second approach to the creation of a local cube. While we will rely again upon the PivotTable report as our design and development tool, this time we will focus more on the use of Microsoft Query (“MS Query”), and begin with a relational database