Viewing 15 posts - 3,811 through 3,825 (of 19,560 total)
Here is a script to get a full blown audit of security
http://jasonbrimhall.info/2010/03/19/security-audit/
It's beyond what you requested but will cover all of the bases.
Another script I saw recently is here that...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 7, 2014 at 1:04 pm
They should still display a database name. With no activity on the server, all of my instances still show a database name for those spids.
I think it must be...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 7, 2014 at 12:51 pm
Robert klimes (2/7/2014)
Jeff Moden (2/7/2014)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 7, 2014 at 12:22 pm
L' Eomot Inversé (2/7/2014)
SQLRNNR (2/7/2014)
ConfidenceTrickster
TURN
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 7, 2014 at 12:14 pm
Ed Wagner (2/7/2014)
L' Eomot Inversé (2/7/2014)
Jeff Moden (2/7/2014)
Koen Verbeeck (2/6/2014)
Steve Jones - SSC Editor (2/6/2014)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 7, 2014 at 11:39 am
Confidence
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 7, 2014 at 11:36 am
Intriguing question
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 7, 2014 at 11:32 am
Jeff Moden (2/7/2014)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 7, 2014 at 11:21 am
MyDoggieJessie (2/7/2014)
Here's the ugliest way around the issue (as pointed out by SQLRNNR)D-ECLARE @String varchar(250)
SET @String = 'xxxdb_backup_2014_02_06_073328_1849272.trn'
SELECT LEFT(@String, CHARINDEX('_', @string, 7)) + REVERSE(SUBSTRING(REVERSE(@String),...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 7, 2014 at 11:05 am
jasona.work (2/7/2014)
SQLRNNR (2/7/2014)
ChrisM@Work (2/7/2014)
Anybody else seeing a kinky image of Koen, Gail and Grant wondering around without their tshirts?
Kinky??
Um no. Just got back from SQLCruise with Grant and nobody...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 7, 2014 at 8:34 am
Jason Carter (2/7/2014)
akthar hussain (2/7/2014)
A question i received on a pre-interview test:How do you eat an elephant?
I believe the best answer to this is the classic
One bite...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 7, 2014 at 8:31 am
call.copse (2/7/2014)
Abu Dina (2/7/2014)
...The second question in particular really bothered me...
That is definitely one to have mapped out in advance. I'm British and so really awkward about that sort of...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 7, 2014 at 8:26 am
ChrisM@Work (2/7/2014)
Anybody else seeing a kinky image of Koen, Gail and Grant wondering around without their tshirts?
Kinky??
Um no. Just got back from SQLCruise with Grant and nobody wants to...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 7, 2014 at 8:20 am
GilaMonster (2/7/2014)
Koen Verbeeck (2/7/2014)
GilaMonster (2/7/2014)
Koen Verbeeck (2/7/2014)
Ed Wagner (2/7/2014)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 7, 2014 at 8:18 am
inoculation
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 7, 2014 at 8:11 am
Viewing 15 posts - 3,811 through 3,825 (of 19,560 total)