If you are working with SQL Server then you might already have used this great cycle selling company’s database (AdventureWorks) at least once. Microsoft has created this cycle selling company database for SQL Server 2005 and later versions, before this sample we had “NorthWind” database. Anyways, if you try to install these sample databases you
Intellisense in SQL Server 2008 r2 management studio
This quick post is about my recent experience with SSMS for SQL Server 2008 r2. Usually I use some other 3rd party tool for SQL Server Development because it is sort of more easier to use when we are developing (but that tool is not good at all when it comes to managing SQL Server).
Can’t access local SQL Server Reporting Server’s Report manger
Yes, though it sounds really strange for local instance of SQL Server Reporting Service (AKA SSRS) it is very real issue, specially if you are using Windows Vista (however I don’t understand why would someone use it )or 7. It is mainly because of new feature called User Access Control (UAC) which prevents system level
Blinking Light Animation in Silverlight using Expression Blend
Before even anyone of you look at my animation, let me clarify again that I DON’T HAVE DESIGNER’S EYE … which basically means if you are looking for some really cool UI then you are at wrong place. With that info. noted I also would like to let you know that though I am not
X Files are real !!!
Well, not real as in some FBI agents trying to solve cases with unexplained phenomenal activity (or may be there are some ! who knows) …. well, for me X file case is like occurrence of some unexplained event and there is no clear explanation of what actually happened. That is exactly what happened yesterday
Styles in Silverlight – Part 1
Honestly, I don’t have so called “designer’s eye”. So I am really bad with designing. I think this is the curse that every developer bares … or may be it is a good thing, who knows. So the demo I am showing here is not so eye catching, but this solves the purpose so I
‘Delete ‘ with Alias in T-SQL
Last week I was working on something where I was required to write a delete query against few records in table. Now a days I am kind of habituated to use alias for tables whenever I write any query (mostly because of tool I am we are using for SQL development, which don’t have intellisence