Things to check that you may not realize are stored in the "system" databases:

• script out all logins for the instance:

  https://support.microsoft.com/en-us/help/918992/how-to-transfer-logins-and-passwords-between-instances-of-sql-server

• script out login server roles:

  SELECT...

you can try looking in the SQL Server error log like this:

EXEC master.dbo.xp_readerrorlog 0, 1, N'Login Failed'

pass.org  says the London group can be found at:

https://sqllondon.pass.org/

meetup group at:

https://www.meetup.com/Microsoft-Data-London/

you may have better luck there.

PASS is the Professional Association of SQL Server, and has lots of resources,...

To understand what this query is doing, think about the sets of data this represents.  To me, this query says:

• Look at all of the requests that were either cancelled,...

I believe that the optimizer will see the estimated count from the subquery and determine that the list of postid from the Comments table won't be selective enough to justify...

I can answer some of your questions.  It is a good decision to not run SSIS as part of the cluster, since it's not a cluster aware process and has...

The main confusion I've experienced with the Access Database Engine redistributable is based on trying to install it on a developers computer.  Since Visual Studio is still a 32 bit...

They did win the NFL championship for the 1964 season...

is the remote procedure being called with a 4 part name directly or by using OPENQUERY?  I try to avoid cross instance items where I can but I do try...

Understanding the impact of creating a potential index requires you take a more holistic approach to how that table is used.  If you look at sys.dm_db_index_operational_stats and sys.dm_db_index_usasge_stats, you can...

I'm a Browns fan... we've forgotten what a "game we shouldn't loose" is.

Can the pivoting be done in Excel or whatever reporting tool your company uses?  While I have seen the dynamic SQL type solutions work for this, it's probably best to...

Over the years as both a Database Developer and DBA, I've found SSIS to be a good tool.  As others have said, not necessarily the best tool, but it exposes...

The interaction between DBAs and Database Developers can vary from company to company.  The Brent Ozar article linked by Beatrix is a good overview of the different positions though.  From...

I tend to use this instead:

 ALTER DATABASE [mydbname] SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE;

this would prevent any non SYSADMIN type users from getting in before the restore...