Dinesh Asanka

  • Interests: Watching Cricket / Writing Articles

SQLServerCentral Article

Review Armtech for SQL Server

How many times have you wished you could throttle the CPU use of SQL Server? Or for a database? Prevent your developers from using too many resources while sharing the server with production or QA. ArmTech for Windows can do this and Dinsesh Asanka brings us a review of how this product worked in his environment.

You rated this post out of 5. Change rating


5,471 reads

SQLServerCentral Article

The Multi Phase Data Pump

SQL Server 2000 has an amazing ETL tool in Data Transformation Services that is included at no charge, something none of the other database vendors include. DTS has great flexibility to make your job easier, but it has some quirks in this version. The Multi Phase Data Pump is hidden inside the tool, but can provide a great programming environment and Dinesh Asanka brings us a look at what you can do wit this tool.

5 (1)

You rated this post out of 5. Change rating


11,981 reads

SQLServerCentral Article

Upsizing the Access Database into the SQL Server

SQL Server and Access are usually linked together as Access used for applications at the beginning of their lifecycle that are later moved to SQL Server when the load gets too high or the data sizes grow. There are often cases where you may also want to use SQL Server as a backend to an Access application. But how do you get your data from Access to SQL Server? Author Dinesh Asanka brings us an overview of the various ways that you can move your Access database to SQL Server.

3.5 (2)

You rated this post out of 5. Change rating


16,897 reads

SQLServerCentral Article

Best Practices are always the Best

On this site, we have taken a contrarian approach to looking at the ways to configure SQL Server with our Worst Practices series. However Microsoft still looks at it from the other side and release a tool called the Best Practices Analyzer for SQL Server. Author Dinesh Asanka brings us a short look at this tool.

4 (1)

You rated this post out of 5. Change rating


12,614 reads


Take the SQL Saturday Topic Survey


What topics do you want to see presented at a future SQL Saturday (or...

Resetting Git and Abandoning Changes–#SQLNewBlogger


I recently had an issue in one of my Git repos, and decided to...

Exploring Window Functions Execution Plans


There are quite a few different ways that you’re likely to see window functions...

Read the latest Blogs


Program Code giving duplicate errors where no duplicates exist

By Andre 425568

On our Java Hibernate program it is giving a duplicate value on an insert...

How to get calculated values from a derived(?) table?

By mjdemaris

Here is my filtered dataset: I would like to calculate the time difference between...

sp_server_diagnostics in ErrorLog

By Casper101

I have the following in the SQL Errorlog, that was never there before: sp_server_diagnostics...

Visit the forum

Question of the Day

Disable Memory Grant Feedback Persistence

In SQL Server 2022, how can I disable memory grant feedback persistence?

See possible answers