lokesh sharma

My name is Lokesh Sharma, I have 5 years of experience working with SQL and am really interested in exploring more and more about this fascinating language. My aim here is to share some of the challenges that I faced while working with SQL and also to get feedback whether the approach I followed is an optimal one or not.

Interests: Writing and troubleshooting SQL Queries obviously :-). Other than that a fitness freak

PROVIDING LOGGING INFORMATION AT COMMAND LINE

by lokesh sharma

EVERYDAY MSBI/SQL CHALLENGES

For providing logging information at command line utility use the option /l

for example

dtexe /f "some path" /l "logging type; connection...

2014-05-03

441 reads

ERROR OPENING SSRS REPORT MANAGER IN INTERNET EXPLORER

by lokesh sharma

EVERYDAY MSBI/SQL CHALLENGES

Writing this post only for internet explorer as not aware of the settings of other browsers such as chrome/mozilla.

To be...

2014-04-30

1,236 reads

by lokesh sharma

EVERYDAY MSBI/SQL CHALLENGES

PROBLEM - ERROR EXECUTING SSIS PACKAGE FROM SQL JOB. Error Message would be something like this - failed to load xml file...

SOLUTION...

2014-04-27

Effect of using operator '-' with dates in vb6

by lokesh sharma

EVERYDAY MSBI/SQL CHALLENGES

Recently I encountered a problem of handling dates while converting a vb6 code to .net code.

Problem - cant predict what the...

2013-05-24

493 reads

MSBI (SSAS, SSRS and SSIS) Training

by lokesh sharma

EVERYDAY MSBI/SQL CHALLENGES

Hi Guys,

Anyone interested in online training for MSBI (SSAS, SSRS and SSIS), please contact @ er.lokeshsharma08@gmail.com.

Features - Best material (practical and theoretical) for becoming familiar with...

2013-05-24

431 reads

Blogs

Leadership in Times of Change: Guiding Teams Through Uncertainty, Disruption, and Transformation

Change is inevitable. What separates thriving organizations from those that falter is not the...

The End of Year Vacation Burn

It’s been a good year for me. With my sabbatical, I felt like I’ve...

Speaking at PASS Summit 2025

In less than one month, I will be speaking not once but twice at...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Powershell script to generate SQL server Inventory in CSV format

By Srinivas Merugu

Comments posted to this topic are about the item Powershell script to generate SQL...

Database Ledger in SQL Server 2022

By Deepam Ghosh

Comments posted to this topic are about the item Database Ledger in SQL Server...

Visit the forum

Question of the Day

Azure SQL Database MAXDOP

When Azure SQL Database was originally released, the MAXDOP was set to 0 for each new database. In Oct 2025, what is the default value for Azure SQL databases?

See possible answers