The IsNumeric function has a very variable interpretation algorithm. In order to get only numeric values following statement should be…
October 28th, 2009
SSRS: Add Excel Export Link to Report
No Comments, SQL Server, by Ralf.How to add a Excel Export Link to a Report Add an item (e.g. TextBox, Image, etc.) and open the…
September 30th, 2009
SSIS: Execute Package via Stored Procedure
1 Comment, IT, SQL Server, by Ralf.There are two options executing SSIS packages: – xp_cmdshell command (not recommended for security reasons) – sp_start_job command The main…
August 26th, 2009
SQL Server: Security Check List
No Comments, SQL Server, by Ralf.In the following you find a compact catalog of steps which should be considered in a SQL Server environment. It…
July 22nd, 2009
Linked SQL Server: Encrypted Connection
4 Comments, SQL Server, by Ralf.Linked SQL Server (applies to SQL Server 2005 / SQL Server 2008 / later) It can happen that an application…
July 7th, 2009
SSIS: SQL Server Agent Job (run packages)
No Comments, SQL Server, by Ralf.If you experience following error “Executed as user: MyDomain\SQLServer. The package execution failed. The step failed.” then check that your…
July 3rd, 2009
SSIS: Import localized Date columns under different regional settings
No Comments, SQL Server, Uncategorized, by Ralf.Importing Date values e.g. from Flat Files it can happen that the format of the date is different to the…
April 17th, 2009
SSIS: Split Excel cell values into rows
6 Comments, .Net, SQL Server, Uncategorized, by Ralf.Here I would like to show you a solution for following problem. One source row coming from Excel contains several…
April 17th, 2009
T-SQL: Split column in several rows
No Comments, .Net, SQL Server, by Ralf.problem If I have a column with several values (separated by CR) which I need separated into rows then following…
April 16th, 2009
SSIS: Excel Import Column Data Types
2 Comments, .Net, OpenSource, PHP, SQL Server, by Ralf.When Excel data is not coming into SSIS right, then do the following: use option “IMEX=1” in ConnectionString (Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\..\MyExcel.xls;Extended…
March 24th, 2009
SQL Server: Version, Service Pack, Edition
1 Comment, SQL Server, Uncategorized, by Ralf.SQL Server: Version, Service Pack, Edition Just run following command within Management Studio: SELECT @@VERSION, SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)…
December 8th, 2008
SSRS: Disable Reporting Services Cache in Preview Mode
4 Comments, .Net, SQL Server, Uncategorized, by Ralf.How to disable caching in SQL Server Reporting Services for Visual Studio in Preview Mode? SQL Server 2005 Service Pack…
August 27th, 2008
ReportViewer: Pass Parameters to Remote Report
No Comments, .Net, ASP.Net, SQL Server, by Ralf.How to pass parameters to ReportViewer Control displaying a remote report (SSRS): ReportParameter[] parameters = new ReportParameter[2]; protected void Page_Load(object…
May 8th, 2008
T-SQL: Dynamic Pivot
2 Comments, PHP, SQL Server, by Ralf.Here is an example using dynamic Pivot: The Pivot columns (country short names) are dynamically generated from a query. Single…
March 25th, 2008
Uninstall Embedded SQL Server Instance
1 Comment, SQL Server, Windows, by Ralf.Folgender Tipp hilft, um die versteckte Instance Microsoft##SSEE von den WSS 3.0 zu entfernen: To uninstall SSEE: Start Registry Editor,…
November 26th, 2007
SQL Server 2008
1 Comment, SQL Server, by Ralf.Die aktuelle CTP gibts hier: https://connect.microsoft.com/programdetails.aspx?ProgramDetailsID=1384
March 1st, 2007
Reports mit ASP.NET und SQL Server 2005: One or more rows contain values violating non-null, unique, or foreign-key constraints
No Comments, ASP.Net, SQL Server, by Ralf.Der Fehler “An error has occurred during report processing. Exception has been thrown by the target of an invocation. Failed…
February 20th, 2007
SQL Server 2005: SP2 & Feature Pack
16 Comments, .Net, SQL Server, by Ralf.Nun gibt mittlerweile schon das zweite Service Pack für den SQL Server 2005. Vor allem die Anbindung von Office 2007…
July 26th, 2006
SSAS: connection problem
No Comments, .Net, by Ralf.In Foren habe ich jetzt oft ueber dieses Problem gelesen, dass bei der Herstellung einer Verbindung zu den MS SQL…
April 9th, 2006
SQL Server: Integration Services
No Comments, .Net, IT, VBA, by Ralf.Die SQL Server Integration Services erlauben das Zusammenfuehren von Daten aus heterogenen Datenquellen. Um den Ueberblick zu behalten wird der…