Sunday, March 10, 2013

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
  • Easier and Faster Programming
  • A method of defining coding standards
SQL Server 2012 provides the functionality of Code Snippets similarly as offered in Visual Studio thus making writing code in SSMS 2012 an even richer experience.

In the screencast, you can see how you can easily create snippets using my freeware tool "Snippets Generator for SQL Server 2012" and how to import it and use it in SSMS 2012.

You can watch the screencast below or at the "SQL Server and .NET TV":

Check out my latest eBook on SQL Server:
Tuning SQL Server - Ebook

Easily secure your SQL Server instances! Try out DBA Security Advisor!
DBA Security Advisor for SQL Server by SQLArtBits
DBA Security Advisor was developed by SQLArtBits. The tool was being carefully developed for an entire year and it contains comprehensive security checks and recommendations based on proven SQL Server security best practices. Feel free to download and use the Community Edition which is free and if you find it useful, you can consider upgrading to the Enterprise Edition!

Artemakis Artemiou [MVP]

Author & Editor

Artemakis Artemiou is a Senior SQL Server Architect, Software Developer and Microsoft Data Platform MVP. He is also an author, regular blogger, president of Cyprus.NET User Group and CY Country leader of INETA-EU. He is also the creator of DBA Security Advisor and In-Memory OLTP Simulator. Artemakis is a frequent guest author of worldwide well-respected online journals where he writes articles focusing on many SQL Server topics.

Reference: The SQL Server and .NET Hub (