Today is a special day – a new year which will define the year 2015. I request my close friend Vinod Kumar, who is SQL Server Expert and thought leader to write a blog post on this first day of the year. I asked Vinod – “What one should change in this year to progress in life?“. If you know Vinod, he is a very positive person and inspiring personality. He immediately responded that – “One does not need a new year to change”. I asked him to elaborate on this subject and our conversation turned out to be an amazing blog post.
SQLAuthority News – Thank You for Amazing Year! – Five Sixty Seconds Video
The year 2014 was amazing and I had a great time learning and sharing knowledge. I must thank you my dear readers for your constant support and motivation. I have been blogging every single day for over 8 years and this is only possible because of your help. Today is…
Read MoreSQL SERVER – UNION and UNION ALL with TEXT DataType – Observation
You can find the difference between UNION and UNION ALL in the following posts Union vs. Union All – Which is better for performance? There is one more difference between the two when a column of TEXT datatype is involved. When you use UNION for a TEXT column you will get…
Read MoreSQL SERVER – Puzzle – Why Divide by Zero Error
Earlier I asked a puzzle SQL SERVER – Puzzle – Why Decimal is Rounded Up? and it was very well received by all of you. You can read various comments posted in the blog post and they are indeed very enlightening. After posting that blog post, I received quite a lots of emails asking…
Read MoreSQL SERVER – Microsoft Releases for December 2014
Earlier this month, Microsoft has released quite a few SQL Server related tools, add-ons, and upgrades. I have listed a few of them here for a quick reference. The descriptions are of each downloads are from Microsoft download pages. Microsoft Azure, Cloud and Enterprise Symbol / Icon Set for Visio, PowerPoint,…
Read More
Google Spreadsheet – Finding Last Value from Column
I have previously written about how to find the top and bottom value of column in SQL Server but recently I got a very interesting question based on the same blog post. The question was how to find the last value from Column in Google Spreadsheet. I find it very interesting and attempted to find the solution in Google Spreadsheet.
SQLAuthority News – Presented on Database Worst Practices at SQL Live, Orlando – November 29, 2014
Earlier last month, I had the opportunity to present at SQL Live 2014. The event was held in Orlando in November 2014. I had a great time attending this event and I presented on the topic Database Worst Practices on November 21, 2014. Here is the title and abstract of the session, which…
Read MoreSQL SERVER – Performance Tuning – Is It Really A Top Skills for a SQL Server Consultant? – Notes from the Field #059
[Note from Pinal]: This is a 59th episode of Notes from the Field series. I get over 100 emails everyday and out of 100 emails nearly 90 of them are really related to performance tuning. The emails I get is from various different IT professionals. There are quite a few application developers…
Read MoreSQL Authority News – I am Participating in Winter Discounts and Christmas Photo Fest
I often get asked which is my favorite tool from DevArt. They have many great tools, but I am really fan of the development productive tool – dbForget Studio for SQL Server. Devart’s dbForge Studio for SQL Server is a fantastic tool for SQL Server development, as soon as I installed it I found so many things to learn. First off, it will increase SQL coding almost instantly. There is very little to learn, you are not just memorizing codes to “cheat” off of. Let us learn about winter discounts.
SQL SERVER – Puzzle – Why Decimal is Rounded Up?
Lots of people know the answer to this puzzle, but I am sure there are many who do not know the answer of the same as well. Here is the puzzle again for those who have vacation for the Holidays! Here is the first script: -- Decimal is rounded up…
Read More