SSMS: Select Multiple Tables/Views/Objects

In Microsoft SQL Server Management Studio (SSMS) I've often been annoyed by the apparent inability to use my Shift or Ctrl keys to select multiple objects at once in the Object Explorer window.

I'm happy to say that there is in fact a way you can multi-select tables, views, whatever objects you like!

Go to the 'View' menu and select 'Object Explorer Details'. This glorious new pane will open and allow you to select as many objects as your heart desires. You can also just hit the F7 key as a quick shortcut. How awesome is that?

It's beyond me why this is only possible in this details pane, so if you happen to have some insight then I'd love to hear about it in a comment down below.

Read More

SSRS: Hide Toolbar and Navigation Using URL Parameters

If you have an SSRS report deployed to a Report Server you can use URL parameters to link to it in such a way that all of the toolbars and navigation items (like breadcrumbs) at the top of the screen are hidden.

First you need to get the URL pointing to your report from the report server. It will look something like this:

https://server/ReportServer/Pages/ReportViewer.aspx?%2fFolderName%2fReportName

Now just add on the following to the end of that URL:

&rs:Command=Render

So it will look something like this:

https://server/ReportServer/Pages/ReportViewer.aspx?%2fFolderName%2fReportName&rs:Command=Render

It's that easy!

Read More