SQL Server – Page 2 – Knowledgebase

Implement conditional (IF THEN ELSE) logic based on a SQL Server Store Procedure result in SSIS 2012

4 September, 2013 Roel van Lisdonk 0 Comments 1 category

There are many ways you could implement conditional (IF THEN ELSE) logic based on a SQL Server Store Procedure result in SSIS, here is just one way: Note For demo purpose I will be

Generate SQL insert statements from Excel / Csv file online

27 June, 2013 Roel van Lisdonk 0 Comments 1 category

Lets say you get a Microsoft Excel file containing the following information: If you want to import these record in a SQL table, just save the excel file as CSV. Then upload it to

How to solve: Unable to open Transact-SQL file in custom editor in Microsoft Visual Studio 2012

13 June, 2013 Roel van Lisdonk 0 Comments 1 category

In my case the error "Unable to open Transact-SQL file in custom editor", was caused by the fact, that I installed BIDS voor Microsoft Visual Studio 2012, but not the SSDT tools. After installing the

Going from 15.000 requests p/s to 250.000 requests p/s with Microsoft SQL Server–Hekaton

4 June, 2013 Roel van Lisdonk 0 Comments 1 category

Microsoft SQL Server up until version 2012, is build on the presumption that the data will be stored on hard disks and the price of this storage is high not even considering the price of

Manually create the SQL Server tables used by de SimpleMembershipProvider

15 April, 2013 Roel van Lisdonk 0 Comments 1 category

Below you will find the t-sql code needed to generate de SQL Server SimpleMembershipProvider tables. set ansi_nulls on go set quoted_identifier on go if object_id('dbo.webpages_Membership') is null begin create table dbo.webpages_Membership (

Installing SSIS support in Microsoft Visual Studio 2012

9 April, 2013 Roel van Lisdonk 0 Comments 1 category

As of 5-mrt-2013, Microsoft Visual Studio 2012 supports SSIS projects by installing Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2012 You can download Microsoft SQL Server Data Tools – Business

Drop all stored procedures not belonging to the dbo schema from a SQL Server database

5 April, 2013 Roel van Lisdonk 0 Comments 1 category

if you want to drop all stored procedures not belonging to the dbo schema from a SQL Server database, you van use the following select statement to generate a list that can be executed to

Fix: Arithmetic overflow error converting IDENTITY to data type int

2 April, 2013 Roel van Lisdonk 0 Comments 1 category

I was getting the error: "Arithmetic overflow error converting IDENTITY to data type int", when inserting a record in a table with a identity column. The max id of this table was 45448, this is

Notes on SqlDependency and QueryNotification in Microsoft SQL Server 2012

1 February, 2013 Roel van Lisdonk 5 Comments 1 category

When you want to start using SqlDependency for QueryNotification in Microsoft SQL Server 2012, there are some steps you need to take, to make this work. In development In development you should take the

Fixing SqlDependency Query Notification subscription failure: info="set options" database_id="0" in SQL Server 2012

31 January, 2013 Roel van Lisdonk 0 Comments 1 category

Registering a query for Query Notification requires the database connection on which the subscription is made to have the correct SET OPTIONS enabled: ANSI_NULLS ON ANSI_PADDING ON ANSI_WARNINGS ON CONCAT_NULL_YIELDS_NULL ON QUOTED_IDENTIFIER ON NUMERIC_ROUNDABORT OFF

Tag: SQL Server