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...

You can add a columnstore index to a table with a rowstore index. It's just another index.

I've had to do this in the past for an app. Here's what I did:

• find out the data being written. dup this table structure in a small admin db...

I think the key words there are performance. If we've improved performance with an OVER(), then yes, we ought to refactor older code. If we've changed from an IF statement...

I get less concerned over the formatting of code. These days we have products like SQL Prompt and other tools that can reformat things as we need them. I do...

Indeed. Part of what I wanted to convey is that you need to look at the problem and decide if it's a nail or screw.

I think most people get using...

LA