5/30/2011

New Blog Domain Name: http://www.bloomconsultingbi.com/

My old blog was:

http://www.tampabaybi.com/

I figure I don't represent Tampa Bay, so I got a new domain -->

http://www.bloomconsultingbi.com/


Same content, new name.

Also, my new twitter handle is: SQLJon

5/12/2011

Splunk - Operational Intelligence

Here's something new I came across this morning - Splunk.

It takes your machine data and makes sense of it.

- Click here for Link -

And Operational Intelligence seems to be like compressed Business Intelligence.

Where BI is like an encyclopedia or newspaper, OI is real time monitoring of process' with the ability to intervene and apply some "action" for exceptions/anomalies.

A dynamic BI if you will.

What's next? - in my opinion, a machine layer of Artificial Intelligence...? that can monitor behavior, watch for deviations, apply rules/actions based on those random occurrences, as well as predict future behavior based on patterns.

Wow!

5/06/2011

Search Stored Procedures with SQL in SQL Server

Here's a good reference link with sample query to search SQL-Server for TEXT.

- Click Here for Link -

Modified the code slightly:

    DECLARE @StringToSearch varchar(100)
    SET @StringToSearch = 'TRU'
    SET @StringToSearch = '%' + UPPER(@StringToSearch) + '%'
    SELECT DISTINCT SO.NAME
    FROM SYSOBJECTS SO (NOLOCK)
    WHERE SO.TYPE = 'P'
    AND UPPER(SO.NAME) LIKE @StringToSearch

5/02/2011

Sample Query's ReportServer LINK

Here's some good links to query the ReportServer

- Click Here for Link -

To get User Permissions by Folder
SELECT
c.[Name]
, u.[UserName]
, r.[RoleName]
FROM [ReportServer].[dbo].[PolicyUserRole] pur
LEFT JOIN [ReportServer].[dbo].[Users] u on pur.[userID]=u.[userID]
LEFT JOIN [ReportServer].[dbo].[Roles] r on pur.[roleID]=r.[roleID]
LEFT JOIN [ReportServer].[dbo].[Catalog] c on pur.[policyID]=c.[policyID]
WHERE [RoleName] = 'Browser'
AND c.[TYPE] = 1
AND c.[Hidden] <> 1
AND c.[Name] <> 'Data Sources'
ORDER BY c.[Name], u.[UserName], r.[RoleName]

To Get Folder Names

SELECT DISTINCT
c.[Name]
FROM [ReportServer].[dbo].[PolicyUserRole] pur
LEFT JOIN [ReportServer].[dbo].[Users] u on pur.[userID]=u.[userID]
LEFT JOIN [ReportServer].[dbo].[Roles] r on pur.[roleID]=r.[roleID]
LEFT JOIN [ReportServer].[dbo].[Catalog] c on pur.[policyID]=c.[policyID]
WHERE [RoleName] = 'Browser'
AND c.[TYPE] = 1
AND c.[Hidden] <> 1
AND c.[Name] <> 'Data Sources'
ORDER BY 1

Mountain Living