Archive for 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 [...]
June 27, 2012
· 
Khilitchandra Prajapati · 
One Comment
Tags: INFORMATION_SCHEMA, INFORMATION_SCHEMA.COLUMNS, SQL Server, Stored Procedure, Tip, View · Posted in: General, Interview QA, Quick Fix, Quick Tips, Script, SQL Server, SQL Server 2012, T-SQL, Tutorial
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 [...]
June 21, 2012
· Khilitchandra Prajapati · No Comments
Tags: Asking for Username and Password, Execution, Fix, Report, SQL Server, SQL Server Reporting Services, SSRS, Tip · Posted in: Business Intelligence, Quick Fix, Quick Tips, SQL Server, SSRS, Suggestion, Tutorial
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 [...]
June 21, 2012
· Khilitchandra Prajapati · No Comments
Tags: EBook, Free, Microsoft Press, Windows Server 2012 · Posted in: E-Book, Free, General, Windows
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”. [...]
June 11, 2012
· Khilitchandra Prajapati · No Comments
Tags: Business Intelligence, Database, Filtering Feature, Microsoft Tools, SQL Server, SQL Server Management Studio · Posted in: Business Intelligence, General, Interview QA, Quick Tips, SQL Server
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 [...]
June 10, 2012
· Khilitchandra Prajapati · No Comments
Tags: 2012, Event, Microsoft, Microsoft Cloud Summit, SQL Server · Posted in: Business Intelligence, General, Microsoft Event, SQL Server
