In every version of SQL Server new T-SQL features are introduced. These are new T-SQL features of SQL Server 2012.
Sample databases dedicated to SQL Server 2012 RC0 are released. AdventureWorks2008R2_Data.mdf and AdventureWorksDWDenali_Data.mdf are those files. You need to attach these mdf files to your SQL Server instance.
Download these sample data files from here.
New to the Express family, LocalDB is a lightweight version of Express that has all its programmability features, yet runs in user mode and has a fast, zero-configuration installation and short list of pre-requisites. Use this if you need a simple way to create and work with databases from code. It can be bundled with Visual Studio, other Database Development tools, or embedded with an application that needs local databases.
Dropping database from SQL Server is not a major task. However, it can be painful if that database is being used at time of dropping it. Read this FAQ from www.sql-server-performance.com
sp_who2 is function you can use to identify who (Login) is running at what (DBName, command) from where (SPID & Host) as you can see in the following image.
If you look closely, you will see that there are two SPID columns with same values. By looking at them, they are same So let us see the coding of this.
So you would see that SPID column is convert(char(5),spid) so why on earth same column twice.
Just see the comment after second SPID.
Handy extra for right-scrolling users.
Do you agree. I am not 
PowerPivot and Power View Lifecycle and BI Semantic Model (BISM) Overview
AlwaysOn SQL 2012
http://channel9.msdn.com/Blogs/mwilmot/SQLShorts-AlwaysOn-SQL-2012
AlwaysOn Availability Groups for SQL 2012
http://channel9.msdn.com/posts/SQLShorts--AlwaysOn-Availability-Groups-for-SQL-2012
SQL 2012 Apollo Column Store
http://channel9.msdn.com/posts/SQLShorts-SQL-2012-Apollo-Column-Store
I was a speaker at TechInsights 2011 which was held in Malaysia at Monash University Kuala Lampur.
Well, this is my first appearance out side Sri Lanka and was a great experience.
I did two sessions 1. CDC for SCD and 2. Resource Governor. To be honest, first session was not much participated second one was far better.
Here are few photos of the sessions.
Here are Presentations and Samples
SQL Server 2012 Release Candidate 0 is now available for download. SQL Server 2012 RC0 (previously code-named Denali) includes several new capabilities (most of which are related to the release’s new features) that weren’t available in SQL Server Denali CTP3, including the following:
For more information about the upcoming release of SQL Server, see Microsoft’s SQL Server 2012 page. You can download SQL Server 2012 RC0 here.
Let’s start with an example.
You will see that MiddleName column has NULL values. If you want to combine all four columns and display them in one column you will write following query.
Result is,
You will realize the obvious problems from the above result set. To avoid this what you should is, use the ISNULL function.
Though the above will solve your problem, as a developer you need to keep an eye on nullability of the column.
With Denali, you have a new function called CONCAT.
And the result is,
which is what we were looking for.
Next question is, how about the performance.
To answer that I will display query execution plans for two queries, one with CONCAT and the other with ISNULL function.
So there is no additional cost with the new function.
