In this presentation, you'll see how you can use Excel 2007 to view data and create quick reports against data in Analysis Services. Then, you'll see how to conditionally format the data and apply rules to the data.
2006-11-08
2,621 reads
SQL Server 2005 replication agents are configured optimally out of the box, but occasionally you might need to alter the default behavior by tweaking the agent's parameters. SQL Server 2005 exposes some parameters through graphical interface that were available only from command line or through agent job steps in previous releases. Baya Pavliashvili encourages you to learn the new options available with each replication agent and how to fine-tune these options for your applications.
2006-11-07
2,281 reads
Working with a new piece of technology can be intimidating. Not having the technology installed correctly can only lead to more difficultly. This guide outlines steps to properly install SQL Server 2005 Reporting Services and the current service pack to get you going in the right direction.
2006-11-06
3,793 reads
You may find this shocking, but some IT people lie on their CV. Richard Morris offers a rare glimpse into the dark underworld of the people tasked with rooting out the CV fraudsters.
2006-11-03
3,591 reads
Most of us don't get to make hiring decisions, whether we're interviewing or helping to interview someone. However we often have input on new employees. Steve Jones brings us some thoughts on helping to make the hiring decision.
2006-11-02
6,332 reads
If you create functions or stored procedures from SQL Server 2005 Management Studio, you will notice that the new window is filled with a template. In general, you get a skeleton interspersed with markers. This article discusses how you can use templates.
2006-11-02
2,522 reads
A new product from SoftArtisans makes it easy for Reporting Services users to work in their familiar Word and Excel environments. Longtime author Jonathan Spink brings us a review of this software.
2006-11-01
4,460 reads
With the release of SQL Server 2005, the paradigm of working with this database changed. Robert Pearl brings us a book review of the highly acclaimed book from one of the premier SQL Server consulting companies in the US: Scalability Experts.
2006-11-01
4,288 reads
Analysis Services and business intelligence are new structures for most of the SQL Server world. BI expert Yaniv Mor brings us another article on Analysis Services, this time explaining the various different options for storing your cube data.
2006-10-31
7,325 reads
DW/BI professionals are often tasked with making evolutionary upgrades and improvements to minimize cost and upheaval in the current analytic environment. We explore four upgrades that can breathe new life into legacy data warehouses.
2006-10-31
2,682 reads
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Comments posted to this topic are about the item Hyperscale Replicas I
Comments posted to this topic are about the item The End of Summer
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers