SQLAuthority News – Pluralsight Giving Away Free Subscription to Quiz Participants

I am sure readers of this site are familiar with Pluralsight.  It is an online training site that describes itself as “a company created by developers, specifically for developers.”  At their site you can find training courses on a variety of topics and weekly webcasts by industry specialists.

Right now the latest news on the blog is that businesses can subscribe to Pluralsight to help train their employees: Pluralsight subscriptions for businesses.  The blog has also introduced course assessments so that users can track their progress – and employers can see how well their employees are doing. Pluralsight is also going to be sponsoring Tech-Ed Australia 2011.  The event runs from August 30 through September 2.  Pluralsight will have a booth at the event and will be giving away fun freebies that everyone looks forward to at these events.

As for courses, there is a huge variety to choose from.  Here is a short list of just a few of the most recent courses available: Web Performance, Windows Phone 7.5 Integrations Features, What’s New in C# 4.0, and Web Application Performance and Scalability Testing.  And these are just the ones listed on the front page! The Web Performance course was designed by Robert Boedigheimer, and focuses on how to reduce the number of files (like CSS, JavaScript, etc) that need to be downloaded when a web page is loaded, and thus increase speed and reduce bandwidth usage.  The Windows Phone 7.5 course was designed by Yacine Khammal, and investigates how to design apps that will blend seamlessly into phone usage – and how to get the most downloads.  These are only a few of the many courses offered!

Pluralsight also hosts weekly webcasts, every Thursday.  Recent speakers include Steve Michelotti discussing MVC Scaffolding, Julie Yack exploring Dynamics CRM, and Dan Sullivan talking about the Regex class.  Follow Pluralsight every Thursday at 11:00 AM EDT/15:00 UTC to listen and learn.

Give Away Contest

Pluralsight Giving Away 2 Free Subscription to Quiz Participants of the my running Quiz Competition. The give away is 2 - 30 days FREE learning to ALL the Courses which are available at Pluralsight.

Answer the following questions in the next 48 hours and you can win this Free Subscription.

Question 1) List days when Joes 2 Pros Contest had two correct answers?
Question 2) List days when Joes 2 Pros Contest had 3 winners instead of 2?
Question 3) Which is your favorite question from Joes 2 Pros Contest? Why?

Anyone in the world can participate in this contest. Your comments will be visible after the contest is over, so please be patient till the winner is announced. The winner will be selected using Random Algorithm.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

About these ads

31 thoughts on “SQLAuthority News – Pluralsight Giving Away Free Subscription to Quiz Participants

  1. Q: Joes 2 Pros Contest had two correct answer
    EVERYDAY

    Q: Joes 2 Pros Contest had 3 winners instead of 2 WHEN 2 WINNERS FROM USA WERE ANNOUNCED ;p

    Q: Which is your favorite question from Joes 2 Pros Contest? Why?
    Row Constructor was my favorite. It saves me so much time while writing queries. I am using that for every insert I make.

    Thanks Pinal .

    Aditi S
    USA

    Like

  2. Hi Sir,

    Answers are as follows :

    Question 1 answer is :

    Day 9
    Question 9
    You need to explicitly insert a value into an identity field for the SalesInvoice table.
    What two things must you do in order for your insert statement to successfully execute? (Choose two)

    Question 2 answer is :

    Day 9
    three winners where

    Winner from USA: TimB
    Winner from India: Diljeet Kumari

    Pluralsight Subscription Winner
    Winner from India: Ritesh Shah

    Question 3 answer is :

    My favourite question was Day 8 question

    Q.8) You have tables named dbo.SalesInvoice and dbo.SalesInvoiceDetail.
    CustomerID is located in the SalesInvoice table and InvoiceID is located in both tables.
    You have been told to show the discount amounts from the SalesInvoiceDetail table that correspond to the sales of a specific CustomerID of 490.
    Which T-SQL statement should you use?

    I liked this question specially because all the options where wrong and i felt happy working out the query for this question.

    P.Anish Shenoy,
    INDIA,Bangalore,Karnataka

    Like

  3. Hi Pinal,

    I’m writing to participate in the Pluralsight contest.

    Question 1)
    List days when Joes 2 Pros Contest had two correct answer?
    Answer: Day 9 (Question 9) and Day 14 (Question 14) had two correct answers.

    Question 2)
    List days when Joes 2 Pros Contest had 3 winners instead of 2?
    Answer: On Day 8 (Question 8), the third winner won a Pluralsight subscription for participating each day.

    Question 3)
    Which is your favorite question from Joes 2 Pros Contest? Why?
    Answer: The Data Row Space Usage and Null Storage topic was my favorite. I liked the level of detail and the variety of things to consider to get an accurate measure of the amount of disk space needed.

    Country:
    United States

    Thanks for the knowledge!

    Regards,

    Bill Pepping

    Like

  4. As for Question 1: Answer is Day 5.

    http://blog.sqlauthority.com/2011/08/05/sql-server-tips-from-the-sql-joes-2-pros-development-series-finding-un-matching-records-day-5-of-35/

    2nd Answer: Day 9.

    SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Overriding Identity Fields – Tricks and Tips of Identity Fields – Day 9 of 35

    Answer 3.

    http://blog.sqlauthority.com/2011/08/12/sql-server-tips-from-the-sql-joes-2-pros-development-series-ranking-functions-rank-dense_rank-and-row_number-day-12-of-35/

    ## All the questions are very good but if we found something to learn then its a matter of favorite. Because normally i am not using Ranking System its new for us.

    Thanks….
    Rajneesh Verma

    Like

  5. Question 1) List days when Joes 2 Pros Contest had two correct answer?
    Answer1) Day 9 and Day 15 had the 2 correct answers

    Question 2) List days when Joes 2 Pros Contest had 3 winners instead of 2?
    Answer 2) Day 9 had 3 winners were one winner got free plural site subscription.

    “Yesterday the RANDOM algorithm picked two winners from USA so today – we will have additional winner from India who will win Pluralsight FREE subscription. ” in your facebook page.

    Question 3) Which is your favorite question from Joes 2 Pros Contest? Why?
    Answer 3)

    There are many i have listed down below ones which actually helped me a lot and got to learn a lot of things thanks to pinal Sir.

    Day 1 ) Wildcard Basics :

    I didn’t know that we can do so much with wildcards searching from specific places to specific letter , range of letters words and special characters i just flew away and explored all that we can posssible do with it.

    Day 12) Ranking functions got to know very much about RANK( ), DENSE_RANK( ), and ROW_NUMBER( ) .

    By this i got to know how exactly ranking works in Universities and true usage of OVER() clause.

    And it also helps me find out an answer to a question which was asked to me in one of the interviews i thought there is one way but it opened the gate and i was with another Idea how to do that.

    I would like to take this opportunity to show what was question and reveal the answer for that:

    Question ) You have DimEmployee table and EmployeeKey column which stores the values of Id of each employee but it is not primary key find me the 10th row.
    Nothing else was given:

    Answer ) I got one answer long back but with that ranking function also we can get the solution.

    Here are the queries if any one like to comment one the same always welcome.

    Query 1)
    use AdventureWorksDW2008R2

    select Top 1 * from DimEmployee where EmployeeKey Not In ( Select Top 9 EmployeeKey from DimEmployee Order By EmployeeKey )

    will fetch us the 10 th row and another query

    Query 2)
    use AdventureWorksDW2008R2

    select * from (select * , RANK() Over(Order By EmployeeKey ) as RowNumber from DimEmployee ) As Number where RowNumber = 10

    All thanks to pinal Sir.

    DILIP KUMAR JENA

    Country : INDIA

    Like

  6. Pingback: SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Sparse Data and Space Used by Sparse Data – Day 17 of 35 Journey to SQLAuthority

  7. Question 1) List days when Joes 2 Pros Contest had two correct answer?
    August 9 2011 – SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Overriding Identity Fields – Tricks and Tips of Identity Fields – Day 9 of 35

    Question 2) List days when Joes 2 Pros Contest had 3 winners instead of 2?
    August 16 2011 – SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – System and Time Data Types – Day 16 of 35

    Question 3) Which is your favorite question from Joes 2 Pros Contest? Why?
    August 3 2011 – SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Finding Apostrophes in String and Text – Day 3 of 35

    Finding Apostrophes in String and Text is my favourite questions. Because your its very interesting to search for apostrophe in String and Text. Your explanation with examples was awesome.

    Gopalakrishnan Arthanarisamy
    Unisys, Bangalore, India

    Like

  8. Question 1) List days when Joes 2 Pros Contest had two correct answers?

    Q 15) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Data Row Space Usage and NULL Storage – Day 15 of 35

    Question 2) List days when Joes 2 Pros Contest had 3 winners instead of 2?

    Q 9) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Overriding Identity Fields – Tricks and Tips of Identity Fields – Day 9 of 35

    Question 3) Which is your favorite question from Joes 2 Pros Contest? Why?

    My favorite qusestion is “Tips from the SQL Joes 2 Pros Development Series – Data Row Space Usage and NULL Storage – Day 15 of 35″.
    Because I was not aware about where and how memory is allocated in SQL Server.

    New Delhi
    India

    Like

  9. ans:
    1. day 15th question had two ans.
    2.day 9th question had 3 winner
    3.day 12 th question was my favorite question.because i use rank() and dense_rank() first time.
    I am learning sqlserver all questions are very good and from that i learn so many thinks.
    Thanks Mr,Pinal for such good question and such a good blog.

    Partha
    India

    Like

  10. Question 1) List days when Joes 2 Pros Contest had two correct answers?

    Day 9 had two correct answers (1 and 4).

    Question 2) List days when Joes 2 Pros Contest had 3 winners instead of 2?

    Day 9 had three winners (TimB, Diljeet Kumari & Ritesh Shah).

    Question 3) Which is your favorite question from Joes 2 Pros Contest? Why?

    Day 13 (Using NTILE). That’s functionality that I had not used before & it seems very useful

    Like

  11. Pingback: SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Geography Data Type – Calculating Distance Between Two Points on the Earth – Day 18 of 35 Journey to SQLAuthority

  12. correct answer is #2 meters
    The STDistance( ) method calculates the shortest distance (in meters) between two Geography data points

    Uday Bhoopalam
    USA

    Like

  13. I like question #15. The question was related to calculating the space occupied by each row given the # of columns, their datatype and the # of rows.

    Thank You
    Uday
    USA

    Like

  14. here is my answers:

    1. Day 15 question had two answers.
    2. Day 19 question had 3 winners
    3. Day 12 question was one of my favorite question was on Day 3 of 35 Finding Apostrophes in String and Text

    Like

  15. 1. Day 9 and Day 15
    2. Day 8
    3. I liked all the questions,every qns is important.
    day 18 qns gives new fetaure of 2008 bcoz many developer don’t know about gemotery and Geography datatype its my favorite.

    Abhishek Mishra,
    INDIA ,NOIDA

    Like

  16. Hi Pinal,

    Here are my answers:

    1) Days when there were two correct answers: Day 9 and Day 15

    2) Days when there were three winners: that would be Day 9 because on the 8th day there were two winners from the USA so you said there would be an extra winner not from the USA on the next day which would be Day 9.

    3) Favorite Question: Day 12, I believe where we did Rank(), Dense_Rank() and etc. It is just something I struggled with at work when I saw it in other’s code but never quite could figure out what was going on. Now it makes sense and I’m hoping to look at that code again or be able to improve some exisiting code by using it.

    Thanks!
    Deb – USA

    Like

  17. Hi Pinal,

    1. Day 9 and Day 15
    2. Day 9
    3. Day 13 (Using NTILE). That’s functionality that I had not used before

    Thanks.
    Ashish Kadam – Pune – India

    Like

  18. Hi Pinal,

    I’m writing to participate in the Pluralsight contest.

    Question 1)
    List days when Joes 2 Pros Contest had two correct answer?
    Answer: Day 9 (Question 9) and Day 14 (Question 14) had two correct answers.

    Question 2)
    List days when Joes 2 Pros Contest had 3 winners instead of 2?
    Answer: On Day 8 (Question 8), the third winner won a Pluralsight subscription for participating each day.

    Question 3)
    Which is your favorite question from Joes 2 Pros Contest? Why?
    Answer: The Data Row Space Usage and Null Storage topic was my favorite. I liked the level of detail and the variety of things to consider to get an accurate measure of the amount of disk space needed.

    Thanks,
    Apaarna,
    Hyderabad,AndhraPradesh,India

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s