SQL consultancy - let Wise Owl make sense of your data

Have you got a pile of data which you need to make sense of?

Steaming pile of data

Sometimes your database can seem like an impenetrable pile, but we can help you make sense out of it.

 

 

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're also experts in Integration Services, Reporting Services, Excel and Access, so we can choose the most appropriate tool for the 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:

The usage of SQL table

Those 246 stored procedures must do something useful ...

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 post