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

SQL SERVER – Find Blocking Using Blocked Process Threshold

June 30, 2014

In my previous blog I was talking about my friend Jim who was on a consulting assignment and was asking me for some help around blocking. Though the tip mentioned was of help, Jim did reach out to me the day after and had more queries. Some of these sound…

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.