In the past few months I was working on SSMS Lizard which is also productivity extension, but different than extensions mentioned here. Would you please consider adding it to...

Hi, Steve. Thanks for article.

But first variant with pure Export-Csv approach is useless due to quoting all values for all fields (for powershell 7 you has QuoteFields parameter but you...

I'd write it like this:

IF @X = 1 BEGIN
    RETURN 'xyz';
END
ELSE BEGIN
    RETURN 'abc';
END;

Indeed preferable, since it should prevent errors like:

Good work. I'd like to suggest a few additions with regard to your examples:

<li style="list-style-type: none;">

• Only use IF with BEGIN and END. That should be mandatory in...

The entire plural column is 'no' including temporal tables.  If tables are collections of rows then they should be plural, no?  If the table name is 'orders' then one...

This is a helpful article with a lot of useful tips and documentation to support those tips.

One thing I noticed missing is location of creating temporary tables in stored...

As mentioned by Jeff tbl-ing is really setting up an environment for bad things. What happens when you have a table tblEmployee and you need to make some changes...

• This reply was modified 4 years, 11 months ago by  Konstantin Taranov.

Well, I got to the first line of the article "Database UPPERCASE". I just wondered why you should have a database in uppercase? What if it consisted of 2...

On the subject of the article itself, thanks for taking the time to put something so extensive together.

As you said, though... "The recommendations in this article are not the...

I hate the way this site does NOT handle tables.  I have a screen wide enough to display the whole table but it's still formatted super narrow so someone...

• This reply was modified 4 years, 11 months ago by  Konstantin Taranov.
• This reply was modified 4 years, 11 months ago by  Konstantin Taranov.

Hi, thank for suggestion, added: https://github.com/ktaranov/sqlserver-kit/blob/master/Utilities/README.md#erbuilder%5B/quote%5D

Hi, Thank you for your efforts,

about ERBuilder, they recently launched 3 new editions (starter, pro, and enterprise) with price starting at...

• This reply was modified 4 years, 11 months ago by  Konstantin Taranov.

Thanks! Just add star in github and if you have a question about SQL Server - open issue or create pull request.

Hi, Marius.

Thanks for suggestion but for scripts (not tools and utilities) i use section Open Source project in main README.md file and your repo already here: https://github.com/ktaranov/sqlserver-kit#open-source

Hi, thank for suggestion, added: https://github.com/ktaranov/sqlserver-kit/blob/master/Utilities/README.md#erbuilder

Added, great thanks for new undocumented flag  (just 2 flags left for 600).

https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Trace%20Flag.md#833