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

Reporting Services Timeout in Sharepoint

by Davy Knuysen 3 March 2010 07:05

Recently someone asked me to check a Reporting Services report that always resulted in an Unexpected Error. The report server was configured for Sharepoint Integrated Mode. I came to the conclusion that the server always returned this error after exactly 2 minutes, so it had to be a timeout exception. The report was kind of big, so [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: bi, moss, reporting services, sql server, data, sharepoint

Davy Knuysen

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

Windows 7 Screen Capture Tool

by Valentino Vranken 14 February 2010 21:48

We’ve finally gotten a built-in tool in Windows to capture those screenshots for blogging/documentation/whatever purposes. And it has been given the magical, oh-so-logical name of Snipping Tool! Update: I’m aware that Vista already contained this tool. But I’m one of those guys who managed to stay away from Vista so to me it’s new Let’s [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: windows, windows 7

A Developer's Blog

IIS 7.5 And Windows Authentication

by Valentino Vranken 14 February 2010 11:34

Owkay, I’ve got a good one for you this time. And all it takes is checking a checkbox, just one checkbox! That’s the solution to a problem with which I’ve been struggling yesterday. What problem? Let me tell you. I’ve been installing Master Data Services (MDS) on my SQL Server 2008 R2. This feature will not only create [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: windows, iis 7.5, master data services, mds, sql server 2008 r2, windows 7

A Developer's Blog

Browsing Cube In Management Studio Throws Class String Error

by Valentino Vranken 12 February 2010 20:49

Using the Management Studio (SSMS) I just received an error which I hadn’t seen before. Here’s what I was doing. On my freshly-installed Windows 7 64-bit machine I have both SQL Server 2008 SP1 and SQL Server 2008 R2 (NOV CTP) running (both 64-bit as well). And I just installed the new Contoso data warehouse and [...]
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, ssms

A Developer's Blog

SSIS: Adding Files To The Miscellaneous Folder

by Valentino Vranken 11 February 2010 22:20

Sometimes my posts are over 20 pages long when pasted into a Word document. That’s when I call them article, or tutorial. Other times I post real quickies about little things that have annoyed me in the past, because I had to spend too much time looking for a solution to a certain issue, or [...]
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, ssis, tfs

A Developer's Blog

Blog N-Technologies

Save up to 35% for the PASS European Conference

Reporting Services Timeout in Sharepoint

Recursively Delete SSIS Folder

Drawing In SQL Server 2008

The Excel Auto Fill Feature

Using Google Reader As Your Blogroll Source

Windows 7 Screen Capture Tool

IIS 7.5 And Windows Authentication

Browsing Cube In Management Studio Throws Class String Error

SSIS: Adding Files To The Miscellaneous Folder

RecentPosts

Blog N-Technologies

Tag cloud

RecentPosts