SQL Archives - Page 118 of 391 - SQL Authority with Pinal Dave

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

July 11, 2015

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…

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,…