Category Archives: SQL Stuff

SQL Server tips, tricks and muses

How to create empty guid in SQL Server – c# Guid.Empty() equivalent

In dotnet you can create a new Guid by using the static Guid class like this (c# syntax) Guid g = Guid.NewGuid(); And you can create an empty guid like this Guid g = Guid.Empty; In SQL Server you can … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , , | 1 Comment

SSRS report print button missing in IE11

If you use reporting services though a report viewer control then you might be missing the print button when viewing in IE11. To fix this, install the latest reportwiewer.exe. This will return the print button but annoyingly it also changes … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , | Leave a comment

SSRS report hangs in IE11

If your SSRS report viewer’s “Loading” popup message never goes away (the report never renders) then chances are you have a reference to an image that does not exist in your report. I got this because I have a report … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , , | 1 Comment

SSAS / Excel 2010 – An error was encountered in the transport layer

Connecting to SQL Server Analysis Services from a remote domain / login When connecting to SSAS from a different remote domain / login using Excel 2010 where you have set up a windows user at the SSAS server, provided adequate … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , , , | 7 Comments

The SQL Server instance specified in SSIS service configuration is not present or is not available

If you get this error when you are trying to expand the MSDB section in SSIS and your target SQL Server is clustered then this is probably because the default reference to an instance of SQL Server in the SSIS … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , | 3 Comments

Sharepoint database connection string – what is it?

I use Team Foundation Server (TFS) for source control of my current data warehouse project with SSIS, SSRS and SSAS but my requirements documents which are mostly word but also Excel, Visio and xMind (Excellent mind mapping diagram software) were … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , , | 5 Comments

SSAS: Excel Data Connection Wizard missing cube(s)

This gallery contains 1 photo.

Have you got missing cubes in your Excel Data Connection Wizard? A customer noticed this yesterday and had spent all afternoon looking for the issue, rebuilding, deploying, processing, deleting and recreating on the server etc. all to no avail. He … Continue reading

Gallery | Tagged , , , , , , , , , , | 4 Comments