All Articles - SQL Authority with Pinal Dave

SQLAuthority News – Implementing a Microsoft SQL Server Parallel Data Warehouse Using the Kimball Approach

September 18, 2011

SQL Documentation, SQL Download, SQL White Papers

This white paper explores how the Kimball approach to architecting and building a data warehouse/business intelligence (DW/BI) system works with Microsoft’s Parallel Data Warehouse, and how you would incorporate this new product as the cornerstone of your DW/BI system. For readers who are not familiar with the Kimball approach, we…

SQLAuthority News – Automation of Data Mining Using Integration Services

September 18, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download, SQL White Papers

This article is a walkthrough that illustrates how to build multiple related data models by using the tools that are provided with Microsoft SQL Server Integration Services. In this walkthrough, you will learn how to automatically build and process multiple data mining models based on a single mining structure, how…

SQL SERVER – Denali – String Function – FORMAT() – A Quick Introduction

September 17, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

In SQL Server Denali, there are two new string functions being introduced, namely: CONCAT() FORMAT() Today we will quickly take a look at the FORMAT() function. FORMAT converts the first argument to specified format and returns the string value. This function is locale-aware and it can return the formatting of…

SQL SERVER 2012 – String Function CONCAT() – A Quick Introduction

September 16, 2011

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server, SQL String

In SQL Server 2012, there are two new string functions being introduced, namely: CONCAT(), FORMAT(). In this blog post we are going to learn about String Function CONCAT(). CONCAT takes a minimum of two arguments to concatenate them, resulting to a single string.

SQLAuthority News – Uncut and Unedited – Interview of Pinal Dave on Book Authoring

September 15, 2011

Pinal Dave

SQL Video

Joes 2 Pros, SQL Wait Stats

I was very happy when books were published and I got a print copy in my hand. In this blog post we will discuss about Book Authoring.

SQL SERVER – Introduction to expressor 3.4 Lookup Tables

September 14, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

In this blog post, I am going to take a closer look at expressor’s new and extremely versatile implementation of lookup tables, which they are releasing as part of the upcoming expressor 3.4 product release. As creation and use of the lookup table can be managed completely through simple-to-use graphical…

SQL SERVER – Denali – New Functions and Shorthand for CASE Statement

September 13, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

This blog post is written in response to the T-SQL Tuesday post of Data Presentation. This is a very interesting subject. I recently started to write about Denali Logical and Comparison functions. I really enjoyed writing about new functions, but there was one question kept cropping up – is the…

SQL SERVER – Denali CTP3 – Step by Step Installation Video – 200 Seconds

September 12, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

SQL Download

My recent article on SQL SERVER – Download Denali CTP3 and Denali CTP 3 Product Guide has inspired today’s post. After reading this blog post, I received a few emails and few comments on facebook page that if I can post a video guide to Denali CTP3 installation. Finally I create…

SQL SERVER – DBA Quiz 2011 – All was well few moments before all went wrong – Reasons and Resolutions

September 12, 2011

Pinal Dave

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

My question just got published at DBA Quiz 2011. This question is inspired from a real life incident, which occurred to me a few years ago. That time, I was a DBA myself and then one fine day, everything went south. When we checked the log, all the logs were…

SQL SERVER 2012 – Logical Function CHOOSE() – A Quick Introduction

September 11, 2011

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server

In SQL Server 2012, there are two new logical functions being introduced, namely: IIF() and CHOOSE(). Today we will quickly take a look at the logical CHOOSE() function. This function is very simple and it returns specified index from a list of values. If Index is numeric, it is converted to integer. On the other hand, if the index is greater than the element in the list, it returns NULL.