Manjuke's Blog
Wednesday, 19 September 2012

Introduction to SSDT (SQL Server Data Tools)

›
What is SSDT ? SQL Server Data Tools (SSDT) is a toolset which provides an integrated environment for database developers to carry out all ...
Friday, 31 August 2012

Installing SQL Server Data Tools (SSDT)

›
What is SQL Server Data Tools? SQL Server Data Tools (SSDT) is a toolset which provides an integrated environment for database developers ...
Wednesday, 11 April 2012

Resolved ~ How to get back SSMS ‘Find and Replace’ Alert

›
  As you know in SQL Server Management Studio (SSMS), once you have cleared the check box value of ‘Always show this message’, from the ‘Fi...
1 comment:
Thursday, 8 March 2012

Locks and Duration of Transactions in MS SQL Server

›
  It is a common argument which I hear among developers these days, regarding SQL locks. Some say that the ‘locks are held for the duration...
2 comments:
Monday, 16 January 2012

Exclusive access could not be obtained because the database is in use ~ Resolved

›
  Sometimes this is a common error message that we encounter, when we try to restore a SQL database, which is being used by other users. ...
10 comments:
Friday, 25 November 2011

Deploy/Use assemblies which require Unsafe/External Access with CLR and T-SQL

›
  What is an Unsafe Assembly? Assemblies which are built using normal computational functions are considered as safe assemblies. But when ...
5 comments:
Tuesday, 22 November 2011

Using CLR functions with T-SQL

›
Why use CLR? Before using CLR, you should question ‘Why’. When using CLR functions within T-SQL, you have to maintain two different progra...
Tuesday, 9 August 2011

Change the data source of a Crystal Report at Run-time using C#

›
It’s a known fact, that in Crystal Reports, if you try to display details, using data in a SQL Server Database other than the one that you’v...
7 comments:
Monday, 8 August 2011

Invoke a custom method when Crystal Report Viewers’ print button is clicked / Add custom button to Crystal Report Viewer Toolbar

›
If you are developing applications which includes reporting with Crystal Reports, you may have noticed that it’s not possible to invoke a cu...
3 comments:
‹
›
Home
View web version

About Me

My photo
Manjuke Fernando
Singapore
My passion lies in building business intelligence and data-based solutions, writing about things I work with and talking about it. New technologies relevant to my line of work interest me and I am often seen playing with early releases of such technologies. My current role involves architecting and building a variety of data solutions, providing database maintenance and administration support, building the organization’s data practice, and training and mentoring peers. My aspiration over the next several years is to achieve higher competency and recognition in the field of Data Analytics and move into a career of data science. Specialities: SQL Server, T-SQL Development, SQL Server Administration, SSRS, SSIS, C#, ASP.Net, Crystal Reports
View my complete profile

Pages

▼
Powered by Blogger.