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 (https://blog.sqlauthority.com)
29 Comments. Leave new
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
1. Day 9 and Day 15 (I checked every day again)
2. According to it was Day 8
3. I liked all the questions, but especially the #15 about the storage as this is when I learned something new. I also liked situations with the tricky questions when there was no correct answer among the choices and we had to figure this trick.
Naomi, USA
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
Hi All,
If you do not see your comment, posted here – it is because I have kept it hidden for next 48 hours.
Kind Regards,
Pinal
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
I am learning sql server 2008 and would love to win.
Please leave a comment to the questions listed in the blog post!
hi pinal how we access pluralsight as free subsicription
Just answer the question in this blog post – if you are lucky winner I will send you code which will give you 30 days free access.
As for Question 1: Answer is Day 5.
https://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.
https://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
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
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
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
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
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
So in order to answer these 3 questions you want us to scroll through all 35 different pages?
If you have participate in earlier 14 questions – you may remember the answer.
HI Pinal,
This is really vry intresting, daily i read and answer for SQL SERVER – Tips from the SQL Joes 2 Pros Development Series for last 15-16 days……
m i eligible for this…..
Thnx
Aditya Bisoi
Chennai ,INDIA
yes and you should participate very quickly.
correct answer is #2 meters
The STDistance( ) method calculates the shortest distance (in meters) between two Geography data points
Uday Bhoopalam
USA
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
Meters
ADITI S
BOSTON, USA
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
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