Dinesh's Blog :::: Being Compiled ::::

Sunday, June 27, 2010

Creating Self-Service Business Intelligence dashboard with PowerPivot – Part I

›
What is Self-Service Business Intelligence? Self-Service Business Intelligence – What is it? Is it a new term? You may know about th...
1 comment:
Monday, June 21, 2010

Designing Database with SQL Server: Microsoft Student Champs Meeting

›
Last week I was invited by Madusha Nanayakkara, Microsoft Student Ambassador to deliver a session at Microsoft Student Champs Meeting. I was...
4 comments:
Sunday, June 20, 2010

OPENROWSET, OPENDATASOURCE - “Microsoft.ace.oledb.12.0” for linked server “(null)” reported error – Excel 2007, 2010

›
SQL Server supports distributed queries in many ways, allowing users to access heterogeneous data sources. The frequency of data access dete...
Thursday, June 17, 2010

What is $IDENTITY?

›
This was in one of my slides of SQL Brain Bashers presentation which was done at SQL Server User Group Meeting. What is $IDENTITY? Everybo...

Cumulative updates for SQL Server 2008 SP1 and SQL Server 2008 R2 RTM

›
If you have not noticed, Microsoft had released two cumulative updates for both 2008 SP1 and 2008 R2 RTM. The cumulative update for SQL Serv...
Wednesday, June 16, 2010

SQL Brain Bashers

›
Yesterday we held our SQL Server User Group meeting and I was one of the speakers. My session was supposed to be on Geospatial Visualization...
Monday, June 7, 2010

Configuring Reporting Services 2008 R2 in SharePoint 2010 Integrated Mode – Part II

›
If you need to create an extremely user-friendly environment for Reporting Services 2008 R2, SharePoint 2010 Integrated Mode is the best sol...
15 comments:

Configuring Reporting Services 2008 R2 in SharePoint 2010 Integrated Mode – Part I

›
Integrating Reporting Services with SharePoint is really a fun and it gives extremely user-friendly environment for Reporting Services. Ther...
6 comments:
Monday, May 31, 2010

Report Viewer Control: Exporting Reports to Word, PDF and Excel Programmatically

›
When Reporting Services reports are shown with ASP.NET Report Viewer control, one of the common requirements for exporting facility is, limi...
Sunday, May 30, 2010

AdventureWorks 2008 R2 RTM is available

›
AdventureWorks sample SQL Server databases are available for SQL Server 2008 R2 RTM. When you install, you get R2 databases as AdventureWork...

SQL Azure vs. SQL Server

›
The cloud-based relational database service, SQL Azure provides relational database functionality as a service. Although this platform provi...
Friday, May 28, 2010

Understanding GRANT, REVOKE and DENY T-SQL Commands

›
GRANT, REVOKE, and DENY commands are T-SQL commands in SQL Server for managing permission. Although we know the correct usage of them, REVOK...
5 comments:
‹
›
Home
View web version

About Me

My photo
Dinesh Priyankara
Colombo, Sri Lanka
Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and business intelligence related projects. He is the Founder/Principal Architect of dinesQL (Pvt) Ltd and he consults, teaches and runs training programs on data related solutions and subjects.
View my complete profile
Powered by Blogger.