Microsoft SQL Server Utilities and Tools

Question

Microsoft SQL Server Utilities and Tools

Viewing 15 posts - 46 through 60 (of 74 total)

You must be logged in to reply to this topic. Login to reply

Robert Sterbal SSChampion Points: 11053 More actions · Answer 1

This script is useful for the people using the Glen Berry DMV queries:
http://www.sqlstad.nl/powershell/automate-glenn-berrys-dmv-scrips-with-powershell/

412-977-3526 call/text

Jeff Moden SSC Guru Points: 1004402 More actions · Answer 2

robert.sterbal 56890 - Thursday, July 20, 2017 12:31 PM
Jeff Moden - Thursday, July 20, 2017 12:16 PM
robert.sterbal 56890 - Thursday, July 20, 2017 7:54 AM
I've decided to try to put up a wiki on Github. I may move it if it is too hard to create and maintain pages.
I put up 3 pages so far:
https://github.com/ktaranov/sqlserver-kit/wiki
https://github.com/ktaranov/sqlserver-kit/wiki/list-of-.sql-files
https://github.com/ktaranov/sqlserver-kit/wiki/RedGate's-Free-eBooks
suggestions welcome
So, are you "ktaranov"?
No. He has figured out how to use Github to compile resources and I thought having multiple views at the same place would be helpful.

First, I DO absolutely appreciate what you're trying to do. Well done there. Just a word of caution and a possible suggestion...

I'd not be one to do such a thing unless I had verified that the code in the links was actually good to go both accuracy-wise and performance-wise. I'd also make it so that the links worked instead of just being a partial, non-clickable link.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Konstantin Taranov SSCertifiable Points: 6498 More actions · Answer 3

robert.sterbal 56890 - Monday, August 14, 2017 12:12 PM
This script is useful for the people using the Glen Berry DMV queries:
http://www.sqlstad.nl/powershell/automate-glenn-berrys-dmv-scrips-with-powershell/

Thanks, awesome link and repo: https://github.com/sanderstad/Export-DMVInformation/

Added to my Powershell script section: https://github.com/ktaranov/sqlserver-kit/commit/f38eebb1c685b33190da75c30ae1d27fabf8033b

Robert Sterbal-482516 SSCrazy Points: 2874 More actions · Answer 4

Please consider adding:

https://www.red-gate.com/products/sql-development/sql-code-guard/

Here is the related links: https://www.red-gate.com/simple-talk/sql/t-sql-programming/sql-code-smells/

Konstantin Taranov SSCertifiable Points: 6498 More actions · Answer 5

Robert Sterbal-482516 - Tuesday, September 12, 2017 4:34 AM
Please consider adding:
https://www.red-gate.com/products/sql-development/sql-code-guard/
Here is the related links: https://www.red-gate.com/simple-talk/sql/t-sql-programming/sql-code-smells/

Hi, Robert. This tool is located in another list - SSMS Addins: http://www.sqlservercentral.com/articles/SSMS/159134/

Robert Sterbal SSChampion Points: 11053 More actions · Answer 6

Are you documenting the smells as well as the tools?

412-977-3526 call/text

Jeff Moden SSC Guru Points: 1004402 More actions · Answer 7

Heh... the list of "smells" reminds me of when Robocop had a hundred rules injected into his memory and could no longer function correctly. If you have enough "smells", no code will work except the nearly useless renditions offered by following ANSI/ISO-Only code rules.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Thom A SSC Guru Points: 99133 More actions · Answer 8

Jeff Moden - Tuesday, September 12, 2017 8:28 AM
Heh... the list of "smells" reminds me of when Robocop had a hundred rules injected into his memory and could no longer function correctly. If you have enough "smells", no code will work except the nearly useless renditions offered by following ANSI/ISO-Only code rules.

How you you suggest SSMS smells Jeff? HOw about Visual Studio Code and BeaverDB (I assume that it smells like a beaver :P)?

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Konstantin Taranov SSCertifiable Points: 6498 More actions · Answer 9

robert.sterbal 56890 - Tuesday, September 12, 2017 8:11 AM
Are you documenting the smells as well as the tools?

I planned to do it in our https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Name%20Convention%20and%20T-SQL%20Programming%20Style.md#t-sql-programming-style but Fill Factor already do it: https://www.red-gate.com/simple-talk/sql/t-sql-programming/sql-code-smells/
I will update our guide in October after analyze Fill Factor article.

Jeff Moden SSC Guru Points: 1004402 More actions · Answer 10

Thom A - Tuesday, September 12, 2017 8:57 AM
Jeff Moden - Tuesday, September 12, 2017 8:28 AM
Heh... the list of "smells" reminds me of when Robocop had a hundred rules injected into his memory and could no longer function correctly. If you have enough "smells", no code will work except the nearly useless renditions offered by following ANSI/ISO-Only code rules.
How you you suggest SSMS smells Jeff? HOw about Visual Studio Code and BeaverDB (I assume that it smells like a beaver :P)?

In honor of the diapers that I'll likely have to wear in a decade or two that will have similar smells, I'll say "It DEPENDS". 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

francesco.mantovani SSC Eights! Points: 840 More actions · Answer 11

What @Robert Sterbal-482516 is trying to say is that a wiki can allows you to sort the column from A to Z.

The goal is to filter by Platform or by Cost. The GitHub table doesn't allows you to do so.
There are a few alternatives:
1) You can simply drag and drop your spreadsheet: https://help.github.com/articles/file-attachments-on-issues-and-pull-requests/
2) You can upload the spreadsheet to Google Sheet and then copy/paste the embedded code to GitHub

🙂 Basically we need raw data 🙂

Thank you so much for your work

Konstantin Taranov SSCertifiable Points: 6498 More actions · Answer 12

francesco.mantovani - Thursday, February 7, 2019 1:30 PM
What @Robert Sterbal-482516 is trying to say is that a wiki can allows you to sort the column from A to Z.
The goal is to filter by Platform or by Cost. The GitHub table doesn't allows you to do so.
There are a few alternatives:
1) You can simply drag and drop your spreadsheet: https://help.github.com/articles/file-attachments-on-issues-and-pull-requests/
2) You can upload the spreadsheet to Google Sheet and then copy/paste the embedded code to GitHub
🙂 Basically we need raw data 🙂
Thank you so much for your work

Hi, Francesco. Thanks for positive feedback. You can sort and filter on this page: http://sqlserver-kit.org/en/sql-server-utilities
For example, all alternatives for SSMS: http://sqlserver-kit.org/en/sql-server-utilities?queries%5Bsearch%5D=%5BMS%5D

In the near future, I plan to collect in a convenient form in Excel all the useful resources from my repository https://github.com/ktaranov/sqlserver-kit

vincent.grazapoli SSC Rookie Points: 48 More actions · Answer 13

Please consider adding SQL+
http://www.sqlplus.net

SQL+ is a tool that generates a class library from stored procedures by utilizing a tagging system in the form of comments. Does all the ADO stuff like setting up parameters and converting result sets into objects.

Robert Sterbal SSChampion Points: 11053 More actions · Answer 14

kast218 - Friday, February 8, 2019 4:33 AM
francesco.mantovani - Thursday, February 7, 2019 1:30 PM
What @Robert Sterbal-482516 is trying to say is that a wiki can allows you to sort the column from A to Z.
The goal is to filter by Platform or by Cost. The GitHub table doesn't allows you to do so.
There are a few alternatives:
1) You can simply drag and drop your spreadsheet: https://help.github.com/articles/file-attachments-on-issues-and-pull-requests/
2) You can upload the spreadsheet to Google Sheet and then copy/paste the embedded code to GitHub
🙂 Basically we need raw data 🙂
Thank you so much for your work
Hi, Francesco. Thanks for positive feedback. You can sort and filter on this page: http://sqlserver-kit.org/en/sql-server-utilities
For example, all alternatives for SSMS: http://sqlserver-kit.org/en/sql-server-utilities?queries%5Bsearch%5D=%5BMS%5D
In the near future, I plan to collect in a convenient form in Excel all the useful resources from my repository https://github.com/ktaranov/sqlserver-kit

Please consider posting the list to a google sheet

412-977-3526 call/text

Konstantin Taranov SSCertifiable Points: 6498 More actions · Answer 15

vincent.grazapoli - Friday, February 8, 2019 8:53 AM
Please consider adding SQL+
http://www.sqlplus.net
SQL+ is a tool that generates a class library from stored procedures by utilizing a tagging system in the form of comments. Does all the ADO stuff like setting up parameters and converting result sets into objects.

Hi, Vincent. Added via https://github.com/ktaranov/sqlserver-kit/commit/7535c7a084e85ad902e73abbfecb86605d34bc48
Could you provide additional information: Modified date, Price, SQL Server support versions, another database support?