Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Excel Rss

Search for any content tagged excel

<< Newer    Items 21 to 40 of 61    Older >>
 

CPU and Scheduler Performance Monitoring using SQL Server and Excel

This article will demonstrate a method of creating an Excel-based CPU/scheduler performance dashboard for SQL Server 2005+.  Read more...
By Derek Colley 2012/10/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,171 reads

Set Up Grouping Intervals for Excel (SQL Spackle)

So you want to group your data for charting in Excel? Here's how, the easy way!  Read more...
By Dwain Camps 2012/07/31 | Source: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 5,214 reads

How to Name Sheets in Exported Excel Workbooks with SSRS 2008 R2

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...
By Stan Kulp 2011/08/22 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 5,576 reads

XLSExport: A CLR procedure to export proc results to Excel

A CLR procedure utilizing the NPOI library to export the results of a passed stored procedure to an Excel spreadsheet.  Read more...
By Bret Lowery 2011/06/23 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 8,735 reads

Excel in the Clouds

Today Steve Jones talks about a new use for cloud computing with Excel to analyze large sets of data.  Read more...
By Steve Jones 2011/06/21 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 147 reads

SQL Server Data Mining with Microsoft Office Excel

This article demonstrates using SQL Server's data mining capabilities with the Excel.  Read more...
By Additional Articles 2011/02/11 | Source: SQL Server Performance | Category: excel
Rating:  Rate this |   Briefcase | 5,266 reads

Protect the Excel files generated by SSIS package-Part I

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...
Rating: |  Discuss |   Briefcase | 5,760 reads

Add Some Spark to Your OData: Creating and Consuming Data Services with Visual Studio and Excel 2010

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...
By Additional Articles 2010/10/20 | Source: CODE Magazine | Category: odata
Rating: (not yet rated)  Rate this |   Briefcase | 1,616 reads

Excel with Stored Procedures

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...
By David Poole 2010/08/13 (first published: 2008/08/13) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 58,936 reads

SQL Server 2008,Windows 2008 x64 and Excel

Learn about how you might solve some issues running SSIS packages using Excel on a Windows 2008 x64 Machine.  Read more...
Rating: |  Discuss |   Briefcase | 7,091 reads

How to Read Excel Cells from SQL Server Integration Services

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...
Rating: |  Discuss |   Briefcase | 13,728 reads

How to find unused Stored Procedures in SQL Server 2005/2008

Use dynamic PivotTables to identify unused Stored Procedures in a SQL Server 2005/2008 database  Read more...
By Ronny Dahl 2010/04/15 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 26,297 reads

Automating Excel from SQL Server

How to have SQL Server drive Excel spreadsheets  Read more...
By Wayne Sheffield 2010/02/19 (first published: 2008/12/05) | Source: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 35,010 reads

Import Excel Spreadsheet to Database Tables

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...
By Peter He 2010/02/17 | Source: SQLServerCentral.com | Category: etl
Rating: |  Discuss |   Briefcase | 17,565 reads

Use SSIS to import one cell of an Excel file into SQL Server

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...
Rating:  Rate this |   Briefcase | 3,846 reads

Self-Service BI with PowerPivot for Excel 2010

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...
By Thiago Zavaschi 2010/01/22 | Source: SQLServerCentral.com | Category: business intelligence
Rating: |  Discuss |   Briefcase | 4,408 reads

Exporting to Excel Using a CLR Stored Procedure

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...
By Anders Pedersen 2009/12/02 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 18,286 reads

Database defintion from an Excel Spec?

Have you ever been required to create a database with nothing but a specification in Excel?  Read more...
By Ian Hadlington 2009/11/12 | Source: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 7,303 reads

How to Dynamically and Iteratively Populate An Excel Workbook from SQL Server

Integration Services is a great ETL tool, allowing you to build complex and dynamic transformations. New author Marie Deschene brings us a  Read more...
By M. Deschene 2009/10/16 (first published: 2008/01/09) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 53,567 reads

Excel with Stored Procedures

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...
By David Poole 2010/08/13 (first published: 2008/08/13) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 58,936 reads
<< Newer    Items 21 to 40 of 61    Older >>