(Jason Thomas) Recently, Bill Jelen aka Mr Excel came up with a podcast that showcased a visualization that he termed as the “100% Visualization”. I have never seen this visualization before and I am not sure whether Stephen Few would approve of it.

(Jugal Shah) I have a need to monitor the SQL Server Services in my environment. Are there any programmatic options to do so? Check out this tip to learn more.

(WIDBA) How do you move SSIS packages from one server to another when using the SSIS Catalog on SQL Server 2012?

(Ramesh Subramanian) Today I came across a scenario where I had to update a few rows based on the result of another query in another database.

(Kenneth Fisher) When writing a script to change a piece of code, say a stored procedure or view, there are 3 basic options. I’ll start at the outset by saying I use all 3 and that they each have their pluses and minuses.

(Manohar Punna) Install SQL 2005 cluster on Windows 2008 R2. It’s always a new issue. Most of them are known. But last night I installed SQL server 2005 cluster on Windows 2008 R2 64bit and the setup almost completed successfully.

(Vishwanath Dalvi) 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.

(SQLDenis) It is almost 8 years since SQL Server 2005 has been released, we have gotten 3 major versions since SQL Server 2000: SQL Server 2005, SQL Server 2008 and SQL Server 2012.

(Tim Wiseman) Someone can bypass most of the permissions-based limitations on viewing data from a SQL instance by restoring a backup to an instance where they have system administrator privileges. One way to help prevent that from happening is to ensure that the backups are encrypted. In this tip we

Nobody doubts the necessity to create SQL Server backups – I have covered this topic extensively before. The question of where to store the backups however often goes unanswered.