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

FIND OBJECTS BEING REFERRED BY SSRS REPORT

by lokesh sharma

EVERYDAY MSBI/SQL CHALLENGES

Hi Everyone

In the daily team meeting today, we had a requirement to find out the stored procedure used/referenced by SSRS...

2016-04-07

1,360 reads

SOME BUGS IN SQL-SSRS 2005

by lokesh sharma

EVERYDAY MSBI/SQL CHALLENGES

Hi Guys
I know sql 2005 is getting outdated and there would be no support from Microsoft from this month. But lets not...

2016-04-01

394 reads

Handling decimal and non numeric types using Case statement

by lokesh sharma

EVERYDAY MSBI/SQL CHALLENGES

Hi Guys

Just encountered a scenario where I needed to handle numeric and non numeric types using Case statement. Here is the...

2015-10-14 (first published: 2015-10-06)

3,491 reads

syntax error in textheader of stored procedure - Cause and Solution

by lokesh sharma

EVERYDAY MSBI/SQL CHALLENGES

Hi Folks,

Comments play an important part in writing any code. Especially when somebody else reads your code. So the other...

2015-08-30

1,294 reads

by lokesh sharma

EVERYDAY MSBI/SQL CHALLENGES

Hi Folks,

Hope you all are doing good. Would like to start with praying for all those who have been affected...

2015-04-26

Data Rendering Eye Opener SSRS

by lokesh sharma

EVERYDAY MSBI/SQL CHALLENGES

Hi Folks

Greetings to everyone!!!

So last week one of the report was having a performance issue. It had 10 datasets ,5...

2015-04-22 (first published: 2015-04-12)

6,351 reads

Toggle Functionality Looses In excel--ssrs 2005

by lokesh sharma

EVERYDAY MSBI/SQL CHALLENGES

Hi Folks

Highlighting on the issue that I faced last week while working on reporting services 2005.

Requirement :- A data region (table)...

2015-04-03

633 reads

Date Range Challenge in sql

by lokesh sharma

EVERYDAY MSBI/SQL CHALLENGES

Hi Folks,

When you work in a offshore - onsite setup in IT industry and if you are fortunate 🙂 to be a...

2015-03-15

497 reads

Bug In ado.net enumerator in foreach loop in SSIS 2012

by lokesh sharma

EVERYDAY MSBI/SQL CHALLENGES

Hi Greetings to everyone,

Today I am going to report a bug in SSIS 2012. In one of the packages I...

2014-07-27

985 reads

CTE - Limitations

by lokesh sharma

EVERYDAY MSBI/SQL CHALLENGES

Hi

Wanted to explore one of the major limitation of CTE in sql 2012 i.e. it cannot be used inside if...

2014-07-27

1,437 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