RSS

Monthly Archives: June 2012

View is not showing newly added column in table

Hi all,
This is for the people who still use “Select * From Table” in their SQL Views. I don’t know what is the reason that you are using this way to create your views, but you could be the victim of this scenario (see… what title says).

Let me show you how you can solve this issue… in-case you come across one.

When this happens??
You make changes in table which is the source of your view. Changes like modifying existing column definition, adding new columns or removing existing columns from table could cause this issue.

Where can I see this issue??
Check the meta-data of your table and view for comparison. (Tip: You can either use traditional method using SYS.OBJECTS joins SYS.COLUMNS or you can check using INFORMATION_SCHEMA.COLUMNS)

What is the solution?
There are different ways to circumvent this issue.

Read the rest of this entry »

 

Tags: , , , , ,

SSRS Report is asking for Username and Password while executing

Hi all,
I want to bring to your focus a very minor detail which could eat-up your time when it happens.

This is the case when your SSRS report is deployed on ReportServer and you are accessing thru any application or interface e.g. SharePoint. Your SSRS report is using Integrated Security and hence no need to provide Username and Password if you have access to the Report. And everything works fine up to this point.

After some days, if you notice that your SSRS Report is not working as expected and it has started asking for Username and Password while executing it. What could be the reason?

Read the rest of this entry »

 

Tags: , , , , , , ,

Free E-Book Offer from Microsoft Press: Introducing Windows Server 2012

Hi all,
Good morning!!!

Microsoft Press launches FREE EBook of “Windows Server 2012”. For IT professionals looking for an early, high-level view of Windows Server 2012, there’s no better resource than the Microsoft Press e-book.

Based on the beta release, this guide introduces its new features and capabilities, with scenario-based insights demonstrating how the platform can meet the needs of your business.

Read the rest of this entry »

 
1 Comment

Posted by on June 21, 2012 in E-Book, Free, General, Windows

 

Tags: , , ,

Filtering Feature in SQL Server Management Studio

Hi All,
How are you doing?

I want to draw our attention to pretty handy-dandy (Yet not complete enough) feature in SQL Server Management Studio. That is “Filtering”.

Advantage:
You can filter the objects (like Tables, Views, Stored Procs etc.) based on certain criteria. You can filter them by “Name, Schema, Owner or Creation Date”.

This will be really great help when you have lots of objects in your database. And by filtering you can choose to see only required objects at a time :)

Read the rest of this entry »

 

Tags: , , , , ,

Microsoft Cloud Summit on 4th July 2012 @ Singapore

Hi guys,
How are you doing?

There is an event going to take place in Singapore on “Microsoft Cloud”. Following is the required details if you are interested.  And there is no need to wait till 4th July for registration, you can get it done by emailing them. :)

Subject:
Registration for the Microsoft Cloud Summit 2012 to be held on Wednesday, 4th July 2012 at Grand Copthorne Waterfront Hotel, Singapore.

Date & Time:
4th July 2012, Wednesday
9:00am – 5:00pm (Registration starts from 8.30am)

Read the rest of this entry »

 

Tags: , , , ,