A new feature of SSRS 2008 R2 is the ability to name sheets in exported Excel workbooks. This article explains how to utilize this feature.  Read more...

A CLR procedure utilizing the NPOI library to export the results of a passed stored procedure to an Excel spreadsheet.  Read more...

Today Steve Jones talks about a new use for cloud computing with Excel to analyze large sets of data.  Read more...

Excel files includes a very good functionality called Macro execution. And here we can use this functionality to write one macro that will generate INSERT statements.  Read more...

Using opendatasource to retrieve data from Excel files as if querying a table.  Read more...

This article demonstrates using SQL Server's data mining capabilities with the Excel.  Read more...

It is not only the data within the database that requires protection but any report generated using SQL Server needs to be protected before being mailed  Read more...

The Open Data Protocol (OData) is an open REST-ful protocol for exposing and consuming data on the web. Also known as Astoria, ADO.NET Data Services, now officially called WCF Data Services in the .NET Framework. There are also SDKs available for other platforms like JavaScript and PHP.  Read more...

Longtime DBA David Poole brings us an interesting situation in involving setting up a user to allow Excel to query data from SQL Server.  Read more...

Learn about how you might solve some issues running SSIS packages using Excel on a Windows 2008 x64 Machine.  Read more...

We can get data in all sorts of formats in the real world. In this new article from Dinesh Asanka, learn how to use scripting to import data from individual Excel cells.  Read more...

Use dynamic PivotTables to identify unused Stored Procedures in a SQL Server 2005/2008 database  Read more...

How to have SQL Server drive Excel spreadsheets  Read more...

Importing Excel Spreadsheets is something that we often do with SQL Server. However it's not as easy as you would like as we move to the 64 bit platform. Peter He brings us a method that will work on all platforms.  Read more...

Recently I needed to find a method to import one cell of an Excel sheet into SQL Server 2005 using a scheduled job on a 64 bit clustered environment. For example, I have a monthly sales report listing sales per product category, such as Books, Magazines, DVDs, etc. I only want to import the Total Sales amount into SQL Server and this number is located in an Excel file "sales.xls.sheet1.cell.B5". I used to use OPENROWSET to solve the problem, however OPENROWSET requires Microsoft Jet OLE DB Provider which is not available in 64 bit. In this tip I am going to talk about how to use SSIS to accomplish this task easily.  Read more...

Thiago kicks off a new series of articles, taking us through everything we need to know to use PowerPivot effectively. First off, he walks us through the prerequisites, and getting started with our first basic data set.  Read more...

The inclusion of the CLR in SQL Server has been controversial, but some people have come up with great ways to take advantage of this feature. New author Anders Pedersen brings us a technique to export data from SQL Server into Excel using the CLR.  Read more...

Have you ever been required to create a database with nothing but a specification in Excel?  Read more...

Integration Services is a great ETL tool, allowing you to build complex and dynamic transformations. New author Marie Deschene brings us a  Read more...

Longtime DBA David Poole brings us an interesting situation in involving setting up a user to allow Excel to query data from SQL Server.  Read more...