This article shows how to use ApexSQL Data Diff, a SQL data compare tool. You can download it here, install, and play along. Let us learn about SQL Server Data Compare Tool.
Developer’s Life – Every Developer is a Sherlock Holmes
I have been thinking a lot about how developers are like super heroes, and I have written two blog posts now comparing them to Spiderman and Superman. I have a lot of love and respect for developers, and I hope that they are enjoying these articles, and others are learning…
Read MoreSQL SERVER – Fix Error – Package ‘Microsoft SQL Management Studio Package’ failed to load in SQL Server Management Studio
I recently formatted my computer and reinstalled my machine and I end up on following error: Package ‘Microsoft SQL Management Studio Package’ failed to load I was able to fix the error quickly, but while I was searching online, I noticed quite a few of the people have similar error…
Read MoreMySQL – Dynamic SQL with EXECUTE and PREPARE Statements
MySQL supports Dynamic SQL with the help of EXECUTE and PREPARE statements. Suppose you have a scenario where you need to pass table name as parameter value and returns all column values, you can use Dynamic SQL. Let us create this table and data. CREATE TABLE TestTable (ID INT, Col…
Read More
SQL SERVER – Keeping MSDB System Database Lean and Fit – Notes from the Field #033
[Notes from Pinal]: I am working with SQL Server for almost 10 years. I have seen the most ignored databases on any database server is system database. We hardly pay attention to them. Just for the sake of it – try to run queries in your master database and see…
Read MoreSQL SERVER – Change Fill Factor – SQL in Sixty Seconds #069
“I want to change fill factor to another value – how do I do that?” The other day I received this question in via Facebook. Fill factor is the value that determines the percentage of space on each leaf-level page to be filled with data. In an SQL Server, the…
Read More
Database – Taking Backup of MySQL and MongoDB on Cloud
Here is the story of my latest weekend experiments. Those who know me are familiar that I try to do something new every weekend and post my experience over here. Earlier this week, I published my course on MySQL Backup and Recovery. After doing this course, I realize that everything I had covered in the course was related to native MySQL backup, but there should be some solution outside which caters to the larger need of MySQL Backup. Additionally, I found that taking backup with MySQL is hit and miss as well as there is no systemic reporting there. I decided to do some research on my own on the internet. I tried out various tools, softwares and quite a few third party plug-ins.