What is ITIL? In simple words please…

By Sunday, September 14, 2014 Permalink 2

For the last four weeks or so I have done some after-work study to get my ITIL® Foundation certification. In this post I share with you my understanding of ITIL® as a concept. The Information Technology Infrastructure Library or ITIL® can be seen as a set of best practices for IT service management. The classic definition ...

Shrinking SQL Server Transaction Logs

By Wednesday, September 10, 2014 Permalink 1

Under some specific circumstances you will find yourself in the need of reducing/shrinking the physical size of transaction logs. Let's see a quick example of how to achieve this: 1) You can use DBCC SQLPERF (LOGSPACE) to quickly and easily list the size and percentage of use of all your databases' transaction logs. You will get something like ...

SQL Server 2014 is here!

By Wednesday, September 10, 2014 Permalink 0

I believe that some of us are still catching up with all the new great features introduced by SQL Server 2012 and now there is more work to do as with April came the general availability of SQL Server 2014, so what's new with SQL Server 2014?With this release, perhaps due to the short time-span ...