Reputation
7,912
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
2 16 50
Impact
~425k people reached

19h
comment The SQL Server Network Interface library could not deregister the Service Principal Name
One does not have anything to do with the other. The error regarding SPN has nothing to do with the service not starting. Error 1067 just means the service did not start, it is not sufficient information to determine why.
1d
comment Is Service Pack 2 completely installed on Passive Node of SQL Server 2012 Instance?
Have you looked at the installation log to see what it says?
1d
comment Output in SQL Profiler has results with Database ID as NULL
Please add a script of the trace you were running.
Apr
24
revised Receiving the following error in step failure of an agent job:
added 44 characters in body
Apr
24
revised Receiving the following error in step failure of an agent job:
added 32 characters in body; edited tags
Apr
24
comment SSMS down arrow on last line
I have never heard of that one, nor is it listed here technet.microsoft.com/en-us/library/…
Apr
21
comment Sql Agent Jobs executes too slow
How large is your msdb.dbo.sysjobhistory table?
Apr
20
comment Passing passwords more securely to mysql utilities on the command line
In Powershell you can put your password in a variable and use the cmdlet get-credentialthen just grab the password property to pass where needed, or use something like read-host "Enter password" -AsSecureString.
Apr
20
comment Why is the transaction log file not truncated though its simple recovery model?
Even though you are using simple recovery I would still consider this a duplicate question.
Apr
18
comment What's a good tool for visualizing SQL Agent jobs?
@steam your edit should be an answer and not an edit to someone's answer.
Apr
18
comment What is the best Technical Advice to setup Microsoft SQL Server in an Entry Level Server with 2 SATA Disks?
This type of question is not something that works well on this site. There are blog post on this topic and RedGate offers a free ebook on hardware for SQL Server.
Apr
14
reviewed Approve webscalesql tag wiki excerpt
Apr
14
reviewed Approve webscalesql tag wiki
Apr
12
comment How to output more than 4000 characters in sqlcmd
Thought about just using PowerShell's SQLPS command Invoke-Sqlcmd? I don't believe it has the character limit issue but have not specifically used it to try.
Apr
4
comment Is it possible to trace queries that never complete with SQL Server 2008 R2?
I knew someone had written about using XEvents to do it, just couldn't remember.
Apr
1
comment SQL Server Timesheet Query Performance
Execution plan would be helpful, can you post the XML or use SQL Sentry Plan Explorer and post it to SQLPerformance.com.
Mar
30
answered Why do maintenance plans exist as a feature?
Mar
14
accepted SSIS Event Handler at Package Level
Mar
14
awarded  Notable Question
Mar
10
comment Poorly Performing Query - SQL Server Best Practices
You might also check with the vendor (Idera). Generally they offer a certain amount of time in tech support to assist with some initial setup like this, worth asking.