SQL Server Archives - Page 189 of 393 - SQL Authority with Pinal Dave

SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Complete Downloadable List – Day 0 of 31

July 1, 2011

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

This blog post is running list of the blog posts in the series of Interview Questions and Answers. At the end of the 31st day of the month, a FREE PDF will be posted here which can be downloadable for offline review. SQL SERVER – Interview Questions and Answers –…

SQL SERVER – Two Puzzles – Answer and Win USD 25 Gift Card

June 30, 2011

Pinal Dave

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

SQL Scripts

Today I have two simple T-SQL Puzzle. You can answer them and win USD 25 Gift card. The gift card will be sent in email to winner. You will get choice of Gift Card brand based on your preference and country location. Puzzle 1: What will be the outcome and…

SQLAuthority News – Monthly list of Puzzles and Solutions on SQLAuthority.com

June 28, 2011

Pinal Dave

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

SQL Scripts

This month has been very interesting month for SQLAuthority.com we had multiple and various puzzles which everybody participated and lots of interesting conversation which we have shared. Let us start in latest puzzles and continue going down. There are few answers also posted on facebook as well. SQL SERVER –…

SQL SERVER – T-SQL Scripts to Find Maximum between Two Numbers

June 26, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

There are plenty of the things life one can make it simple. I really believe in the same. I was yesterday traveling for community related activity. On airport while returning I met a SQL Enthusiast. He asked me if there is any simple way to find maximum between two numbers…

SQLAuthority News – Download Whitepaper – SQL Server 2008 R2 Analysis Services Operations Guide

June 25, 2011

Pinal Dave

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

SQL Download, SQL White Papers

SQL Server Analysis Service (SSAS) has been always interesting subject for research. Analysis Services cubes are a very powerful tool in the hands of the business intelligence (BI) developer. They provide an easy way to expose even large data models directly to business users. Microsoft has published very informative white…

SQL SERVER – SSAS – Multidimensional Space Terms and Explanation

June 22, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Business Intelligence

I was presenting on SQL Server session at one of the Tech Ed On Road event in India. I was asked very interesting question during ‘Stump the Speaker‘ session. I am sharing the same with all of you over here. Question: Can you tell me in simple words what is…

SQL SERVER – List of Article on Expressor Data Integration Platform

June 22, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download, SSIS

The ability to transform data into meaningful and actionable information is the most important information in current business world. In this fast growing and changing business needs effective data integration is single most important thing in making proper decision making. I have been following expressor software since November 2010, when…