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...

I want to show you another easier way to pull information to help predict database growth again using the Data Mining Tools.  Read more...

An article from new author Lokesh Gunjugnur that shows how you can set up tracking for database growth on multiple servers and creating custom reports in Excel.  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...

This SQL School video explains how to use the Data Mining add-in for Excel 2007. The installation and configuration are covered.  Read more...

In this video MVP Brian Knight continues on with more advanced data mining using Excel.  Read more...

Excel has greatly helped ease the process of data mining. In this video MVP Brian Knight shows how you can start using the data mining add-ins for Excel to get started.  Read more...

How can we determine the sheet names in our SSIS package and process this variable number of sheets?  Read more...

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

Using Excel as a tool for data mining and predictions is very powerful. Learn how to take advantage of SSAS in SQL Server 2005 with Microsoft Office Excel 2007.  Read more...

Comparing data from two queries to see if they return the same results can be an interesting challenge. David Ziffer brings us a great way to do this using Excel.  Read more...

This article focuses upon Column charts, and extends the examination of Reporting Services charts for Analysis Services data sources that we began in Introducing Reporting Services Charts for Analysis Services.  Read more...

There is value in using the extended properties across some of the industry leading data modeling tools. What if I do not have access to any of those tools? Is it possible to build the extended properties and then be able to generate reports by using Excel or Reporting Services?  Read more...

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

Troubleshoot SQL Server Reporting Services (SSRS) issues such as configuration, report designs and importing and exporting report data using Excel.  Read more...

Calculate the Running Total for the last five Transactions on an Iterative basis  Read more...

Exporting data from your database and building reports is easy with Reporting Services, but sometimes you need to use other sources  Read more...

Longtime author Dinesh Asanka brings us a short tutorial on importing your data from Excel 2007 into a database using Integration Services.  Read more...

How to have SQL Server drive Excel spreadsheets  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...

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