Free SQLUG Event: SCOM 2007 R2 And Managing SQL Server

by Valentino Vranken 6 May 2010 19:38

No excuses for not attending if you’re a SQL Server DBA, system administrator or just interested in the subject. It’s a free training event, it’s presented by Ricardo Noulez and it’s taking place in the Microsoft offices in Zaventem. When? Thursday, April 20th, 2010 Where? Microsoft België Corporate Village Leonardo Da Vincilaan 3 1935 Zaventem More info Managing SQL Server requires insight in the [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: events, community event, data, sqlug

A Developer's Blog

Importing Data Using The Wizard: Mixing The Wrong Ingredients

by Valentino Vranken 3 May 2010 20:39

A while ago I wrote an article about how you can use the SQL Server Import and Export wizard to import Excel data into a SQL Server database. In this sequel I’m going to show you some problems which you may encounter when using that wizard. Just like any good old wizard, he’s only as [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: integration services, sql server, data, excel, ssis

A Developer's Blog

Importing Excel Data Using Integration Services

by Valentino Vranken 20 April 2010 21:21

In a previous article I’ve shown you how to import data from an Excel sheet using the OPENROWSET() function. And I concluded by stating that it’s not the best option when automating your data import. Today I’ll repeat the Excel data import process by using SQL Server Integration Services, also known as SSIS. I’ll be using SQL [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: integration services, data, excel, ssis, tutorial

A Developer's Blog

Retrieving Data From Excel

by Valentino Vranken 29 March 2010 20:16

The purpose of this article is to demonstrate how to retrieve data from an Excel sheet and put it in a table in a SQL Server database. Introduction Anyone who’s ever used a computer for a significant amount of time has probably come into contact with Excel, the spreadsheet application part of the Microsoft Office suite. Its [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: sql server, data, excel, t-sql

A Developer's Blog

SSMS: Color The Status Bar

by Valentino Vranken 23 March 2010 21:35

One is never too old to learn, right? Here’s a Management Studio feature which has been introduced in SQL Server 2008. And I’ve discovered it about a month ago. Since then, I use it very day! What am I talking about? Well, the Management Studio allows you to link a color to a connection. Each time [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: management studio, data, sql server 2008, ssms

A Developer's Blog

Save up to 35% for the PASS European Conference

by Valentino Vranken 6 March 2010 15:34

As I have recently become a core-member of the Belgian SQLUG, you’re probably going to see a bit more spread-the-word posts about interesting events or other advantages, such as this one. The Belgian SQL Server User Group offers a significant 35% discount for its members (even more than the early-bird discount) for any PASS European Conference [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: events, community event, sql server 2008 r2, sqlug

A Developer's Blog

Recursively Delete SSIS Folder

by Valentino Vranken 28 February 2010 22:12

A while ago I posted a query to create a list of all the Integration Services packages deployed to the MSDB. I am now using that query to take it a step further. If you’ve been using SSIS for a while you’ve probably noticed that the Management Studio doesn’t like to delete Integration Services folders that [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: integration services, t-sql, data, script, ssis

A Developer's Blog

Drawing In SQL Server 2008

by Valentino Vranken 26 February 2010 21:18

A while ago I had been playing a bit with the new spatial data types in SQL Server 2008. Not only can SQL Server store such data, it can also visualize it. So I had come up with the following query: select geometry::STPolyFromText ('POLYGON((1 1, 1.5 1.85, 2.5 1.85, 3 1, 2.5 0.15, 1.5 0.15, 1 1), (1.5 [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: sql server, fun, hoegaarden, spatial data, sql server 2008

A Developer's Blog

The Excel Auto Fill Feature

by Valentino Vranken 20 February 2010 21:29

A couple of days ago I discovered a very interesting double-click feature in Excel. One that probably already exists for ages – the oldest version that I was able to try it out on is Excel 2002 and it worked – but due to being used to other habits I just never found out about [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: office, excel

A Developer's Blog

Using Google Reader As Your Blogroll Source

by Valentino Vranken 19 February 2010 20:46

If you’re using Google Reader and you’ve got a WordPress blog then I’ve got a really useful tip for you! Especially if you want to save time maintaining all those links in your blogrolls. You can synchronize your blogrolls on your blog with folders in your Google Reader. Which means zero maintenance for your blogrolls: they’re automatically [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: blogging, google reader, wordpress

A Developer's Blog

Blog N-Technologies

Free SQLUG Event: SCOM 2007 R2 And Managing SQL Server

Importing Data Using The Wizard: Mixing The Wrong Ingredients

Importing Excel Data Using Integration Services

Retrieving Data From Excel

SSMS: Color The Status Bar

Save up to 35% for the PASS European Conference

Recursively Delete SSIS Folder

Drawing In SQL Server 2008

The Excel Auto Fill Feature

Using Google Reader As Your Blogroll Source

RecentPosts

Blog N-Technologies

Tag cloud

RecentPosts