Microsoft SQL Server Utilities and Tools

Question

Microsoft SQL Server Utilities and Tools

Viewing 15 posts - 1 through 15 (of 74 total)

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

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

Awesome list. Did you ever consider posting the content on a wiki?

Konstantin Taranov SSCertifiable Points: 6498 More actions · Answer 2

Robert Sterbal-482516 - Thursday, June 22, 2017 9:21 PM
Awesome list. Did you ever consider posting the content on a wiki?

Hi, Robert. Great thanks for your feedback. This list maintained on Github: https://github.com/ktaranov/sqlserver-kit/blob/master/Utilities/README.md
You can anytime create pull request or issue. Or just post here your suggestions.

sql_lock SSCrazy Eights Points: 9373 More actions · Answer 3

Wowzer. Nice list of tools.

Thank you for taking the time to compose these!

Konstantin Taranov SSCertifiable Points: 6498 More actions · Answer 4

sql_lock - Friday, June 23, 2017 12:16 AM
Wowzer. Nice list of tools.
Thank you for taking the time to compose these!

Thanks for your answer! Be free correct some errors or add more tools. Also you can sort and search useful utilities here: http://sqlserver-kit.org/en/sql-server-utilities

GregLow SSC Veteran Points: 254 More actions · Answer 5

Hi Koisntantin,
We've also got a free set for your list (SDU Tools): http://www.sqldownunder.com/resources/sdutools
All developer and DBA utilities.
Regards,
Greg

Konstantin Taranov SSCertifiable Points: 6498 More actions · Answer 6

greg 86273 - Friday, June 23, 2017 1:33 AM
Hi Koisntantin,
We've also got a free set for your list (SDU Tools): http://www.sqldownunder.com/resources/sdutools
All developer and DBA utilities.
Regards,
Greg

Hi, Greg. Yes, I know about your very good function and scripts and this types of links we maintained in main README file in Resource section: https://github.com/ktaranov/sqlserver-kit/blob/master/README.md (your link in Other section).
Also I recommended you put your awesome work on github - I promise you create some pull requests.

Thom A SSC Guru Points: 99127 More actions · Answer 7

You have mssql for Visual Studio code as not Cross Platform, but I can confirm that it very much works on Ubuntu 16.04 (and I imagine Mac/Docker as well).

Thom~

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

databoffin SSC Veteran Points: 279 More actions · Answer 8

Hi, I tried to update this via git a few months back bu OmniCompare is now Aireforge Studio.

Release date: 21 June 2017
Download page: https://aireforge.com/studio/download
Free version: Yes
Paid version: $299

It’s hard to categorise but I would say it falls into [IDX],[MG], [SC].

Cheers,
Phil

Solving data & infrastructure issues via xTEN[/url] and our application, Aireforge[/url].

Konstantin Taranov SSCertifiable Points: 6498 More actions · Answer 9

Thom A - Friday, June 23, 2017 2:35 AM
You have mssql for Visual Studio code as not Cross Platform, but I can confirm that it very much works on Ubuntu 16.04 (and I imagine Mac/Docker as well).

Thanks for answer - corrected in this commit: https://github.com/ktaranov/sqlserver-kit/commit/1101140c6200f4a8b962625f64a763899d51d276

Konstantin Taranov SSCertifiable Points: 6498 More actions · Answer 10

databoffin - Friday, June 23, 2017 3:09 AM
Hi, I tried to update this via git a few months back bu OmniCompare is now Aireforge Studio.

Release date: 21 June 2017
Download page: https://aireforge.com/studio/download
Free version: Yes
Paid version: $299
Itâ€™s hard to categorise but I would say it falls into [IDX],[MG], [SC].
Cheers,
Phil

Thanks for your useful product, update info and rename it: https://github.com/ktaranov/sqlserver-kit/commit/1101140c6200f4a8b962625f64a763899d51d276. Are you planing add support for SQL Server 2017?

databoffin SSC Veteran Points: 279 More actions · Answer 11

kast218 - Friday, June 23, 2017 3:55 AM
databoffin - Friday, June 23, 2017 3:09 AM
Hi, I tried to update this via git a few months back bu OmniCompare is now Aireforge Studio.

Release date: 21 June 2017
Download page: https://aireforge.com/studio/download
Free version: Yes
Paid version: $299
Itâ€™s hard to categorise but I would say it falls into [IDX],[MG], [SC].
Cheers,
Phil
Thanks for your useful product, update info and rename it: https://github.com/ktaranov/sqlserver-kit/commit/1101140c6200f4a8b962625f64a763899d51d276. Are you planing add support for SQL Server 2017?

Yeah, we already support it and Azure SQL database.

Solving data & infrastructure issues via xTEN[/url] and our application, Aireforge[/url].

lindsayscott23 SSCrazy Points: 2339 More actions · Answer 12

Hi Koisntantin,

Thanks loads for putting this list together. There's loads of new utilities and tools here that I'd never heard of (along with some old favourites!)

Are there any from the list you'd consider to be essentials for a SQL developers toolkit?

Thanks again, I'll have loads of fun exploring these!

Lins

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

There are a few steps to repurposing content to a wiki. I'd be happy to get the process started to see if it makes any sense.

Essentially every resource will be given its own page, and one ore more categories. The main category will be:

https://sqlserver.miraheze.org/wiki/Category:SQL_Server_KIT

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

I use Brent Ozar's sql_blitz and other tools you can find at:

https://www.brentozar.com/blitz/

Konstantin Taranov SSCertifiable Points: 6498 More actions · Answer 15

lindsayscott23 - Friday, June 23, 2017 4:33 AM
Hi Koisntantin,
Thanks loads for putting this list together. There's loads of new utilities and tools here that I'd never heard of (along with some old favourites!)
Are there any from the list you'd consider to be essentials for a SQL developers toolkit?
Thanks again, I'll have loads of fun exploring these!
Lins

Hi, lindsayscott23. Thanks for your question.

My favorite developer tools for SQL Server - SSMS 17.1 with SSMS Boost and Apex SQL Search addons. Also very useful SSDT extension for Visual Studio (it helps compare schema and data changes between instances) and DBeaver (portable version) or HeidiSQL for working with different types of databases. For testing highly recommended RML Utilities for SQL Server, HammerDB and SQLQueryStress. And SentryOne Plan Explorer awesome tool for analyzing query plans. All this tools free.

If you have some budget I can recommend Red Gate Tools and DbForge.