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

PROVIDING LOGGING INFORMATION AT COMMAND LINE

by lokesh sharma

EVERYDAY MSBI/SQL CHALLENGES

For providing logging information at command line utility use the option /l

for example

dtexe /f "some path" /l "logging type; connection...

2014-05-03

439 reads

ERROR OPENING SSRS REPORT MANAGER IN INTERNET EXPLORER

by lokesh sharma

EVERYDAY MSBI/SQL CHALLENGES

Writing this post only for internet explorer as not aware of the settings of other browsers such as chrome/mozilla.

To be...

2014-04-30

1,226 reads

by lokesh sharma

EVERYDAY MSBI/SQL CHALLENGES

PROBLEM - ERROR EXECUTING SSIS PACKAGE FROM SQL JOB. Error Message would be something like this - failed to load xml file...

SOLUTION...

2014-04-27

Effect of using operator '-' with dates in vb6

by lokesh sharma

EVERYDAY MSBI/SQL CHALLENGES

Recently I encountered a problem of handling dates while converting a vb6 code to .net code.

Problem - cant predict what the...

2013-05-24

488 reads

MSBI (SSAS, SSRS and SSIS) Training

by lokesh sharma

EVERYDAY MSBI/SQL CHALLENGES

Hi Guys,

Anyone interested in online training for MSBI (SSAS, SSRS and SSIS), please contact @ er.lokeshsharma08@gmail.com.

Features - Best material (practical and theoretical) for becoming familiar with...

2013-05-24

429 reads

Blogs

A New Word: Immerensis

immerensis – n. the maddening inability to understand the reasons why someone loves you...

Deploy a Dockerized Python TODO App to Azure Container Apps Using Pulumi and Azure Key Vault

By Ige Adetokunbo Temitayo

In this post, I will guide you on how to deploy a dockerized simple...

SQL Server Wait Stats

Everything in SQL Server is waiting for something…this is by design. And most people...

Read the latest Blogs

Forums

mysql query timeout upped but job still fails about same number of minutes in

hi, i changed my mysql based linked server's timeout to N'600' instead of N'0'...

Somebody realized to configure Cluster-Aware updating on VMWare nodes

By boskabouter 007

Creating an Windows Server Fail-over Clusters with two SQL server 2022 and a File...

is it cache or something else

hi a few days ago i narrowed down the cause of a new problem...

Visit the forum

Question of the Day

SQL Server Collations

At what levels can we set the collation in SQL Server 2022?

See possible answers