SQL SERVER – UNION and UNION ALL with TEXT DataType – Observation
SQL SERVER – Puzzle – Why Divide by Zero Error
SQL SERVER – Microsoft Releases for December 2014
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
SQL SERVER – Performance Tuning – Is It Really A Top Skills for a SQL Server Consultant? – Notes from the Field #059
SQL 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?
SQL SERVER – Story of Temporary Objects
SQL Server’s version of Transact SQL provides the ability to create and leverage temporary objects for use within the scope of your query session or batch. There are many reasons why you may decide to use temporary objects and we will explore them later in this article. In addition to meeting various data-tier requirements, temporary objects can also be beneficial from a performance and scalability perspective.




