In this article, I’ll show how to use ApexSQL Diff, a SQL Server Schema Compare Tool. You can download it here, install, and play along while reading this blog post.
Developer’s Life – Every Developer is a Chhota Bheem
Chhota Bheem is a cartoon character that is extremely popular where I live. He is my daughter’s favorite characters. I like to say that children love Chhota Bheem more than their parents – it is lucky for us he is not real! Children love Chhota Bheem because he is the…
Read MoreSQLAuthority News – SQL Server 2012 Service Pack 2 is Available
Microsoft has announced SQL Server 2012 service pack 2 is available earlier this week. Service packages are cumulative updates and upgrade all editions of SQL Server 2012. This service pack contains up to and including SQL Server 2012 Service Pack1 Cumulative Update 9 (CU9). Here is the list of the…
Read MoreSQL SERVER – How to Get SQL Server Restart Notification?
Few days back my friend called me to know if there is any tool which can be used to get restart notification about SQL in their environment. I told that SQL Server can do it by itself with some configurations. He was happy and surprised to know that he need…
Read MoreSQL SERVER – SQL Server High Availability Options – Notes from the Field #032
[Notes from Pinal]: When it is about High Availability or Disaster Recovery, I often see people getting confused. There are so many options available that when the user has to select what is the most optimal solution for their organization they are often confused. Most of the people even know…
Read More
SQL SERVER – Attach or Detach Database – SQL in Sixty Seconds #068
When we have to move a database from one server to another server or when we have to move a database from one file to another file, we commonly use Database Attach or Detach process. I have been doing this for quite a while as well. Recently, when I was visiting an organization I found that in this organization lots of developers are still using an older version of the code to attach the database. I quickly pointed that out to them the new method to attach the database, however it was really interesting to find out that they really did not know that sp_attach_db is now a deprecated method to attach the database. This really made me to do today’s SQL in Sixty Seconds. I demonstrate in this SQL in Sixty Seconds how to attach or detach the database using a new method of attaching database. Let us learn about Attach or Detach Database.
MySQL – Video Course – MySQL Backup and Recovery Fundamentals
Data is the one of the most crucial things for any organization and keeping data safe is the biggest challenge for any DBA. This is true for any organizations. Think about the scenario that you have a database which is extremely important and suddenly you accidently delete the most important…
Read More