SQL Server 2008 Extended Events are the new low level, high performance eventing system in SQL Server. They use less system resources and provide better tracking of SQL Server performance than previous methods like Perfmon and SQL Trace/Profiler events. Performance Analysis history – SQL Server 2000 & 2005 In versions prior to SQL Server 2008
Below are the limitations in the SQL Azure CTP1: When writing applications for SQL Azure, you can use the following drivers and libraries: • .NET Framework Data Provider for SQL Server (System.Data.SqlClient) from the .NET Framework 3.5 Service Pack 1 or later. • Entity Framework from the .NET Framework 3.5 Service Pack 1 or later.
SQL Azure team released CTP1 of Microsoft Project Code-Named “Houston” which is available on SQL Azure Labs. This is a new web based tool hosted in Windows Azure that can be used to manage your SQL Azure database. In the past the primary mechanism for managing SQL Azure has been SQL Server Management Studio. For
Basically many of the projects require Base64 Encoding and Decoding for their projects for basic URL Encoding and Decoding. Sometimes the data need to store in the Base64 format in the DB and while fetching need to decode from the Base64 format. The below SQL Server Functions will deserve the basic encoding and decoding features