The more I learn about SQL Server (mostly through painful lessons lol), the more I find it useful to consider somewhat higher-level interview questions.

Things like version control. Not necessarily product...

Hi Michael,

Thanks for your feedback. I will look into the comments issue. I can see the view definition, but I am sysadmin so that makes sense. I will test with...

It may be some time before the full impact of any tech comprises from the Capitol insurrection are made clear. Stolen laptops, passwords, hidden cameras or recording devices may have...

• This reply was modified 4 years, 8 months ago by webrunner.

Thanks for your reply, Andy. I don't recall exactly, but basically I downloaded VS 2017 Community Edition to my local computer, ran some steps to get the offline files, then...

Thanks, Brian, for your response.

That being said, why do you need this installed on a server?  I don't think I have ever installed visual studio on a server.  I always...

Never mind. I think this is the answer: There seemed to be some lag time where AD needed to synchronize the info. The user can now log in successfully. I...

Thanks, Steve, those are great points.

Thanks for this editorial and for the link to the Paul Cunningham article. Great food for thought.

Although I understand that much of the advice is timeless, so to speak, I...

Thanks for this info!

-- webrunner

+10

That is what I use. Great combination. I also add Red Gate SQL Search. I'm open to better SQL IDEs but SSMS is the most...

Thanks to both of you for your help! I'll read through those references.

-- webrunner

Lol! This has me waiting for a button that takes us to the "FDYFreirePrageny" version of SQLServerCentral. 🙂

-- webrunner

Thanks for this article! It is very helpful to see more articles on Always On Availability Groups.

-- webrunner

Hi Jeffrey,

Actually I think I realize what's happening. There are multiple availability groups filled with databases that have somewhat similar names. I just checked and the database giving me the...

Hi Jeffrey,

I tried both the listener and the primary replica node. I use this query to determine the current primary replica.

IF SERVERPROPERTY ('IsHadrEnabled') = 1
BEGIN
SELECT
  ...