SQL Tips and Tricks Archives - Page 151 of 536 - SQL Authority with Pinal Dave

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

December 21, 2014

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? When I wrote the blog post, there was a small…

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

December 20, 2014

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL PASS, SQLAuthority Author Visit

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. Here is the title and abstract of the session,…

SQL SERVER – Reverse String Word By Word – Part 4

December 19, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL String

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. In this blog post we will see a similar script by SQL Expert Paul G. He has essentially sliced…

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

December 18, 2014

Pinal Dave

SQL Tips and Tricks

Notes from the Field, SQL Server, SSIS

[Notes from Pinal]: 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. With the release of SQL Server 2012, Integration Services (SSIS) received a significant overhaul. The most notable change was the addition of the SSIS catalog, a new deployment and storage mechanism that helps to centralize and standardize the storage, execution, and logging of SSIS packages. In this post, I will briefly illustrate how to set up the SSIS catalog on a new installation of SQL Server 2012 or 2014.

SQL SERVER – Reverse String Word By Word – Part 3

December 17, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL String

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. Right after the solution of the Sanjay, another expert Yuri Petrov suggested a modification to the script. In this blog…

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

December 16, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Dell

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. The backbone for every successful detective is to be logical in their approach while working on the case. While watching movies, I have…

SQL SERVER – Reverse String Word By Word – Part 2

December 15, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL String