Part 2 on listing the names of the months between date ranges, with an improved script from readers Miladin Joksic and Peter Lalovsky that adds more details.
SQL SERVER – List the Name of the Months Between Date Ranges – Correction
Sanjay Monpara caught a small error in my script to list the name of the months between two dates: it skipped the first month. Here is his corrected script.
SQL SERVER – Reverse String Word By Word Part 4
In Reverse String Word By Word Part 4, Paul G slices the string by a delimiter and rebuilds it in reverse order. Here is his full script.
SQL SERVER – Creating the SSIS Catalog – Notes from the Field #058
SQL Server 2012 added the SSIS Catalog to store, run and log packages in one place. In Notes from the Field #058, Tim Mitchell shows how to set it up.
SQL SERVER – Reverse String Word By Word Part 3
Reverse String Word By Word Part 3 shows Yuri Petrov’s way to reverse words in a sentence, using an auxiliary numbers table in two parts.
SQL SERVER – Reverse String Word By Word Part 2
In Reverse String Word By Word Part 2, Sanjay Monpara and Yuri Petrov improve my script. The new, more robust version uses a Split function.
Primary Data File Extensions: Does the .mdf Name Matter?
Can a primary data file end in something other than .mdf? I built a demo database with odd names, checked each file, then detached and attached it.