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,515 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

399 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,521 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,312 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,358 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

641 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

506 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

995 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,442 reads

Blogs

Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server

By Anthony Nocentino

Here’s the scenario: one of my SQL Server instances migrated to the DR array....

The Book of Redgate: Products

We are product focused at Redgate Software. Here is another of our values that...

KDA: Echoes of Deception - Case 7

A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...

Read the latest Blogs

Forums

The SQL Server 2016 Plan

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The SQL Server 2016 Plan

whats that ssis analyzer product that documents lineage

hi, a few years ago was at a very large company that bought a...

Implicit Conversions Cripple SQL Server

Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server

Visit the forum

Question of the Day

BIT_COUNT() III

In SQL Server 2025, I run this code:

select bit_count(-1)

What is returned?

See possible answers