<?xml version="1.0" encoding="UTF-8"?><!-- generator="WordPress/2.9.2" -->
<rss version="0.92">
<channel>
	<title>Ralf Eisenreich</title>
	<link>http://sqlblog.de/blog</link>
	<description>SQLBlog.DE &#124; ..things to remember</description>
	<lastBuildDate>Wed, 03 Mar 2010 08:39:36 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>ETL Best Practices: Data-Flows vs. T-SQL-Statements</title>
		<description><![CDATA[Often ETL design is realized using set-based data processing (SQL-Statements). Especially developers with a database professional background are induced to extract, load and transform (ETL) data using Stored Procedures. On the other side there are advantages of record-based data processing.
The following slides give an overview and recommendation about usage scenarios. There are some tips which [...]]]></description>
		<link>http://sqlblog.de/blog/2010/03/etl-best-practices-%e2%80%93-data-flows-vs-t-sql-statements/</link>
			</item>
	<item>
		<title>T-SQL: IsNumeric function</title>
		<description><![CDATA[The IsNumeric function has a very variable interpretation algorithm. In order to get only numeric values following statement should be used:

CASE WHEN (NUM_VALUE LIKE '%[0-9]%' AND ISNUMERIC(NUM_VALUE) = 1) THEN CAST(NUM_VALUE AS FLOAT) ELSE NULL END AS NUM_VALUE

]]></description>
		<link>http://sqlblog.de/blog/2009/11/t-sql-isnumeric-function/</link>
			</item>
	<item>
		<title>SSRS: Add Excel Export Link to Report</title>
		<description><![CDATA[How to add a Excel Export Link to a Report
Add an item (e.g. TextBox, Image, etc.) and open the properties dialog. Under the navigation tab use the setting Go to URL and add following comand.

=Globals!ReportServerUrl.ToString() + "/Pages/ReportViewer.aspx?"
+ System.Web.HttpUtility.UrlEncode("https://ReportServer/ReportFolder/Report.rdl")
+ "&#038;rs:Command=Render&#038;rs:Format=EXCEL&#038;rc:OmitFormulas=true"
+ "&#038;[Parameter_Name1]=" + Join(Parameters![Parameter_Name1].Value, "&#038;[Parameter_Name1]=") --> Multivalue Parameter
+ "&#038;[Parameter_Name2]=" + System.Web.HttpUtility.UrlEncode(Parameters![Parameter_Name2].Value) --> Normaler Paraemter

It is important to [...]]]></description>
		<link>http://sqlblog.de/blog/2009/10/ssrs-add-excel-export-link-to-report/</link>
			</item>
	<item>
		<title>SSIS: Execute Package via Stored Procedure</title>
		<description><![CDATA[There are two options executing SSIS packages:
- xp_cmdshell command (not recommended for security reasons)
- sp_start_job command
The main difference between both options is the execution method. The xp_cmdshell command is a synchronous call and the sp_start_job command is an asynchronous call.
xp_cmdshell command (synchronous)

enable xp_cmdshell mode in Surface Area Configuration Tool for SQL Server
use following procedure to [...]]]></description>
		<link>http://sqlblog.de/blog/2009/09/ssis-execute-package-via-stored-procedure/</link>
			</item>
	<item>
		<title>W123: Lüftungsgitter ausbauen und wechseln</title>
		<description><![CDATA[Kurzanleitung für Mercedes W123: Lüftungsgitter ausbauen und wechseln

Halteklammern lösen: Dazu die Spreizer in der Mitte mit einem kleinen Schraubendreher durch drücken (siehe Bild 1). Diese fallen dann in den Kasten und müssen nach Abnahme des Gitters eingesammelt werden. Es sind bei beiden Seiten je vier Klammern zu lösen.

linken Scheibenwischer abmontieren: Dazu Kappe am Scheibenwischer hochklappen [...]]]></description>
		<link>http://sqlblog.de/blog/2009/09/w123-luftungsgitter-ausbauen-und-wechseln/</link>
			</item>
	<item>
		<title>SQL Server: Security Check List</title>
		<description><![CDATA[In the following you find a compact catalog of steps which should be considered in a SQL Server environment.
It is a conclusion of information from different sources.
Check List
Installation &#038; Patching

Are only required components installed? Additional components should be installed when required.
As Service Account a Local or Domain Account should be rather used than a System [...]]]></description>
		<link>http://sqlblog.de/blog/2009/08/sql-server-security-check-list/</link>
			</item>
	<item>
		<title>Wireshark: successor application of Ethereal</title>
		<description><![CDATA[Wireshark is the successor application of Ethereal. Wireshark is a free (GNU General Public License) network traffic analyser (packet sniffer).
This tool is very useful to test encrypted connections of own applications or to analyse active connections and data flows on the own desktop.
Here is an application screenshot:
The application layout consists of 3 parts (windows) &#8211; [...]]]></description>
		<link>http://sqlblog.de/blog/2009/07/wireshark-successor-application-of-ethereal/</link>
			</item>
	<item>
		<title>Linked SQL Server: Encrypted Connection</title>
		<description><![CDATA[Linked SQL Server (applies to SQL Server 2005 / SQL Server 2008 / later)
It can happen that an application may need data stored in second database which is not located on the same instance of SQL Server. That instance could be on the same physical machine or it could be on another machine. There are [...]]]></description>
		<link>http://sqlblog.de/blog/2009/07/linked-sql-server-encrypted-connection/</link>
			</item>
	<item>
		<title>virtuelle Weinproben: aromicon</title>
		<description><![CDATA[Manchmal ist es schwierig, jemanden den Geschmack von Wein zu beschreiben. Eine coole Suchmaschine Weinsuchmaschine hilft dabei: aromicon.

aromicon ist eine Geschmackssuchmaschine für Wein. Sie können Weine nach den Suchkriterien Wunscharomen, passende Speisen, Süße, Rebsorte, Tannine und Region anzeigen lassen. Die Suche erfolgt in tausenden von Weinen aus zahlreichen Onlineshops.

[Quelle: http://www.aromicon.com]
]]></description>
		<link>http://sqlblog.de/blog/2009/07/virtuelle-weinproben-aromicon/</link>
			</item>
	<item>
		<title>SSIS: SQL Server Agent Job (run packages)</title>
		<description><![CDATA[If you experience following error &#8220;Executed as user: MyDomain\SQLServer. The package execution failed. The step failed.&#8221;
then check that your Service User for the SQL Server Agent has full file permissions to all packages, config files and log files!
Moreover this service user should be member of the SQL Server DTS Group.
]]></description>
		<link>http://sqlblog.de/blog/2009/07/ssis-sql-server-agent-job-run-packages/</link>
			</item>
	<item>
		<title>SSIS: Import localized Date columns under different regional settings</title>
		<description><![CDATA[Importing Date values e.g. from Flat Files it can happen that the format of the date is different to the Host System date formatting of the regional settings. Especial the date setting for English (UK: day/month/year) and English (US: month/day/year) are often very problematic.
In SSIS a solution for this issue can be realized with a [...]]]></description>
		<link>http://sqlblog.de/blog/2009/07/ssis-import-localized-date-columns-under-different-regional-settings/</link>
			</item>
	<item>
		<title>Amazon Top 10 Bestsellerliste nach Michael Jacksons Ableben</title>
		<description><![CDATA[Traurig aber wahr: Michael Jackson ist verblasst.
Seine Musik begleitet uns aber weiter und momentan spiegelt sich dies stark in den Verkauscharts  (z.B. bei Amazon) wieder.
[Quelle: Amazon.de]
]]></description>
		<link>http://sqlblog.de/blog/2009/06/amazon-top-10-bestsellerliste-nach-michael-jacksons-ableben/</link>
			</item>
	<item>
		<title>SSIS: Split Excel cell values into rows</title>
		<description><![CDATA[Here I would like to show you a solution for following problem.
One source row coming from Excel contains several values within one column. Each one of these values should be reflected in a separate row in the data destination.
So the basic problem is that there we have a &#8220;list column&#8221; whose contents should be result [...]]]></description>
		<link>http://sqlblog.de/blog/2009/04/ssis-split-excel-cell-values-into-rows/</link>
			</item>
	<item>
		<title>T-SQL: Split column in several rows</title>
		<description><![CDATA[problem
If I have a column with several values (separated by CR) which I need separated into rows then following solution can help:
possible solution: T-SQL
One possible solution using T-SQL is following statement.
The function fn_Split returns all values in a list and the replace function converts the CR (carriage returns) to commas.

SELECT
[Key]
,[b.Value]
,[c.Value]
FROM
[dbo.TableExcel] AS a
CROSS APPLY
fn_Split(REPLACE(a.Persons, CHAR(10)+CHAR(13),','), ',') [...]]]></description>
		<link>http://sqlblog.de/blog/2009/04/t-sql-split-column-in-several-rows/</link>
			</item>
	<item>
		<title>SSIS: Excel Import Column Data Types</title>
		<description><![CDATA[When Excel data is not coming into SSIS right, then do the following:

use option &#8220;IMEX=1&#8221; in ConnectionString (Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\..\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1")
modify registry setting &#8220;TypeGuessRows=8&#8221; to a much higher value
use a sql statement to retrieve data (e.g. &#8220;SELECT * FROM [sheet1$A5:M2000]&#8220;)

NOTE: The setting IMEX=1 tells the Excel driver to use Import mode. This mode reads the [...]]]></description>
		<link>http://sqlblog.de/blog/2009/04/ssis-excel-import-column-data-types/</link>
			</item>
</channel>
</rss>
