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

396 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,501 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,300 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,355 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

636 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

500 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

991 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,440 reads

Blogs

“We love to debate minutiae”

By Brian Kelley

I am guilty as charged. The quote was in reference to how people argue...

Advice I Like: Knots

Learn how to tie a bowline knot. Practice in the dark. With one hand....

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...

Read the latest Blogs

Forums

how to write this query?

Hi everyone I asked this earlier but the desired outcome is a bit different...

Windows logins for users migrated from DomainA to DomainB

Hi, I have a SQL Server instance where users connect to via Windows Authentication,...

Multiple Deployment Processes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Deployment Processes

Visit the forum

Question of the Day

Upgrading Admin Queries

I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?

See possible answers