December 2007
If you want to be able to see the complexity and size of queries, consider implementing estimated execution plans in your organization.
SQL Server Magazine
December 2007
Estimated execution plans are very useful when trying to see how complex and large a query is. However, these plans aren't always generated. Find out why estimated execution plans aren't generated in certain situations.
SQL Server Magazine
May 2007
Data Mining Add-ins for Office 2007 help you develop business intelligence by using the power of SQL Server 2005 and Microsoft Office Excel 2007 to analyze your organization's data.
SQL Server Magazine
April 2007
Microsoft Excel 2007 PivotTables give you more ways than ever to analyze and present data from SQL Server Analysis Services 2005 OLAP cubes.
SQL Server Magazine
November 20, 2006
How can you use SQL Server 2005 Reporting Services to deploy reports when Windows Authentication isn’t available—and without the risk of one partner seeing another’s data? Here’s how to set up custom authentication and filtering for Web-based reporting.
SQL Server Magazine
December 2006
Are you wondering about alternatives for providing reports in a non-Windows–authenticated environment? One effective approach is the use of the Report Server Web service. Here are the pros and cons of this solution.
SQL Server Magazine
June 2006
Check out Report Builder, a new and easy-to-learn ad hoc reporting tool in SQL Server 2005 Reporting Services.
SQL Server Magazine
June 2006
Learn different ways to build a report model.
SQL Server Magazine
April 20, 2006
The Visual Studio 2005 report wizards are great for creating simple reports. But read on if you want to learn more about refining your report model.
SQL Server Magazine
March 2006
Add compression capabilities to SQL Server 2005 by leveraging the Common Language Runtime (CLR) and taking advantage of the new varbinary(max) data type.
SQL Server Magazine
March 2006
If you're embarking on a solution for compressing data, you'll find this compression overview helpful.
SQL Server Magazine
January 13, 2006
SQL Server Projects restrict the custom .NET assemblies you can reference.
SQL Server Magazine
November 2005
SQL Server 2005 Express Edition and SQL Server 2005 Workgroup Edition provide many SQL Server 2005 features and are geared toward the needs of developers and smaller organizations.
SQL Server Magazine
Add these Headlines to your Website
