Saturday, February 14, 2015

One Important Aspect - Mentor

Looking back to my education and career journey, there were times when I felt like it was totally stagnant, and other times of leap and bound moment.

Monday, February 2, 2015

Execute SSIS remotely - PowerShell

Since SQL Server 2012, Microsoft introduce a new way of interacting and storing SSIS package. SSIS packages are frequently executed in scheduling format often through SQL Server agent jobs. Today blog post will be focusing on remotely calling SSIS package stored in this new SSISDB Catalog.

Wednesday, January 7, 2015

SQL Server Database File - Date Modified

Recently, there was a discussion if the date modified of the database files shown in Windows explorer could be used to determine when the database was last used (or recently used). Often, this date is used to determine when a file (eg. word, excel) is last updated. Could that also be applied to SQL Serve database?

Sunday, January 4, 2015

Microsoft Specialist - Implementing Microsoft Azure Architecture Solutions

I have been using Microsoft Azure with credit from MSDN subscription (Free credit! See the MSDN subscription section on this post) for sometimes now. Mostly for VMs and SQL Database (Microsoft Azure SQL Database). Recently I have also started exploring other Azure services like Azure Active Directory for cloud identity and access management, as well as deploying and implementing .NET web application to Azure Websites along with Visual Studio Online.

Monday, December 1, 2014

SSIS Connection Manager Properties

The SSIS packages stored in SSIS Catalog (introduced in SQL Server 2012, and also SQL Server 2014) allow configuration changes made on the project or the package connection managers, depending how the connection was setup. It is important to have a good understanding of how the values in these properties are being used.