SQL Server – Does the SQL Agent Service Account Must be a SysAdmin?
As of today (5/14/2013) this MSDN article says “SQL Server Agent service startup account must be a member of the SQL Server...
2013-05-14
794 reads
As of today (5/14/2013) this MSDN article says “SQL Server Agent service startup account must be a member of the SQL Server...
2013-05-14
794 reads
One of the Microsoft’s recommendation for optimizing the tempDB performance is to make each tempdb data file the same size. Today,...
2013-05-06
931 reads
Often times I keep checking the error log to make sure if everything is running fine. Here is an undocumented stored...
2013-03-25
398 reads
When an error is raised by the SQL Server Database Engine, we usually see the Severity Level as in the...
2012-11-02
438 reads
Here is a typical scenario every SQL Server DBA faces: Transaction Log grows unexpectedly or becomes full!! So, do I need to increase...
2012-10-12
476 reads
When tried to empty one of the tempdb data file using the below T-SQL command: (My goal here is to...
2012-10-07
1,576 reads
Today we got an escalation where on one of the servers ‘Agent XPs’ was in a disabled state. And when...
2012-09-19
411 reads
By Brian Kelley
In Parts 1-3, I covered how I prepare for a certification exam. In this...
By Steve Jones
I was chatting with the product managers at Flyway and one asked me whether...
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
Hi I have an overnight process that moves allot of claims records Been working...
Comments posted to this topic are about the item Unlocking Data Transformation: My journey...
Comments posted to this topic are about the item Putting the Player with the...
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers