×

WMI issue with SQL Server 2014

November 21, 2014

Issue: I installed sql2014 enterprise edition with cu3 in the following machine.  Just as a disclaimer I have been running a SQL 2012 edition on the same host without any issue with WMI counters. I could not see any WMI counters for sql2014.  I tried perfmon.exe and also querying: Then I snipped through SQL server […]

Deadlock Detection and Reporting part-II

November 21, 2014

This is a continuation of the series about deadlock. The first part was how you detect deadlock in SQL Server and collect that information.  This part will be about reporting from the collected information. On the 2nd step of the job the code below will parse the XML and send .xdl file along with information in tabular format. […]

Deadlock Detection and Reporting part-I

November 21, 2014

This will be a 2 part series about deadlock. The first part will be about how you detect deadlock in SQL Server and collect that information. The second part will be about reporting from the collected information. A deadlock is a transient event until one of the processes becomes a victim. Unless you persist all […]


profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook

Happy Monday! Hope you had a great weekend.
@codegumbo will be talking about: "DevOps & Databases: Challenges &... Possibilities"
Registration details:
https://www.meetup.com/dbavug/events/281082077/
Wednesday, December 8, 2021
12:00 PM to 1:00 PM EST

#devops #database #DBA
#Developers

Happy Friday! Do not forget to sign up for a talk by @codegumbo "DevOps & Databases: Challenges & Possibilities"...
Registration details:
https://www.meetup.com/dbavug/events/281082077/
Wednesday, December 8, 2021
12:00 PM to 1:00 PM EST

#devops #database #DBA
#Developers

More than a great read from @nocentino It's a step by step guide to Configure SQL Server on Linux for Active Directory ... Authentication #SQLServer #SQLonLinux #AzureSQL
#MVPBuzz
https://www.nocentino.com/posts/2021-12-1-sql-server-linux-active-directory/.

#sqlhelp
I am member of 'SQL Active Directory Admin' group in synapse workspace.
Using SSMS I can connect to 'Dedicated... SQL endpoint' but getting log in failure while trying to connect to 'Serverless SQL endpoint'
Any suggestion?
#Azure #azuresynapse

Load More...
/* (function () { var s = document.createElement('script'); s.type = 'text/javascript'; s.async = true; s.src = 'https://app.termly.io/embed.min.js'; s.id = '4f4146f3-eaa6-4e46-8f46-3fc9f2223b5f'; s.setAttribute("data-name", "termly-embed-banner"); var x = document.getElementsByTagName('script')[0]; x.parentNode.insertBefore(s, x); })(); */