-
“SSPI handshake failed” \ “The login is from an untrusted domain” errors
I’ve recently encountered an issue that was difficult to resolve and I didn’t find the particular cause that was troubling us documented elsewhere on the web so thought I’d record it here. The issue was with a service account connecting to SQL Server and intermittently failing to logon. Errors reported in the Windows Application Event… Read more
-
Some differences with SQL Server when running on AWS RDS
If you plan on using Amazon Web Services (AWS) to host your SQL Server based applications in the cloud, then you have a couple of options. One is just to have an EC2 instance (a VM) and install the versions of the OS and SQL Server you want. There are also images you can use… Read more
-
Extended Events Made Easy – Sorting, Grouping and Aggregation
When I’m using Profiler to analyse performance issues I often save the results to a table, or upload a trace file into a table, so that I can analyse the data. Often this involves aggregating the values for particular queries so that I can see the most resource hungry. This is by no means a… Read more
-
T-SQL Tuesday 107 – Viral Demo
For this month’s T-SQL Tuesday. Jeff Mlakar invites to talk about “a project you worked on or were impacted by that went horribly wrong”: https://www.mlakartechtalk.com/t-sql-tuesday-107-invitation-death-march/ I’m not sure the story I’m about to share is exactly what Jeff was looking for, but when you say failed project, this one usually comes to mind. This is… Read more
-
Checking for Membership of a Specific Active Directory Group
As part of my job I manage a bunch of SQL instances for Development and Test. Access is managed though Active Directory groups, so I rarely have to do anything regards managing permissions. Nonetheless I often get requests from people to give them access. This is usually for a new starter or someone who has… Read more
-
Extended Events Made Easy: Using XEvent Profiler
In this post we’ll look at how quick and easy it is to use the XEvent Profiler to create an Extended Events (XE) session to replace the most common usage of SQL Server Profiler. Before you start, update your SSMS to a recent version (17.3) or later: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017 Now, let me ask you the question… Read more
