Vikash K. Agarwal

Vikash K. Agarwal is a technology architect for Tally Solutions. He has almost 12 years of IT experience in various roles and specializes in system-design and programming with Microsoft Visual C++ and Win32. He is an MCSE and an MCDBA.
Email: vikash.agarwal@tallysolutions.com

My Latest Content

My Latest Comments

Author Articles

Inline Conditional Aggregation: One for All

By Vikash K. Agarwal, 07/24/2003

For most simple aggregations, using GROUP BY with an aggregation function returns the information you need. Inline conditional aggregation uses CASE...END to return multiple ...

Using T-SQL to Generate a Resultset in Tree Form

By Vikash K. Agarwal, 03/21/2001

Use recursive stored procedures to generate a tree from a SQL Server table.

Temporary Tables: Local vs. Global

By Vikash K. Agarwal, 03/21/2001

A comparison of local temporary tables and global temporary tables.

Keep Database Schema Online

By Vikash K. Agarwal, 10/19/2000

Build an ASP page that lets you access your database schema through the Internet.

Downloads

Have to create custom code just to determine who has what permissions? Try Security Explorer, an enterprise security management solution for SQL, SharePoint, and more. As expert Robert Davis reports, “DBAs who deal with compliance regulations will find this tool indispensible.”

Tip Guides

Migrating to Windows 7 comes with one major drawback: Win7 “application obsolescence.” This tip guide explains how VMware ThinApp can encapsulate applications in self-contained executables and how you can avoid the ten most common Win7 application migration pitfalls.

Subscribe to SQL Server Magazine!

Web Seminars

Despite the promise of cloud computing, IT administrators may be hesitant to entrust the performance of their business-critical processes to a 3rd party. View this webinar to learn how you can reap the benefits of cloud computing while maintaining absolute control over your data.

eLearning Series

Windows IT Pro brings the experts direct to you to share their real-world perspective, experience, and expertise. During each event, three sessions stream in real time, allowing you to learn, to ask questions, and to get solutions.
Upcoming event: SQL Server Consolidation

© 2012 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.