Feeds:
Posts
Comments

Archive for the ‘SQL Authority’ Category

SQLAuthority News – Business Intelligence features of SQL Server 2012 RC0 – Download Virtual Machine

Posted in Business Intelligence, PostADay, SQL, SQL Authority, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on February 12, 2012 | Leave a Comment »

I am in front of computer 16+ hours of the day. However, I accept that I am bit lazy when it is about doing installation etc. I always prefer that IT department help me to install my computer and I use it right away. Same feeling I get when I have to install Beta, RC [...]

Read Full Post »

SQL SERVER – Solution – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser

Posted in Pinal Dave, PostADay, Readers Question, SQL, SQL Authority, SQL Puzzle, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on February 11, 2012 | 1 Comment »

Yesterday was really fun. I asked a simple Brain Teaser and we had excellent conversation on SQLAuthority Page as well SQL SERVER – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser. That was an easy puzzle for those who have attended the SQL Server Questions and Answers online course. Here is a quick recap of the puzzle. Lots [...]

Read Full Post »

SQL SERVER – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser

Posted in Pinal Dave, PostADay, Readers Question, SQL, SQL Authority, SQL Puzzle, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on February 10, 2012 | 14 Comments »

It seems that we all love to solve puzzles. On SQLAuthority Page, we have been playing the number game and those who are playing with us know how much fun we are having. Sometimes, the answers are so innovative and informative that they open up those aspects of the technology which I have not thought [...]

Read Full Post »

SQL SERVER – INNER JOIN Returning More Records than Exists in Table

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Joins, SQL Puzzle, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on February 9, 2012 | 10 Comments »

I blog and engage with the community because it gives me satisfaction when someone resolves an issue. A few days ago, I blogged about a DBA who began his first day at a new company and could not find out where the installation summary file was. He was very happy when I featured his story [...]

Read Full Post »

SQL SERVER – Convert Subquery to CTE – SQL in Sixty Seconds #001 – Video

Posted in Database, Pinal Dave, PostADay, SQL, SQL Authority, SQL in Sixty Seconds, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Video on February 8, 2012 | 14 Comments »

SQL Server is an ocean of information. I believe if one starts learning today, after 60 years he/she may still be learning the subject (there are always a few exceptions)! Recently, I published the SQL Server Questions and Answers video tutorial, and since the course came out, I have been receiving lots of request to [...]

Read Full Post »

Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 16,216 other followers