Extended Events Permissions
Some view the permissions for Extended Events as a limitation. I see the required permissions as an appropriate set and recommend all to work with XE and permissions to...
2017-12-26
127 reads
SQL RNNR
An Identity Crisis: Is it Profiler or is it Extended Events?
I have been working on this article for far longer than one might think is necessary for something of this...
2018-01-04 (first published: 2017-12-22)
2,009 reads
An Identity Crisis: Is it Profiler or is it Extended Events?
I have been working on this article for far longer than one might think is necessary for something of this...
2017-12-22
113 reads
An Identity Crisis: Is it Profiler or is it Extended Events?
Despite it being new, it seems there are a handful of "facts" already published about it that may or may not be accurate. Due to that, I want to...
2017-12-22
3 reads
Capture Index Maintenance Operations
One good database maintenance practice is to keep the indexes in good working order. This is typically done via index...
2017-12-20
598 reads
Capture Index Maintenance Operations
If an application vendor has something built into their code to perform index maintenance, unbeknownst to you, that is a near-worst case scenario.
Related Posts:
Where is that Mask? December 28,...
2017-12-20
2 reads
T-SQL Tuesday #097: Learning Plans
Stylishly Late
I am fabulously late and therefor breaking the guiding rules that make up TSQLTuesday. Where’s the ruler to slap...
2017-12-18
467 reads
T-SQL Tuesday #097: Learning Plans
If you are not progressing, you are regressing. In the same vein, if you are not learning, you are regressing.
Related Posts:
T-SQL Tuesday #102: Giving Back May 8, 2018
T-SQL...
2017-12-18
2 reads
Incorrect Syntax – What?
Intuitive errors are very helpful when trying to troubleshoot a problem. On the other hand, when we receive an error...
2017-11-17
328 reads
Incorrect Syntax – What?
Intuitive errors are very helpful when trying to troubleshoot a problem. On the other hand, when we receive an error that is vague, we sometimes find ourselves wanting to...
2017-11-17
20 reads
Blogs
Why Developers Shouldn’t Have sysadmin access in SQL Server
Why Developers Shouldn’t Have sysadmin access in SQL Server 7 reasons—and exactly what to do instead It...
A New Word: Ecstatic Shock
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
Forums
sp_prepare and sp_execute vs sp_executesql
I have noticed sp_executesql also makes a single plan for a stmt with parameter...
Find Invalid Objects in SQL Server
Comments posted to this topic are about the item Find Invalid Objects in SQL...
Question of the Day
Who am I?
If I want to track which login called a stored procedure and use the value in an audit, what function can I use to replace the xxx below?
create procedure AddNewCustomer
@customername varchar(200)
AS
BEGIN
DECLARE @added VARCHAR(100)
SELECT @added = xxx
IF @customername IS NOT NULL
INSERT dbo.Customer
(
CustomerName,
AddedBy
)
VALUES
(@customername, @added)
END See possible answers