All Articles - SQL Authority with Pinal Dave

Interview Question of the Week #028 – T-SQL Script to Detect SQL Server Version and Property

July 12, 2015

Here is a very basic question I just came across the other day. I was interviewing nearly 20 candidates and I found that only 5 of them could write the query (with the help of the internet). Question: How to determine the version and properties of SQL Server with the help of…

POSTGRESQL – How to Create Function? – How to Declare Local Variable

July 11, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

I have written few courses on PostgreSQL on Pluralsight. You can watch list of all the courses over here. Recently, after watching my courses one of the user who is familiar with SQL Server but just beginning with PostgreSQL asked me very interesting questions. Let us here the question in…

SQL SERVER – Puzzle – Working with functions to Concatenate columns

July 10, 2015

Pinal Dave

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

Every now and then I get pulled into coding review sessions and those are some of the fun times I every have working with T-SQL of any sorts. This blog is inspired by one such time where I saw at a customer location a code that was lengthy and in…

SQL SERVER – Using Project Connections in SSIS – Notes from the Field #088

July 9, 2015

Pinal Dave

SQL

Notes from the Field, SQL Server, SSIS

[Notes from Pinal]: SSIS is very well explored subject, however, there are so many interesting elements when we read, we learn something new. A similar concept has been Using Project Connections in SSIS.

SQL SERVER – 2016 FIX: Install – Rule “Oracle JRE 7 Update 51 (64-bit) or higher is required” failed

July 8, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

I enjoy spending time with my daughter almost every single day. It keeps me busy at home and most importantly, some quality time with her allows me to relax after a long day at work. But there one thing that has caught my attention every single day I have been…

SQL SERVER – Identifying Blocking Chain Using SQL Scripts

July 7, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

There are a number of blog posts that have been written on this very topic. This can be from basics to almost advanced in many ways. I am outlining some of them here below: SQL SERVER – Quickest Way to Identify Blocking Query and Resolution – Dirty Solution SQL SERVER…

SQL SERVER – Creating Dataset Using VALUES Clause Without Creating A Table

July 6, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

You know that you can add data to a table using VALUES clause. But did you know that you can create a dataset using VALUES clause like a table without adding into another table? Suppose you want to create a data set with two columns named a and b SELECT…

Interview Question of the Week #027 – Move TempDB from One Drive to Another Drive When Low Disk Space

July 5, 2015

Pinal Dave

SQL Interview Questions and Answers

SQL Performance, SQL Scripts, SQL Server, SQL TempDB

Here is one of the important interview question which is related to TempDB and how to Move TempDB from One Drive to Another Drive When Low Disk Space.

SQL SERVER – Secure by Default – The Mantra

July 4, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Security

Generally the talks I give at conferences revolve around performance and tuning. These are always the most sought after topic and I don’t disappoint the requests because they give me an opportunity to learn something new too. Last month when I visited Sri Lanka for the first ever SQLSaturday event,…

SQL SERVER – Difference Between Read Committed Snapshot and Snapshot Isolation Level

July 3, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Transaction Isolation

It is quite common that when a new feature gets introduced, there is a lot of talk about them. Sometimes even the old capabilities are lesser known because they can be used interchangeably in conversations. I have seen many DBAs getting confused between these two terms because both of them…