Screencast: Working with Snippets in SQL Server 2012

Welcome to another screencast of the “SQL Server 2012 Screencast Series“! In this short screencast we talk about code snippets in SQL Server 2012 Management Studio. Code Snippets are being used for many years now by developers in Integrated Development Environments (IDEs) like Microsoft Visual Studio. Their benefits vary. Some of them are: Code Reuse … Read more…

Screencast: Migrating to a Contained Database in SQL Server 2012 or later

Via this post, you can watch an interesting screencast, about Migrating to a Contained Database in SQL Server 2012 or later.   Introduction: What are Contained Databases in SQL Server? Contained Databases is an exciting new feature, originally shipped with SQL Server 2012. Among other, it introduces a more robust security model where you can … Read more…

[Webcast] SQL Server 2012: The Database Engine

– Celebrating 250.000+ Visits! – SQL Server 2012 shipped with a plethora of useful new features. In this webcast we will see the majority of the Database Engine features. To this end, we are going to see enhancements that fall into the following SQL Server areas: High Availability Manageability Enhancements Programmability Performance & Scalability Security … Read more…

Sequence Objects in SQL Server 2012 and Later

In this article, we will be discussing about Sequence objects in SQL Server 2012 and later, and see a relevant example. In an older article on our blog, we wrote on how someone can mimic the operation of Sequence Objects using other alternative ways. However, since SQL Server 2012 and later, Sequence Objects are available … Read more…

Webcast: Introducing SQL Server 2012 “Denali” (CTP1)

Hello and Happy New Year 2011! Wishing all the best, always in good health! Microsoft has recently released CTP1 of SQL Server 2012 codenamed “Denali“. This new version of SQL Server Server introduces many new features that increase productivity and reduce the development and administration effort. One of my main observations is that there is … Read more…