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

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

SSMS Showing Incorrect Version Numbers In Object Explorer

by Valentino Vranken 9 January 2010 22:21

Ever since I upgraded to SQL Server 2008 Service Pack 1 I noticed that the Management Studio was reporting incorrect version numbers when connected to Integration or Reporting Services. This incorrect version number is located to the right of the server instance in the Object Explorer. As usual, a picture says so much more than … [...]
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, bug, data, integration services 2008, reporting services 2008, sql server 2008, ssis, ssrs

A Developer's Blog

Report Builder 2.0: Cannot switch data source

by Valentino Vranken 12 September 2009 08:43

I came across an issue when playing around with Report Builder 2.0. I had created a report using an embedded data source. Once I’d published the report to the report server, I couldn’t get it to run anymore. Instead it gave me the following error: This report cannot be run in report builder because it contains [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: reporting services, bug, data, report builder 2.0, report builder 3.0, reporting services 2008, sql server 2008, ssrs

A Developer's Blog

Want to link datasets? Please vote!

by Valentino Vranken 13 June 2009 13:22

Now that the European Elections are over once again, I’d like to draw your attention to another request for voting. Using Reporting Services 2008, at this moment it is not possible to link two datasets. Linking datasets would be really interesting in certain cases. Imagine you’ve got two datasets, used in two different report data regions. [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: reporting services, data, reporting services 2008, sql server 2008, ssrs

A Developer's Blog

BUG: Foreach Loop Container

by Valentino Vranken 9 June 2009 18:09

If you’re using Integration Services 2008 and the Foreach Loop Container in the Control Flow, you’ll very likely encounter this bug. The Foreach Loop has several enumerators available. By default it selects the Foreach File Enumerator. However, as the screenshot below shows, there’s no way to configure it – the Enumerator configuration group just shows blank [...]
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, bug, data, sql server 2008, ssis

A Developer's Blog

FIX: Visual Studio crashes after playing around with its windows

by Valentino Vranken 14 May 2009 19:13

Lately I had been getting annoyed by Visual Studio crashing on me while working on ETL packages. The crashes seemed somehow related to debugging a package because they usually occurred after I clicked the “Package execution completed. Click here to switch to design mode, or select Stop Debugging from the Debug menu.” link. But I [...]
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, visual studio, bids, bugfix, business intelligence development studio, data, sql server 2008, ssis, visual studio 2008

A Developer's Blog

10.0.2531.0

by Valentino Vranken 12 April 2009 11:19

Right. 10.0.2531.0. That’s the version number that my SELECT @@VERSION statement is reporting when executed on my SQL Server 2008. How come? Well, I installed Service Pack 1. In other words, SP1 for SQL Server 2008 is out and can be downloaded from the Microsoft Download Center! Besides fixing several bugs there are some new features to [...]
Click here to see the original post

Currently rated 1.0 by 1 people

Currently 1/5 Stars.
1
2
3
4
5

Tags: sql server, data, sql server 2008

A Developer's Blog

The power of the placeholder

by Valentino Vranken 7 April 2009 13:02

Once upon a time in a Business Intelligence Development Studio 2005 Reporting Services solution there liveth a Textbox object which developers could use to put text on a report. It was a fairly simple object, allowing only two ways of programming the text. The first and most simple way of the two was to type plain [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: reporting services, data, reporting services 2008, sql server, sql server 2008, ssrs

A Developer's Blog

Full Text Search: fatal error 30059

by Valentino Vranken 4 March 2009 16:53

If you have installed SQL Server 2008 without making any modifications to the default service settings and you’re trying out the AdventureWorks2008 sample database, you may be getting some similar errors as the following in the Application event log: A fatal error occurred during a full-text population and caused the population to be cancelled. Population type [...]
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, full-text indexing, sql server 2008

A Developer's Blog

Blog N-Technologies

SSMS: Color The Status Bar

Drawing In SQL Server 2008

SSMS Showing Incorrect Version Numbers In Object Explorer

Report Builder 2.0: Cannot switch data source

Want to link datasets? Please vote!

BUG: Foreach Loop Container

FIX: Visual Studio crashes after playing around with its windows

10.0.2531.0

The power of the placeholder

Full Text Search: fatal error 30059

RecentPosts

Blog N-Technologies

Tag cloud

RecentPosts