Author Archives: davidbridge

About davidbridge

I am a contractor for David Bridge Technology Limited specialising in database design and Web development using Microsoft technologies such as c#, MVC .net and SQL Server (full stack)

Output sub query as CSV when Joining tables (one to many relationship)

This will show you how to get something like this from a table join and then I’ll explain how the SQL works. Name csv UK London,Manchester,Birmingham USA New Your,Washington,Kentucky France Paris,Leon,Frejus Suppose we have two tables — Create base table CREATE … Continue reading

Posted in Uncategorized | Leave a comment

Creating and Migrating an encrypted database.

This is a simple tutorial on how to… Create a database Setting up encryption Add encrypted data to a table Migrate the encrypted database to another server The tutorial is supplied without warranty and David Bridge and David Bridge Technology Limited accept … Continue reading

Posted in Uncategorized | Leave a comment

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

MOTOROLA Universal Bluetooth Keyboard & Mouse – pc use – missing backslash

I bought a Motorola droid bluetooth keyboard which is supposed to be for a mobile phone or tablet (Xoom) but it has no backslash on it which is annoying when you connect it to a pc (which obviously you can or … Continue reading

Posted in Hardware stuff, Other stuff | Tagged , , , , , , , , , , , | 2 Comments

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