SQL Server Interview questions - Submit yours

By Rajib Bahar at January 26, 2009 06:44
Filed Under: SQL
I get a lot of questions from my peers about finding a good place to get SQL server interview questions. I have had the privilege of being both the interviewor and interviewee. So, I thought I'd put together a collection on my blog. I look forward to hearing your comments. Please post your favorite or most challenging questions on SQL server.

Here is the list of links to blogs and/or websites that I found useful:

VLDB - What's the largest database have you worked with?

By Rajib Bahar at January 19, 2009 15:52
Filed Under:
I am asking this question to all of my SQL Server colleagues. There is no right or wrong answer to this. I am interested in learning the experience others have with VLDB systems. Please share your stories. I will compile the responses and make a newer blog entry. That new entry will have your story and link back to your blog if you have any. Feel free to send your responses via facebook, twitter, plaxo, linkedin, livespace, and email. Thanks

MS SQL Server 2008 Debugging

By Rajib Bahar at January 15, 2009 21:20
Filed Under: SQL
I like the new debugging capabilities of SQL Server 2008. It brings in features such as stepping in, stepping out, and stepping over. This can come handy when we are trying to track the actual issue. I found this feature interesting because it empowers developers to track issues at the most granular level. Now, we can step inside system functions, and stored procedures to figure out the values of internal variables and sets. See the video below for a quick guide on how to debug in SQL Server 2008 management studio.

SQLServerpedia is the wikipedia for MSSQL server pros

By Rajib Bahar at January 09, 2009 07:02
Filed Under: Interesting, SQL

I ran into SQLServerpedia.com recently. I thought the concept was interesting. Kevin Kline and his colleagues launched that portal. Just like Wikipedia, users can edit entries related to MS SQL server. This will be a useful work related resource for me.

After reading the entries at the SQL server wiki site, I ran into another site that had an intersting tool. They call it TallEye. The purpose of that tool is to find out where you end up after digging a very deep hole from any location in the world map. So, I dug hole at Bangladesh and found out I'd emerge in South Pacific ocean. Interestingly enough, they did not advise how to bypass the core of earth.

Kahar interviews Garry Schyman at KFAI radio - Part 2

By Rajib Bahar at January 08, 2009 18:00
Filed Under:


Kahar interviews Garry Schyman at KFAI radio. Garry Schyman is well known for his composition work on the game BioShock 1 and 2. He is also behind the internet hit song "Praan".
----

Feel free to reach out to me at my blog:
http://www.rajib-bahar.com

Other sites of interest:
http://www.kfai.org
http://www.youtube.com/kfairadio
http://www.youtube.com/rajib2k5

http://www.youtube.com/rajib2k5

Kahar interviews Garry Schyman at KFAI Radio - Part 1

By Rajib Bahar at January 08, 2009 18:00
Filed Under:


Kahar interviews Garry Schyman at KFAI radio. Garry Schyman is well known for his composition work on the game BioShock 1 and 2. He is also behind the internet hit song "Praan".
----

Feel free to reach out to me at my blog:
http://www.rajib-bahar.com

Other sites of interest:
http://www.kfai.org
http://www.youtube.com/kfairadio
http://www.youtube.com/rajib2k5

http://www.youtube.com/rajib2k5

Kahar interviews Garry Schyman at KFAI radio - Part 3

By Rajib Bahar at January 08, 2009 18:00
Filed Under:


Kahar interviews Garry Schyman at KFAI radio. Garry Schyman is well known for his composition work on the game BioShock 1 and 2. He is also behind the internet hit song "Praan".
----

Feel free to reach out to me at my blog:
http://www.rajib-bahar.com

Other sites of interest:
http://www.kfai.org
http://www.youtube.com/kfairadio
http://www.youtube.com/rajib2k5

http://www.youtube.com/rajib2k5

Kahar interviews Garry Schyman at KFAI radio - Part 4

By Rajib Bahar at January 08, 2009 18:00
Filed Under:


Kahar interviews Garry Schyman at KFAI radio. Garry Schyman is well known for his composition work on the game BioShock 1 and 2. He is also behind the internet hit song "Praan".
----

Feel free to reach out to me at my blog:
http://www.rajib-bahar.com

Other sites of interest:
http://www.kfai.org
http://www.youtube.com/kfairadio
http://www.youtube.com/rajib2k5

http://www.youtube.com/rajib2k5

KFAI - Bangla music show hosted by Kahar and Dolly Khondkar

By Rajib Bahar at January 05, 2009 18:00
Filed Under:


This is just a behind the scene clip of the Bangla Music Show by Kahar and Dolly...

http://www.youtube.com/rajib2k5

Experimenting with social media API in .NET and SQL

By Rajib Bahar at January 03, 2009 10:14
Filed Under: SQL, .NET
I started experimenting with Social Media Api such as Facebook, Twitter, GData. There are plenty of libraries in .NET one can take advantage of. Just for fun, I wrote one tool that allows users to save wikipedia articles locally. The data resides in a local SQL compact database. This .NET app integrates status message functionality from facebook and twitter. Feel free to check it out at http://apps.facebook.com/wikiarticlesaver

These days I am also looking at TokBox api. In my humble opinion, Toxbox is a video chat service which integrates the best features in video conferencing, youtube, and skype. I love it. Most recently, I added some of my friends such as Garry Schyman and others there. TokBox was founded by one of the co-founder of youtube, Jawed Karim.

See below for a way to integrate TokBox in a site:
<object type="application/x-shockwave-flash" data="http://www.tokbox.com/vc/al8iat0y002k9zad" width="300" height="413" pid="495fd42c4c185981"><param name="movie" value="http://www.tokbox.com/vc/al8iat0y002k9zad"/><param name="allowFullScreen" value="true"/><param name="flashvars" value="guestList=true&textChat=true"/></object>

Tag cloud

Month List