SQL Archives - Page 186 of 519 - SQL Authority with Pinal Dave

MySQL – Download MySQL Workbench Shortcut in PDF

February 2, 2014

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…

MYSQL – Could not Drop Object [Content] (‘Cannot delete or update a parent row: a foreign key constraint fails’, 1217) DROP DATABASE DatabaseName

February 1, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL, SQL Error Messages

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…

SQL SERVER – Synchronize Schema across Multiple Environment – How to Overcome Database Migration Challenge

January 31, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Embarcadero, SQL Utility

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…

SQL SERVER – How to Survive on Free Tools for Month – SQL Data Compare Software – The ApexSQL Data Diff Tool

January 29, 2014

Pinal Dave

SQL

ApexSQL

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

January 28, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Utility

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…

SQL SERVER – Rename a Table Name Containing [ or ] Identifier in the Name – Part 2

January 26, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

Yesterday I posted article where we discussed how to rename a table name where identifier is part of the tablename. Read the blog post Rename a Table Name Containing [ or ] in the Name – Identifier in the Table Name. If the table name contains an identifier, it is…

SQL SERVER – Rename a Table Name Containing [ or ] in the Name – Identifier in the Table Name

January 25, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Management Studio

Just a day ago, my old colleague sent me an email. “I accidently renamed my tablename as a [], and now I am not able to rename it back with the help of T-SQL to its original name which was ProjectA. Is there any way to fix it?” Very interesting…