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

454 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,262 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

509 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

443 reads

Blogs

T-SQL Tuesday #203: Risk and Reward

This is timely, as I’m currently on a boat in the Adriatic taking a...

dataMinds Connect 2026 – Slides & Scripts

By Koen Verbeeck

You can find the slides and SQL scripts for my session “Spice up your...

How to Clear the SSMS Cache (SSMS 21 and Later)

How to Clear the SSMS Cache (SSMS 21 and Later) Updated...

Read the latest Blogs

Forums

Risk Vs Reward, The never ending ROI discussion.

Comments posted to this topic are about the item Risk Vs Reward, The never...

Hyperscale Replicas IV

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Hyperscale Replicas IV

The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek

By Dhananjay Chaudhari

Comments posted to this topic are about the item The SQL Server Date Magic:...

Visit the forum

Question of the Day

Hyperscale Replicas IV

In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?

See possible answers