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 thru the forums in Technet I came across a post today regarding the support for data mining in future versions of SQL. For those who are […]
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 […]
Indexes and lookups
Recompiling a stored procedure and rebuilding indexes is something that many DBAs are familiar with but even then there are a lot of misunderstandings about how the process […]
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 message when setting up database mirroring
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 ‘TCP://XXXXXX:2022’. The […]
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 […]