This page has 0 threads | Add post

Consultancy

SQL consultancy and software development

Do you have a pile of data which you need to make sense of?

Do you suspect the SQL Server database built for you by your third-party vendor might contain lots of useful information, if you only knew how and where to look?

Not only can Wise Owl create whizzy procedures in SQL to extract and analyse your data, but (uniquely) we've also got the training experience to then show you how we did it (it helps that we are also gurus in Integration Services, Reporting Services, Python, Excel and C# - among other things - so we always know which is the right tool to choose for any particular job).

How well do we know SQL?

Just for fun, we thought we'd see how many stored procedures, functions and triggers we'd included in our main two internal databases (called Wombat and Website, for reasons which will only be partially obvious ...). Here are the results:

Here's the SQL to do this, for interest:

-- create table variable giving SQL use

DECLARE @usage TABLE(

SystemName varchar(50),

SqlThing varchar(50),

NumberWritten int

)

-- insert all of Wombat objects

INSERT INTO @usage(

SystemName,

SqlThing,

NumberWritten

)

SELECT

'Wombat',

type_desc AS 'SQL thing',

COUNT(*) as 'Number written'

FROM

Wombat.SYS.objects

where

type in ('fn','p','tf','tr')

group by

type_desc

-- add website objects

INSERT INTO @usage(

SystemName,

SqlThing,

NumberWritten

)

SELECT

'Website',

type_desc AS 'SQL thing',

COUNT(*) as 'Number written'

FROM

WiseOwlWebSite.SYS.objects

where

type in ('fn','p','tf','tr')

group by

type_desc

-- show results

SELECT * FROM @usage

ORDER BY NumberWritten DESC

As the above shows, we believe in comments, indentation and coding standards!

How well can we pass on this knowledge?

One common problem with any consultancy is that you end up with a system which no one can understand or change. No one wants to be reliant on an (expensive) third party.

We recognise this problem, and make these promises:

Promise	Details
Intellectual property	If you pay us to write SQL for you, we'll give it to you! There'll be no licensing issues: the SQL is yours to do what you want wtih.
Training	We'll happily pass on our knowledge of SQL in general and the system we've written for you in particular, as best we can (it's what we do!). Obviously we may charge for this training, however.

What should you do now?

If you think we may be able to help you, there's only one way to find out! Send us a summary of what you're trying to achieve, and we'll get back to you with a proposal.

This page has 0 threads

Add a new post

Choose area

SQL consultancy and software development

How well do we know SQL?

How well can we pass on this knowledge?

What should you do now?

Head office

London

Manchester