That gives the installation of the files for Full-Text search, not if it is in use. Enabled is a strange term. It's essentially always enabled if installed, but might not...

Thom has provided good logic. What do you want? 35 characters from the beginning and then remove any whitespace? Or remove whitespace, then take the 35 characters from the left.

As Phil noted, input types matter

DECLARE @i INT = 100
, @j NUMERIC(7, 4)
SELECT @j = @i
SELECT @i, @j

I have a home office, and I'm in and out regularly, but I do make it a point often to not go in there unless I need something or I'm...

Those are cool places. I'm heading to Lingen this year, from Amsterdam. I count the latter as I spent a weekend there in college, getting another 2 days this year.

I've...

Glad to see you've been to a few places. I've done a lot in the last 4-5 years, close to and in my 50s. It's a challenge to travel, though...

Good point, Rod. You can do this from ADS/VS. I'll do a short article on that.

You can use PoSh (https://www.visualstudiogeeks.com/DevOps/UsingPowerShellForGitHooksWithVstsGitOnWindows). You could also use batch files (https://stackoverflow.com/questions/49032756/git-hooks-on-windows-with-batch).

These technically start with bash as the way git works is to be cross-platform, so bash is...

I think AGs are great, but as you noted, testing is important. I've backup/restore elsewhere and verify things work on the new version. That's really important. I'd also set up...

It's not permissions, it's a policy. There is something set that is interfering with the sQL installation.

The big issue for compliance in many orgs is knowing what was done. Not preventing mistakes, but knowing that a mistake was made.

There are companies who have developers merge code...

There is an OPENDATASOURCE or OPENROWSET, though this is really for adhoc work. You can use those if you have a SQL SErver instance.

SSMS does not connect directly to Excel.

dbcc is there to alert you of problems when they occur, primarily corruption issues.

If you don't run these, then they can be in your backups. Potentially if you needed to...

This is a policy issue, not Microsoft. Your org has locked down the machine. Talk to a domain admin.

The Bible series are a good overview of the platform. That being said, SQL Server 2016 changed how the platform works dramatically, so I don't know that I'd pay much...