Monthly Archives: May 2016

Powershell Commands for SQL Server

The Intransigent Data Blog Posted on by

SQLPS The SQLPS utility is being replaced by the sqlps module: Import-Module “sqlps” -DisableNameChecking To run this interactively against a remote server, enter a remoting session: Enter-PSSession -ComputerName HOST-NAME -Credential DOMAIN\user Add a User to a SSAS Role This solves … Continue reading →

Posted in DBA

SSRS Date Range Parameter

The Intransigent Data Blog Posted on by

Summary A method for providing a selection of pre-set date ranges plus the ability to enter a custom range of dates. Until the SSRS improvements in 2016, this will require Nullable date parameter boxes to be used. (Why could not … Continue reading →