All Articles - SQL Authority with Pinal Dave

Developers – A Fun List of Things Related to Developer

February 9, 2014

Earlier in the month of December 2013, I have written few articles which were related to the Developer and fun stuff. In those articles I had asked if I have missed anything, which I should have in the article and missed or not. I have got quite a few suggestions…

SQL Puzzle – A Quick Fun with Bit Wise Operator – Part 2

February 8, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

This is a follow up, puzzle of SQL Puzzle – A Quick Fun with BitWise Operator. Lots of people really like the earlier puzzle where I have used Bit Wise Operator AND and build a simple puzzle. Today we are going to use another bit wise operator – OR. First execute…

SQL Puzzle – A Quick Fun with Bit Wise Operator

February 7, 2014

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

It has been a long time since we have puzzle on this blog so let us have a quick puzzle this Friday. It is based on Bit Wise Operator and very simple if you know those operators. We will guess the output of the SQL script. For example, here is…

SQL SERVER – Learning SSIS – Where Do I Start? – Notes from the Field #014

February 6, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore

[Note from Pinal]: This is a new episode of Notes from the Field series. SQL Server Integration Service (SSIS) is one of the most key essential part of the entire Business Intelligence (BI) story. It is a platform for data integration and workflow applications. As wikipedia says – It features…

SQL SERVER – Retrieve All the Data from VARCHAR(MAX) Column

February 5, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

In this blog post we will discuss a very common problem which developer who are working with SQL Server Management Studio and VARCHAR(MAX) Datatype faces. In database table if you have over 8200 characters in a column with datatype VARCHAR (MAX) it is not easy to display them in SSMS.…

MySQL – Learning Online MySQL Workbench Guided Tour – Pluralsight Course

February 4, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

MySQL Workbench is the default IDE for MySQL and the most popular IDE among MySQL Developers and Administrator. There are three major sections in MySQL Workbench. 1) Developement – Developer can perform various activities related to SQL development in this area. For example – building queries, executing queries, etc 2)…

9 Things You Should be Doing with Your Backups – Backup Tips – SQL Server Backup Tips

February 3, 2014

Pinal Dave

SQL Tips and Tricks

SQL Backup, SQL Scripts, SQL Server, SQLBackupAndFTP

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

February 2, 2014

Pinal Dave

SQL, SQL Tips and Tricks

Cheatsheet, MySQL, SQL Shortcut

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…