Selected Tweets of Year 2013!

Another year has come to an end. Being faithful to the “tradition” of posting the last day of every year my selected tweets for the year that ends, here I am again, posting the “Selected Tweets of Year 2013!”. 2013 was remarkable, especially when it comes to Community. Interacting with you, the SQL Server Community … Read more…

Where are Programmability Objects Stored in SQL Server?

SQL Server programmability objects such as stored procedures, functions, assemblies, etc. are widely used, especially in cases of a major database design where you want to have a well-structured database with code reuse and performance.   The need to know where are Programmability Objects Stored in SQL Server Even though many of us use these … Read more…

Monitoring Locking in SQL Server

SQL Server, has a specific dynamic management view (DMV) which provides detailed information regarding the active locks within the SQL Server instance that is, locks that have been already granted or they are waiting to be granted. The DMV is called: sys.dm_tran_locks.   Using the sys.dm_tran_locks DMV for Monitoring Locking in SQL Server The following … Read more…

Snippets Generator v2.1 is Out!

[Update 2018] Please visit Snippet’s Generator page for the latest release of the tool and much more. Our software tool “Snippets Generator” just got new features with its brand new release v2.1! Snippets Generator allows the user to easily create T-SQL snippets for use in SQL Server 2012 SSMS or later! In this new release, the … Read more…

Massively Detaching and Re-attaching Databases in SQL Server

In this article, we will be discussing about massively detaching and re-attaching databases in SQL Server.   Why massively detaching and re-attaching all the databases in a SQL Server instance? There are cases where you might need to massively detach and re-attach all the databases in a SQL Server instance. Such scenario can be a … Read more…

The SELECT ALL USER SECURABLES Permission in SQL Server 2014

The SELECT ALL USER SECURABLES permission in SQL Server 2014 is a very useful new server-level permission. The login that gets granted this permission, can view the data in all databases that the user can connect to. For example, consider a scenario where you have the following three databases: db1 db2 db3 Each database has … Read more…

T-SQL Tip: Inserting Leading Characters to a String

This post, is actually a T-SQL tip, on how to easily insert leading characters to a string. The Scenario for Inserting Leading Characters Consider that  you have a fixed-length table column for which you want to add leading characters, so that all its records, values with the same number of characters. How to Insert Leading … Read more…

CDNUG Event Review – May 22, 2013 – Windows / SQL Azure

Earlier this month, on the 22nd, another Cyprus .NET User Group event took place. The event featured two hourly topics dedicated to the Microsoft Cloud and its services. The first topic was on Windows Azure for Developers and the second on Windows Azure SQL Database, formerly SQL Azure. The event was also live streamed and … Read more…

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…