Capturing Real-Time Currency Conversions in SSIS
Integration excels at moving and transforming data in real time. Jeff Singleton brings us a great use of SSIS in making currency conversions using a web service.
2010-04-29
9,257 reads
Articles
Configure Windows Firewall for SQL Server 2008 Analysis Services in Windows Server 2008 R2
As I am new to Windows Server 2008 R2 it would be great if you can let me know the step by step approach to enable the default port of SQL Server 2008 Analysis Services in Windows Firewall for user connectivity.
2010-04-29
2,698 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.
2010-04-28
16,622 reads
Consolidating SQL Server Error Logs from Multiple Instances Using SSIS
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
SQL Server Luxembourg User Group Meeting
Our next meeting will be held on Friday 30th April in downtown Luxembourg.
2010-04-27
346 reads
SSIS for Multiple Environments
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,935 reads
SQLCLR function to return free space for all drives on a server
When looking for impending problems due to lack of disk space it's necessary to know how much space is available on each drive. There have been other tips written about how to do this, but in this tip I show you a way this can be done using SQLCLR.
2010-04-27
3,390 reads
Optimising Server-Side Paging - Part I
This article by Paul White presents an optimisation for paging through a wide data set.
2010-04-26
27,834 reads
PASS Virtual Chapters Late April Presentations
To finish up the month of April we’ve got sessions from AppDev and DBA and I’m even including one from PASS on ‘Intro to Speaking At PASS’.
2010-04-26
455 reads
How to Evict a Failed Node and Add it Back to SQL Server 2005 Cluster
Adding and removing nodes in SQL Server Clusters is not so difficult, and instructions on how to do so abound on the internet. However, mismanagement when adding/removing nodes can quickly become a 'gotcha' that wastes time. Bo Chen offers insight into some of those scenarios that are not normally covered in the standard online documents.
2010-04-26
2,048 reads
Blogs
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
A question about how to store the address in the database
I have an app that has an address field on the customer and the...
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers