Learn more about SQL Server tools

   
   



















































SQL Server Business Intelligence Tips and Tricks


Latest SQL Server Tips
Configure the SQL Server Integration Services For Loop Container
How can I configure the For Loop Container in SQL Server Integration Services? What options are available? How do you establish variables? How can you test the process?
What's Trending?
Handle Excel exceeds maximum 65,536 rows in SSRS 2008R2
SQL Server Reporting Services allows you to export data into multiple formats (i.e. Excel, PDF, XML) and you can find all the supported formats here. SSRS 2008R2 supports the .xls file extension for Excel, but these Excel files support a maximum of 65,536 records per sheet. When you try to export a SSRS report which has more than 65,536 records it will fail to export the report into Excel.
SQL Server Tutorials
SQL Server Webcasts
Evolution of SQL Server Self Service Business Intelligence
Learn how Reporting has evolved into Business Intelligence (BI) on the SQL Server platform then determine how your current solution measures up. In this session, we will discuss the self-service BI continuum along with the associated technology options, challenges, opportunities and more. Learn the best practices from the field to overcome some common challenges for getting reporting out to the user community.

Community members w
All Categories

 
Sponsor Information







 

Follow

Get Free SQL Tips

Twitter

LinkedIn

Google+

Facebook

Pinterest

RSS

Learning

DBAs

Developers

BI Professionals

Careers

Q and A

Today's Tip

Resources

Tutorials

Webcasts

Whitepapers

Tools

Search

Tip Categories

Search By TipID

Authors

Community

First Timer?

Pictures

Free T-shirt

Contribute

Events

User Groups

Author of the Year

More Info

Join

About

Copyright

Privacy

Disclaimer

Feedback

Advertise

Copyright (c) 2006-2015 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.