SQL Server backups are essential for any business that store their data in SQL Server. The following is a list of best practices you should be following if you are the person in charge with maintaining your organization’s databases. Let us see some of the SQL Server Backup Tips.
MySQL – Download MySQL Workbench Shortcut in PDF
MySQL Workbench is default IDE for MySQL and it is available to download for free on MySQL’s website. It is a fully featured IDE with three major sections. 1) SQL Development 2) SQL Administration and 3) Data Modeling. Each section is quite big on its own. Â There are plenty of…
Read MoreMYSQL – Could not Drop Object [Content] (‘Cannot delete or update a parent row: a foreign key constraint fails’, 1217) DROP DATABASE DatabaseName
If you are using MySQL following, you must have faced following error when you want to drop a table or database. This error happens when we try to drop a table or database which has a foreign key constraint associated with another table, schema or database. Could not Drop Object…
Read MoreSQL SERVER – Synchronize Schema across Multiple Environment – How to Overcome Database Migration Challenge
Let us begin today’s blog post with interested story, which we all database developers go through once in a life time. Story of Database Developer This about a scenario – you have been out of town on vacation for one week and now you are just back to work. You…
Read MoreSQL SERVER – Virtualized SQL Server Performance and Storage System – Notes from the Field #013
[Note from Pinal]: This is a new episode of Notes from the Field series. A common comment I often hear from the developers is – “I have virtual environment and I have followed all the tricks and tips which I should apply to SQL Server but still I do not see a performance improvement to my server. I believe virtualization is not a good thing.” The matter of the fact is that we do not know how to tune virtualized server. Regular SQL Server where we have dedicated server and virtualized SQL Server have few different tricks associated with them. Let us learn about Virtualized SQL Server Performance and Storage System.
SQL SERVER – How to Survive on Free Tools for Month – SQL Data Compare Software – The ApexSQL Data Diff Tool
In the previous article I wrote about comparing two Windows Azure, SQL databases using free community version of ApexSQL Diff. In this article we will write about comparing data in two Windows SQL Azure databases using a free Community version of ApexSQL Data Diff – a tool for SQL data comparison and synchronization.
SQL SERVER – Back& Reborn as Premier Back End SaaS Provider
Back&, an international provider of Back Office Services, is proud to announce the launch of their revolutionary Zero Entry pricing model and Back End SaaS product. By creating a Better BackOffice, Back& has destroyed the barriers of cost and time – enabling companies and small business of any size access…
Read More
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.