without reinventing the wheel?

it's much easier to add it:

it's in the zip...

DelimitedSplit8K is a TSQL function.

Find the article with the string splitter named DelimitedSplit8K here on SSC and download it;

it makes spitting things like this a lot easier.

once split, you just filter for items that...

here's the script i use to generate the CREATE VIEW scripts for all extended events on the server:;

it has a reference to master.dbo.DelimitedSplit, which is a version i made of...

I've created views for all my Extended Events, so they are a little slow, but orders of magnitude easier to use.

yes the views shread the XML, but once written they...

In Registered Servers, "Local Server Groups", save Credentials with either SQL or Windows;the data is stored in your %appdata% folder, so it is user specific and not shared.

Central Management...

I've seen this happen recently on a Web/WPF app where the SQL Instance was using SQL Express;

as a resource conservation attempt, the express version defaults databases to auto close,and...

this is what i've used for quite a long time:

I wanted both server uptime and the SQLService uptime.

i made a simple stored proc, sp_help_uptime and put it in master,...

well, sp_who/sp_who2 should at l least show what is connecting to that database, I would just force the database off line then.

in 2005 and above, i know we could do...

The SSRS Service is always active in the database, even when it's not really doing anything.

SQL Server Reporting Services has two parts:

The Service and the Databases it points to and...

at the time i was answering, i had tunnel vision.

i swear, it looked like...

since this is more of an in your face dashboard, you'll need to build the pieces, failed jobs vs next scheduled jobs.

this site has a nice query for the next...

also in my experience, every trigger,package,procedure and function in oracle will have to be rewritten, even when they is doing the most trivial CRUD operations, and especially because the...

Eric thanks for prompting me to investigate Server Roles deeper.

this is the role i came up with, that grants select on any user objects as well as the view server...

interestingproblem;

here's how i think i would tackle it;

substitute [ClarkKent] for your [domain\ADGroup]

Create LOGIN [ClarkKent] WITH PASSWORD='NotTheRealPassword'

--see anything in the DMV's

GRANT VIEW SERVER STATE TO [ClarkKent];

--allow to see object definitions, tables...