Stored Procedures in LightSwitch

I do understand that Visual Studio 2010 LightSwitch should be a simple tool for building simple applications, but I would like it to be able to run stored procedures as well.
If you agree with me, please vote for this proposal on Microsoft Connect: https://connect.microsoft.com/VisualStudio/feedback/details/632862/run-stored-procedures-from-lightswitch

As always there is a complicated way to run stored procedures in code.
You could to define a custom WCF RIA Service that exposes your database stored procedures. Then add the RIA Service as a data source.

It is also described in this article:
http://tejana.wordpress.com/2010/12/09/microsoft-lightswitch-and-stored-procedures-using-wcf-ria-services/

However, why should thousands and thousands of developers write something that is relatively complicated and clearly infrastructure work? The deal between business developers and MS developers is that MS provides infrastructure and we do business functionality.

Isn't it better for MS to include this in LightSwich so that developers does not have to write this again and again and again? (Maybe Microsoft should find motivation to do this in how much will they save on support if they do not have to explain and debug this to thousands of people.)

Visual Studio 2010 LightSwitch

Couple of months ago Microsoft announced that they are developing application for creating simple business applications without coding. It is still in Beta 1. This is a simple system that allows you to create forms for aditing database tables and glue them together in an application.

Application built with this are not amazing, but usefull little things that I can quicly deploy to allow customers to search and populate simple set of little tables. Instead of getting an application developer and doing a project for couple of days or weeks, I can provide solution in couple of hours.

Another intersting aspect is that applications can be deployed as Windows (2-tier or 3-tier ClickOnce) or Web (3-tier) applications. This is due to the fact that applications are built on Silverlight platform.

StarInix Database Compare – free SQL Compare alternative

Colleague showed me a nice free program as SQL Compare alternative – StarInix Database Compare. It’s a free program that can compare two database on SQL Server, MySQL or MS Access.

To display TSQL code differences, it invokes ExamDiff  (also freeware and which is installed along with StarInix Database Compare). Unlike Red Gate’s program, it does not produce script that would make databases identical.

Double-hop on SQL Server

How to set delegation for SQL Server?

How to resolve an error like:

Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

It typically occurs when you use linked server – when you request from machine A something from machine B which then requests something from machine C.

Excellent text:

http://kendalvandyke.blogspot.com/2008/11/delegation-what-it-is-and-how-to-set-it.html

Domain Groups membership list?

How to check which Domain Groups are you member of?

> net user MyLogin /domain

List members of Domain Group with Command Prompt NET command

I often look for a way to list members of Active Directory/domain group using NET command from Command Prompt:

>net group MyGroup /domain

SQL Server 2008 R2 Launch in Toronto

Whole day event on Monday May 31,2010 in MARS.

Time		Description
8:00 - 9:00 am		Registration
9:00 - 9:15 am	( SQL PASS Community Representant ) &Daniel Shapiro	Welcome & Introductions
9:15 - 11:15 am	John Hancock	Keynote Presentation: Data Platform Vision & SQL Server 2008 R2 Introduction
SQL Server 2008 R2 Overview: Trusted & Scalable Platform (20 min.), Managed Self-Service BI (20 min.), IT & Developer Efficiency (20 min.)
11:15– 11:30 am	Break	Break	Break	Break
		DBA TRACK	BI TRACK	Visual Studio TRACK
11:30 – 12:30pm	Session Title:	Ensure Business Continuity with SQL Server 2008 R2, Windows Server 2008 & Hyper-V Live Migration	Enable Managed Self-service BI with PowerPivot for Excel and SharePoint 2010	Developing SQL Applications with Visual Studio 2010
Speaker:	Saleem Kanji	Howard Morgenstern	Adam Gallant and Paul Sanford
Content Link:			TBC
12:30 - 1:30 pm		Lunch	Lunch	Lunch
1:30 – 2:30pm	Session Title:	Simplify management of your SQL Server data platform with Multi-server Management	Achieve Rapid Reporting with Reporting Services and Report Builder 3.0	Managing Change for SQL Server applications using Team Foundation Server
Speaker:	Marc Theoret	Doug Harrison	Adam Gallant and Paul Sanford
Content Link:
2:30 - 2:45 pm	Break	Break	Break	Break
2:45 – 3:45 pm	Session Title:	Deliver unprecedented access to business-critical data at a lower TCO with SQL Server 2008 R2 Parallel Data Warehouse	Importance of Master Data Management	Targeting SQL Azure using Visual Studio
Speaker:	Doug Harrison	Marc theoret	David Remmer
Content Link: