Yearly Archives: 2012

Microsoft SQL Server 2012 introduces 14 new built-in functions. These functions are divided into 4 categories. In this article I will be covering usage & functionality of these new 14 functions. I strongly feel, these functions are very useful for developer point of view. These new functions are: 1) Conversion functions · PARSE (Transact-SQL) · … Continue reading →

I am trying to restore database on SQL cluster & failover happen. Once the SQL Server came up on the other node all the databases came up, except for the database which was in restoration prior to the failover. Now, We have 2 options one is to restore database again or second to start restore … Continue reading →

In previous versions of SQL Server, the user-defined role-based security are there in order to achieve access rights as per requirement. The user-defined role customized roles at the database level, not at the server level. This is because at the server level, administrators had to use fixed roles. Server roles were fixed and could not … Continue reading →

With the introduction of the Database Recovery Advisor, restoring databases to a point in time will be made much easier. SQL Server provides a variety of backup types & creating the right recovery sequence for any point in time can get tricky. To help make this process much more streamlined, SQL Server 2012 introduces a … Continue reading →

Variable Type Description %ALLUSERSPROFILE% Local Returns the location of the All Users Profile. %APPDATA% Local Returns the location where applications store data by default. %CD% Local Returns the current directory string. %CMDCMDLINE% Local Returns the exact command line used to start the current Cmd.exe. %LOGONSEVER% Local Returns the name of the domain controller that validated … Continue reading →