Great Movies!! But No Repeat Value..

• Hazaaron Khwahishen Aisi
• Ek Chalis Ki Last Local
• Johny Gaddar

Comics:: Herb & Jamaal

English::

Chiaroscuro

PritishNandy 09 June 2010

Yesterday was awful, remembering the Bhopal trauma, a story I had covered with grief and anger. This morning, the rains washed it all away.
Every grief we feel is so quickly replaced by beauty, joy, hope. I guess this makes life so magical. This chiaroscuro of pain and delight

chiaroscuro
A monochrome picture made by using several different shades of the same colour

However, my own painting that Salman has no magnanimously displayed is so esoteric, that even I don't know what exactly it is

Confined to and understandable by only an enlightened inner circle

SQL Server

SQL Server 2008 - Trouble exploring databases node with newly created user. Grant new user rights for each of the databases with no rights http://connect.microsoft.com/SQLServer/feedback/details/424329/the-server-principal-testuser-is-not-able-to-access-the-database-msdb-under-the-current-security-context https://www.orcsweb.com/blog/desiree/the-server-principal-a-is-not-able-to-access-the-database-b-under-the-current-security-context-microsoft-sql-server-error-916/ http://blogs.msdn.com/b/euanga/archive/2006/05/04/585513.aspx

How to identify your SQL Server version and edition? SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') http://support.microsoft.com/kb/321185

How To: Reset Identity column in SQL Server DBCC CHECKIDENT('Customer', RESEED, 0) http://geekswithblogs.net/TakeNote/archive/2007/11/30/117258.aspx

List All the Tables for All Databases sp_msforeachdb 'select "?" AS db, * from [?].sys.tables' http://blog.sqlauthority.com/2009/04/26/sql-server-list-all-the-tables-for-all-databases-using-system-tables/

SQL Documentation BI Documenter - http://msdn.microsoft.com/en-us/magazine/ee335714.aspx SQL Doc - http://www.simple-talk.com/sql/sql-tools/database-documentation-using-sql-doc/ Code project - http://www.codeproject.com/KB/database/sqldoc.aspx

Error: Saving changes not permitted Menu >> Tools >> Options >> Designers >> Uncheck “Prevent Saving changes that require table re-creation http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-–-fix-management-studio-error-saving-changes-in-not-permitted-the-changes-you-have-made-require-the-following-tables-to-be-dropped-and-re-created-you-have-either-made-changes/

SQL Server Performace

Tip of the Day #5 (SQL Server memory usage) http://blog.colinmackay.net/archive/2008/07/20/2996.aspx

SQL Server queries with DMVs for examining bottlenecks *** http://searchsqlserver.techtarget.com/tutorial/SQL-Server-queries-with-DMVs-for-examining-bottlenecks

Using COALESCE to Build Comma-Delimited String

http://www.sqlteam.com/article/using-coalesce-to-build-comma-delimited-string

Download details: Microsoft® SQL Server® 2008 Express with Advanced Services http://www.microsoft.com/downloads/en/details.aspx?FamilyId=B5D1B8C3-FDA5-4508-B0D0-1311D670E336&displaylang=en

SqlMag article: SQL Server 2008 Express Editions http://www.sqlmag.com/article/sql-server-2005-express/sql-server-2008-express-editions.aspx

Silverlight:: Get User Name

• http://stackoverflow.com/questions/1176566/get-current-windows-user-name-within-silverlight
  
• Silverlight Windows User Identity Name
  
• http://stackoverflow.com/questions/1176566/get-current-windows-user-name-within-silverlight
  
• http://forums.silverlight.net/forums/t/10809.aspx
  

Silverlight

Cynergy

http://www.cynergysystems.com/blogs/page/rickbarraza

Watermark Textbox

http://www.solutionbot.com/2010/06/02/silverlight-watermark-textbox/

Silent installation

http://timheuer.com/blog/archive/2010/03/25/using-sllauncher-for-silent-install-silverlight-application.aspx

Duplex pooling

http://www.lightstreamer.com/demo/Silverlight_StockListDemo/

Comet

http://cometdaily.com/2009/10/23/concrete-comet-examples/

RIA & MVVM

http://wildermuth.com/2009/12/15/Architecting_Silverlight_4_with_RIA_Services_MEF_and_MVVM_-_Part_1

VS 2010 Binding Builder Feature

http://blogs.msdn.com/b/wpfsldesigner/archive/2010/06/14/how-to-enable-using-the-binding-builder-in-wpf-and-silverlight-applications.aspx

Customize Splash Screen

1. Custom Loading Screens in Silverlight *** http://pagebrooks.com/archive/2009/02/19/custom-loading-screens-in-silverlight.aspx

2. SilverZine Tutorial - Splash screens and Loaders in Silverlight http://silverzine.com/tutorials/splash-screens-and-loaders-in-silverlight/

Bind ComboBox with DataGrid

ComboBox in DataGrid - Manish Dalal's blog *** http://weblogs.asp.net/manishdalal/archive/2008/09/28/combobox-in-datagrid.aspx

Defining Silverlight DataGrid Columns at Runtime - Scott Morrison - Site Home - MSDN Blogs ** http://blogs.msdn.com/b/scmorris/archive/2008/04/14/defining-silverlight-datagrid-columns-at-runtime.aspx

Custom Controls

Creating a Silverlight Custom Control (LinkLabel control)- The Basics http://www.silverlightshow.net/items/Creating-a-Silverlight-Custom-Control-The-Basics.aspx

Combo Box

Rapid Access Key Selector Behavior for ComboBox and ListBox *** http://gallery.expression.microsoft.com/en-us/RapidAccessKey

Use Styles for an editable Silverlight ComboBox **** http://timheuer.com/blog/archive/2008/11/05/silverlight-editable-combobox-using-styles.aspx

Download details: Microsoft Expression Blend Software Development Kit (SDK) for Silverlight 4

http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=d197f51a-de07-4edf- 9cba-1f1b4a22110d

Telerik Blogs > Server-side paging, sorting and filtering for your Silverlight DataGrid http://blogs.telerik.com/blogs/posts/09-01-21/Server-side_paging_sorting_and_filtering_for_your_Silverlight_DataGrid.aspx

Telerik Recruiting Application

http://blogs.telerik.com/blogs/posts/10-04-08/silverlight_recruiting_application_wrap-up_and_source_code.aspx

Expression Blend templates, Part 1 – Understanding templates http://expressioniq.com/?p=60

TED: Sunitha Krishnan fights sex slavery

Windows Vista:: how to delete failed mapped network drive?

NET USE * /delete will delete all network drives and printers. Replace the * with the full UNC path and share name to delete a specific connection to a share. A standard user may not have the rights to disconnect from a network share.

http://www.dslreports.com/forum/r19451998-Vista-how-to-delete-failed-mapped-network-drive

Analysis Services:: Problem Starting SQL Server Analysis Services.

For those who are facing problem in Starting SQL Server Analysis Services, please follow the following steps to fix the issue.

Open Control Panel
Go to Regional and Language Options Locale Settings
Change the Format, Location and Administrative from English(India) to English(United States)
Restart the System
Once your system is Restarted open the Registry Editor (from Start = > Run => regedit)
Navigate to HKEY_USERS
Look for LSA entry @ S-1-5-18
Search for LocaleName
Update the following keys
Locale = 00000409
LocaleName = en-US
sCountry = United States
10. Open the SQL Server Configuration Manager, and start the SQL Server Analysis Services.

FYI: This is caused because Windows Vista is supporting en-IN whereas SQL Server 2005 does not provide support for en-IN, so if you try to run SQL Server Analysis Services it will give the following exception (can be found in Event Viewer)

The service cannot be started: Message-handling subsystem: The message manager for the default locale cannot be found. The locale will be changed to US English. Errors in the metadata manager. LOG file extension can be only .LOG. Message-handling subsystem: The message manager for the default locale cannot be found. The locale will be changed to US English. Message-handling subsystem: The message manager for the 16393 locale cannot be found. Internal error: Failed to generate a hash string.

http://dotnetslackers.com/Community/blogs/bmdayal/archive/2009/04/04/problem-starting-sql-server-analysis-services.aspx

Reporting Services:: Subscription Fail - The user or group name ‘Domain\User’ is not recognized

For any of you that work closely with Reporting Services, I am sure you can vouch that the system offers a great amount of flexibility and capability. At the same time though you also have probably encountered your fair share of strange, random and undocumented issues. One today I found happened with a Subscription.

Failed sending mail: The user or group name ‘Domain\UserNoMore’ is not recognized

Recently, we had a user leave the company. For the sake of this article we will happily refer to him as UserNoMore. When you create a subscription you are not propted to define an owner. You get the happy assignement automagically. When the user account is deactivated authentication ceases and emails and file archives begin to fail.

In my experience here it took a little finess and hackery to correct. Now let me first say I niether condone nore dismiss the need of making direct changes to data. So in this case after attempting any known fix or finding any interface I determined the fix would be in a bit of DML. Really the fix was pretty simple. Find the subscription, determine a different user to own, update the subscriptions. In this case I selected the service account for Reporting Services so I wouldn’t have to worry later (and I guess technically you could do this for all subscriptions if thats how you shop is set security wise).

In the ReportServer$InstanceName database for reporting services you will find 3 key tables:

Catalog – Reports, Folders and basically all Items
Subscriptions – The scheduled report processes
User – Well…any user or group in Reporting Services

Step 1- Get the Report ID in Question

SELECT ItemID, Name
FROM [ReportServer$InstanceName].[dbo].[Catalog]
WHERE [Name] =‘MonthlySalesReport’
and [Type] = 2 –Report Item Type

Step 2 – Find the Subscription

SELECT

[SubscriptionID],[OwnerID],[Report_OID]
FROM [ReportServer$InstanceName].[dbo].[Subscriptions]
WHERE [Report_OID] = ’1551AA5B-0FF1-494B-8725-73E22AA34D9F’

Step 3 – Select another User

SELECT [UserID],[UserName]
FROM [ReportServer$InstanceName].[dbo].[Users]
WHERE [UserName] = ‘Domain\RSServiceAccount’

Step 4 – Update the Subscription

UPDATE

[ReportServer$InstanceName].[dbo].[Subscriptions]
SET [OwnerID] = ’6BDB4964-EE28-4E96-BCB2-E4509FAC909B’
WHERE [OwnerID] = ’3D272CE2-A9B3-4B89-8993-C72E8D43A6EE’
AND [Report_OID] = ’1551AA5B-0FF1-494B-8725-73E22AA34D9F’

Really an easy fix…not clean but it worked for me. Feel free to provide feedback.

Enjoy!

http://speeddba.wordpress.com/2008/10/17/failed-sending-mail-the-user-or-group-name-domainuser-is-not-recognized/

Set permissions on SSRS

1. Run Sql Server Management Studio as Administrator (right click "Run as Administrator")
2. Connect to a Reporting Services server using Windows Authentication.
3. Right click Home, Select Properties, Select Permissions.
4. Click Add Group or User, Type your Username, Click Ok.
5. Check the box for Content Manager, Click Ok.

Now you can access Reporting Services via Sql Server Management Console without running as administrator.

You should also have permissions to browse Report Manager (http://localhost/Reports). If not, but you do see the Information Bar complaining then add http://localhost/ to Explorer's Trusted Sites Zone.

How to Disable Adobe Updater

1. Step
   1. 1

   Open "My Computer" by double-clicking on the desktop icon or clicking on the "Start" menu and selecting the "My Computer" button. Open the drive that contains your Adobe programs. By default, this is the "C" drive.

2. Step2

   Double-click on "Program Files" to view software files installed on your computer. Open the "Common Files" folder by double-clicking on the folder name.

3. Step3

   Locate the Adobe folder and double-click on it to open it. The Adobe folder contains files for all Adobe programs installed on your system. Locate and open the Adobe Updater folder, which will be named "Updater" followed by a version number, such as 5 or 6.

4. Step4

   Locate the executable file titled "Adobe Updater" within the "Updater" folder. Double-click the file to initiate the Adobe Updater application. The program will take a few moments to connect to the Internet to search for updates.

5. Step5

   After it finishes searching, a prompt window will appear to install new updates. Click "Preferences" on the left-hand side and uncheck the "Automatically check for Adobe updates" box. Click "OK" to accept the changes. Adobe Updater will not check for available updates unless manually instructed to do so.

   
   

http://www.ehow.com/how_5098323_disable-adobe-updater.html

SubSonic 2.x

http://www.codeproject.com/KB/database/SubsonicDAL.aspx

SQL Server:: VIEW in a VIEW

AVOID REUSING VIEW IN ANOTHER VIEW

Subsonic

SubSonic2

Work through

http://www.codeproject.com/KB/database/SubsonicDAL.aspx

SubSonic3

FAQ

http://subsonicproject.com/docs/SubSonic_3_Frequently_Asked_Questions

How to generate classes for Views

http://stackoverflow.com/questions/1078311/sql-views-in-subsonic-3-0

Classes generated for View DO NOT work
http://stackoverflow.com/questions/1299998/activerecord-and-gethashcode-fails-if-int-is-nullable

Detect asynchronous postback in ASP.NET | SharePoint 2010, SharePoint, C-sharp, ASP.Net, JQuery, SQL Server Solutions

Detect asynchronous postback in ASP.NET | SharePoint 2010, SharePoint, C-sharp, ASP.Net, JQuery, SQL Server Solutions

Java Script

Lesson 1
Lesson 2

SQL Server :: Storing Images and BLOB files

1. Insert BLOB 
   

   INSERT INTO BLOBTest (BLOBName, BLOBData)  
   

    SELECT 'First test file',    
   

     BulkColumn FROM OPENROWSET(Bulk 'C:\temp\nextup.jpg', SINGLE_BLOB) AS BLOB 
   

 

http://www.databasejournal.com/features/mssql/article.php/3724556/Storing-Images-and-BLOB-files-in-SQL-Server-Part-2.htm

 

1. Export BLOB 
   

   bcp "select datei from Person.Address WHERE
   addressid=1 " queryout "c:\TestOut.doc" -T -n -Slocalhost\AdventureWorks
   

http://www.sqlservercentral.com/Forums/Topic487470-338-1.aspx

IEBlog : Introducing IE=EmulateIE7

IEBlog : Introducing IE=EmulateIE7: ""

Where have all the good guys gone?

Pritish Nandy, 12 April 2010, 11:17 AM IST

I was born into a world without villains. The British had left India. We were a free nation. There were many heroes: Gandhi, Subhash Bose, Sri Aurobindo, Nehru, Sardar Patel, Maulana Azad, Ambedkar. Remarkable guys who fought, each in his own way to bring us freedom. A spanking new nation was about to be built. Everyone was excited. It was heady times; it felt great to be an Indian. All our other identities were subsumed.

Yes, there was a bloody Partition. Many had lost their homes and families. Some people were angry, very angry, but that anger was specific. It was directed at those responsible for the bloodshed. It was not free floating rage. No one in those days was stupid enough to confuse Pakistanis with Muslims or the British with Christians. Everyone was anxious to put the past behind and get on with the task of building a new India. Since I grew up in Kolkata I met many people, Hindus and Muslims, who had fled what was then East Pakistan. They were trying hard to rebuild their lives. The locals did not see them as unwelcome immigrants. Instead, they went out of their way to help them. I remember my mother giving her blouses to a refugee woman to embroider even though she could barely afford it on her meagre school teacher’s salary.

There was magic in the air, the magic of nation building. There were dreams that everyone dreamt, of creating a new India where we would all be Indians first. In our living room hung pictures of Rabindranath Tagore, Gandhi, Subhash Bose. My father would proudly tell me stories of the freedom struggle and politicians were then our biggest heroes. No, I never heard of a film star or a cricketer then. We spoke only about politicians and how they would change India. We believed in them. We admired them.

By the time I was in high school things had changed. People were burning buses and trams to protest against a one paisa ticket price rise. It wasn’t actually the price rise. It was free floating rage against being let down by the political class. When I joined college, the best students of my class vanished one day only to surface in Naxalbari fighting for what they saw as a just cause, the rights of the rural poor. I may not have agreed with them but like all young men of the time I believed in the good fight. Student politics in Europe was hotting up. Tariq Ali in England, Daniel Cohn-Bendit in Paris, Rudi Dutschke in Germany inspired the May uprising in Europe. Governments began to feel threatened by youth power. Che was the new idol and young people swore by his vision of a new world. But no, it didn’t take long for disenchantment to set in. Marxism became the God that failed.

It wasn’t only Marxism. Politics failed India. Pictures of politicians in the living rooms disappeared. We read about bloody clashes between political parties, religious groups, castes, communities. Regional issues reared their head. New conflicts emerged. We began to hear of crimes we had never heard before. Suddenly there were villains all around. People we began to hate, who were among us but not one of us. Politics became murky; we began to seek our heroes elsewhere. Actors became stars. So did writers, singers, journalists, sports people. Doctors, teachers, social workers were still respected. Some of them migrated to politics, won elections. But our world without villains had changed forever.

Today we live in a world where villains are everywhere. Politics has more than its share and even though everyone wants to be in politics, the reasons are different. Politics hardly offers nation building opportunities. It offers money, power, pelf. So do some other professions as well but politics is the shortest cut. That’s because at the heart of it lies all pervasive corruption. An honest politician today is as rare as the mountain quail that ornithologist Salim Ali spent his whole life searching for. When I began my life as a journalist, it was possible to expose a corrupt neta and see him sacked or punished. Today, if you expose a corrupt neta, you are more likely to get sacked yourself.

Then there are the other villains around us. Terrorists, extortionists, underworld syndicates, Maoists (often confused with the Naxalites of yore), the khaps who love to murder their own, suicide bombers fighting for lost causes, bigots who beat up young girls for drinking or wearing short dresses, fundamentalists constantly in search of new victims, regional groups who see other Indians as the enemy, book burners, art vandals, hackers, poachers who are wiping out entire animal species, corrupt Government officers, rogue policemen, environmental predators, fake drug manufacturers, the land mafia encroaching on public land in connivance with those who are supposed to protect it. The villains are everywhere, growing by the day. Where have the heroes gone? I often wonder. Where’s the India we once dreamt of?