All Articles - SQL Authority with Pinal Dave

SQL SERVER – Images and media file management in SQL Server and MySQL – Coding Media Management Tools is Never Easy

March 3, 2014

A core element to both web and mobile app development is rich media management. How you approach the control of images in particular can be tricky. In most cases you have two avenues: You either save it as a database BLOB or simply link to it as a file. Going…

SQL SERVER – Listing Primary Key of Table with Stored Procedure sp_pkeys

March 2, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys

Here is a follow up blog post of my earlier blog post on very similar subject Listing Foreign Key Relationships of Table with Stored Procedure sp_fkeys. In previous blog post we listed foreign keys and now we will list the primary key of the table with the help of Stored…

SQL SERVER – Listing Foreign Key Relationships of Table with Stored Procedure sp_fkeys

March 1, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys

A very cool trick which I have previously not shared on my blog regarding how to list all the foreign key relationship of table with the help of Stored Procedure sp_fkeys. Here is a quick script how you can use stored procedure sp_fkeys to list all the foreign key relationship.…

SQL SERVER – 28 Links for Learning SQL Wait Stats from Beginning

February 28, 2014

Pinal Dave

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

SQL Scripts, SQL Wait Stats

It has been exact two years since I have written series on SQL Wait Statistics and Queues. I often received quite a few questions related to this subject. Here are my answers to the questions. Q: The series which you have written two years ago, is it still relevant to…

SQL SERVER – Dude, Where is the SQL Agent Job History? – Notes from the Field #017

February 27, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore

[Note from Pinal]: Everybody knows what is SQL Agent Jobs. We know that they run at regular interval and does the task assigned. However, there are way many more things we should know about SQL Jobs but do not know it or never learnt to care about it. One of…

SQL SERVER – Find Anything in Object Explorer in SSMS

February 26, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

This blog post is a follow up post of an excellent write up by my friend Vinod Kumar. I suggest you read his blog post here SSMS Tips–Object Explorer Details. After reading his blog post, I called him up and had an interesting conversation with him. Here is our conversation:…

MySQL – Profiler : A Simple and Convenient Tool for Profiling SQL Queries

February 25, 2014

Pinal Dave

SQL

Devart, MySQL, SQL Utility

In terms of working with highly loaded databases, any badly-designed request can cause significant performance degradation. Depending on the used DBMS features, various methods are used for query optimization. However, a general rule can be pointed out for all types of DBMS: the fewer server resources are expended when executing…

SQL SERVER – Contest Post – Notes from the Field – Learning Performance Tuning and Database Health

February 24, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field

One of the most appreciated and loved the series on SQLAuthority.com is Notes from the Field. I often received how did I come up with the idea behind it. Here is the story for the same. Inceptions of Notes from the Field There are two aspects of any technology 1)…

SQLAuthority News – Two Whitepapers from AzureCAT Team on SQL Database

February 23, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Recently I was reading about SQL Database on Azure. There are lots of confusion around SQL Database around SQL Azure and I have been looking for a good authentic documentation which I can refer as well as I can use that in my day job. After a quick research I…

SQLAuthority News – 4 Whitepapers on Windows Azure

February 22, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL White Papers

Windows Azure is getting quite a lot of traction in the industry and I often get questions about if there is authentic learning on this subject. Microsoft has published following 4 white paper which covers many interesting topics related to SQL Server and Windows Azure. Application Patterns and Development Strategies…