While browsing the TechNet forums, I came across a discussion about the future of data mining support in SQL Server. For those who are currently using SQL Server […]
How to reassign a Domain name in BIG ROCK
I recently needed to perform the above operation as part of moving my website. Let me first explain my setup and then the steps that were performed to […]
Understanding Indexes and Lookups in SQL Server: Execution Plans and Performance Tuning
This post provides a practical walkthrough on how index creation and modification affect execution plans, particularly in SQL Server 2008 R2 using FactResellerSales and DimProduct tables from the […]
Automating AWS instance shutdown and start-up
I love AWS and we recently had a very nice summit in Bangalore which I was able to attend. Once of the immediate things that caught my attention […]
Shutting down unutilized EC2 instances
Using AWS is easy and very cost effective; however there are ways to make it even more cost effective by shutting it down when not needed. This might […]
Always use source control
One important thing I learned early on in my career is that source control is important. It is a shame when weeks or month worth of effort gets […]
“ALTER DATABASE” failed error when configuring mirroring
Error Message TITLE: Microsoft SQL Server Management Studio —————————— Alter failed for Database ‘Mirror’. (Microsoft.SqlServer.Smo) The ALTER DATABASE command could not be sent to the remote server instance […]
Allowing users to connect remotely to a desktop
Before a user can connect to a RDP session they will need to be made a member of the Remote Desktop Users Groups this is found under control […]
Adding a parameter to the Report
We add parameters to reports to be able to dynamically fetch very selective data from the underlying database. Sometimes parameters are used for controlling the behaviour of a […]
Loading data from Excel AcquireConnection Error
[Excel Source [108]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager “Excel Connection Manager” failed with error code 0xC0209303. There may be error […]