Tags » SQL Authority

SQL SERVER - List the Name of the Months Between Date Ranges - Correction

Earlier I wrote a blog post about SQL SERVER – List the Name of the Months Between Date Ranges. It was written in the response to the question – How to list the name of the months between two date ranges? 190 more words

SQL Authority

SQLAuthority News - Presented on Database Worst Practices at SQLPASS 2014 in Seattle - November 5, 2014

Earlier last month, I had the opportunity to present at SQLPASS 2014. The event was held in Seattle in November 2014. I had a great time attending this event and I presented on the topic Database Worst Practices on November 5, 2014. 260 more words

SQL Authority

SQL SERVER - Reverse String Word By Word - Part 4

Earlier I wrote a blog post about SQL SERVER – Reverse String Word By Word. SQL Server Expert Sanjay Monpara and Yuri Petrov contributed to the blog post with their excellent script which I have blogged earlier. 162 more words

SQL Authority

SQL SERVER - Creating the SSIS Catalog - Notes from the Field #058

: SSIS is very well explored subject, however, there are so many interesting elements when we read, we learn something new. A similar concept has been Creating the SSIS catalog. 649 more words

SQL Authority

SQL SERVER - Reverse String Word By Word - Part 3

Earlier I wrote a blog post about SQL SERVER – Reverse String Word By Word. SQL Server Expert Sanjay Monpara wrote a great comment to the blog post where he has proposed alternate solution. 214 more words

SQL Authority

SQL SERVER - Proving that the Source of the Problems aren’t Tied to the Database

I have always wondered how Sherlock Holmes cracked the toughest of mysteries every single time. This fascination always lead me to learn new techniques every single time. 1,150 more words

SQL Authority

SQL SERVER - Reverse String Word By Word - Part 2

Earlier I wrote a blog post about SQL SERVER – Reverse String Word By Word. SQL Server Expert Sanjay Monpara wrote a great comment to the blog post where he has proposed alternate solution. 226 more words

SQL Authority