Monthly Archives: April 2017

Unhide Very Hidden Sheets in Excel

Aim: To unhide Very Hidden Sheets in Excel. As part of a recent data warehouse project, I had to extract data from an Excel spreadsheet (yuck, I know!). Based on some of the formulae in the┬ávisible sheets, it was apparent that there was another sheet hidden in the file. However, it was not possible to […]

SSRS Expressions: Format Dates & Numbers

Aim:┬áTo format dates & numbers embedded in text strings in SQL Server Reporting Services. To embed formatted dates in text strings, set the expression for the text string to: =”From ” + Format(Parameters!StartDate.Value, “yyyy-MM-dd”) + ” to ” + Format(Parameters!EndDate.Value, “yyyy-MM-dd”) E.g. for @StartDate = 01/02/2017 & @EndDate = 31/03/2017, the string will appear in […]

Kevin Kline

Career and Technical Advice for the IT Professional

TroubleshootingSQL

Explaining the bits and bytes of SQL Server and Azure

SQL Authority with Pinal Dave

SQL Server Performance Tuning Expert

Powershellshocked

A blog about PowerShell and general Windows sysadmin stuff

Simon Learning SQL Server

I'm trying to become "better" at SQL Server and data - here's how I'm doing it!