Luke Hayler - SQL Server developer

It’s almost time for another SQLBits, and in my [humble] opinion, it’s not soon enough. These free conferences are fantastic and if you do have the opportunity to attend I suggest you do so. Whilst I have only a small idea as to what goes into organising a conference, I am pretty sure that it [...]

The recruitment industry is a cut-throat and ruthless arena. Or so I’ve been told. It’s fast paced, with no time to spare on ifs, buts and maybes. Recruiters have a race against time to find the right candidate and get their details over to their prospective client. This race against time is not necessarily to [...]

 
OLE DB Source Adapter
The OLE DB source connection has several Access Modes:

Openrowset
Openrowset From Variable
SQL Command
SQL Command From Variable

For now, I am going to focus on the SQL Command options. Using the SQL Command Access Mode requires you to set the SqlCommand property (typing in your SQL query directly), effectively ‘hard coding’ [...]

This is a quick look at how to create and use subtotals in your Matrix objects.
Subtotals 101
SQL Server Reporting Services makes it relatively easy to add totals to your columns and rows in a matrix object. In short, it’s as easy as right-click>Subtotal. Seriously, that’s it. Well, unless you want to format them, but that’s [...]