SQL Server hides a lot of very useful information in its error log files. Unfortunately, the process of hunting through all these logs, file-by-file, server-by-server, can cause a problem. Rodney Landrum offers a solution which will allow you to pull error log records from multiple servers into a central database, for analysis and reporting with T-SQL.
2010-04-28
2,955 reads
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.
2010-04-28
16,569 reads
In this article, Zach Mattson shows us how you can set up SSIS to handle multiple application environments and easily move packages from development to QA to production.
2010-04-27
9,750 reads
This article brings us an SSIS package that reads an XML file and sequentially displays each XML record in a MessageBox before inserting it into a staging table. You can use this to get XML data into your SQL Server database for further processing.
2010-04-13
10,088 reads
While it does not bring revolutionary changes, the release of SQL Server 2008 delivers functionality, scalability, and performance improvements to SQL Server Integration Services (SSIS). Here is a comprehensive listing of new and enhanced features of SSIS with a short description of each.
2010-04-07
4,355 reads
In this article, learn how to use the SQL Server agent proxy to run an SSIS Package under whatever account you choose.
2010-03-25
57,271 reads
Learning about practical Integration Services is an important part of the well rounded DBA for the future. Read a sample chapter from this new book.
2010-03-23
2,307 reads
Martin Policht delves deeper into the specifics of SQL Server 2008 and 2008 R2's Integration Services by presenting the most straightforward method of creating SSIS packages using Import and Export Wizard.
2010-03-19
4,663 reads
2010-03-04
3,292 reads
The Data Mining Query Task can be used to run prediction queries based on data mining models built in analysis service.
2010-03-04
2,911 reads
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
I spend my days working on and managing SQL Server instances—working days at least,...
Want to learn SQL and get some real practice this December? Check out the...
Hi, is there a way when using excel as a flat file source in...
Bonjour à tous, je vais bientôt démarrer un projet d'archivage de données pour alléger...
Hello, I’ve been trying to install Ms SQL Server 2005 for over two weeks...
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers