In this blog I am trying to put the things together a very basic level tutorial on understanding databases and more specifically how to implement one in MS […]
Generate Create and insert scripts for database objects from within SSMS
In this post we explore the option within SSMS which allows the DBA and developer to generate scripts for all data and database objects within SQL Server Database. […]
SQL Server Service fails to start: – Network protocols not enabled
There are a number of reasons why the SQL Server service may fail to start most of the time it has to do with the permissions of the […]
Data mining in SQL Server
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 […]