Jake and Greta playing folk music with Solar Flare Radio Crew - KFAI Radio

By Rajib Bahar at August 28, 2012 18:00
Filed Under:

Ryan and Rajib interviews Jake and Greta during their appearance in KFAI radio. They played folks music


Paul Riedner & Matthew Griswold sharing their experience being Iraq Veteran & some music

By Rajib Bahar at August 28, 2012 18:00
Filed Under:

Paul interviews his guest Matthew Griswold. They discuss their experience as Iraq war veterans, non-profit activities to promote music as a form of therapy. Toward the end of this discussion Matthew sings one of his original song


Brian Johnson rocking the station with Solar Flare Radio Crews

By Rajib Bahar at August 20, 2012 18:00
Filed Under:

Brian plays one of his song with us. Solar Flare Radio crews put together this live concert with multiple bands.


Running at Night in Eagan - 6 Mile Course from Thomson Reuters to Best Buy

By Rajib Bahar at August 15, 2012 18:00
Filed Under:

I was running at night again. This route took me straight to Best Buy, which is 3 miles from Thomson Reuters in eagan. After reaching BestBuy, I came back to Thomson.


Is a table variable always the answer?

By Rajib Bahar at August 14, 2012 00:27
Filed Under: SQL

I usually got good results with table variables over cursors or derived queries. I wanted to take advantage of available memories. In one of my previous project, I tried to implement an alternative to cursor via table variable. Unfortunately, it caused the SSIS process to run out of memory after running for 8+ hours. I was surprised to see it perform slower than a derived query version of that same query. It was doing a very basic data retrieval function such as selecting the data. After working with our DBA, we discovered that the server didn't have enough memory available during the time of execution (due to high user traffic). The query would slow down after processing few thousands of rows of data. It took some time to work with our colleagues to figure out the most optimal # rows the table variable can handle at any given time. Anyways, we resorted to the derived queries approach for bigger datasets.

Rajib & MJ Interviews Leeza Ali - Distinguished Young Women - Art Matters - KFAI Radio

By Rajib Bahar at August 09, 2012 18:00
Filed Under:

In her early years, Leeza Ali was recognized as a piano prodigy. She continued to excel in it. We interviewed her sister Nora Ali several years ago. Following her sister's footstep, she participated in "Distinguished Young Women" program in 2011. Leeza is very active in community activities. Her notable philanthropic work includes holding concert for children of Afghanistan via P.E.C.A. (Partnership for the Education of Children in
Afghanistan.), "Be Your Best Self" via Distinguished Young Women.

Links to learn more about Leeza's work:
- http://greenroom.fromthetop.org/2010/09/27/building-schools-in-afghanistan-one-concert-at-a-time-part-1/
- http://blog.al.com/live/2011/06/sister_a_source_of_inspiration.html
- http://soundcloud.com/leeza-ali


The EXECUTE permission was denied on the object 'sp_ssis_addlogentry'

By Rajib Bahar at August 07, 2012 05:51
Filed Under: Database, SQL, SQL Server

I have been lazy about blogging for a long long long time... I thought I'd get back into it again with an error message. Depending upon a project, I either get full-admin privilege or restricted privilege. Both options have merit, but, I prefer more flexibility in anything I do. This particular error message is very trivial. I'll not be breaking any ground by saying the solution is to grant proper permission. We often run into this kind of permission issues whenever dealing with database objects. It happens whenever the user lacks permission to utilize an object. How did I run into this error? I usually prefer storing ssis logging data in a table. One of these days, I'll get motivated to write my own custom solution. Until then I find the built-in logging mechanism sufficient. In most ssis projects, I had the privilege to utilize sp_ssis_addlogentry object. I didn't have to worry about setting that permission. When this issue arose I had to get help from our dba Jimit Mehta. He's a dba-super-hero for our team. As soon as he ran the statement below, my headache was gone. 



grant execute on sp_ssis_addlogentry to [domain_name\user_name]


Tag cloud

Month List