Category Archives: Referene

Azure Database pricing tier selection

Azuer provides multiple Servie level options to choose for your database(s)s depending on number of databases/ Size/ CPU/ Number of Sessions/ Number of Connections to the database. As the number of database you want to host increases you have more … Continue reading

Posted in Azure, Referene, Uncategorized | Tagged , , , , | Leave a comment

Execute As in SQL (Similar to Runas in Windows context)

When we need to execute any SQL statement with other user context we have to use EXECUTE AS statement to impersonate other user access. Impersonation can be done as different login or different user.This is similar to RunAs in windows … Continue reading

Posted in Referene, SQL, SQL Query, Uncategorized | Tagged , , , | Leave a comment

Fix: DBAMP Error: MALFORMED_QUERY: Implementation restriction: CollaborationGroupRecord requires a filter by a single Id, CollaborationGroupId or RecordId using the equals operator

Actual problem is the procedure fails to pull CollaborationGroupRecord table data due to api restrictions. You need to exclude the table from sf_replicateAll and/or sf_RefreshAll procedures as a resolution. Fix: Add below 2 lines of code next to < if … Continue reading

Posted in Referene, SQL Error, Useful Link | Tagged , , , , , , , | Leave a comment

Report Data Pane is missing – Latest SQL Version – SystemInfo – Azure Infographics

Just want to share something interesting I have come across in last few weeks… ALT + CTRL + D is the shortcut to get the Report Data Pane back. At times you will not be able to see the shortcut! … Continue reading

Posted in commands, knowledge, Productivity, Referene | Tagged , , , , , | Leave a comment

SSIS Expressions – Date operations, Data Type conversions and more…

I had to use Derived Column Transformation Editor to split a datetime column into 2 parts one with Date only and another column only with Time. I had to invest some time to get the simple solution as follows… There … Continue reading

Posted in Productivity, Referene, SQL, SSIS | Tagged , , , , , | 1 Comment

Microsoft Azure enhancements – 2014 December 11 – SQL 2014 Features and Compatibility

Azure enhancements released are huge and touching multiple services like Premium Storage, RemoteApp, Database etc… I am impressed with SQL Database enhancements! * Performance: Significant improvement to performance compare to existing offerings, support for In-memory columnstore queries. * Large Database … Continue reading

Posted in Azure, Referene, SQL | Tagged , , , | Leave a comment

Talend… I am liking it 

Going through week long Talend trainings, definitely the product is great than I expected! Few advantages I consider: • Can scale from small data to any size • Supports multiple platforms • Open source data integration software Go explore more … Continue reading

Posted in Referene, Talend | Tagged | Leave a comment