All Articles - SQL Authority with Pinal Dave

Developer’s Life – Every Developer is a Iron Man

June 29, 2014

Iron Man is another superhero who is not naturally “super,” but relies on his brain (and money) to turn him into a fighting machine. While traditional superheroes are still popular, a three-movie franchise and incorporation into the new Avengers series shows that Iron Man is popular enough on his own.…

MySQL – Add a Column at Particular Ordinal Position in Table

June 28, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL, SQL Scripts

Sometimes you may need to add a column at a particular ordinal position in the table. In SQL Server there is no option to do it via SQL although you can use Designer from SQL Server Management Studio. In MySQL you can do it as part of ALTER TABLE statement.…

SQL SERVER – Activity Monitor to Identify Blocking – Find Expensive Queries

June 27, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Activity Monitor

Recently when I was busy working on my next course for Pluralsight, one of my friend pinged me for some help over messenger. And the conversation went on a different spin, here is a gist of what we talked and I felt this was worth a share – Me: Hi…

SQL SERVER – SSIS Component Error Outputs – Notes from the Field #034

June 26, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Server, SSIS

[Notes from Pinal]: Error confuses people and stops the operations. Developer search more on error online rather than best practices. Lots of people think that SSIS is all about arranging various operations together in one logical flow. Well, the understanding is absolutely correct, but the implementation of the same is not as easy as it seems.

SQL SERVER – In-Memory Databases and Caching Wars

June 25, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Server

The In-Memory Database and In-Memory Caching market is heating up and we (the users) are the real winners. Exciting!!!

SQL SERVER – Backup to Azure Blob using SQL Server 2014 Management Studio

June 24, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Azure, SQL Backup and Restore

Recently, while working on a demo about backup, I realized that in management studio, now there is a new option in the backup screen called a URL. This feature is called as “backup to URL”. I checked earlier version of SSMS and found that this was not there in the…

SQL SERVER – SQL Server Data Compare Tool

June 23, 2014

Pinal Dave

SQL

ApexSQL, SQL Utility

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

June 22, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Developer, Superhero

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…

SQL SERVER – Fix Error – Package ‘Microsoft SQL Management Studio Package’ failed to load in SQL Server Management Studio

June 21, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, 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…

MySQL – Dynamic SQL with EXECUTE and PREPARE Statements

June 20, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

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…