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

395 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,494 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,299 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,354 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

635 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

499 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

990 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,439 reads

Blogs

Resetting on the AI hype train

By Brian Kelley

There's a great article from MIT Technology Review about resetting on the hype of...

A New Word: Etherness

etherness – n. the wistful feeling of looking around a gathering of loved ones,...

Vibe Coding a Login Tracking System

A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...

Read the latest Blogs

Forums

The Max PK Length

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Max PK Length

My experience using the GitHub Copilot in SSMS 22

By Daniel Calbimonte

Comments posted to this topic are about the item My experience using the GitHub...

The Microsoft SQL Year in Review

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Microsoft SQL Year in...

Visit the forum

Question of the Day

The Max PK Length

If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?

See possible answers