If you have installed SQL server 2012 Enterprise Evaluation Edition, this trial software will expire after 180 days without any pre alert notification. This SQL query will show the current version and edition of SQL Server you are using.

Mozilla’s Firefox browser has tremendous flexibility to customize internal settings to make it faster, better, and more productive. However, the plaque of malware has forced Mozilla to add a delay when attempting to install new extensions. Power-users frequently will want to disable this delay.

Whenever you download files using Mozilla Firefox’s default download manager, the browser forces files to be scanned for malware and viruses after downloading. If you only download files from legitimate sources, you can disable this scan to speed up your Firefox experience.

The sharing of files and folders is a very easy task in windows; however, it could also be dangerous, if you are not aware of what files and folders are shared from your computer to your network. Two different methods are described.

SQL Server 2012 has introduced the new logical function IIF(). The behavior of function IIF() is quite similar to CASE and IF statements in SQL Server. Using IIF(), you can use fewer lines of code, and your code will be more readable.

Within Windows 8, Internet Explorer (IE) and many other applications launch automatically in full-screen mode. As this is gaining in popularity, many users are wanting to know how to do this in prior versions of Windows as well. Through these registry changes you can force IE to open in full-screen mode in any version of [...]

SQLCMD command line Utility is an alternative way to execute SQL scripts using the command line. This allows us to execute SQL scripts without touching SQL Server Management Studio (SSMS) GUI.

Facebook has introduced (actually reintroduced) a new feature which suggests a photo tag based on facial recognition. From your previous uploaded photos, it recognizes your identity and suggests a tag when you or your friends upload a photo of you onto Facebook. If this bothers your sense of privacy, you can disable this feature through [...]

SQL Server 2012 introduced the powerful new CHOOSE() function. This tech-recipe will explore its use and common mistakes through some simple examples.

Errors warning that “there is already an object” and that the “database already exists” can easily be avoided by first determining if your table and database have already been created.