Ιούλιος 2012 - Δημοσιεύσεις
In this post I would like to demonstrate with a hands-on example how to use the new THROW statement available to us for error handling in SQL Server 2012. Well, most of you know that we have TRY-CATCH statements for exception handling since SQL Server
Διαβάστε περισσότερα
In this post I would like to demonstrate with a few examples how to use the new DMOs (Dynamic Management Objects – DMVs & DMFs) that are available to us with the RTM version of SQL Server 2012.Some of them were present in SQL Server 2008 R2 SP1 but
Διαβάστε περισσότερα
In this post I would like to provide you with a hands-on example on how to perform a Page Restore using the SSMS in SQL Server 2012.We could perform page restores in SQL Server 2005/2008 (with T-SQL ) but in SQL Server 2012 we have SSMS UI support for
Διαβάστε περισσότερα
In this post I will explain when the actual caching (the stored procedure is placed in the procedure cache ) takes place. Many people think that the execution plan of a stored procedure is cached in the procedure cache when the stored procedure is created.
Διαβάστε περισσότερα
In this post Ι would like to demonstrate with a hands-on example the negative performance implications when using built-in or user defined functions in a WHERE statement of a SQL query. ( read more )
Διαβάστε περισσότερα
In this rather short post , I would like to talk about a very handy and easy to use tool (SQL Space Map) that makes it very easy to identify space utilisation for a particular database in our SQL Server instance. ( read more )
Διαβάστε περισσότερα
In this post I would like to talk about various reports ( SQL Server 2012 Performance Dashboard Reports ) that are available to us (through Microsoft Download) and their purpose is to give us an overview of the overall performance of an SQL Server instance.Basically
Διαβάστε περισσότερα
I will be writing a new series of posts about the new T-SQL functions that are available to us in SQL Server 2012. In this rather sort post I will demonstrate with hands-on examples how to use the new string function,CONCAT(). ( read more )
Διαβάστε περισσότερα
I will be writing a new series of posts about the new T-SQL functions that are available to us in SQL Server 2012. In this rather sort post I will demonstrate with a hands-on examples how to use 3 new conversion functions in SQL Server 2012, PARSE, TRY_CONVERT
Διαβάστε περισσότερα
I will be writing a new series of posts about the new T-SQL functions that are available to us in SQL Server 2012. In this rather sort post I will demonstrate with a hands-on examples how to use 2 new logical functions in SQL Server 2012, CHOOSE and IIF.
Διαβάστε περισσότερα
In this post I will demonstrate how to install SQL Server 2012 in your machine. I had no intention of writing such a post but I installed SQL Server 2012 Developer edition a few weeks back in my Windows 7 Ultimate SP1 laptop and it worked just fine.Then
Διαβάστε περισσότερα
In this post I would like to talk about a new security enhancement that was introduced in SQL Server 2012,user defined server roles.As we all know we had (and still have in SQL Server 2012) user defined database roles for database level permissions.In
Διαβάστε περισσότερα
In this post I would like to demonstrate with a hands-on example how to backup and restore the tail of the transaction log.In this post I will also demonstrate how to take full and differential backups and how to restore them. I will also talk about the
Διαβάστε περισσότερα