Dinesh Asanka

  • Interests: Watching Cricket / Writing Articles

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.

2005-07-26

5,465 reads

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)

2005-03-29

11,897 reads

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)

2005-02-21

16,772 reads

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)

2004-11-11

12,611 reads

Basics of C2 Auditing

Auditing in SQL Server is something that is becoming more and more prevelant, and will likely become more regulated over time. Dinesh Asanka brings us a new article on the basics of SQL Servers most powerful auditing configuration, C2 level auditing.

4.88 (8)

2004-11-03

32,155 reads

Blogs

Power BI: Making Date & Time Keys

By

Saving the Day from Delay Part 2 Creating DateKey and TimeKey columns can be...

Daily Coping 18 Jan 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

How to get data in a DataFrame via .NET for Apache Spark

By

When I first started working with Apache Spark, one of the things I struggled...

Read the latest Blogs

Forums

Selecting last 6 months

By sqlErik

Hi, I need to select rows from the last 6 months prior to the...

Nested loop/HashJoin and left/right/full join

By 892717952

1. What is the difference among nested loop?hash join and merge join? 2. what...

SSMS & Excel - Copy Paste - DateTime Columns

By AMCiti

Dear Group: I am not sure if this is a T-SQL / SSMS issue,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers