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

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

How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases

Comments posted to this topic are about the item How to Use sqlpackage to...

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