I would start by reading this:

https://www.microsoft.com/en-us/learning/certification-exam-policies.aspx

Specifically the section about the NDA:

 Why am I required to accept a non-disclosure agreement (NDA) before I take an exam?

The Microsoft Certification Program requires candidates...

In the  article you mention PoSH as well, and my tool of choice (despite the bugs I've found and live with) is Powershell Plus Professional Edition (which is...

I think our approaches to index creation/removal are a bit different.  But if it works for you, that's good!

My thoughts though about performance are less about indexes specifically, but on...

Rob Reid - If you have the server running for a week or two and you designed the thing, you should have access to the metrics on the server, right? ...

My first recommendation is not  to use Excel and VBA to pull data from the database (or push it in... I'm a little unclear on what is happening here) but...

I am glad it worked for you!

For me, intellisense has never worked well over a linked server or even cross-database on the same instance.  Sometimes it gives me the list...

My personal preference is to avoid the "all in one" solutions as they often have limited features and updates have a higher chance of introducing bugs in features I use. ...

So, natively I don't think SQL Server has anything like this.  That being said, getting the result you list is not an impossible task in SQL Server.  Quick bit of...

The screenshots make me wonder if it is worth doing fragmentation work at all.  The index size is pretty small with the largest being 15 MB.  So rebuilding or reorganizing...

one thought (without downloading your code, so excuse any suggestions you already did) - put "SET NOCOUNT ON" at the start of your script and have the DBA run the...

My opinion - a SQL Server DBA is not likely to get much training from a project.  A database developer would; a database architecht would, but the administration side of...

Step 1 - check the logs.  SSRS logs, SQL Server logs, and Windows event logs.  One of those will have more information about the error.

If the logs are not helpful,...

I agree with Steve here.

On top of that, if you are wanting someone to help with a project, you should provide some details on the project.  Is it strictly a...

I just read the article and I think I am a mix of gatekeeper and flexible.   Some things I see as hard-fast rules that should not be debated with new...

To recovery the master key, if the password is known, you run (the button for adding SQL is missing for me right now, sorry for the poor formatting):

OPEN MASTER KEY...