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. […]
Popular Posts
Trending Posts
Recent Posts
Editors Choice
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 […]
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 […]