Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Dinesh Asanka

SQLServerCentral.com profile

   Items 1 to 20 of 29    Older >>
 

How to Read Excel Cells from SQL Server Integration Services

We can get data in all sorts of formats in the real world. In this new article from Dinesh Asanka, learn how to use scripting to import data from individual Excel cells.  Read more...
Rating: |  Discuss |   Briefcase | 13,484 reads

Checkpoints in SSIS

Integration Services has a lot of features to enable to you perform ETL operations on data moving into SQL Server. Longtime author Dinesh Asanka brings us an article on   Read more...
Rating: |  Discuss |   Briefcase | 9,518 reads

SSIS and Excel 2007

Longtime author Dinesh Asanka brings us a short tutorial on importing your data from Excel 2007 into a database using Integration Services.  Read more...
Rating: |  Discuss |   Briefcase | 13,903 reads

SSAS Database Backup

Longtime SQL Server author Dinesh Asanka brings us a new article on backing up an Analysis Services database.  Read more...
By Dinesh Asanka 2008/07/17 | Source: SQLServerCentral.com | Category: analysis services (ssas)
Rating: |  Discuss |   Briefcase | 9,451 reads

Applying Your Scripts across Multiple SQL Server Databases

This review of RedGate's new SQL Multi Script tool that aids you in deploying a script across multiple databases.  Read more...
By Dinesh Asanka 2008/03/20 | Source: SQLServerCentral.com | Category: product reviews
Rating: |  Discuss |   Briefcase | 3,260 reads

The OUPUT Command

SQL Server 2005 has added many new T-SQL commands, one of which is the OUTPUT command. Longtime SQL Server author Dinesh Asanka brings us a short look at how you can use this command.   Read more...
By Dinesh Asanka 2007/07/09 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 16,156 reads

A Review of SQL Refactor

Longtime author Dinesh Asanka takes a look at one of the new tools on the market, SQL Refactor from Red Gate.   Read more...
By Dinesh Asanka 2007/03/27 | Source: SQLServerCentral.com | Category: product reviews
Rating: |  Discuss |   Briefcase | 3,417 reads

SQL Server Agent 2005

SQL Server 2005 has brought about many paradigm changes, including substantial changes to the SQL Server Agent subsystem. Dinesh Asanka takes a new look at roles and counters in 2005.   Read more...
By Dinesh Asanka 2006/05/03 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 21,445 reads

Triggers to Execute in Pre Defined Order

SQL Server allows multiple triggers on a table, but the order in which they are executed can sometimes cause problems. Author Dinesh Asanka brings us a technique for managing the order of execution for your triggers.   Read more...
By Dinesh Asanka 2006/04/06 | Source: SQLServerCentral.com | Category: sql puzzles
Rating: |  Discuss |   Briefcase | 10,869 reads

Does Barcoding Give Headaches to You? Neodynamic is a Solution

Do you have a need to generate bar codes for an application? Check out this new product, reviewed by Dinesh Asanka, that uses Reporting Services to help you easily print bar codes.   Read more...
By Dinesh Asanka 2006/03/09 | Source: SQLServerCentral.com | Category: product reviews
Rating: |  Discuss |   Briefcase | 6,636 reads

Calling COM From T-SQL

One of the lesser used features of SQL Server is the ability to access the functionality in various DLLs using a COM interface. Dinesh Asanka brings us a basic article with a few examples in how you can work with COM components from inside SQL Server 2000.   Read more...
By Dinesh Asanka 2005/10/31 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 11,017 reads

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.   Read more...
By Dinesh Asanka 2005/07/26 | Source: SQLServerCentral.com | Category: product reviews
Rating: |  Discuss |   Briefcase | 5,457 reads

Globalization in SQL Server

SQL Server can support many different languages through Unicode. Author Dinesh Asanka brings us a basic article on how the server supports different languages.   Read more...
By Dinesh Asanka 2005/07/04 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 12,897 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.   Read more...
By Dinesh Asanka 2005/03/29 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 11,839 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.   Read more...
By Dinesh Asanka 2005/02/21 | Source: SQLServerCentral.com | Category: upgrading
Rating: |  Discuss |   Briefcase | 16,667 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.   Read more...
By Dinesh Asanka 2004/11/11 | Source: SQLServerCentral.com | Category: configuring
Rating: |  Discuss |   Briefcase | 12,544 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.   Read more...
By Dinesh Asanka 2004/11/03 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 26,430 reads

Review - dbMaestro

Version control in SQL Server is fairly immature, to put it nicely. Fortunately it's also an area that a number of vendors are working to make smoother. Dinesh Asanka looks at dbMaestro, a tool from Extreme Technologies to help you track changes in multiple databases.   Read more...
By Dinesh Asanka 2004/10/20 | Source: SQLServerCentral.com | Category: product reviews
Rating: |  Discuss |   Briefcase | 7,498 reads

InfoPath 2003 - Part 3

Continuing his series on SQL Server and InfoPath 2003, the new reporting tool that has been added to Office. This time Dinesh looks at a practical application using expense entry along with some more features of this new tool.   Read more...
By Dinesh Asanka 2004/09/14 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 7,067 reads

InfoPath 2003 - Part 2

Continuing with Dinesh Asanka's series on SQL Server and Infopath 2003, he shows us this time how to build a report that joins two tables and includes some conditional formatting. Infopath 2003 is part of Office 2003 and is a great quick and dirty tool for getting to your SQL Server data.   Read more...
By Dinesh Asanka 2004/08/31 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 7,493 reads
   Items 1 to 20 of 29    Older >>