The User Profile Synchronization service does not start on a stand-alone installation of SharePoint Server 2010

SharePoint Server 2010  has two installation options:
1- Complete Installation:
     You can add more Web Front End Servers,  Application Services Servers, and DataBase servers to your
    farm.
2- Stand-alone Installation:
    This installs all the components of SharePoint on one server, and you don't have the possibility to join more
     servers to the Farm.

One of the limitations of Stand-alone Scenario is:
"The User Profile Synchronization service is not designed to work on a stand-alone installation of SharePoint Server 2010."

Source:
http://support.microsoft.com/kb/983061

Configuring My Site in SharePoint 2010

The following article explains how to configure My Site in SharePoint 2010.
http://sharepointgeorge.com/2010/configuring-my-site-sharepoint-2010/

Multilingual user interface overview (SharePoint Server 2010)

Dears,
I found the following article from MSDN which explains

• Use and benefits of the multilingual user interface
  
  
• How the multilingual user interface works
  
  
• What is supported by the multilingual user interface
  
  
• Adding and modifying application content
  
  
• Exporting and importing translated content
  
  
• Using the multilingual user interface with managed metadata
  
  
• Limitations of the multilingual user interface 

http://technet.microsoft.com/en-us/library/ff805062.aspx#Section2 

New SharePoint Developer Features in VS2010 SP1 – Unit Testing and IntelliTrace (Saaid Khan)

As part of VS 2010 SP1 SharePoint developers can now take advantage of IntelliTrace as well as create unit tests that use SharePoint API’s.

With 64-bit support now enabled in IntelliTrace, you can use IntelliTrace in your SharePoint farm solutions. You can set a break-point in your code or break execution and then view the IntelliTrace data. You can also collect IntelliTrace data and save the .itrace log file for viewing at a later time. Check out Justin Marks great article on IntelliTrace in VS2010.

For those SharePoint developers that create unit tests, you can now create and execute unit tests for your SharePoint 2010 solutions if they use SharePoint API’s. In order to execute these unit tests you first need to deploy your SharePoint solution to your local developer machine. After that, you can execute the unit tests as you would normally.

Source

Display Success and Error messages in SharePoint 2010

One of the common functions which is required from any developer; is to display a Success and Error messages to the user, and it’s always better to use the same style of the main application.
In SharePoint: SPUtility class contains two methods to achieve this.
Success Message:

SPUtility.TransferToSuccessPage: It is used to display a Success Message, and it has two overloads.

SPUtility.TransferToSuccessPage Method (String message)

Example:

SPUtility.TransferToSuccessPage("Welcome, You are in Success Page");

Figure (1) shows the output of this code. In this case the “Ok” button will redirect to the current SharePoint Site home page.

Figure(1) Success Page

SPUtility.TransferToSuccessPage Method (String message, String nextUrl, String linkText, String linkUrl)

Example:

SPUtility.TransferToSuccessPage("Welcome, You are in Success Page", "/SitePages/Continue.aspx", "", "");

In this case the “Ok” button will redirect to “"/SitePages/Continue.aspx” page.

Error Message:
The same is applied to SPUtility.TransferToErrorPage: it is used to display error message.

SPUtility.TransferToErrorPage(String message)

Example:

SPUtility.TransferToErrorPage("Sorry it seems that you did a mistake. This is the error page"); 

Figure (3) Error Page

SQL 2008 DateTime dataTypes

SQL 2008 introduced new types of DateTime data type (Time, Date, DateTime, DateTime2, SmallDateTime and DateTimeOffset).
The following query example explains the difference between each one of them.

SELECT 
CAST('2007-05-08 12:35:29. 1234567 +12:15' AS time(7)) AS 'Time' 
,CAST('2007-05-08 12:35:29. 1234567 +12:15' AS date) AS 'Date' 
,CAST('2007-05-08 12:35:29.123' AS smalldatetime) AS 'Smalldatetime' 
,CAST('2007-05-08 12:35:29.123' AS datetime) AS 'Datetime' 
,CAST('2007-05-08 12:35:29.1234567+12:15' AS datetime2(7)) AS  'Datetime2'
,CAST('2007-05-08 12:35:29.1234567 +12:15' AS datetimeoffset(7)) AS   'Datetimeoffset'
,CAST('2007-05-08 12:35:29.1234567+12:15' AS datetimeoffset(7)) AS 'Datetimeoffset IS08601';

Here is the result set.

Data type	Output
Time	12:35:29. 1234567
Date	2007-05-08
Smalldatetime	2007-05-08 12:35:00
Datetime	2007-05-08 12:35:29.123
datetime2	2007-05-08 12:35:29. 1234567
Datetimeoffset	2007-05-08 12:35:29.1234567 +12:15

Reference:
MSDN

Filter list of SQL objects in SQL Management Studio

As I believe that to increase your productivity; you have to master using the tools which you are using. SQL Management Studio is one of the tools which is used by any developer during the day.
If you are working in a large project and you have a large number of objects (Tables, Stored Procedures, Functions or Views) in the application database, and you want to edit a certain one. Instead of scrolling up and down and reading the names, you can easily filter the list using the Filter context menu.
The following screen-shots present how you can find a table by name and Creation date.