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:

OneNote publishing

I really enjoy using OneNote from Office 2007. It's a little known tool that looks like a notebook on your screen. It allows you to write using keyboard and pen and include other files like video, audio, diagrams... into it.
It is very cool way for people to collaborate on project. I know some companies that were using it to (co)write specs or design documentation in it. All the needed to do was to create a new notebook on shared folder and them everybody can start writing into it (at the same time).

What was missing for me was a way to collaborate over web. Naturally, Microsoft offered a way to collaborate through SharePoint, but I do not have SharePoint available for everything that I do. Is there some alternative that I do not know about?

In cases when you just want to publish your OneNote notebook over the web, you can use OneNote Web Exporter. It creates an .html file and set of OneNote files that you can put on a web server.

Mount ISO file

Somebody in MS, created WinXpVirtualCdControlPanel a small unsupported to for attaching ISO files as virtual CDs. That alleviates a need to burn ISO files on CD or DVD.