Formatting Dates with CONVERT

2018-01-29 1 Comments

Dave Mason - SQL Server CONVERT

Displaying dates and times with different formats in TSQL is a task I run into quite a bit. I used to visit this page so many times, I'm surprised it doesn't have a "Welcome back, Dave!" banner on it at the top.


Installing SSRS 2017

2018-01-17 0 Comments

Dave Mason SQL Server SSRS 2017

Back in 2017 before SQL Server 2017 reached its GA release, I wrote a post about installing multiple instances of SSRS on the same host. I used SQL Server 2017 RC2 to do my testing and provide some screen shots. But by the time the GA release of SQL 2017 arrived, the SSRS installation was decoupled from the main SQL Server installation package (much like SSMS 2017). I'd gotten a few questions and comments in the post asking about the "new" SSRS 2017 installation. I'll try to address that here, based on some brief installation testing.


T-SQL Tuesday #98: Technical Challenges

2018-01-09 0 Comments

Dave Mason T-SQL Tuesday

For T-SQL Tuesday #98, Arun Sirpal (b|t) asks us to write about a time when we faced a technical challenge that we overcame. Thanks for asking, Arun!


Generating Random Passwords In Bulk

2018-01-04 0 Comments

Idera Software hosted another SQL Chat on Twitter yesterday. One of the questions that came up was about security: