Killexams.com 70-461 free pdf | 70-461 pdf download | Bioptron Light and Colour Therapy

Pass4sure 70-461 dumps | Killexams.com 70-461 actual questions | http://www.lightandcolour.net/

70-461 Querying Microsoft SQL Server 2012/2014

Study usher Prepared by Killexams.com Microsoft Dumps Experts

Exam Questions Updated On :


Killexams.com 70-461 Dumps and actual Questions

100% actual Questions - Exam Pass Guarantee with elevated Marks - Just Memorize the Answers



70-461 exam Dumps Source : Querying Microsoft SQL Server 2012/2014

Test Code : 70-461
Test name : Querying Microsoft SQL Server 2012/2014
Vendor name : Microsoft
free pdf : 297 actual Questions

definitely examine these current dumps and success is yours.
this is top notch, I handed my 70-461 exam final week, and one exam earlier this month! As many humans factor out here, these brain dumps are a exquisite route to study, either for the exam, or just for your expertise! On my checks, I had masses of questions, pleasurable element I knew complete of the solutions!!


I want actual test questions latest 70-461 examination.
The killexams.com is the awesome web page where my goals approach real. With the aid of manner of the usage of the free pdf material for the practise certainly introduced the actual spark to the studies and severely ended up by route of the usage of acquiring the qualitymarks within the 70-461 exam. Its miles pretty smooth to stand any exam with the assist of your absorb a study material. Thank youplenty for all. maintain up the top class expertise toil guys.


determined an redress supply for actual 70-461 actual test questions.
Great!, I proud to exist trained with your 70-461 QA and software. Your software helped me a lot in preparing my Microsoft exams.


Do you exigency Latest dumps of 70-461 exam to pass the exam?
Due to consecutive failures in my 70-461 exam, I was complete devastated and thought of changing my territory as I felt that this is not my cup of tea. But then someone told me to give one eventual try of the 70-461 exam with killexams.com and that I wont exist disappointed for sure. I thought about it and gave one eventual try. The eventual try with killexams.com for the 70-461 exam went successful as this site didnt retain complete the efforts to Make things toil for me. It didnt let me change my territory as I cleared the paper.


can you believe, complete 70-461 questions I organized were asked.
I would hold a privilege to exclaim Many Many Thanks to complete team members of killexams.com for providing such a wonderful platform made available to us. With the succor of the online questions and caselets, I absorb successfully cleared my 70-461 certification with 81% marks. It was really helpful to understand the ilk and patterns of questions and explanations provided for answers made my concepts crystal clear. Thanks for complete the advocate and maintain doing it. complete the best killexams.


obtain those 70-461 questions.
I recognize the struggles made in developing the exam simulator. Its far remarkable. I passed my 70-461 exam particularly with questions and answers provided with the aid of killexams.com team


Awesome Source! I got Actual test questions of 70-461 exam.
This exam coaching package deal protected the questions I became asked on the exam - something I didnt reckon will exist viable. So the stuff they provide is certainly valid. It seems to exist frequently up to date to hold up with the official updates made to 70-461 exam. Very top quality, the trying out engine runs easily and could exist very person pleasant. there is not anything I dont dote about it.


70-461 exam is not any extra arduous to pass with these free pdf.
killexams.com became a blessing for 70-461 exam, since the system has plenty of tiny details and configuration tricks, which can exist challenging in case you dont absorb much of 70-461 revel in. killexams.com 70-461 questions and solutions are enough to hold a seat and pass the 70-461 check.


do not forget to keep these actual test questions for 70-461 exam.
The 70-461 exam is supposed to exist a completely diffcult exam to clear But I cleared it remaining week in my first attempt. The killexams.com free pdfs guided me well and I was rightly prepared. recommendation to other students - dont hold this exam lightly and test very well.


Is there a shortcut to speedy retain together and pass 70-461 examination?
I changed into so much sluggish and didnt exigency to toil arduous and usually searched quick cuts and handy strategies. While i used to exist doing an IT route 70-461 and it became very difficult for me and didnt able to learn any manual line then i heard about the website online which had been very renowned in the marketplace. I were given it and my problems removed in few days when i started it. The sample and exercise questions helped me loads in my prep of 70-461 exams and i efficaciously secured birthright marks as nicely. That became just because of the killexams.


Microsoft Querying Microsoft SQL Server

Microsoft updates its database Story with SQL Server 2019 and new cloud database features | killexams.com actual Questions and Pass4sure dumps

(photograph courtesy Wikimedia Commons user Moumou82 / cc3.0)

one of the crucial simple features of computing infrastructure will play a key role in Microsoft’s Ignite 2018 pitch to developers and consumers, with a few new database points competing for locality alongside dozens of other new services for Azure.

The enterprise plans to introduce SQL Server 2019 this week in Orlando, and it'll moreover lengthen a key means of its newest cloud database — Cosmos DB — to complete Azure valued clientele. it will additionally Make it easier for users of its Azure SQL cloud database to instantly scale their needs as their functions develop or trade.

Given how valuable the database is to the total traffic computing utility stack, here is an gigantic enviornment of competition between cloud vendors and traditional database suppliers alike. Amazon net features presents six sorts of managed databases and supports a number of others that consumers could wish to control themselves, together with SQL Server and Oracle.

SQL Server has been round because 1989, and the most up-to-date version is designed for consumers who're managing their own servers and exigency to hold one of the most leading massive-statistics purposes into their mix. Microsoft plans to publish that a preview version of the database that has constructed-in aid for Hadoop and Spark, and may additionally allow clients of different databases to query statistics stored in Oracle, Teradata, or MongoDB commandeer from SQL Server.

Azure Cosmos DB, probably the most biggest cloud items Microsoft launched closing year, is capable for the familiar public to hold capabilities of its multimaster capabilities after a preview length. Multimaster elements unveiled prior this yr at Microsoft construct will allow purchasers to write facts to assorted cloud computing regions at the equal time, improving the efficiency and reliability of their apps.


Adaptive question Processing in SQL Server | killexams.com actual Questions and Pass4sure dumps

Introduction

Adaptive query processing is the newest, greater query processing role added in the SQL Server database engine. This formula is obtainable in SQL Server (starting with SQL Server 2017 (14.x)) and Azure SQL Database. 

question efficiency is complete the time a locality of research and innovation. once in a while, Microsoft includes new role and functionality in SQL Server to increase query performance to assist their clients. In SQL Server 2016, Microsoft delivered query keep. question maintain monitors question efficiency and provides the best route to elect more suitable question plans for execution. query reclaim is a characteristic to persist question execution plans and dissect the history of query plans to identify the queries that may reason efficiency bottlenecks. Any element in time these plans can moreover exist reviewed, and the consumer can use map forcing to implement the query processor to opt for and use a specific query map for execution. you could examine more about question reclaim in video display question performance using question maintain in SQL Server.

In SQL Server 2017, Microsoft went one step extra and labored on improving the question map first-class. This enhanced question map exceptional is Adaptive question Processing. 

query Execution Plan

just before SQL Server 2017, question processing was a uniform technique with a inevitable set of steps. The SQL Server query optimizer first generates a group of possible question plans for a question or batch of T-SQL code submitted via the database engine to query optimizer. in accordance with the can impregnate of the question plan, optimizer selects the bottom-cost query plan.

as soon as the query execution map is competent and accessible to execute, SQL Server storage engines fetch the query map and execute it in response to the genuine question map and recur the data set.

This conclude to conclusion procedure (question map technology, and submitting the map for processing) as soon as started, has to accelerate to completion. gratify discern figuring out a SQL Server question Execution map for more guidance.

in this method, question performance is relative upon the normal worthy of the query plan, exist a fraction of order, operation order and preference of actual algorithm dote nested loop unite or hash exist a fraction of, and so on. also, cardinality estimates play a vital role to rule the character of the question plan. Cardinality represents the estimated variety of rows back on execution of a question.

The accuracy of cardinality drives a stronger pleasant of query execution map and more redress allocation of reminiscence, CPU to the question. This development leads to an improved and superior execution of question, referred to as adaptive query processing. they will focus on exactly how SQL Server achieves this in relaxation of the section,.

Adaptive question Processing

ahead of SQL Server 2017, the behavior of question Optimizer changed into not most useful; it confident to opt for the bottom impregnate query map for execution, despite negative initial assumptions in estimating inaccurate cardinality, which ended in unsafe query performance.

In Adaptive question Processing, SQL Server optimized the query optimizer to generate more redress and first-class question plans with greater accurate cardinality. Adapting query Processing gets a higher-suggested question plan. There are three new techniques for adapting to software workload qualities.

Adapting query Processing options
  • Batch Mode reminiscence award feedback. This approach helps in allocating the required reminiscence to meet in complete returning rows. The birthright allocation of reminiscence helps in, 1) reducing extreme reminiscence provides that maintain away from concurrency considerations and, 2) fixing underestimated reminiscence offers that steer clear of expensive spills to disk.

    query performance suffers when reminiscence allocation sizes don't seem to exist sized accurately. In Batch Mode reminiscence supply comments, optimizer repeats the workload and recalculates the specific reminiscence required for a question after which updates the provide value for the cached plan.  When a similar query remark is executed, the question uses the revised reminiscence award measurement and improves the query efficiency.

  • Batch Mode Adaptive exist a fraction of. This technique gives the choice of algorithm option and the query map dynamically switches to a better exist a fraction of mode complete the route through map execution.  This defers either hash exist a fraction of or nested loop exist fraction of choice except after first input has been scanned.

    the new operator within the family unit, Adaptive exist a fraction of operator helps in defining a threshold. This threshold is used to examine with the row import number of the construct unite enter; if the row import number of the construct unite enter is below the threshold, a nested loop unite would exist enhanced than a hash unite and query map switches to nested loop exist fraction of. otherwise, with not a soul switches question map continues with a hash exist fraction of.

    This mode above complete helps the workload with common fluctuations between wee and majestic exist fraction of enter scans.

  • Interleaved Execution. Interleaved execution is material to multi-statement table valued capabilities (MSTVFs) in SQL Server 2017 because MSTVFs absorb a fixed cardinality guess of “100” in SQL Server 2014 and SQL Server 2016, and an estimate of “1” for earlier types, which leads to passing through inaccurate cardinality estimates to the question plan. In Interleaved execution approach, each time SQL Server identifies MSTVFs during the optimization process, it pauses the optimization, executes the applicable subtree first, gets accurate cardinality estimates after which resumes optimization for leisure of the operations. This approach helps in getting actual row counts from MSTVFs instead of mounted cardinality estimates to Make map optimizations downstream from MSTFs references; this effects in improvement in workload efficiency. also, Interleaved execution allows for plans to conform according to the revised cardinality estimates as MSTVFs changes the unidirectional border of single-question execution between the optimization and execution part.
  • further records for Adaptive question Processing innovations

    There are inevitable data linked to every Adaptive query Processing mode while optimizer improves the query efficiency using these innovations.

    Batch Mode reminiscence supply feedback. remarks isn't persisted as soon as a map is evicted from cache. You should not in a position to fetch the legacy of the query map in query keep, as reminiscence accouter feedback will trade best the cached map and adjustments are at present now not captured in the question store. also, in case of failover, remarks might exist lost.

    Batch Mode Adaptive join. SQL Server can dynamically swap between both forms of joins and at complete times Make a choice from nested loop and hash exist fraction of; merge unite is not at present fraction of the adaptive join. additionally, adaptive joins introduce a far better reminiscence requirement than an indexed nested loop exist a fraction of equivalent plan.

    Interleaved Execution. There are some restrictions; 1) the MSTVFs must exist read-most effective, 2) the MSTVFs cannot exist used interior of a stagger result operation, 3) the MSTVFs don't seem to exist eligible for interleaved execution if they conclude not use runtime constants.

    Configure Adapting question Processing

    There are dissimilar alternate options to configure Adaptive question Processing. These options are as follows:

    alternative-1: SQL Server by means of default allows for Adaptive query Processing and executes the queries beneath compatibility degree a hundred and forty.

    option-2: T-SQL is available to allow and disable complete three Adaptive question Processing options:

    T-SQL to disable Adaptive question Processing innovations

  • ALTER DATABASE SCOPED CONFIGURATION SET DISABLE_BATCH_MODE_MEMORY_GRANT_FEEDBACK = ON;
  • ALTER DATABASE SCOPED CONFIGURATION SET DISABLE_BATCH_MODE_ADAPTIVE_JOINS = ON;
  • ALTER DATABASE SCOPED CONFIGURATION SET DISABLE_INTERLEAVED_EXECUTION_TVF = ON;
  •        T-SQL to allow Adaptive query Processing recommendations

  • ALTER DATABASE SCOPED CONFIGURATION SET DISABLE_BATCH_MODE_MEMORY_GRANT_FEEDBACK = OFF;
  • ALTER DATABASE SCOPED CONFIGURATION SET DISABLE_BATCH_MODE_ADAPTIVE_JOINS = OFF;
  • ALTER DATABASE SCOPED CONFIGURATION SET DISABLE_INTERLEAVED_EXECUTION_TVF = OFF;
  • option-three:implement Adaptive query Processing approach the use of question trace. query trail takes priority over a database scoped configuration and different settings.

  • option (USE hint ('DISABLE_BATCH_MODE_MEMORY_GRANT_FEEDBACK'));
  • alternative (USE trace('DISABLE_BATCH_MODE_ADAPTIVE_JOINS'));
  • choice (USE trace('DISABLE_INTERLEAVED_EXECUTION_TVF'));
  • abstract

    The adaptive question processing improves the high-quality of a query plan. This helps in deciding upon the birthright join, commandeer order of operation and greater accurate reminiscence allocation to meet complete rows. The three thoughts of adaptive question processing Make SQL Server 2017 drastically quicker at processing the workload. also, adaptive question processing offers significant advancements devoid of refactoring T-SQL code.

    universal, adaptive query processing is a pretty pleasurable addition in SQL Server and permits SQL Server to generate well recommended fine query plans to control software workload processing.

    See complete articles through Anoop Kumar


    Microsoft’s SQL Server receives built-in assist for Spark and Hadoop | killexams.com actual Questions and Pass4sure dumps

    It’s time for the subsequent version of SQL Server, Microsoft’s flagship database product. The company today announced the primary public preview of SQL Server 2019 and whereas yet one other supplant to a proprietary database may moreover no longer seem complete that pleasing in the nascence look, Microsoft is making an attempt to conclude just a few rather wonderful things with this update.

    What’s on the core of the entire most unique updates is an acknowledgement that there are very few organizations that handiest use a single database product. So what Microsoft is doing with SQL Server is including new connectors that enable enterprise to use SQL Server to query different databases, together with those of Oracle, Teradata and MongoDB. This turns SQL Server into anything of a digital integration layer — yet the data by no means needs to exist replicated or moved to SQL Server.

    but there's more! SQL Server 2019 will comprise built-in usher for Spark and the Hadoop File device. That’s an acknowledgement of the popularity of these open-supply tools, as well as the value of massive information workloads that SQL Server, if it needs to exclaim vital, must exist in a position to guide, too, and it has to achieve this in a route that many organizations are already regular with.

    There’s yet another open source point here, too: SQL Server will succor these large data clusters with the aid of the Google-incubated Kubernetes container orchestration equipment. every cluster will comprise SQL Server, the Hadoop file system and Spark.

    As for the identify, it’s cost noting that many pundits anticipated a “SQL Server 2018,” but Microsoft opted to skip a year after SQL Server 2016 and 2017. So SQL Server 2019 it is.

    more Microsoft Ignite 2018 coverage


    Unquestionably it is arduous assignment to pick dependable certification questions/answers assets regarding review, reputation and validity since individuals fetch sham because of picking incorrectly benefit. Killexams.com ensure to serve its customers best to its assets concerning exam dumps update and validity. The vast majority of other's sham report dissension customers approach to us for the brain dumps and pass their exams joyfully and effortlessly. They never trade off on their review, reputation and character on the grounds that killexams review, killexams reputation and killexams customer conviction is imperative to us. Uniquely they deal with killexams.com review, killexams.com reputation, killexams.com sham report objection, killexams.com trust, killexams.com validity, killexams.com report and killexams.com scam. On the off chance that you discern any unsuitable report posted by their rivals with the name killexams sham report grievance web, killexams.com sham report, killexams.com scam, killexams.com protest or something dote this, simply recall there are constantly poverty-stricken individuals harming reputation of pleasurable administrations because of their advantages. There are a huge number of fulfilled clients that pass their exams utilizing killexams.com brain dumps, killexams PDF questions, killexams hone questions, killexams exam simulator. Visit Killexams.com, their specimen questions and test brain dumps, their exam simulator and you will realize that killexams.com is the best brain dumps site.

    Back to Braindumps Menu


    1Y0-327 exam prep | 9L0-314 drill test | 000-X01 actual questions | HP2-E51 test questions | 000-280 cram | 70-354 drill test | 1Z0-542 braindumps | CQE study guide | 2M00001A dump | 000-N11 brain dumps | HP0-171 study guide | P2090-046 test prep | HP0-S13 drill exam | 71-571 sample test | HP0-J19 study guide | 132-S-800-1 exam prep | 000-035 braindumps | JN0-522 free pdf | 000-550 mock exam | 000-649 bootcamp |


    Dont Miss these Microsoft 70-461 Dumps
    If are you burdened how to pass your Microsoft 70-461 Exam? With the succor of the confirmed killexams.com Microsoft 70-461 Testing Engine you will learn how to boom your abilties. The majority of the scholars start identifying when they learn that they absorb to seem in IT certification. Their brain dumps are complete and to the point. The Microsoft 70-461 PDF documents Make your imaginative and prescient large and assist you lots in instruction of the certification exam.

    killexams.com will exist a trustworthy and trustworthy platform provides 70-461 exam questions with 100 percent success guarantee. you wish to drill questions for one day minimum to attain well in the test. Your actual journey to success in 70-461 exam, really starts with killexams.com test drill questions that's the wonderful and verified supply of your targeted position. killexams.com Discount Coupons and Promo Codes are as under; WC2017 : 60% Discount Coupon for complete exams on website PROF17 : 10% Discount Coupon for Orders larger than $69 DEAL17 : 15% Discount Coupon for Orders larger than $99 SEPSPECIAL : 10% Special Discount Coupon for complete Orders At killexams.com, they absorb an approach to provide fully tested Microsoft 70-461 actual Questions and Answers which you will exigency to Pass 70-461 exam. they absorb an approach to truly usher people to recall the free pdf and Guarantee to pass. It is a pleasurable call to accelerate up your position as a professional and boost yourself at the accelerate of technology. Click http://killexams.com/pass4sure/exam-detail/70-461

    In case you're looking out Pass4sure 70-461 drill Test containing actual Test Questions, you are at birthright region. They absorb incorporated database of inquiries from Actual Exams so as that will enable you to assemble and pass your exam on the primary endeavor. complete tutoring materials at the site are Up To Date and demonstrated with the usher of their masters.

    We tender ultra-present day and a la mode Pass4sure drill Test with Actual Exam Questions and Answers for fresh out of the box new syllabus of Microsoft 70-461 Exam. drill their actual Questions and Answers to better your mastery and pass your exam with elevated Marks. They ensure your finish inside the Test Center, securing the greater fraction of the subjects of exam and build your learning of the 70-461 exam. Pass four beyond any doubt with their precise inquiries.

    killexams.com 70-461 Exam PDF incorporates Complete Pool of Questions and Answers and Dumps verified and certified comprehensive of references and Ass (where significant). Their objective to congregate the Questions and Answers isn't in every case best to pass the exam toward the inaugurate endeavor however Really better Your learning about the 70-461 exam themes.

    70-461 exam Questions and Answers are Printable in elevated character Study usher that you may down load in your Computer or another gadget and inaugurate setting up your 70-461 exam. Print Complete 70-461 Study Guide, convey with you while you are at Vacations or Traveling and luxuriate in your Exam Prep. You can fetch birthright of passage to exceptional 70-461 Exam free pdf out of your on line account whenever.

    killexams.com Huge Discount Coupons and Promo Codes are as under;
    WC2017: 60% Discount Coupon for complete exams on website
    PROF17: 10% Discount Coupon for Orders greater than $69
    DEAL17: 15% Discount Coupon for Orders greater than $99
    DECSPECIAL: 10% Special Discount Coupon for complete Orders


    Download your Querying Microsoft SQL Server 2012/2014 Study usher immediately after looking for and Start Preparing Your Exam Prep birthright Now!

    70-461 Practice Test | 70-461 examcollection | 70-461 VCE | 70-461 study guide | 70-461 practice exam | 70-461 cram


    Killexams LX0-103 test prep | Killexams 190-957 braindumps | Killexams OA0-002 questions and answers | Killexams 050-SEPROSIEM-01 study guide | Killexams C9020-562 drill test | Killexams ASF bootcamp | Killexams 000-963 VCE | Killexams CCBA braindumps | Killexams CMS7 actual questions | Killexams 000-038 dump | Killexams 156-915-65 cram | Killexams 000-894 pdf download | Killexams HP0-096 dumps questions | Killexams 000-094 study guide | Killexams LOT-408 brain dumps | Killexams 000-R18 actual questions | Killexams HP0-M26 braindumps | Killexams CVA cheat sheets | Killexams 6006-1 actual questions | Killexams ICDL-Powerpoint drill questions |


    Exam Simulator : Pass4sure 70-461 Exam Simulator

    View Complete list of Killexams.com Brain dumps


    Killexams 70-545-CSharp test prep | Killexams MA0-103 actual questions | Killexams LOT-849 study guide | Killexams 000-598 drill Test | Killexams HP0-M55 exam prep | Killexams 000-J02 dumps questions | Killexams A2040-409 mock exam | Killexams JN0-692 examcollection | Killexams ITILSC-OSA brain dumps | Killexams A2090-422 dumps | Killexams P8060-002 free pdf | Killexams 156-910-70 braindumps | Killexams C4040-124 drill questions | Killexams E20-895 drill test | Killexams C2180-273 drill test | Killexams 300-460 free pdf download | Killexams PC0-006 study guide | Killexams 156-730 exam questions | Killexams CBAP braindumps | Killexams 644-334 test prep |


    Querying Microsoft SQL Server 2012/2014

    Pass 4 confident 70-461 dumps | Killexams.com 70-461 actual questions | http://www.lightandcolour.net/

    Microsoft SQL Server Utilities and Tools | killexams.com actual questions and Pass4sure dumps

    Useful free and paid Microsoft SQL Server utilities and tools – a complete list of 275 SQL Server Utilities updated on Jan 24, 2019.

    Utility types (main purpose), in braces {} current counts:

  • : Backup solutions {6}
  • [BI]: traffic Intelligence Solutions {4}
  • [D]: Documentation solutions {7}
  • [DA]: Database Architecture {13}
  • [DC]: Data compare {12}
  • [ETL]: Extract Download Load (ETL) Tools {1}
  • : Internal SQL Server utilities (for example, bcp) {14}
  • [IDX]: Index manager {2}
  • [G]: Data generation {4}
  • [J]: Job managers {3}
  • [M]: Monitoring and alerting Tools {16}
  • [MG]: Migration utensil {26}
  • [MS]: Management Studio (alternative for SSMS) {26}
  • [REC]: Recovery tools {7}
  • : Search tools {3}
  • [SC]: Structure compare {18}
  • [T]: Testing tools {5}
  • [ST]: Statistics utilities {3}
  • [?]: Not yet classified {114}
  • Name/Description Cross Database Platform Type Official/Download page Release Author License Free version Price SSMS No No [MS] SSMS 2018-11-21 Microsoft Yes No bcp Utility No No bcp Utility 2012-02-11 Microsoft Yes No sqlcmd Utility No No sqlcmd Utility 2016-08-23 Microsoft Yes No mssql-cli No Linux,Mac [?] mssql-cli 2018-07-06 Microsoft BSD-3 Open Source No Azure Data Studio No Linux,Mac [MS] Azure Data Studio 2018-12-19 Microsoft Yes No RML Utilities for SQL Server No No [T] RML Utilities for SQL Server 2014-12-12 Microsoft Yes No GraphView No No [?] GraphView 2016-02-23 Microsoft Yes No Baseline Security Analyze No No [?] Baseline Security Analyze 2015-01-09 Microsoft Yes No tablediff Utility No No tablediff Utility – Microsoft Yes No Microsoft Log Parser No No [?] Microsoft Log Parser – Microsoft Yes No Log Parser Lizard GUI Oracle,MySQL,PostgreSQL,Other No [MS] Log Parser Lizard GUI 2017-06-01 Lizard Labs Yes $59 Diskspd No No [T] Diskspd 2015-12-14 Microsoft Yes No HammerDB No No [T] HammerDB 2015-05-04 Open Source Yes No Exchange Server error Code Look-up No No [?] Exchange Server error Code Look-up 2004-05-10 Microsoft Yes No LINQPad No No [?] LINQPad 2016-01-02 Joseph Albahari Non-commercial $45 SqlDynamite No No SqlDynamite 2016-04-06 Anatoly Sova Yes No SQL Server Data Tools No No [MS] SQL Server Data Tools 2018-04-10 Microsoft Yes No Database Health Monitor No No [M] Database Health Monitor 2016-03-20 Steve Stedman Yes No SchemaDrift No No [SC] SchemaDrift 2016-02-28 Steve Stedman Yes No Dbeaver Oracle,MySQL,PostgreSQL,Other Linux,Mac [MS] Dbeaver 2018-09-24 Open Source Yes No HeidiSQL Oracle,MySQL,PostgreSQL,Other No [MS] HeidiSQL 2017-12-19 Open Source Yes No SQLExecStats No No [ST] SQLExecStats 2016-02-08 Joe Chang Yes No ExpressProfiler No No [?] ExpressProfiler 2016-02-15 Chris Moore Yes No Data Migration Assistant No No [MG] Data Migration Assistant 2017-03-15 Microsoft Yes No SQL Server Migration aide for Sybase No No [MG] Migration aide for Sybase 2017-02-17 Microsoft Yes No dta Utility No No dta Utility – Microsoft Yes No osql Utility No No osql Utility – Microsoft Yes No sqldiag Utility No No sqldiag Utility – Microsoft Yes No sqldumper Utility No No sqldumper Utility – Microsoft Yes No SqlLocalDB Utility No No SqlLocalDB Utility – Microsoft Yes No sqllogship Utility No No sqllogship Utility – Microsoft Yes No sqlservr Application No No sqlservr Application – Microsoft Yes No sqlps Utility No No sqlps Utility – Microsoft Yes No sqlmaint Utility No No sqlmaint Utility – Microsoft Yes No Ssms Utility No No Ssms Utility – Microsoft Yes No dtexec Utility No No dtexec Utility – Microsoft Yes No SQL Server 2016 Report Builder No No [?] SQL Server 2016 Report Builder 2016-09-16 Microsoft Yes No SQL Server 2005 Best Practices Analyzer No No [?] BPA 2005 2008-08-13 Microsoft Yes No SQL Server 2000 Best Practices Analyzer No No [?] BPA 2000 2010-04-26 Microsoft Yes No SQL Server 2008 R2 Best Practices Analyzer No No [?] BPA 2008 2010-06-18 Microsoft Yes No SQL Server 2012 Best Practices Analyzer No No [?] BPA 2012 2012-06-04 Microsoft Yes No DLM Dashboard No No [M] DLM Dashboard 2016-04-27 Red Gate Yes No Red Gate SQL Compare No No [DC] Red Gate SQL Compare 2016-10-31 Red Gate No $495 Red Gate SQL Data Compare No No [SC] Red Gate SQL Data Compare 2016-05-09 Red Gate No $495 Red Gate SQL Prompt No No [MS] Red Gate SQL Prompt 2016-04-28 Red Gate No $369 Red Gate SQL Monitor No No [M] Red Gate SQL Monitor 2015-10-15 Red Gate No $1495 Red Gate SQL Backup Pro No No Red Gate SQL Backup Pro 2014-07-08 Red Gate No $995 Red Gate SQL Doc No No [D] Red Gate SQL Doc 2016-04-26 Red Gate No $369 Red Gate SQL Data Generator No No [G] Red Gate SQL Data Generator 2016-04-26 Red Gate No $369 Red Gate SQL Dependency Tracker No No [?] Red Gate SQL Dependency Tracker 2016-04-26 Red Gate No $369 Red Gate SQL Multi Script No No [?] Red Gate SQL Multi Script 2016-04-15 Red Gate No $245 Red Gate SQL Index Manager No No [IDX] Red Gate SQL Index Manager ? Red Gate No $149 Red Gate SQL Comparison SDK No No [DC],[SC] Red Gate SQL Comparison SDK 2016-02-22 Red Gate No $895 Red Gate SQL Clone No No [?] Red Gate SQL Clone 2017-02-27 Red Gate No $6955 Red Gate SQL Provision No No [?] Red Gate SQL Provision 2018-02-26 Red Gate No $2955 Red Gate Data Masker Oracle No [?] Red Gate SQL Data Masker 2018-02-26 Red Gate No $2395 DLM Automation No No [?] DLM Automation ? Red Gate No ? ReadyRoll No No [?] ReadyRoll 2016-01-03 Red Gate No $345 Rapid Database Extractor Oracle No [?] Rapid Database Extractor 2016-11-03 Idera Yes No SQL XEvent Profiler No No [?] SQL XEvent Profiler 2014-03-14 Idera Yes No SQL Check No No [?] SQL Check 2015-09-24 Idera Yes No SQL Fragmentation Analyzer No No [?] SQL Fragmentation Analyzer 2012-11-16 Idera Yes No SQL Heat Map No No [?] SQL Heat Map 2016-01-27 Idera Yes No SQL Hekaton reminiscence Check No No [?] SQL Hekaton reminiscence Check 2015-06-10 Idera Yes No SQL Page Viewer No No [?] SQL Page Viewer 2014-08-25 Idera Yes No SQL Update Statistics No No [ST] SQL Update Statistics 2015-12-14 Idera Yes No SQL Statistics Aggregator No No [ST] SQL Statistics Aggregator 2015-05-18 Idera Yes No SQL Backup Status Reporter No No SQL Backup Status Reporter 2015-08-07 Idera Yes No SQL Integrity Check No No [?] SQL Integrity Check 2013-08-26 Idera Yes No SQL Job Manager No No [J] SQL Job Manager 2012-03-19 Idera Yes No Azure SQL Database Backup No No Azure SQL Database Backup 2012-10-02 Idera Yes No SQL Column Search No No SQL Column Search 2015-11-17 Idera Yes No SQL Permissions Extractor No No [?] SQL Permissions Extractor 2015-08-07 Idera Yes No SQL BI Check No No [BI] SQL BI Check 2016-04-13 Idera Yes No SQL Inventory Check No No [?] SQL Inventory Check 2016-03-24 Idera Yes No SQL Diagnostic Manager No No [?] SQL Diagnostic Manager ? Idera No $1747 SQL Safe Backup No No SQL Safe Backup 2016-09-08 Idera No $907 SQL Compliance Manager No No [?] SQL Compliance Manager 2015-09-08 Idera No $2657 SQL Inventory Manager No No [?] SQL Inventory Manager 2016-04-22 Idera No $3195 SQL Virtual Database No No [?] SQL Virtual Database 2016-03-24 Idera No $625 SQL Secure No No [?] SQL Secure 2016-04-19 Idera No $907 SQL Doctor No No [?] SQL Doctor 2015-12-17 Idera No $625 SQL Admin Toolset No No [?] SQL Admin Toolset 2016-01-13 Idera No $395 SQL Defrag Manager No No [?] SQL Defrag Manager 2016-03-10 Idera No $1495 DBArtisan No No [?] DBArtisan ? Idera No $3122 SQL BI Manager No No [BI] SQL BI Manager 2015-09-08 Idera No $697 SQL Enterprise Job Manager No No [J] SQL Enterprise Job Manager 2015-09-08 Idera No $697 DB Optimizer No No [?] DB Optimizer ? Idera No $1420 SQL Query Store Optimizer No No [?] SQL Query Store Optimizer 2016-07-01 Idera Yes No Rapid SQL Oracle,MySQL,PostgreSQL,Other No [MS] Rapid SQL ? Idera No $710 SQL Comparison Toolset No No [DC],[SC] SQL Comparison Toolset ? Idera No $745 ER/Studio Data Architect Oracle,MySQL,PostgreSQL,Other No [DA] ER/Studio Data Architect Idera No $1287 DB Change Manager Oracle,MySQL,PostgreSQL,Other No [SC] DB Change Manager ? Idera No $1420 Uptime Infrastructure Monitor No Linux [?] Uptime Infrastructure Monitor ? Idera No ? dbForge Schema Compare No No [SC] dbForge Schema Compare 2016-09-16 Devart Shareware No $150 dbForge Data Compare No No [DC] dbForge Data Compare 2016-09-28 Devart Shareware No $150 dbForge Data Generator No No [G] dbForge Data Generator 2016-09-16 Devart Shareware No $250 dbForge Query Builder No No [?] dbForge Query Builder 2016-08-17 Devart Shareware No $100 dbForge Event Profiler No No [?] dbForge Event Profiler 2016-09-16 Devart Freeware Yes No dbForge SQL Decryptor No No [?] dbForge SQL Decryptor 2017-04-20 Devart Freeware Yes No dbForge Studio No No [MS] dbForge Studio 2017-03-12 Devart Shareware Yes $250 dbForge Fusion No No [?] dbForge Fusion 2016-12-27 Devart Shareware No $150 dbForge Documenter No No [D] dbForge Documenter 2016-09-16 Devart Shareware No $150 Devart outdo Add-in for SQL Server No No [?] Devart outdo Add-in for SQL Server 2017-09-13 Devart Shareware No $100 dbMonitor Oracle,MySQL,PostgreSQL,Other No [M] dbMonitor 2012-11-01 Devart Freeware Yes No Minion Enterprise No No [?] Minion Enterprise ? MinionWare No $1500 SQL Server Compression Estimator No No [?] SQL Server Compression Estimator 2011-06-02 Bob Tavlor Yes No ClearTrace No No [?] ClearTrace 2016-07-07 Bill Graziano Yes No Dell Security Explorer No No [?] Dell Security Explorer 2015-06-25 Dell No $850 Dell LiteSpeed for SQL Server No No [?] Dell LiteSpeed for SQL Server 2015-07-31 Dell No ? Dell Toad for SQL Server No No [MS] Dell Toad for SQL Server 2015-05-12 Dell No ? Dell Spotlight on SQL Server Enterprise No No [?] Dell Spotlight 2016-03-10 Dell No $2561 Dell Foglight No No [?] Dell Foglight 2015-09-22 Dell No ? Dell Discovery Wizard No No [?] Dell Discovery Wizard 2011-09-22 Dell Yes No Dell Enterprise Reporter No No [?] Dell Enterprise Reporter ? Dell No $511 SQL Scripter No No [?] SQL Scripter 2013-02-24 Thomas Hinsenkamp No €99 Simple Dynamic Scheduler No No [?] Simple Dynamic Scheduler 2016-05-02 Miljan Radovic Yes No ApexSQL Audit No No [?] ApexSQL Audit 2017-07-11 ApexSQL No $1699 ApexSQL Backup No No ApexSQL Backup 2017-10-12 ApexSQL No $499 ApexSQL Defrag No No [IDX] ApexSQL Defrag 2017-06-29 ApexSQL No $499 ApexSQL Log No No [?] ApexSQL Log 2017-05-24 ApexSQL No $1999 ApexSQL Monitor No No [M] ApexSQL Monitor 2017-10-05 ApexSQL No $499 ApexSQL Plan No No [?] ApexSQL Plan 2018-04-05 ApexSQL Yes No ApexSQL Propagate No No [?] ApexSQL Propagate 2017-09-25 ApexSQL Yes No ApexSQL Recover No No [REC] ApexSQL Recover 2017-10-26 ApexSQL No $1999 ApexSQL Build No No [?] ApexSQL Build 2017-05-15 ApexSQL No $399 ApexSQL Clean No No [?] ApexSQL Clean 2017-09-28 ApexSQL No $399 ApexSQL Data Diff No No [DC] ApexSQL Data Diff 2017-10-26 ApexSQL No $399 ApexSQL Decrypt No No [?] ApexSQL Decrypt 2017-08-16 ApexSQL Yes No ApexSQL Diff No No [SC] ApexSQL Diff 2017-10-26 ApexSQL No $399 ApexSQL Doc No No [D] ApexSQL Doc 2017-09-06 ApexSQL No $299 ApexSQL Generate No No [G] ApexSQL Generate 2017-07-13 ApexSQL No $499 ApexSQL Script No No [?] ApexSQL Script 2016-05-10 ApexSQL No $249 ApexSQL Trigger No No [?] ApexSQL Trigger 2017-06-01 ApexSQL No $1999 ApexSQL Trigger Veiwer No No [?] ApexSQL Trigger Viewer 2017-06-01 ApexSQL Yes No ApexSQL Snapshot Utility No No [?] ApexSQL Snapshot Utility 2016-01-12 ApexSQL Yes No ApexSQL Model No No [DA] ApexSQL Model 2018-09-10 ApexSQL No $399 ApexSQL Analyze No No [?] ApexSQL Analyze 2017-12-13 ApexSQL No $299 ApexSQL BI Monitor No No [BI],[M] ApexSQL BI Monitor 2018-05-18 ApexSQL No $499 ApexSQL VM Monitor No No [M] ApexSQL VM Monitor 2018-05-09 ApexSQL No $999 ApexSQL Job No No [J] ApexSQL Job 2018-03-29 ApexSQL No $499 ApexSQL Enforce No No [?] ApexSQL Enforce 2018-07-19 ApexSQL No $299 DBBest T-SQL Analyzer No No [?] DBBest T-SQL Analyzer 2015-03-13 DBBest No $89 DBBest Database Compare Suite No No [SC],[DC] DBBest Database Compare Suite 2015-09-04 DBBest No $349 Advanced Query Tool No No [?] Advanced Query Tool 2015-03-18 Cardett Associates No $180 SqlDiffFramework No No [SC] SqlDiffFramework 2012-04-17 Michael Sorens Yes No DataGrip Oracle,MySQL,PostgreSQL,Other Linux,Mac [MS] DataGrip 2017-02-21 Jet Brains No $89 Pssdiag and Sqldiag Manager No No [?] Pssdiag and Sqldiag Manager 2017-01-06 Jack Li Yes No SQL Nexus Tool No No [?] SQL Nexus Tool 2016-11-20 Jack Li Yes No DBSophic Qure Profiler No No [?] DBSophic Qure Profiler ? DBSophic No $300 DBSophic Qure Optimizer No No [?] DBSophic Qure Optimizer ? DBSophic No ? RestoreChecker No No [?] RestoreChecker 2015-01-15 SQLServerUtilities No $99 SQLScripter No No [?] SQLScripter 2009-08-24 SQLServerUtilities No $99 SQLC No No [DC],[SC] SQLC 2017-11-19 David Ingleton Yes No Database Performance Analyzer Oracle, MySQL, Other Linux [M] Database Performance Analyzer ? SolarWinds No $1995 Database Performance Analyzer for MSSQL No No [M] Database Performance Analyzer for MSSQL ? SolarWinds No $1995 SQL Enlight No No [MS] SQL Enlight 2016-04-25 UbitSoft No $295 Aireforge Studio No No [MG],[SC] Aireforge Studio 2017-06-21 AireForge Yes $299 HexaTier No No [?] HexaTier ? HexaTier No ? SoftTree SQL Assistant Oracle,MySQL,PostgreSQL,Other No [MS] SoftTree SQL Assistant 2017-12-17 SoftTree No $215 DB Audit and Security 360 Oracle,MySQL,Other No [?] DB Audit and Security 360 2015-02-07 SoftTree No $499 EMS SQL Management Studio No No [MS] EMS SQL Management Studio 2016-05-26 EMS No $257 EMS SQL Backup No No EMS SQL Backup 2016-04-13 EMS Yes $82 EMS SQL Administrator No No [?] EMS SQL Administrator 2015-04-14 EMS Yes $135 EMS SQL Manager No No [?] EMS SQL Manager 2016-05-26 EMS Yes $135 EMS Data Export No No [?] EMS Data Export 2016-04-29 EMS No $47 EMS Data Import No No [?] EMS Data Import 2016-04-14 EMS No $47 EMS Data Pump No No [?] EMS Data Pump 2016-11-03 EMS No $47 EMS Data Generator No No [G] EMS Data Generator 2010-07-10 EMS No $47 EMS DB Comparer No No [SC] EMS DB Comparer 2015-07-24 EMS No $47 EMS DB Extract No No [?] EMS DB Extract 2008-10-16 EMS No $47 EMS SQL Query No No [?] EMS SQL Query 2012-03-29 EMS No $47 EMS Data Comparer No No [DC] EMS Data Comparer 2012-11-16 EMS No $47 NitroAccelerator No No [?] NitroAccelerator 2016-07-10 Nitrosphere No $1265 ERwin Data Modeler Oracle,MySQL,PostgreSQL,Other No [DA] ERwin Data Modeler 2016-06-03 ERwin No $810 Toad Data Modeler Oracle,MySQL,PostgreSQL,Other No [DA] Toad Data Modeler 2016-06-16 Dell No $562 SQL Power Architect Oracle,MySQL,PostgreSQL,Other Linux,Mac [DA] SQL Power Architect 2016-02-11 SQLPower Yes $995 DbWrench Oracle,MySQL,PostgreSQL,Other Linux,Mac [DA] DbWrench 2016-07-06 Nizana Systems No $99 Navicat Data Modeler Oracle,MySQL,PostgreSQL,Other Linux,Mac [DA] Navicat Data Modeler 2016-08-01 PremiumSoft No $199 DeZign for Databases Oracle,MySQL,PostgreSQL,Other No [DA] DeZign for Databases 2016-04-25 Datanamic No $259 ERDesigner NG Oracle,MySQL,PostgreSQL,Other Linux,Mac [DA] ERDesigner NG 2013-04-10 Mirko Sertic Open Source No Vertabelo Oracle,MySQL,PostgreSQL,Other Online [DA] Vertabelo ? Vertabelo No $948 dbDiffo Oracle,MySQL,PostgreSQL,Other Online [DA] dbDiffo ? Contenet Ltd Yes No SQL DXP Oracle,MySQL No [DC],[SC] SQL DXP 2016-06-20 SQL Delta No $530 Aqua Data Studio Oracle,MySQL,PostgreSQL,Other Linux,Mac [MS] Aqua Data Studio 2016-07-06 AquaFold No $499 RazorSQL Oracle,MySQL,PostgreSQL,Other Linux,Mac [MS] RazorSQL 2016-09-29 Richardson Software No $100 SQL Pretty Printer No No [?] SQL Pretty Printer 2016-02-19 Gudu Software No $50 Database .NET Oracle,MySQL,PostgreSQL,Other No [MS],[SC] Database .NET 2018-08-20 fish's dotNET Non-commercial $69 dbMigration .NET Oracle,MySQL,PostgreSQL,Other No [DC],[SC] dbMigration .NET 2018-08-20 fish's dotNET Non-commercial $49 Is It SQL No No [M] Is It SQL 2017-04-06 Bill Graziano Non-commercial No Database Experimentation aide Technical Preview 2 No No [T] Database Experimentation Assistant 2017-03-24 Microsoft Yes No Data Platform Studio No No [MG] Data Platform Studio ? Red Gate Software Yes ? Flyway Oracle,MySQL,PostgreSQL,Other No [MG] Flyway 2018-01-30 boxfuse Apache Open Source $950 Liquibase Oracle,MySQL,PostgreSQL,Other No [MG] Liquibase 2018-04-11 Liquibase Apache Open Source No My Batis Oracle,MySQL,PostgreSQL,Other Linux,Mac [MG] My Batis 2018-03-20 My Batis Apache Open Source No SentryOne map Explorer No No [?] SentryOne map Explorer 2017-05-25 SentryOne Yes No SQL Sentry No No [M] SQL Sentry 2016-12-07 SentryOne No ? DBmaestro TeamWork Oracle No [?] DBmaestro TeamWork ? DBmaestro No ? xSQL Schema Compare No No [SC] xSQL Schema Compare 2017-03-01 xSQL Software Shareware Yes $399 xSQL Data Compare No No [DK] xSQL Data Compare 2017-06-26 xSQL Software Shareware Yes $399 xSQL Script Executor MySQL,DB2,SQL Server CE No [?] xSQL Script Executor 2015-02-25 xSQL Software Freeware Yes $249 xSQL Builder No No [?] xSQL Builder 2017-03-15 xSQL Software Shareware No $799 xSQL Documenter Oracle,MySQL,SQLite,Other No [D] xSQL Documenter 2017-01-04 xSQL Software Shareware No $199 xSQL Profiler No No [?] xSQL Profiler 2017-06-28 xSQL Software Shareware Yes $999 xSQL Schema Compare SDK No No [SC] xSQL Schema Compare SDK 2017-10-25 xSQL Software Shareware No $1499 xSQL RSS Reporter No No [D] xSQL RSS Reporter 2014-11-25 xSQL Software Shareware No $169 xSQL Database Searcher No No xSQL Database Searcher 2017-05-09 xSQL Software Freeware Yes No Cloud-based DB Monitoring Platform No Mobile [M] Cloud-based DB Monitoring Platform ? SQLTreeo No €180 SchemaCrawler Oracle,MySQL,PostgreSQL,Other Yes [D],[SC] SchemaCrawler 2017-02-27 Sualeh Fatehi Open Source No SA MaaS Microsoft SQL Server No No [M] SA MaaS Microsoft SQL Server ? SENTINELAGENT No ? CatCompare v2 No No [?] CatCompare v2 2017-01-07 Andy Leonard No $295 SSIS Catalog Compare v2.0 Bundle No No [?] SSIS Catalog Compare v2.0 Bundle 2017-01-06 Andy Leonard No $495 MS Kerberos Configuration Manager No No [?] MS Kerberos Configuration Manager 2017-01-31 Microsoft Yes No Spotlight No No [M] Spotlight ? Quest Software Yes ? DBConvert Studio Oracle,MySQL,PostgreSQL,Other No [MG] DBConvert Studio 2017-03-01 DMSoft Technologies No $499 DbDefence No No [?] DbDefence 2017-03-01 ActiveCrypt Software Yes $698 SQL Server Migration aide for MySQL MySQL No [MG] SQL Server Migration aide for MySQL 2017-02-17 Microsoft Yes No sqlcmd for Mac and Linux No Linux,Mac [?] sqlcmd for Mac and Linux 2017-01-26 Soheil Rashidi Open Source No SQL Migrator No No [MG] SQL Migrator ? Datamate Technology ? ? MS FoxPro to MS SQL Migration and Sync No No [MG] MS FoxPro to MS SQL Migration and Sync 2013-10-08 DMSoft Technologies No $149 MySQL to MS SQL Migration and Sync No No [MG] MySQL to MS SQL Migration and Sync 2013-10-08 DMSoft Technologies No $149 Oracle to MS SQL Migration and Sync No No [MG] Oracle to MS SQL Migration and Sync 2013-10-09 DMSoft Technologies No $149 PostgreSQL to MS SQL Migration and Sync No No [MG] PostgreSQL to MS SQL Migration and Sync 2013-10-08 DMSoft Technologies No $149 MS outdo to MS SQL Migration No No [MG] MS outdo to MS SQL Migration 2013-09-23 DMSoft Technologies No $149 SQLite to MS SQL Migration and Sync No No [MG] SQLite to MS SQL Migration and Sync 2014-05-08 DMSoft Technologies No $149 IBM DB2 to MS SQL Migration and Sync No No [MG] IBM DB2 to MS SQL Migration and Sync 2013-09-09 DMSoft Technologies No $149 MS Access to MS SQL Migration and Sync No No [MG] MS Access to MS SQL Migration and Sync 2013-10-08 DMSoft Technologies No $149 Firebird to MS SQL Migration and Sync No No [MG] Firebird to MS SQL Migration and Sync 2013-09-11 DMSoft Technologies No $149 SQLines SQL Converter No No [MG] SQLines SQL Converter ? Dmtolpeko Open Source No SQLite & SQL Server Compact Toolbox No No [?] SQLite & SQL Server Compact Toolbox ? ErikEJ Open Source No SqlPad Postgres,MySQL,Crate,Vertica No [MS] SqlPad ? Rickbergfalk Open Source No Html-query-plan No No [?] Html-query-plan ? JustinPealing Open Source No SqlQueryStress No No [?] SqlQueryStress ? Adam Machanic Open Source No SQL Server Migration aide for DB2 DB2 No [MG] SQL Server Migration aide for DB2 2017-02-17 Microsoft Yes No SQL Server Migration aide for Oracle Oracle No [MG] SQL Server Migration aide for Oracle 2017-02-17 Microsoft Yes No SQL Server Migration aide for Access Access No [MG] SQL Server Migration aide for Access 2017-02-17 Microsoft Yes No mssql for Visual Studio Code No Linux,Mac [MS] mssql for Visual Studio Code 2017-05-02 Microsoft Open Source No Microsoft Assessment and Planning No No [?] Microsoft Assessment and Planning 2017-02-10 Microsoft Yes No mssql-scripter No Linux,Mac [?] mssql-scripter ? Microsoft Open Source No DBFS No Linux [M] DBFS ? Microsoft Open Source No comparator Oracle,MySQL,PostgreSQL,Other No [DC] comparator 2017-06-06 Pumpet LGPL-3.0 Open Source No Navicat for SQL Server No Mac [MS] Navicat for SQL Server 2017-06-14 PremiumSoft No $699 Navicat Premium Oracle,MySQL,PostgreSQL,Other Mac [MS] Navicat Premium 2017-06-14 PremiumSoft No $1299 DbVisualizer Oracle,MySQL,PostgreSQL,Other Linux,Mac [MS],[DA] DbVisualizer 2017-08-22 DbVis Software AB. Yes $197 DbSchema Oracle,MySQL,PostgreSQL,Other Linux,Mac [DA] DbSchema 2017-06-19 Wise Coders Solutions Yes $127 DBGhost No No [?] DBGhost 2017-01-31 Innovartis Ltd No £430 SQLAutomate Oracle,MySQL,Other No [?] SQLAutomate 2017-06-19 OnLine ToolWorks     No $99 BimlExpress No No [?] BimlExpress ? Varigence   No No BIDS Helper No No [?] BIDS Helper 2015-03-17 Microsoft   Open Source No Azure Data Warehouse Migration Utility No No [MG] Azure Data Warehouse Migration Utility ? Microsoft ? ? Dell Benchmark Factory Oracle,MySQL,Other No [T] Dell Benchmark Factory ? Quest Software No $4413 manduka Oracle Linux,Mac [?] manduka 2017-03-08 Virtusa Corporation Yes No PowerBI Desktop Oracle,MySQL,PostgreSQL,Other No [BI] PowerBI Desktop 2017-07-11 Microsoft Yes ? Stellar Phoenix SQL Database Repair No No [REC] Stellar Phoenix SQL Database Repair 2017-07-05 Stellar Technology No $349 DataNumen SQL Recovery No No [REC] DataNumen SQL Recovery 2017-03-20 DataNumen No $500 Recovery Toolbox for SQL Server No No [REC] Recovery Toolbox for SQL Server ? Recovery Toolbox Shareware No $99 SQL MDF Viewer No No [?] SQL MDF Viewer ? SysTools Shareware No $129 SQL MDF Recovery Tool No No [REC] SQL MDF Recovery Tool ? SysTools Shareware No $129 SQL Passord Recovery No No [REC] SQL Passord Recovery ? SysTools Shareware No $69 SQL Decryptor No No [?] SQL Decryptor ? SysTools Shareware No $69 SQL Backup Database Recovery No No [REC] SQL Backup Database Recovery ? SysTools Shareware No $149 SQL Log File Viewer No No [?] SQL Log File Viewer ? SysTools Shareware No $999 DAX Studio No No [?] DAX Studio ? Sqlbi Freeware Yes No SQL Cop No No [?] SQL Cop ? LessThanDot Freeware Yes No Dataedo Oracle,MySQL No [D] Dataedo 2017-09-15 Logic Systems Shareware Yes $239 Azure Database Migration Service Oracle,MySQL, Other Online [MG] Azure Database Migration Service 2017-12-01 Microsoft Yes No FlowHeater Oracle,MySQL,PostgreSQL,Other No [ETL] FlowHeater 2017-10-02 FlowHeater GmbH Shareware No $79 EDIS No No [ETL] EDIS ? SQL ETL Shareware Yes $599 SchemaSpy Oracle,MySQL,PostgreSQL,Other Linux,Mac [D] SchemaSpy 2018-08-05 Rafal Kasa MIT Open Source No Adminer Oracle,MySQL,PostgreSQL,Other Linux,Mac [MS] Adminer 2018-02-20 Jakub Vrána Apache Open Source No Full Convert Oracle,MySQL,PostgreSQL,Other No [MG] Full Convert 2018-08-20 Spectral Core Shareware Yes $699 Replicator Oracle,MySQL,PostgreSQL,Other No [DC] Replicator 2018-08-20 Spectral Core Shareware Yes $699 JackDB Oracle,MySQL,PostgreSQL,Other Online [MS] JackDB ? JackDB No $48 SQL Workbench Oracle,MySQL,PostgreSQL,Other Linux,Mac [MS] SQL Workbench 2018-08-20 Thomas Kellerer Yes No Valentina Studio MySQL,PostgreSQL,Other Linux,Mac [MS] Valentina Studio 2018-09-24 Paradigma Software Yes $200 SSMS

    Download page: SSMSRelease date: 2018-11-21Support Version: 2005-2017/AzureAuthor: MicrosoftFree version: YesPrice: No

    SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing complete components of SQL Server. SSMS combines a broad group of graphical tools with a number of moneyed script editors to provide developers and administrators of complete skill levels access to SQL Server. This release features improved compatibility with previous versions of SQL Server, a stand-alone web installer, and toast notifications within SSMS when new releases become available.

    bcp Utility

    Download page: bcp UtilityRelease date: 2012-02-11Support Version: 2008/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    The bcp utility bulk copies data between an instance of MicrosoftSQL Server and a data file in a user-specified format. The bcp utility can exist used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files. Except when used with the queryout option, the utility requires no learning of Transact-SQL. To import data into a table, you must either use a format file created for that table or understand the structure of the table and the types of data that are telling for its columns.

    sqlcmd Utility

    Download page: sqlcmd UtilityRelease date: 2016-08-23Support Version: 2008-2017/AzureAuthor: MicrosoftFree version: YesPrice: No

    The SQLCMD utility allows users to connect to, send Transact-SQL batches from, and output rowset information from SQL Server instances. The bcp utility bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format. The bcp utility can exist used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files.

    mssql-cli

    Download page: mssql-cliRelease date: 2018-07-06Support Version: 2008-2017/AzureAuthor: MicrosoftFree version: Open SourcePrice: No

    Interactive command line query utensil for SQL Server.

  • Auto-completion
  • Syntax highlighting
  • Query history
  • Configuration file support
  • Multi-line queries
  • Azure Data Studio

    Download page: Azure Data StudioRelease date: 2018-12-19Support Version: 2008-2017/AzureAuthor: MicrosoftFree version: YesPrice: No

    Azure Data Studio (previously SQL Operations Studio) is a data management utensil that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux.

    Azure Data Studio List of Extensions

  • Cross-Platform DB management for Windows, macOS and Linux with simple XCopy deployment
  • SQL Server Connection Management with Connection Dialog, Server Groups, and Registered Servers
  • Object Explorer supporting schema browsing and contextual command execution
  • T-SQL Query Editor with advanced coding features such as autosuggestions, error diagnostics, tooltips, formatting and peek definition
  • Query Results Viewer with advanced data grid supporting large result sets, export to JSON\CSV\Excel, query map and charting
  • Management Dashboard supporting customizable widgets with drill-through actionable insights
  • Visual Data Editor that enables direct row insertion, update and deletion into tables
  • Backup and Restore dialogs that enables advanced customization and remote filesystem browsing, configured tasks can exist executed or scripted
  • Task History window to view current stint execution status, completion results with error messages and stint T-SQL scripting
  • Scripting advocate to generate CREATE, SELECT and DROP statements for database objects
  • Workspaces with complete Git integration and Find In Files advocate to managing T-SQL script libraries
  • Modern light-weight shell with theming, user settings, complete screen support, integrated terminal and numerous other features
  • RML Utilities for SQL Server

    Download page: RML Utilities for SQL ServerRelease date: 2014-12-12Support Version: 2008/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    The RML utilities allow you to process SQL Server trail files and view reports showing how SQL Server is performing. For example, you can quickly see:

  • Which application, database or login is using the most resources, and which queries are answerable for that
  • Whether there were any map changes for a batch during the time when the trail was captured and how each of those plans performed
  • What queries are running slower in todays data compared to a previous set of data
  • GraphView

    Download page: GraphViewRelease date: 2016-02-23Support Version: –Author: MicrosoftFree version: YesPrice: No

    GraphView is a DLL library that enables users to use SQL Server or Azure SQL Database to manage graphs. It connects to a SQL database locally or in the cloud, stores graph data in tables and queries graphs through a SQL-extended language.

    Microsoft Baseline Security Analyze

    Download page: Baseline Security AnalyzeRelease date: 2015-01-09Support Version: –Author: MicrosoftFree version: YesPrice: NoInstruction: http://www.sqlshack.com/how-to-install-and-use-microsoft-baseline-security-analyzer-mbsa/

    The Microsoft Baseline Security Analyzer provides a streamlined mode to identify missing security updates and common security misconfigurations. MBSA 2.3 release adds advocate for Windows 8.1, Windows 8, Windows Server 2012 R2, and Windows Server 2012. Windows 2000 will no longer exist supported with this release.

    tablediff Utility

    Download page: tablediff UtilityRelease date: –Support Version: 2005-2016Author: MicrosoftFree version: YesPrice: NoInstruction: SQL Server tablediff utility by Robert Sheldon

    The tablediff utility is used to compare the data in two tables for non-convergence, and is particularly useful for troubleshooting non-convergence in a replication topology. This utility can exist used from the command prompt or in a batch file to fulfill the following tasks:

  • A row by row comparison between a source table in an instance of SQL Server acting as a replication Publisher and the destination table at one or more instances
  • Perform a speedy comparison by only comparing row counts and schema.
  • Perform column-level comparisons.
  • Generate a Transact-SQL script to fix discrepancies at the destination server to bring the source and destination tables into convergence.
  • Log results to an output file or into a table in the destination database.
  • Microsoft Log Parser

    Download page: Microsoft Log ParserRelease date: –Support Version: –Author: MicrosoftFree version: YesPrice: NoInstruction: Microsoft Log Parser Utility: Swell ETL by Robert Sheldon

    Log parser is a powerful, multifarious utensil that provides universal query access to text-based data such as log files,XML files and CSV files, as well as key data sources on the Windows operating system such as the Event Log, the Registry, the file system, and vigorous Directory.

    Log Parser Lizard GUI

    Download page: Log Parser Lizard GUIRelease date: 2017-06-01Support Version: 2008-2017Author: Lizard LabsFree version: YesPrice: $59

    Log Parser Lizard is a GUI for Microsoft Logparser, definitely the best one available on the market today. Log Parser is a very powerful and multifarious query software utensil that provides universal query access (using SQL) to text-based data, such as log files, XML files, and TSV/CSV text files, as well as key data sources on the Microsoft Windows operating system, such as the Windows Event Log, IIS log, the registry, the File System, the vigorous Directory services and much more.

    Diskspd

    Download page: DiskspdRelease date: 2015-12-14Support Version: –Author: MicrosoftFree version: Yes

    DISKSPD is a storage load generator / performance test utensil from the Windows/Windows Server and Cloud Server Infrastructure Engineering teams. Compilation is supported with Visual Studio and Visual Studio Express. use the Visual Studio solution file inside the diskspd_vs2013 directory.

    HammerDB

    Download page: HammerDBRelease date: 2015-05-04Support Version: –Author: Open SourceFree version: YesPrice: No

    HammerDB is an open source database load testing and benchmarking utensil for Oracle, SQL Server, DB2, TimesTen, PostgreSQL, Greenplum, Postgres Plus Advanced Server, MySQL, Redis and Trafodion SQL on Hadoop.

    Microsoft Exchange Server error Code Look-up

    Download page: Exchange Server error Code Look-upRelease date: 2004-05-10Support Version: –Author: MicrosoftFree version: YesUseful link: http://www.sqlshack.com/how-to-install-and-use-microsoft-baseline-security-analyzer-mbsa/

    Determine error values from decimal and hexadecimal error codes in Microsoft Windows operating systems.

    LINQPad

    Download page: LINQPadRelease date: 2016-02-01Support Version: 2008/2012/2014/2016Author: Joseph AlbahariFree version: YesPrice: $45

    Instantly test any C#/F#/VB snippet or program, Query databases in LINQ (or SQL) — SQL/CE/Azure, Oracle, SQLite & MySQL. standard edition free, with no expiry. luxuriate in moneyed output formatting, optional autocompletion and integrated debugging, Script and automate in your favorite .NET language, Super lightweight — single 15MB executable! SQL Server query execution map visualizer for LINQPad http://bit.ly/QueryPlanVisualizer

    SqlDynamite

    Download page: SqlDynamiteRelease date: 2016-04-06Support Version: 2008/2012/2014/2016Author: Anatoly SovaFree version: YesPrice: No

    Easy text search in stored procedures, functions, tables, views and triggers. Supports MSSQL, Oracle, SAP, Firebird, Mysql, PostgreSQL, DB2, Informix, SQLite, Ingres, SQL Azure, Interbase.

    SQL Server Data Tools

    Download page: SQL Server Data ToolsRelease date: 2018-04-10Support Version: 2008-2017/AzureAuthor: MicrosoftFree version: YesPrice: No

    SQL Server Data Tools (SSDT) is a modern development utensil that you can download for free to build SQL Server relational databases, Azure SQL databases, Integration Services packages, Analysis Services data models, and Reporting Services reports. With SSDT, you can design and deploy any SQL Server content ilk with the identical ease as you would develop an application in Visual Studio.

    Database Health Monitor

    Download page: Database Health MonitorRelease date: 2016-03-20Support Version: 2008/2012/2014/2016Author: Steve StedmanFree version: YesPrice: No

    Database Health Monitor is a powerful performance monitoring and diagnostics solution that alerts administrators to server health, performance or availability problems within their SQL Server environment, complete from a central console.

    SchemaDrift

    Download page: SchemaDriftRelease date: 2016-02-28Support Version: 2008/2012/2014Author: Steve StedmanFree version: YesPrice: No

    SchemaDrift is a SQL Server database comparison utensil that allows you to compare the schema, the tables, indexes, stored procedures, functions, and much more between SQL Server databases

    DBeaver

    Download page: DBeaverRelease date: 2018-09-24Support Version: 2005-2017Author: Open SourceFree version: YesPrice: No

    Free multi-platform database utensil for developers, SQL programmers, database administrators and analysts. Supports complete common databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MongoDB, Cassandra, etc

    HeidiSQL

    Download page: HeidiSQLRelease date: 2017-12-19Support Version: 2005-2017Author: Open SourceFree version: YesPrice: No

    HeidiSQL is a useful and trustworthy utensil designed for web developers using the common MySQL server, Microsoft SQL databases and PostgreSQL. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Also, you can export structure and data either to SQL file, clipboard or to other servers.

    SQLExecStats

    Download page: SQLExecStatsRelease date: 2016-02-08Support Version: 2008/2008R2/2012/2014Author: Joe ChangFree version: YesPrice: No

  • Automate collection of key DMVs for query tuning.
  • Collates query exec stats with execution map details.
  • Cross reference index usage by execution plan, what plans reference infrequently used indexes.
  • Saves XML map for top queries.
  • Save information directly to Microsoft outdo 2003 file format and in binary.
  • ExpressProfiler

    Download page: ExpressProfilerRelease date: 2016-02-15Support Version: 2008/2008R2/2012/2014Author: Chris MooreFree version: YesPrice: No

    ExpressProfiler (aka SqlExpress Profiler) is a simple and speedy replacement for SQL Server Profiler with basic GUI and integration with Red Gate Ecosystem project.

    Data Migration Assistant

    Download page: Data Migration AssistantRelease date: 2017-03-15Support Version: 2005/2008/2008R2/2012/2014/2016/AzureAuthor: MicrosoftFree version: YesPrice: No

    Data Migration aide (DMA) enables you to upgrade to a modern data platform by detecting compatibility issues that can repercussion database functionality on your new version of SQL Server. It recommends performance and reliability improvements for your target environment. It allows you to not only stagger your schema and data, but moreover uncontained objects from your source server to your target server.

    SQL Server Migration aide for Sybase

    Download page: Migration aide for SybaseRelease date: 2017-02-17Support Version: 2005/2008/2008R2/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    Microsoft SQL Server Migration aide (SSMA) for Sybase is a utensil to automate migration from MySQL database(s) to SQL Server and Azure SQL DB.

    dta Utility

    Download page: dta UtilityRelease date: –Support Version: 2005/2008/2008R2/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    Capture performance and usage data about your Microsoft SQL Server 2005+ databases to inform insights and better troubleshooting. Key real-time metrics provide an overview of your databases and detailed measurements about reminiscence usage, connections, network I/O, and file I/O.

    osql Utility

    Download page: osql UtilityRelease date: –Support Version: 2005/2008/2008R2/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    The osql utility allows you to enter Transact-SQL statements, system procedures, and script files.This utility uses ODBC to communicate with the server.

    sqldiag Utility

    Download page: sqldiag UtilityRelease date: –Support Version: 2005/2008/2008R2/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    The SQLdiag utility is a general purpose diagnostics collection utility that can exist accelerate as a console application or as a service.You can use SQLdiag to collect logs and data files from SQL Server and other types of servers, and use it to monitor your servers over timeor troubleshoot specific problems with your servers.SQLdiag is intended to expedite and simplify diagnostic information gathering for Microsoft Customer advocate Services.

    sqldumper Utility

    Download page: sqldumper UtilityRelease date: –Support Version: 2005/2008/2008R2/2012Author: MicrosoftFree version: YesPrice: No

    You can use the Sqldumper.exe utility to generate a dump file on require for any Microsoft Windows application.For example, you can generate a dump file for debugging an application problem when a computer that is running SQL Server 2005,Microsoft SQL Server 2008, Microsoft SQL Server 2008 R2, or Microsoft SQL Server 2012 is not responding to user requests.A dump file can exist a mini-dump file, a complete dump file, or a filtered dump file.

    SqlLocalDB Utility

    Download page: SqlLocalDB UtilityRelease date: –Support Version: 2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    SqlLocalDB lets you create, delete, start, stop, and fulfill a number of other related tasks on an instance of SQL Server 2012 Express LocalDB,an execution mode of SQL Server Express that’s targeted at developers. A LocalDB instance uses a minimal set of files to start the database engine.

    sqllogship Utility

    Download page: sqllogship UtilityRelease date: –Support Version: 2005/2008/2008R2/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    The sqllogship application performs a backup, copy, or restore operation and associated clean-up tasks for a log shipping configuration.The operation is performed on a specific instance of Microsoft SQL Server for a specific database.

    sqlservr Application

    Download page: sqlservr ApplicationRelease date: –Support Version: 2005/2008/2008R2/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    The sqlservr application starts, stops, pauses, and continues an instance of Microsoft SQL Server from a command prompt.

    sqlps Utility

    Download page: sqlps UtilityRelease date: –Support Version: 2008/2008R2/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    The sqlps utility starts a Windows PowerShell 2.0 session with the SQL Server PowerShell provider and cmdlets loaded and registered. You can enter PowerShell commands or scripts that use the SQL Server PowerShell components to toil with instances of SQL Server and their objects. This feature will exist removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and map to modify applications that currently use this feature. use the sqlps PowerShell module instead.

    sqlmaint Utility

    Download page: sqlmaint UtilityRelease date: –Support Version: 2005/2008/2008R2/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    The sqlmaint utility performs a specified set of maintenance operations on one or more databases. use sqlmaint to accelerate DBCC checks, back up a database and its transaction log, update statistics, and rebuild indexes. complete database maintenance activities generate a report that can exist sent to a designated text file, HTML file, or e-mail account. sqlmaint executes database maintenance plans created with previous versions of SQL Server. To accelerate SQL Server maintenance plans from the command prompt, use the dtexec Utility. This feature will exist removed in the next version of Microsoft SQL Server. Avoid using this feature in new development work, and map to modify applications that currently use this feature. use SQL Server maintenance map feature instead.

    Ssms Utility

    Download page: Ssms UtilityRelease date: –Support Version: 2005/2008/2008R2/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    The Ssms utility opens SQL Server Management Studio. If specified, Ssms moreover establishes a connection to a server, and opens queries, scripts, files, projects, and solutions. You can specify files that hold queries, projects, or solutions. Files that hold queries are automatically connected to a server if connection information is provided and the file ilk is associated with that ilk of server. For instance, .sql files will open a SQL Query Editor window in SQL Server Management Studio, and .mdx files will open an MDX Query Editor window in SQL Server Management Studio. SQL Server Solutions and Projects will open in SQL Server Management Studio.

    dtexec Utility

    Download page: dtexec UtilityRelease date: –Support Version: 2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    The dtexec command prompt utility is used to configure and execute SQL Server Integration Services packages. The dtexec utility provides access to complete the package configuration and execution features, such as parameters, connections, properties, variables, logging, and progress indicators. The dtexec utility lets you load packages from these sources: the Integration Services server, an .ispac project file, a Microsoft SQL Server database, the SSIS Package Store, and the file system.

    SQL Server 2016 Report Builder

    Download page: SQL Server 2016 Report BuilderRelease date: 2016-09-16Support Version: 2016Author: MicrosoftFree version: YesPrice: No

    Report Builder provides a productive report-authoring environment for IT professionals and power users. The download provides a stand-alone installer for Report Builder.

    Report Builder provides data visualizations that comprise charts, maps, sparklines, and data bars that can succor capitulate new insights well beyond what can exist achieved with standard tables and charts. use Report Builder to create reports and shared datasets. Publish report parts, and then browse the Report fraction Gallery to reuse existing report parts as building blocks for creating new reports quickly with a “grab and go” experience.

    SQL Server 2005 Best Practices Analyzer

    Download page: BPA 2005Release date: 2008-08-13Support Version: 2005Author: MicrosoftFree version: YesPrice: No

    The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment.

    SQL Server 2000 Best Practices Analyzer

    Download page: BPA 2000Release date: 2010-04-26Support Version: 2000Author: MicrosoftFree version: YesPrice: No

    SQL Server 2000 Best Practices Analyzer is a database management utensil that lets you verify the implementation of common Best Practices on your servers.

    SQL Server 2008 R2 Best Practices Analyzer

    Download page: BPA 2008Release date: 2010-06-18Support Version: 2008/2008R2Author: MicrosoftFree version: YesPrice: No

    The Microsoft SQL Server 2008 R2 BPA is a diagnostic utensil that performs the following functions:

  • Gathers information about a Server and a Microsoft SQL Server 2008 or 2008 R2 instance installed on that Server
  • Determines if the configurations are set according to the recommended best practices
  • Reports on complete configurations, indicating settings that disagree from recommendations
  • Indicates potential problems in the installed instance of SQL Server
  • Recommends solutions to potential problems
  • SQL Server 2012 Best Practices Analyzer

    Download page: BPA 2012Release date: 2012-04-06Support Version: 2012Author: MicrosoftFree version: YesPrice: No

    The Microsoft SQL Server 2012 BPA is a diagnostic utensil that performs the following functions:

  • Gathers information about a Server and a Microsoft SQL Server 2012 instance installed on that Server
  • Determines if the configurations are set according to the recommended best practices
  • Reports on complete configurations, indicating settings that disagree from recommendations
  • Indicates potential problems in the installed instance of SQL Server
  • Recommends solutions to potential problems
  • DLM Dashboard

    Download page: DLM DashboardRelease date: 2016-04-27Support Version: 2005/2008/2012/2014Author: Red GateFree version: YesPrice: No

    DLM Dashboard tracks your database schemas and alerts you when they change. DLM Dashboard monitors up to 50 of your databases, and sends you an email alert as soon as your databases start to drift, or change from their expected state. On the web dashboard, you can discern exactly what changed, who made the changes, and when.

    Red Gate SQL Compare

    Download page: Red Gate SQL CompareRelease date: 2016-10-31Support Version: 2005/2008/2012/2014/2016Author: Red GateFree version: NoPrice: $495

    Compares and synchronizes SQL Server database schemas

    Red Gate SQL Data Compare

    Download page: Red Gate SQL Data CompareRelease date: 2016-05-09Support Version: 2005/2008/2012/2014Author: Red GateFree version: NoPrice: $495

    SQL Data Compare is the industry-standard utensil for comparing and deploying SQL Server database contents

    Red Gate SQL Prompt

    Download page: Red Gate SQL PromptRelease date: 2016-04-28Support Version: 2005/2008/2012/2014Author: Red GateFree version: NoPrice: $369

    Write, format and refactor SQL effortlessly

    Red Gate SQL Monitor

    Download page: Red Gate SQL MonitorRelease date: 2015-10-15Support Version: 2005/2008/2012/2014Author: Red GateFree version: NoPrice: $1495

    Real-time SQL Server performance monitoring, with alerts and diagnostics

    Red Gate SQL Backup Pro

    Download page: Red Gate SQL Backup ProRelease date: 2014-07-08Support Version: 2005/2008/2012/2014Author: Red GateFree version: NoPrice: $995

    Compress, verify, and encrypt SQL Server backups

    Red Gate SQL Doc

    Download page: Red Gate SQL DocRelease date: 2016-04-26Support Version: 2005/2008/2012/2014Author: Red GateFree version: NoPrice: $369

    Document your databases automatically, create documents as HTML, PDF, Microsoft Word or Compiled HTML succor files

    Red Gate SQL Data Generator

    Download page: Red Gate SQL Data GeneratorRelease date: 2016-04-26Support Version: 2005/2008/2012/2014Author: Red GateFree version: NoPrice: $369

    Generate realistic test data fast

    Red Gate SQL Dependency Tracker

    Download page: Red Gate SQL Dependency TrackerRelease date: 2016-04-26Support Version: 2005/2008/2012/2014Author: Red GateFree version: NoPrice: $369

    Visualize knotty databases simply

    Red Gate SQL Multi Script

    Download page: Red Gate SQL Dependency TrackerRelease date: 2016-04-15Support Version: 2005/2008/2012/2014Author: Red GateFree version: NoPrice: $245

    Deploy multiple scripts to multiple servers with just one click

    Red Gate SQL Index Manager

    Download page: Red Gate SQL Index ManagerRelease date: ?Support Version: 2008/2012/2014Author: Red GateFree version: NoPrice: $149

    Analyze, manage, and fix database index fragmentation

    Red Gate SQL Comparison SDK

    Download page: Red Gate SQL Comparison SDKRelease date: 2016-02-22Support Version: 2008/2012/2014Author: Red GateFree version: NoPrice: $895

    Compare and synchronize automatically database schemas and data

    Red Gate SQL Clone

    Download page: Red Gate SQL CloneRelease date: 2017-02-27Support Version: 2008-2017Author: Red GateFree version: NoPrice: $6955

  • SQL Clone is a database provisioning utensil that lets you create complete copies of SQL Server databases and backups in seconds, using around 40MB of disk space per clone.
  • Instead of spending hours provisioning copies of your database for development, testing, or diagnostics, SQL Clone creates one data image of a SQL Server database or backup, which you use as the source for clones.
  • Clones toil just dote normal databases. You can connect to them and edit them using any program. SQL Clone's web app provides an smooth central site to create and manage clones.
  • With SQL Clone, your team can toil locally on up-to-date, isolated copies of the database to accelerate up development, accurately test code, and fix issues faster.
  • Red Gate SQL Provision

    Download page: Red Gate SQL ProvisionRelease date: 2018-02-26Support Version: 2008-2017Author: Red GateFree version: NoPrice: $2955

    Create, protect, and manage SQL Server database copies for compliant DevOps

    Red Gate SQL Data Masker

    Download page: Red Gate SQL Data MaskerRelease date: 2018-02-26Support Version: 2008-2017Author: Red GateFree version: NoPrice: $2355

    Replace sensitive data with realistic, anonymized, test data

  • Multiple methods to sanitize sensitive information
  • Use templates to remain consistent with existing data formats
  • Replacement data sets included, such as Names, Zip Codes, Emails
  • Populate test data as well as sanitize existing information
  • Simple, repeatable, fast, and smooth to use
  • Supports SQL Server and Oracle databases
  • DLM Automation

    Download page: DLM AutomationRelease date: ?Support Version: 2008/2012/2014Author: Red GateFree version: NoPrice: ?

    Automate your database changes with continuous integration and automated deployment

    ReadyRoll

    Download page: ReadyRollRelease date: 2016-03-01Support Version: 2012/2014Author: Red GateFree version: NoPrice: $345

    It generates numerically ordered SQL migration scripts that sit inside your project and hold your schema from one version to the next. You can add them to version control, use them to build and release, and automate database and application deployments, complete in one process.

    Rapid Database Extractor

    Download page: Rapid Database ExtractorRelease date: 2016-11-03Support Version: 2008/2012/2014/2016/AzureAuthor: IderaFree version: YesPrice: No

  • Manage SQL Server and Oracle data sources
  • Manipulate database objects
  • Interactively edit SQL code
  • Selectively execute SQL queries to retrieve data
  • Export data to common file formats
  • Connect to cloud and accelerate in cloud (provisional)
  • SQL XEvent Profiler

    Download page: SQL XEvent ProfilerRelease date: 2014-03-14Support Version: 2012/2014Author: IderaFree version: YesPrice: No

    Idera’s SQL XEvent Profiler emulates the functionality and simplicity of SQL Server Profiler, letting you quickly view data from SQL eventsand discern whats happening on the server. Plus, it leverages SQL Extended Events (XEvents) as the backing technology — making it more efficient than SQL Trace.

    SQL Check

    Download page: SQL CheckRelease date: 2015-09-24Support Version: 2005/2008/2008R2/2012/2014Author: IderaFree version: YesPrice: No

  • Check out what happens in batches, compilations, recompilations, and transactions throughout the SQL Server environment
  • Monitor some of the most vital metrics in SQL Server including wait stats, reads, writes, session details, and cache hits
  • See SQL operations as they occur for the latest information; reckon it a heart rate monitor for your SQL Server environment
  • Install easily without agents
  • SQL Fragmentation Analyzer

    Download page: SQL Fragmentation AnalyzerRelease date: 2012-11-16Support Version: 2005/2008/2008R2/2012/2014Author: IderaFree version: YesPrice: No

  • Analyze fragmentation by one table or an entire database
  • Identify databases in exigency of defragmentation
  • Set fragmentation thresholds: normal, warning, critical
  • SQL Heat Map

    Download page: SQL Heat MapRelease date: 2016-01-27Support Version: 2005/2008/2008R2/2012/2014Author: IderaFree version: YesPrice: No

  • Get one visual view of storage in complete tables of a database
  • See storage allocation, utilization, and ilk of data
  • Quickly locate tables and indexes that exigency more allocated storage
  • SQL Hekaton reminiscence Check

    Download page: SQL Hekaton reminiscence CheckRelease date: 2015-06-10Support Version: 2014Author: IderaFree version: YesPrice: No

  • Monitor the repercussion of reminiscence optimized tables on server memory
  • Identify elevated reminiscence utilizing tables
  • Assess server reminiscence capacity
  • Simulate touching to In-Memory OLTP
  • SQL Page Viewer

    Download page: SQL Page ViewerRelease date: 2014-08-25Support Version: 2005/2008/2008R2/2012/2014Author: IderaFree version: YesPrice: No

  • Displays page plane data summary and detail information
  • Has elegant GUI design for speedy access in 1 click
  • Can select any SQL server and database table
  • Can navigate to any page data quickly in a tree view
  • Can launch directly within SSMS for optimal usability
  • SQL Update Statistics

    Download page: SQL Update StatisticsRelease date: 2015-12-14Support Version: 2005/2008/2008R2/2012/2014Author: IderaFree version: YesPrice: No

  • Launch directly within SSMS for optimal usability
  • Identify out-of-date SQL Server table and index statistics
  • View and change database statistics options
  • Create graphical histograms for each column’s statistics
  • SQL Statistics Aggregator

    Download page: SQL Statistics AggregatorRelease date: 2015-05-18Support Version: 2005/2008/2008R2/2012/2014Author: IderaFree version: YesPrice: No

  • Aggregate IO statistics to identify problem tables
  • Correlate disk activity with query map nodes
  • Compare runs of a query over time
  • Export and import results for smooth collaboration
  • SQL Backup Status Reporter

    Download page: SQL Backup Status ReporterRelease date: 2015-08-07Support Version: 2005/2008/2008R2/2012Author: IderaFree version: YesPrice: No

  • Quickly identify databases which absorb not had backups
  • View backup history including the backup date and type
  • Have simplified grid view for smooth sorting and navigation
  • Identify complete and differential backups for many databases
  • SQL Integrity Check

    Download page: SQL Integrity CheckRelease date: 2013-08-26Support Version: 2005/2008/2008R2/2012Author: IderaFree version: YesPrice: No

  • Easily accelerate a CHECKDB for any database on-demand
  • View integrity check results to identify corruption
  • Routinely verifies when eventual check was performed
  • Receive alerts when databases are due for checks
  • Do not exigency to write and maintain scripts
  • SQL Job Manager

    Download page: SQL Job ManagerRelease date: 2012-03-19Support Version: ?Author: IderaFree version: YesPrice: No

  • Have management console to easily view past and current jobs
  • Can identify and redress job contention
  • Can drag and drop jobs across servers to plane workloads
  • Can "at a glance" view to discern failed or runaway jobs
  • Have customizable calendar view
  • Azure SQL Database Backup

    Download page: Azure SQL Database BackupRelease date: 2012-10-02Support Version: ?Author: IderaFree version: YesPrice: No

  • Save time and storage space with up to 95% compression
  • Backup on-premise or to Azure BLOB storage
  • Central data storage to forestall data loss
  • View historical backup and restore operations
  • Restore with transaction consistency to and from the cloud
  • SQL Column Search

    Download page: SQL Column SearchRelease date: 2015-11-17Support Version: 2005/2008/2008R2/2012/2014Author: IderaFree version: YesPrice: No

  • Find potentially sensitive data
  • Search an entire instance or a specific table
  • Export results to CSV format for smooth analysis and reporting
  • SQL Permissions Extractor

    Download page: SQL Permissions ExtractorRelease date: 2015-08-07Support Version: 2005/2008/2008R2/2012Author: IderaFree version: YesPrice: No

  • Generate T-SQL scripts for copying of user permissions
  • Edit, save, and execute permissions scripts
  • Include kick plane permissions for selected databases
  • Copy, extract, modify and apply changes in four steps
  • SQL BI Check

    Download page: SQL BI CheckRelease date: 2016-04-13Support Version: 2005/2008/2008R2/2012Author: IderaFree version: YesPrice: No

  • Real-time performance monitoring for SQL Server Analysis Services (SSAS)
  • See physical server metrics for CPU, disk, and storage
  • View analysis metrics for SSAS processing, memory, and cache
  • Get up and running in minutes, no agents required
  • SQL Inventory Check

    Download page: SQL Inventory CheckRelease date: 2016-03-24Support Version: 2005/2008/2008R2/2012Author: IderaFree version: YesPrice: No

  • Discover unknown and forgotten instances posing security and performance risks
  • Track SQL Servers to manage license and advocate costs
  • Stay on top of vital SQL Server updates and patches
  • SQL Diagnostic Manager

    Download page: SQL Diagnostic ManagerRelease date: ?Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $1747

  • Performance monitoring for physical and virtual environments
  • Query map monitoring to discern the causes of blocks and deadlocks
  • Integrated SQL Doctor expert recommendations
  • Easy integration with Microsoft SCOM
  • Predictive alerting with settings to avoid unsuitable alerts
  • Web-based dashboard with at-a-glance views of top issues and alert
  • SQL Safe Backup

    Download page: SQL Safe BackupRelease date: 2016-03-24Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $907

  • Backup faster than autochthonous SQL and reclaim space with dynamic compression
  • Reduce failures due to network problems
  • Automate full, differential, and transaction log backups
  • Integrated cloud backup advocate for Amazon S3
  • Instant Restore provides immediate access to backup data
  • Web-based dashboard provides at-a-glance views of top issues and alerts
  • SQL Compliance Manager

    Download page: SQL Compliance ManagerRelease date: 2015-09-08Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $2657

  • Audit Sensitive Data – discern who did what, when, where, and how
  • Track and Detect – monitor and alert on suspicious activity
  • Satisfy Audits – for PCI, HIPAA, FERPA and SOX requirements
  • Generate Reports – 25 built-in reports to validate SQL Server audit trails
  • Minimize Overhead – light data collection agent minimizes server imp
  • SQL Inventory Manager

    Download page: SQL Inventory ManagerRelease date: 2016-04-22Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $3195

  • View your SQL Server inventory – know what you absorb where & who owns it
  • Auto-discover any new servers installed, to better manage server sprawl
  • Get alerts when a server goes down, or space is running low
  • Set tags to better organize servers and databases across the enterprise
  • Quickly deploy and access from anywhere via web-based and agentless UI
  • SQL Virtual Database

    Download page: SQL Virtual DatabaseRelease date: 2016-03-24Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $625

  • Immediate access – fetch data from backup files instantly
  • Acts dote a actual database – use 3rd party and autochthonous tools
  • OLR replacement – better solution to kick plane recovery
  • Multiple Uses – reporting, data extraction, analysis, etc.
  • Read/Write advocate – inserts, updates, DBCC commands
  • SQL Secure

    Download page: SQL SecureRelease date: 2016-04-19Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $907

  • Identify existing vulnerabilities in your SQL Servers
  • Harden security policies across SQL Servers
  • Rank security levels with the security report card
  • Analyze and report user permissions across SQL Servers
  • Customizable templates for PCI, HIPAA and more
  • SQL Doctor

    Download page: SQL DoctorRelease date: 2015-12-17Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $625

  • New and enhanced Expert Recommendations to succor better performance
  • Dashboard exposes performance metrics in real-time
  • "Quick Findings" instantly locates SQL performance issues
  • Executable scripts are generated to optimize performance
  • Stored history of analysis recommendations for trending
  • SQL Admin Toolset

    Download page: SQL Admin ToolsetRelease date: 2016-01-13Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $325

  • 24 essential desktop tools for your everyday SQL Server needs
  • Run every day diagnostics across multiple SQL servers
  • Complete administrative tasks in minutes, not hours
  • Perform analysis on your SQL data
  • SQL Defrag Manager

    Download page: SQL Defrag ManagerRelease date: 2016-03-10Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $1495

  • Automate identification of index fragmentation "hot spots"
  • Schedule index defragmentation jobs
  • Avoid database contention with system resource pre-checks
  • Reduce page splits with index fill factor settings control
  • Centrally manage, report and notify instantly
  • DBArtisan

    Download page: DBArtisanRelease date: ?Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $3122

  • Manage multiple platforms (Oracle, SQL Server, DB2, Sybase) from one UI
  • Proactively manage space, data and performance with built-in analytics
  • Easily find and fix performance issues using intelligent diagnostics
  • Move schema and table data across different platforms with ease
  • Protect data security with view, award and revoke of permissions
  • SQL BI Manager

    Download page: SQL BI ManagerRelease date: 2015-09-08Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $697

  • Monitor SSAS, SSRS, & SSIS health with agentless monitoring
  • View vigorous sessions, workload, and report generation performance
  • Identify issues with access to data including cube size and resource utilization
  • Set up alerts with configurable thresholds
  • Log in from anywhere for at-a-glance views of top issues and alerts
  • SQL Enterprise Job Manager

    Download page: SQL Enterprise Job ManagerRelease date: 2015-09-08Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $697

  • Monitor SQL Server agent jobs across the enterprise
  • Easily view job status and details with familiar calendar layout
  • Chain jobs together and build automated workflows
  • Configure and manage jobs that accelerate over multiple instances
  • Set alerts to exist notified of potential issues
  • Web-based architecture simplifies deployment
  • DB Optimizer

    Download page: DB OptimizerRelease date: ?Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $1420

  • Streamline tuning of SQL code on major DBMSs from one interface
  • Tune SQL dote a pro with automated performance optimization suggestions
  • Tackle knotty SQL queries with visual SQL tuning diagrams
  • Pinpoint problem SQL with database profiling of wait-time analysis
  • Load test alternative SQL queries in simulated production environment
  • SQL Query Store Optimizer

    Download page: SQL Query Store OptimizerRelease date: 2016-07-01Support Version: 2016Author: IderaFree version: YesPrice: No

  • Improve SQL Server 2016 Query Store performance
  • See complete Query Store properties in single summary table
  • Execute predefined actions that modify Query Store properties and contents
  • Edit complete modifiable Query Store properties in single overview panel
  • Get up and running in minutes with no agents
  • Rapid SQL

    Download page: Rapid SQLRelease date: ?Support Version: 2005/2008/2008R2/2012/2014Author: IderaFree version: NoPrice: $710

  • Create high-performing SQL code on major DBMSs from one interface
  • Easily build knotty SQL statements with visual query builder
  • Quickly construct, dissect and execute SQL code with code analyst
  • Simplify debugging SQL code, functions, and stored procedures
  • Collaborate effectively across development teams with version control
  • SQL Comparison Toolset

    Download page: SQL Comparison ToolsetRelease date: ?Support Version: 2005/2008/2008R2/2012/2014Author: IderaFree version: NoPrice: $745

  • Compare and synchronize SQL Server data and schema objects
  • Easy navigation of user interface improves efficiency
  • Automate comparison and synchronization operations
  • Customize schema compare and synchronization sessions
  • Generate ready-to-use database synchronization scripts
  • ER/Studio Data Architect

    Download page: ER/Studio Data ArchitectRelease date: ?Support Version: 2005/2008/2008R2/2012/2014Author: IderaFree version: NoPrice: $1287

  • Create efficient models to build a business-driven data architecture
  • Document and enhance existing databases to reduce redundancy
  • Implement naming standards to better data consistency and quality
  • Effectively share and communicate models across the enterprise
  • Map data sources and trail origins to enhance data lineage
  • DB Change Manager

    Download page: DB Change ManagerRelease date: ?Support Version: 2005/2008/2008R2/2012/2014/2016Author: IderaFree version: NoPrice: $1420

  • Quickly roll out and reconcile database changes
  • Reveal, track, and report on database changes
  • Comply with database audit and reporting requirements
  • Protect data privacy within the database environment
  • Track changes from multiple major database platforms
  • Uptime Infrastructure Monitor

    Download page: Uptime Infrastructure MonitorRelease date: ?Support Version: ?Author: IderaFree version: NoPrice: ?

  • Monitor servers, VMs, network devices, and applications from a unified dashboard
  • Use historic data to map for future server capacity needs
  • Track service-level performance trends for SLA compliance and reporting
  • Monitor virtually anything via a host of pre-built plug-ins or custom scripts
  • Streamline incident management with autochthonous ServiceNow integration
  • dbForge Schema Compare

    Download page: dbForge Schema CompareRelease date: 2017-09-15Support Version: SQL Azure/2000/2005/2008/2008R2/2012/2014/2016/2017Author: DevartFree version: NoPrice: $150

    dbForge Schema Compare for SQL Server is a trustworthy utensil that will reclaim you time and distress when you exigency to compare databases on SQL Server. The relentlessly tested compare utensil allows working with live SQL Server databases, database snapshots, and backups. You can compare your SQL Server databases, dissect differences and synchronize your schemas using generated SQL script in a well-designed user interface quickly and without errors.

    dbForge Data Compare

    Download page: dbForge Schema CompareRelease date: 2017-08-30Support Version: SQL Azure/2000/2005/2008/2008R2/2012/2014/2016Author: DevartFree version: NoPrice: $149

    dbForge Data Compare for SQL Server is a powerful, speedy and smooth to use SQL comparison tool, capable of using autochthonous SQL Server backups as metadata source. With dbForge Data Compare you can tune your SQL database comparison, quickly dissect differences in a well-designed user interface and effortlessly synchronize data via a convenient wizard with additional options.

    dbForge Data Generator

    Download page: dbForge Data GeneratorRelease date: 2017-09-15Support Version: Amazon RDS/SQL Azure/2000/2005/2008/2008R2/2012/2014/2016Author: DevartFree version: NoPrice: $249

    dbForge Data Generator for SQL Server is a powerful GUI utensil for speedy generation of meaningful test data. The utensil includes 190+ predefined generators with sensible configuration options, that allow emulating column-intelligent real-world data. dbForge Data Generator for SQL Server can reclaim your time and distress by populating SQL Server tables with millions of rows of test data that looks just dote actual data.

    dbForge Query Builder

    Download page: dbForge Query BuilderRelease date: 2017-08-30Support Version: Amazon RDS/SQL Azure/2000/2005/2008/2008R2/2012/2014/2016Author: DevartFree version: NoPrice: $99

    dbForge Query Builder for SQL Server allows users to build knotty SQL queries via an intuitive visual query building interface easily and without manual code writing. This SQL query designer will exist useful to those, who often create queries to databases. Visual features to create queries, usage of graphical SQL query creator to interactively build queries, would exist most appreciated by users who absorb no sustain in writing queries manually. But even experienced users can reclaim a lot of time on routine work.

    dbForge Event Profiler

    Download page: dbForge Event ProfilerRelease date: 2017-08-30Support Version: 2008/2012/2014/2016Author: DevartFree version: YesPrice: No

    dbForge Event Profiler for SQL Server is a FREE utensil that allows you to capture and dissect SQL Server events. The events and data columns are stored in a physical trail file for later examination. You can use this information to identify and troubleshoot many SQL Server-related problems.

    dbForge SQL Decryptor

    Download page: dbForge SQL DecryptorRelease date: 2017-04-20Support Version: 2000/2005/2008/2008R2/2012/2014/2016Author: DevartFree version: YesPrice: No

    Decrypt SQL Server Procedures, Functions, Triggers, and Views

    dbForge Studio

    Download page: dbForge StudioRelease date: 2017-08-03Support Version: 2005/2008/2008R2/2012/2014/2016/2017/Amazon RDS/SQL AzureAuthor: DevartFree version: YesPrice: $249

  • Code completion — to create total SQL statement in a few keystrokes
  • SQL formatting — to result common coding style (standard)
  • SQL snippets — to reclaim time storing and reusing repeated code fragments
  • Quick kick information — to clarify hints with info on database objects
  • Code navigation — quick jump by F12 to variable declaration, kick editor, etc.
  • dbForge Fusion

    Download page: dbForge FusionRelease date: 2016-12-27Support Version: Amazon RDS/SQL Azure/2000/2005/2008/2008R2/2012/2014Author: DevartFree version: NoPrice: $149

    dbForge Fusion for SQL Server is a powerful Visual Fusion plugin designed to simplify SQL database development and enhance data management capabilities. When you integrate dbForge Fusion for SQL Server into Microsoft Visual Fusion, complete database development and administration tasks become available from your IDE. It provides an easier route to explore and maintain existing databases, design compound SQL statements and queries, and manipulate data in different way.

    dbForge Documenter

    Download page: dbForge DocumenterRelease date: 2017-08-30Support Version: 2005/2008/2008R2/2012/2014/2016Author: DevartFree version: NoPrice: $149

    dbForge Documenter for SQL Server is a majestic time saver when it comes to documentation of SQL Server databases. This utensil automatically generates documentation of an entire SQL Server database in a few clicks. The utensil includes a wide range of options to customize the generated documentation to meet your specific requirements.

    dbForge Developer Bundle

    Download page: dbForge Developer BundleRelease date: 2017-08-30Support Version: 2005/2008/2008R2/2012/2014/2016Author: DevartFree version: NoPrice: $849

    Developer Bundle for SQL Server is a utensil pack that extends SSMS with many essential features aimed not only boost developers' productivity but moreover reduce expenses while performing routine tasks.

  • Increase productivity, when creating knotty queries and code writing with SQL Complete, Search, Documenter and Query Builder.
  • Save your time while comparing and synchronizing data and schema with Source Control, Data Compare, and Schema Compare.
  • Simplify the testing process drastically and generate intensional test data with Data Generator and Unit Test.
  • Monitor SQL Server performance and troubleshoot database issues using Index Manager, Monitor, as well as Event Profiler.
  • dbForge Compare Bundle for SQL Server

    Download page: dbForge Compare Bundle for SQL ServerRelease date: 2017-08-30Support Version: 2005/2008/2008R2/2012/2014/2016Author: DevartFree version: NoPrice: $299

    One solution to wield SQL data and schema diffs.

  • A variety of supported schema objects.
  • Convenient comparison wizards will succor you to tune data and schema comparisons up to your needs..
  • Compare databases with different structures.
  • Manage comparison results by applying filtering, grouping, exclude or comprise the needed objects to continue working with them, etc.
  • Handy Synchronization wizards will succor you to: create accurate synchronization scripts, migrate any schema differences, dependency check to script objects in the redress order for updates, resolve synchronization issues automatically, view warnings on controversial points prior to synchronization.
  • Command-line interface.
  • Devart outdo Add-in for SQL Server

    Download page: Devart outdo Add-in for SQL ServerRelease date: 2017-09-13Support Version: 2005/2008/2008R2/2012/2014/2016Author: DevartFree version: NoPrice: $100

    Devart outdo Add-ins allow you to toil with database and cloud data in Microsoft outdo as with usual outdo spreadsheets.

    Minion Enterprise

    Download page: Minion EnterpriseRelease date: ?Support Version: 2008/2008R2/2012Author: MinionWareFree version: NoPrice: $1500

    Minion Enterprise was designed by database administrators (DBAs) specifically to address the issues that consume the most time and reason the most problems. Minion shrinks dozens of those one-at-a-time tasks down to a central process. And, it does this without the usual overhead of monitoring software. When you install Minion Enterprise, it automatically begins gathering data from instances across your enterprise. That single repository of data allows you to centrally audit, alert, report, and investigate your entire environment. Even better, it opens up a new world of central management: audit SQL and AD security, clone user permissions across servers, standardize and implement SQL Server settings, automate error log searches, and so very much more.

    SQL Server Compression Estimator

    Download page: SQL Server Compression EstimatorRelease date: 2011-06-02Support Version: 2008/2008R2/2012Author: Bob TavlorFree version: YesPrice: No

    SQL Server Compression Estimator (SSCE) will allow you to estimate the best compression for your objects. It will estimate both ROW and PAGE compression, and will optionally report the Index Maintenance Ratio (a ratio that indicates how often an index is updated versus how often it is used to fill queries). You can then use that information to perhaps elect a less aggresive compression algorithm for heavily updated indexes.

    ClearTrace

    Download page: ClearTraceRelease date: 2016-07-07Support Version: 2008/2012/2014/2016Author: Bill GrazianoFree version: YesPrice: No

    ClearTrace imports SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008, SQL Server 2005, SQL Server 2000 trail and Profiler files into SQL Server and displays summary performance information.

    Dell Security Explorer

    Download page: Dell Security ExplorerRelease date: 2015-06-25Support Version: 2008/2012/2014Author: DellFree version: NoPrice: $850

    This single toolset maximizes productivity through extensive automation, intuitive workflows and built-in expertise. Plus, it complements Microsoft tools by solving key SQL Server challenges, so you can proactively manage large numbers of databases. It moreover makes it smooth to manage change, resolve issues quickly and promote the highest levels of code quality, performance and maintainability.

    Dell LiteSpeed for SQL Server

    Download page: Dell Security ExplorerRelease date: 2015-07-31Support Version: 2008/2012/2014Author: DellFree version: NoPrice: ?

    Dramatically reduce backup and restore times and minimize storage costs while increasing the reliability of SQL Server data protection operations across the entire enterprise. Easily manage and monitor SQL Server protection while delivering a wide array of recovery capabilities. With LiteSpeed, a complete workbench of SQL Server recovery tools are at your fingertips so you can fetch data back online — fast.

    Dell Toad for SQL Server

    Download page: Dell Toad for SQL ServerRelease date: 2015-05-12Support Version: 2008/2008R2/2012/2014Author: DellFree version: NoPrice: ?

    Use a single console to manage access controls, permissions and security across Microsoft platforms that span multiple servers. Security Explorer provides an array of security enhancements, including the ability to identify who has rights to resources across the entire organization. You can moreover grant, revoke, clone, modify and overwrite permissions quickly and from a central location. Unlike autochthonous tools, Security Explorer provides the ability to back up and restore permissions only, ensuring the integrity of data. Security Explorer provides on-the-fly reports to succor meet auditing requirements.

    Dell Spotlight

    Download page: Dell SpotlightRelease date: 2016-03-10Support Version: 2008/2008R2/2012/2014Author: DellFree version: NoPrice: $2561

    When you can diagnose SQL Server performance issues quickly and accurately, ensuring a hale database infrastructure is not just possible, but easy. Spotlight on SQL Server Enterprise delivers simplicity without compromise by providing unmatched monitoring, diagnosis and optimization of your SQL Server environments, ensuring peak performance around the clock. With intuitive overviews of enterprise health and performance, automated alerts and actions, an integrated Xpert tuning module and mobile device support, Spotlight on SQL Server Enterprise makes it easier than ever to obtain the data you exigency to ensure the health of your SQL Server databases.

    Dell Foglight

    Download page: Dell FoglightRelease date: 2015-09-22Support Version: 2008/2008R2/2012/2014Author: DellFree version: NoPrice: ?

    Ensure optimal database performance with comprehensive database, storage and virtualization monitoring and advanced workload analytics. Foglight for Databases enables you to consolidate and standardize database performance management across your diverse multi-platform environments – even when you use autochthonous or third-party tools — to promote collaboration, better service levels and reduce costs. fetch a wealth of information at a fraction of the repercussion of conventional collection methods.

    Dell Discovery Wizard

    Download page: Dell FoglightRelease date: 2011-09-22Support Version: 2008/2008R2/2012/2014Author: DellFree version: YesPrice: No

  • Take inventory of your network databases, including data amounts
  • Choose the databases you want to consolidate
  • Review database history, including installation and creation dates
  • Find the SQL Server versions and service packs currently deployed
  • Identify names of servers, instances and operating systems
  • Learn the identity of your conclude users
  • Dell Enterprise Reporter

    Download page: Dell Enterprise ReporterRelease date: ?Support Version: 2008/2008R2/2012/2014Author: DellFree version: NoPrice: $511

    Dell Enterprise Reporter for SQL Server provides ad-hoc reporting for visibility database security configuration, including users and logins, roles and database permissions

    SQL Scripter

    Download page: SQL ScripterRelease date: 2013-02-24Support Version: ?Author: Thomas HinsenkampFree version: NoPrice: €99

    SQL Scripter is a powerful utensil for Microsoft SQL Server database administrators and developers to generate data scripts in a readable and executable T-SQL format.

    Simple Dynamic Scheduler

    Download page: Simple Dynamic SchedulerRelease date: 2016-05-02Support Version: 2008/2012/2014Author: Miljan RadovicFree version: YesPrice: No

    Simple Dynamic Scheduler is alternative scheduling utility which uses SQL Server to store complete configurations and logic.

  • Simple – smooth to manage (once you finish reading this page)
  • Dynamic – Not static
  • Purely T-SQL – says it all
  • Open source – Adoptable code to suit your traffic needs
  • Light-weight – Provides only conclusion machanism (Run or Hold) without actually executing anything
  • ApexSQL Audit

    Download page: ApexSQL AuditRelease date: 2017-07-11Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $1699

  • Audit complete SQL database and security activities
  • Meet compliance requirements e.g. HIPAA, PCI
  • Out-of-the-box and custom Win and Web reporting
  • Securely store audit data in a tamper-evident repository
  • Fully customize complete auditing, alerts, and reporting
  • Who, what, where, and when ilk auditing
  • Deploy on SQL Server Failover Clusters
  • Easily manage auditing on multiple servers
  • ApexSQL Backup

    Download page: ApexSQL BackupRelease date: 2017-10-12Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $499

  • Manage SQL backups across multiple servers
  • Configure SQL backup plans with advanced scheduling
  • Increase productivity with backup templates
  • Automatic SQL backup naming using variables
  • Restore to a point in time directly from timeline
  • Schedule and execute index maintenance tasks
  • Log shipping to multiple destinations
  • Cleanup SQL backup and restore history
  • ApexSQL Defrag

    Download page: ApexSQL DefragRelease date: 2017-06-29Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $499

  • Index fragmentation analysis
  • Index defragmentation
  • Custom policies: use custom policies to automate database index maintenance
  • Set thresholds for reorganizing and rebuilding jobs
  • ApexSQL Log

    Download page: ApexSQL LogRelease date: 2017-05-24Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $1999

  • Audit data, schema, and leave changes
  • Gain complete visibility into your transaction logs
  • Rollback or replay any database transaction
  • Forensically investigate who changed what and when
  • Implement before and after auditing
  • View a complete history of row changes
  • Reverse inadvertent or malicious database transactions
  • Avoid performance overhead and data storage
  • ApexSQL Monitor

    Download page: ApexSQL MonitorRelease date: 2017-10-05Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $499

  • Monitor multiple SQL Server instances
  • View system performance metrics
  • Identify performance issues and deadlocks
  • Use comprehensive dashboard for viewing metrics
  • Analyze query waits
  • Review query execution plans
  • Calculate baselines and thresholds
  • Visualize data with logarithmic scaling
  • ApexSQL Plan

    Download page: ApexSQL PlanRelease date: 2018-04-05Support Version: 2008-2017Author: ApexSQLFree version: YesPrice: No

  • Analyze and optimize SQL query execution plans
  • Identify query performance issues and deadlocks
  • Understand query performance characteristics
  • Analyze query waits & review query execution plans
  • Customize graphical query execution map view
  • See the actual relative cost of each map operator
  • Analyze query live performance statistics
  • Compare estimated and actual query execution plans
  • ApexSQL Propagate

    Download page: ApexSQL PropagateRelease date: 2017-09-25Support Version: 2008-2017Author: ApexSQLFree version: YesPrice: No

  • Execute scripts on saved list of servers/databases
  • Parse SQL scripts prior to execution
  • Create SQL scripts directly in the application
  • Manage lists of SQL scripts and SQL databases
  • Set order of SQL scripts execution
  • Export execution results into TXT or CSV file
  • Preview exaction results by databases or by scripts
  • Edit SQL scripts in a built-in IDE prior to execution
  • ApexSQL Build

    Download page: ApexSQL BuildRelease date: 2017-05-15Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $399

  • Create executable installation packages
  • Deploy databases directly from SQL source control
  • Consolidate multiple SQL scripts
  • Build databases from scripts, source control, etc
  • Ensure error free deployments
  • Preview the script repercussion by action or SQL object
  • ApexSQL Clean

    Download page: ApexSQL CleanRelease date: 2017-09-28Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $399

  • View and dissect SQL and client code dependencies
  • Perform repercussion analysis on potential changes
  • Remove unwanted objects risk free
  • Map dependencies down to the column level
  • Analyze external databases for dependencies
  • View kick dependencies graphically
  • Design the appearance of the dependency diagram
  • Create and export reports from kick dependencies
  • ApexSQL Data Diff

    Download page: ApexSQL Data DiffRelease date: 2017-10-03Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $599

  • Compare data in live DBs, backups and SC projects
  • Perform row plane recovery without restoring
  • Community, Standard, and Professional editions
  • Compare huge databases quickly and without errors
  • Automate and schedule data migrations
  • Initiate database compares directly from SSMS
  • Export results to HTML, CSV and Excel
  • Create executable installation packages
  • Integrate with complete common SC systems e.g. Git, SVN
  • Deploy data changes directly from a source control label
  • ApexSQL Decrypt

    Download page: ApexSQL DecryptRelease date: 2017-08-16Support Version: 2008-2017Author: ApexSQLFree version: YesPrice: No

  • Decrypt SQL procedures, functions, triggers and views
  • Initiate decryption directly from SSMS
  • Decrypt objects with a single click
  • Filter encrypted objects
  • View original DDL script
  • Export encrypted objects into a SQL script
  • Decrypt databases from multiple servers
  • Decrypt wizard with built-in IDE
  • ApexSQL Diff

    Download page: ApexSQL DiffRelease date: 2017-10-26Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $599

  • Compare live DBs, backups, scripts and SC projects
  • Deploy a database directly from source control
  • Integrate with complete common SC systems e.g. Git, SVN
  • Automate and schedule database synchronizations
  • Initiate database compares directly from SSMS
  • Report results to HTML, XML and Excel
  • Create executable .NET packages
  • ApexSQL Doc

    Download page: ApexSQL DocRelease date: 2017-09-06Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $699

  • Document SQL Server databases and SSIS packages
  • Generate documentation in CHM, HTML, Word and PDF
  • Automate and schedule the documenting process
  • Display graphical relationship diagrams
  • Document SSAS Multidimensional and Tabular models
  • Document SSIS Control flood and Data flood diagrams
  • Fully customize the documentation output
  • Include Data model diagrams
  • ApexSQL Generate

    Download page: ApexSQL GenerateRelease date: 2017-07-13Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $499

  • Generate SQL test data for specified tables
  • Export test data to SQL, XML, CSV, JSON, Excel
  • Generate millions of rows quickly
  • Customize test data map with detailed options
  • Support a complete range of SQL data types
  • Choose from multiple generators (Random List etc)
  • Retain data consistency with alien key support
  • Emulate real-world test data
  • ApexSQL Script

    Download page: ApexSQL ScriptRelease date: 2017-05-08Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $399

  • Script both SQL database objects and data
  • Create executable .NET packages
  • Script objects directly to Source Control
  • Automate SQL database scripting and migrations
  • Integrate with common source control systems
  • Script an entire server down to individual columns
  • Save customized scripting profiles as projects
  • Easily decrypt some/all encrypted database objects
  • ApexSQL Trigger

    Download page: ApexSQL TriggerRelease date: 2017-06-01Support Version: 2008/2012/2014/2016Author: ApexSQLFree version: NoPrice: $1299

  • Track data / DML changes in SQL Server databases
  • Integrate royalty free auditing into your apps
  • Translate data into information with lookups
  • Create reports and exports from audited data
  • Customize trigger templates with a built-in IDE
  • Add additional data to audit trail with watches
  • Track schema / DDL changes in audited database
  • Audit who, what, and when for complete changes
  • ApexSQL Trigger Viewer

    Download page: ApexSQL Trigger ViewerRelease date: 2017-06-01Support Version: 2008-2017Author: ApexSQLFree version: YesPrice: No

    Read-only auditing reports for conclude users

    ApexSQL Snapshot Utility

    Download page: ApexSQL Snapshot UtilityRelease date: 2016-01-12Support Version: 2008/2012/2014/2016Author: ApexSQLFree version: YesPrice: No

    Utility to create a lightweight 'snapshot' of a database schema, that can exist used by ApexSQL Diff as a datasource

    ApexSQL Model

    Download page: ApexSQL ModelRelease date: 2018-10-10Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $399

    Create database model diagrams and synchronize changes with existing databases.

  • Forward and reverse engineer
  • Customize the appearance of models
  • Create new or modify existing kick groups
  • Navigate through model history
  • Export database models as imagesCustomize print output
  • ApexSQL Analyze

    Download page: ApexSQL AnalyzeRelease date: 2017-12-13Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $299

    Database dependency analysis

  • View and dissect SQL dependencies
  • Customize the appearance of dependency diagrams
  • Map dependencies down to the column level
  • Visualize kick dependencies graphically
  • Export diagrams as image files
  • Perform repercussion analysis on potential kick deletions
  • ApexSQL BI Monitor

    Download page: ApexSQL BI MonitorRelease date: 2018-09-18Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $499

  • Monitor SSAS, SSIS and SSRS performance
  • Add custom performance counters
  • Track system performanceUse baselines to customize alert thresholds
  • View real-time and historical data
  • Set up various alert actions for each counter
  • Generate built-in and custom reportsTrack user activity
  • ApexSQL VM Monitor

    Download page: ApexSQL VM MonitorRelease date: 2018-05-09Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $999

    Virtualization performance monitoring

  • Monitor multiple hypervisors – Hyper-V and ESXi
  • View system performance metrics of monitored hosts
  • Monitor virtual machines performance
  • Monitor performance of host devices
  • Use comprehensive dashboards for viewing metrics
  • Calculate baselines and thresholds
  • View top 5 loaded virtual machines for specific hosts
  • Create and export comprehensive performance reports
  • ApexSQL VM Job

    Download page: ApexSQL JobRelease date: 2018-03-29Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $499

  • Manage SQL Server Agent jobs across multiple servers
  • Get a detailed job history overview
  • Manage SQL Server services on managed servers
  • Export job details to PDF, HTML, XML or CSV format
  • Manage SQL Server schedulesControl the status of SQL Server Agent services
  • Define and manage SQL Server alertsMonitor SQL Server Agent logs
  • ApexSQL Enforce

    Download page: ApexSQL EnforceRelease date: 2018-07-19Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $299

  • Review databases and individual SQL scripts
  • Import and export rulesProcess unattended via the CLI
  • Seamlessly integrate into your CI/CD processLeverage a library of 100+ pre-written rules
  • Create custom rules with a built in IDE
  • Write custom rules in C# or VB.NETCreate HTML reports and XML exports
  • Integrate with SSMS and Visual Studio
  • Generate SQL to fix violations
  • DBBest T-SQL Analyzer

    Download page: DBBest T-SQL AnalyzerRelease date: 2015-03-13Support Version: 2008/2012/2014Author: DBBestFree version: NoPrice: $89

    T-SQL Analyzer is a code analyzing utensil for finding problematic spots in your Transact-SQL code in SQL Server. The utensil analyzes stored procedures and user-defined functions in your SQL Server database against a predefined set of best drill rules.

    DBBest Database Compare Suite

    Download page: DBBest Database Compare SuiteRelease date: 2015-09-04Support Version: 2008/2012/2014/2016Author: DBBestFree version: NoPrice: $349

    Comparing two production databases for migrating or upgrading

    Advanced Query Tool

    Download page: Advanced Query ToolRelease date: 2015-03-18Support Version: 2008/2012/2014/2016Author: DBBestFree version: NoPrice: $180

    AQT provides a simple and easy-to-use interface to your many different databases: Oracle, DB2 for LUW, DB2 for z/OS, DB2 for iSeries, Sybase ASE, SQL Server, Informix, MySQL, MS Access, SQLite, Other.

    SqlDiffFramework

    Download page: SqlDiffFrameworkRelease date: 2012-04-17Support Version: 2008/2012/2014/2016Author: Michael SorensFree version: YesPrice: No

    SqlDiffFramework compares two data sources and highlights both row and column differences for just the columns you want.

  • Compare the identical data over time (either current data vs. prior data or two snapshots of prior data)
  • Compare the identical data on two different servers
  • Compare data from different systems (e.g. SQL Server vs. Oracle)
  • Verify two systems absorb synchronized data
  • DataGrip

    Download page: DataGripRelease date: 2018-02-21Support Version: 2008-2017Author: Jet BrainsFree version: NoPrice: $89

  • Exploring your databases
  • Intelligent coding assistance
  • Executing queries
  • Among other things, DataGrip comes with user parameters support, CSV editor, diagram builder, version control advocate and many other features
  • Pssdiag and Sqldiag Manager

    Download page: Pssdiag and Sqldiag ManagerRelease date: 2015-04-17Support Version: 2012/2014Author: Jack LiFree version: YesPrice: No

    PSSDIAG is a diagnostics utility used to collect profiler trace, perfmon data for SQL Server. PSSDAIG was created to troubleshoot SQL Server 7.0 and 2000 issues. It was evolved and shipped with SQL Server 2005 and beyond. But the shipped product only has a data collector engine called sqldiag.exe. Microsoft Product advocate continues to maintain a configuration utensil that allows engineers to dynamically configure on what to collect.

    SQL Nexus Tool

    Download page: SQL Nexus ToolRelease date: 2016-11-20Support Version: 2008/2012/2014/2016Author: Jack LiFree version: YesPrice: No

    SQL Nexus is a utensil that helps you identify the root reason of SQL Server performance issues. It loads and analyzes performance data collected by SQLDiag and PSSDiag and Sqldiag Manager. It can dramatically reduce the amount of time you spend manually analyzing data

  • Fast, smooth data loading: You can quickly and easily load SQL trail files;
  • Visualize loaded data via reports
  • Executing queries
  • Among other things, DataGrip comes with user parameters support, CSV editor, diagram builder, version control advocate and many other features
  • DBSophic Qure Profiler

    Download page: DBSophic Qure ProfilerRelease date: ?Support Version: 2008/2012Author: DBSophicFree version: NoPrice: $300

    SQL server trail analysis tool

  • View SQL activity in real-time
  • Group, sort and export batches
  • Real time index recommendations
  • Compare SQL traces
  • No limitations on the number of SQL servers, databases, processors etc.
  • DBSophic Qure Optimizer

    Download page: DBSophic Qure OptimizerRelease date: ?Support Version: 2008/2012Author: DBSophicFree version: NoPrice: ?

    The workload tuning solution that automatically optimizes millions of queries in one go

    RestoreChecker

    Download page: RestoreCheckerRelease date: 2015-01-15Support Version: ?Author: SQLServerUtilitiesFree version: NoPrice: $99

    RestoreChecker is a utility that restores SQL Server backup files in order to verify that the backup files can exist successfully restored and in addition fulfill data integrity checks on the backups restored while offloading the intensive IO activity from your production servers.

    SQLScripter

    Download page: SQLScripterRelease date: 2009-08-24Support Version: ?Author: SQLServerUtilitiesFree version: NoPrice: $99

    SQLScripter is a powerful command line utility that scripts SQL Server objects. The utility is designed to automate the process of schema generation.

    SQLC

    Download page: SQLCRelease date: 2017-11-19Support Version: ?Author: David IngletonFree version: YesPrice: No

    SQLC is a software utensil for comparing two SQL Server databases. With SQLC you can fulfill kick comparison (Database schema) as well as Data comparison (Table data)

    Database Performance Analyzer

    Download page: Database Performance AnalyzerRelease date: ?Support Version: 2008-2017/Azure/AmazonAuthor: SolarWindsFree version: NoPrice: $1995

    Monitor across your entire environment: physical servers, virtualized, and in the Cloud

    Database Performance Analyzer for MSSQL

    Download page: Database Performance Analyzer for MSSQLRelease date: ?Support Version: 2008-2017/Azure/AmazonAuthor: SolarWindsFree version: NoPrice: $1995

    Optimize and tune SQL Server deployed anywhere – physical, virtual, or cloud based. Includes Azure SQL database, Azure virtual machines, and Amazon RDS.

    SQL Enlight

    Download page: SQL EnlightRelease date: 2016-04-25Support Version: 2005/2008/2008R2/2012/2014Author: UbitSoftFree version: NoPrice: $295

  • Advanced static analysis
  • T-SQL code formatting
  • Statements history
  • Validate T-SQL code for syntax errors
  • Script Summary
  • Refactoring
  • Continuous integration support
  • Aireforge Studio

    Download page: Aireforge StudioRelease date: 2017-06-21Support Version: 2008/2012/2014/2016/AzureAuthor: AireForgeFree version: YesPrice: $299

    Aireforge Studio contains a growing suite of tools that succor administrators to stabilize, optimize & secure multiple database instances with ease. exist it, keeping two instances in sync for recovery purposes or synchronizing the settings of over 200 replication subscribers; their tools will help.

    HexaTier

    Download page: HexaTierRelease date: ?Support Version: ?Author: HexaTierFree version: NoPrice: ?

    Providing an all-in-one solution to protect your data from internal and external attacks with four key elements, including: Database Security, Discovery of Sensitive Data. Dynamic Data Masking, and Database Activity Monitoring to comply with regulatory requirements.

    SoftTree SQL Assistant

    Download page: SoftTree SQL AssistantRelease date: 2017-12-17Support Version: 2005/2008/2008R2/2012/2014/2016/2017Author: SoftTreeFree version: NoPrice: $215

  • Triples SQL developer productivity
  • Improves code character and accuracy
  • Provides unmatched intelligent SQL code intellisense features
  • Provides interactive SQL reference and SQL code assistance systems
  • Provides advanced SQL code formatters and beautifiers; SQL syntax validation, code structure views for speedy code navigation, and more…
  • Download page: DB Audit and Security 360Release date: 2015-02-07Support Version: 2005/2008/2008R2/2012/2014/2016Author: SoftTreeFree version: NoPrice: $499

    DB Audit and Security 360 is a professional all-in-one database security and auditing solution for Oracle, Sybase, DB2, MySQL and Microsoft SQL Server. DB Audit and Security 360 enables database and system administrators, security administrators, auditors and operators to track and dissect any database activity including database security, access and usage, data creation, change or deletion. What makes this solution really unique is its built-in advocate for multiple auditing methods giving you the flexibility to elect the best meet for your database security requirements.

    EMS SQL Management Studio

    Download page: EMS SQL Management StudioRelease date: 2016-05-26Support Version: 2000/2005/2008/2008R2/2012/2014Author: EMSFree version: NoPrice: $257

    EMS SQL Management Studio for SQL Server is a complete solution for Microsoft SQL Server database administration and development. With components that focus on complete censorious MS SQL Server database management tasks, SQL Studio is a single workbench that provides you with must-have tools for administering SQL Server databases, managing database schema and objects as well as for SQL Server database design, migration, extraction, SQL Server query building, data import, export and database comparison. SQL Studio unites these database tools for MSSQL Server in one powerful and easy-to-use environment that can toil round the clock. Whether you are a database or application developer, DBA or traffic analyst, SQL Studio for SQL Server offers complete essential SQL Server tools to Make you more productive than ever before!

    EMS SQL Backup

    Download page: EMS SQL BackupRelease date: 2016-04-13Support Version: 2000/2005/2008/2008R2/2012/2014Author: EMSFree version: YesPrice: $82

    EMS SQL Backup for SQL Server is an efficient utensil for automating backup, restore and log shipping tasks on complete SQL Servers in your company. In addition, SQL Backup allows you to update statistics, fulfill re-indexing, truncate database, check database integrity and fulfill many other tasks that can exist united into policies and deployed to SQL Servers in a few clicks. SQL Backup monitors the maintenance stint execution, quickly investigates and resolves issues.

    EMS SQL Administrator

    Download page: EMS SQL AdministratorRelease date: 2015-04-14Support Version: 2000/2005/2008/2008R2/2012/2014Author: EMSFree version: YesPrice: $135

    EMS SQL Administrator for SQL Server is a toolset for efficient SQL Server administration. It provides a complete and easy-to-use set of tools for administering SQL Server. SQL Administrator is designed specifically for database administrators and allows you to fulfill administrative tasks in the fastest, easiest and most efficient way.

    EMS SQL Manager

    Download page: EMS SQL ManagerRelease date: 2016-05-26Support Version: 2000/2005/2008/2008R2/2012/2014Author: EMSFree version: YesPrice: $135

    EMS SQL Manager for SQL Server is a elevated performance graphical utensil for Microsoft SQL Server database development and administration. It makes creating and editing MS SQL Server database objects smooth and fast, and allows you to accelerate SQL scripts, manage SQL server users and their privileges, build SQL queries visually, toil with metadata, export and import SQL Server database data and much more.

    EMS Data Export

    Download page: EMS Data ExportRelease date: 2016-04-29Support Version: –Author: EMSFree version: NoPrice: $47

    EMS Data Export for SQL Server is a powerful utensil to export SQL Server database data quickly to any of 20 available formats, including MS Access, MS Excel, MS Word, RTF, HTML, TXT, ODF and more. Data Export for SQL Server has a friendly wizard, which allows you to set various options of SQL Server export process visually and a command-line utility to automate your SQL Server export jobs using the configuration file.

    EMS Data Import

    Download page: EMS Data ImportRelease date: 2016-04-14Support Version: –Author: EMSFree version: No Price: $47

    EMS Data Import for SQL Server is a powerful utensil to import data to SQL Server tables from MS outdo 97-2007, MS Access, DBF, TXT, CSV, MS Word, RTF, ODF and HTML files. This utility allows you to quickly import data to one or several SQL Server tables or views at once, reclaim complete SQL Server import parameters set on current wizard session, use special batch insert mode to import SQL Server data at the maximum possible accelerate and much more.

    EMS Data Pump

    Download page: EMS Data PumpRelease date: 2016-11-03Support Version: –Author: EMSFree version: NoPrice: $47

    EMS Data Pump for SQL Server is an excellent migration utensil for converting databases and importing table data from an ADO-compatible source (e.g. MS Access, MySQL or any other database with ADO support) to SQL Server databases. Database conversion and migration become as smooth as possible with Data Pump for SQL Server!

    EMS Data Generator

    Download page: EMS Data GeneratorRelease date: 2010-07-10Support Version: –Author: EMSFree version: NoPrice: $47

    EMS Data Generator for SQL Server is an impressive utensil for generating test data to SQL Server database tables. The utility can succor you to simulate the database production environment and allows you to populate several SQL Server database tables with test data simultaneously, define tables for generating data, set value ranges, control a wide variety of generation parameters for each territory ilk and much more. It has plenty of powerful functionalities to generate SQL Server test data in a simple and direct way.

    EMS DB Comparer

    Download page: EMS DB ComparerRelease date: 2015-07-24Support Version: –Author: EMSFree version: NoPrice: $47

    EMS DB Comparer for SQL Server is an excellent utensil for comparing SQL Server database schemas and discovering differences in their structures. You can view complete the differences in compared database objects and execute an automatically generated script to synchronize structure of SQL Server databases and eliminate these differences. Define comparison parameters and many other features Make your toil with their utensil for SQL Server database synchronization smooth and fast.

    EMS DB Extract

    Download page: EMS DB ExtractRelease date: 2008-10-16Support Version: –Author: EMSFree version: NoPrice: $47

    EMS DB Extract for SQL Server is an impressive and easy-to-use utensil for creating SQL Server database backups in a profile of SQL scripts. This database script utility allows you to reclaim metadata of complete SQL Server database objects as well as SQL Server table data as database snapshots. supple customization of the extract process enables you to select objects and data tables for SQL Server database dump and tune many other extract options.

    EMS SQL Query

    Download page: EMS SQL QueryRelease date: 2012-03-29Support Version: –Author: EMSFree version: NoPrice: $47

    EMS SQL Query for SQL Server is a useful utensil that lets you quickly and simply build SQL queries to SQL Server databases. Visual SQL Server query building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to SQL Server databases, select tables and fields for a query to SQL Server, set the selection criteria and many more.

    EMS Data Comparer

    Download page: EMS Data ComparerRelease date: 2012-11-16Support Version: –Author: EMSFree version: NoPrice: $47

    EMS Data Comparer for SQL Server is a powerful and easy-to-use utensil for SQL Server data comparison and synchronization. Using this utility you can view complete the differences in compared SQL Server tables and execute an automatically generated script to eliminate these differences. Data Comparer for SQL Server provides a wide range of configuration parameters for speedy and efficient data comparison and synchronization of SQL Server databases.

    NitroAccelerator

    Download page: NitroAcceleratorRelease date: 2016-07-10Support Version: 2008/2012/2014/2016Author: NitrosphereFree version: NoPrice: $1265

    Accelerates and Secures SQL Server network traffic resulting in orders of magnitude performance improvement while securing the data across the network.

    ERwin Data Modeler

    Download page: ERwin Data ModelerRelease date: 2016-06-03Support Version: 2008/2012/2014/2016Author: ERwinFree version: NoPrice: $810

    ERwin Data Modeler is an industry-leading data modeling solution that provides a simple, visual interface to manage your knotty data environment

    Toad Data Modeler

    Download page: Toad Data ModelerRelease date: 2016-06-16Support Version: 2008/2012/2014Author: DellFree version: NoPrice: $562

    Easily create high-quality data models. Toad Data Modeler enables you to rapidly deploy accurate changes to data structures across more than 20 different platforms. It allows you to construct analytic and physical data models, compare and synchronize models, quickly generate knotty SQL/DDL, create and modify scripts, as well as reverse and forward engineer both databases and data warehouse systems

    SQL Power Architect

    Download page: SQL Power ArchitectRelease date: 2016-02-11Support Version: 2008/2012/2014Author: SQLPowerFree version: YesPrice: $995

    The SQL Power Architect data modeling utensil was created by data warehouse designers and has many unique features geared specifically for the data warehouse architect. It allows users to reverse-engineer existing databases, fulfill data profiling on source databases, and auto-generate ETL metadata.

    DbWrench

    Download page: DbWrenchRelease date: 2016-07-06Support Version: 2008/2012/2014Author: Nizana SystemsFree version: NoPrice: $99

  • makes creating and modifying databases quicker and easier
  • streamlines many common database tasks
  • supports many operating systems and databases in a single license
  • Navicat Data Modeler

    Download page: Navicat Data ModelerRelease date: 2016-08-01Support Version: 2008/2012/2014/2016Author: PremiumSoftFree version: NoPrice: $199

    Navicat Data Modeler is a powerful and cost-effective database design utensil which helps you build high-quality conceptual, analytic and physical data models. It allows you to visually design database structures, fulfill reverse/forward engineering processes, import models from ODBC data sources, generate knotty SQL/DDL, print models to files, and much more.

    DeZign for Databases

    Download page: DeZign for DatabasesRelease date: 2016-04-25Support Version: 2008/2012/2014Author: DatanamicFree version: NoPrice: $259

    DeZign for Databases is an intuitive database design and modeling utensil for developers and DBA's that can succor you model, create and maintain databases. The software uses entity relationship diagrams (ERDs, data models) to graphically design databases and automatically generates the most common SQL and desktop database.

    ERDesigner NG

    Download page: ERDesigner NGRelease date: 2013-04-10Support Version: 2008/2012/2014Author: Mirko SerticFree version: Open SourcePrice: No

    The Mogwai ERDesigner is an entity relationship modeling/design tool(ERD) such as ERWin and co. The only dissimilarity is that it is Open Source and does not cost anything. It was designed to Make database modeling as smooth as it can exist and to advocate the developer in the total development process, from database design to schema and code generation.

    Vertabelo

    Download page: VertabeloRelease date: ?Support Version: 2012Author: VertabeloFree version: NoPrice: $948

    Design your database online but very expensive

    dbDiffo

    Download page: dbDiffoRelease date: ?Support Version: ?Author: Contenet LtdFree version: YesPrice: No

    dbDiffo – The free online database schema designer

    SQL DXP

    Download page: SQL DXPRelease date: 2016-06-20Support Version: 2008/2012/2014/AzureAuthor: SQL DelteFree version: NoPrice: $530

    SQL DXP compares databases on different server platforms and can generate scripts to Make the source database generally the identical as the target database regardless of platform.

    Aqua Data Studio

    Download page: Aqua Data StudioRelease date: 2016-07-06Support Version: 2008/2012/2014Author: AquaFoldFree version: NoPrice: $499

    Aqua Data Studio is productivity software for Database Developers, DBAs, and Analysts. It allows you to develop, access, manage, and visually dissect data. Whether you are working with relational, nosql or cloud databases, your data is easily and quickly accessible with Aqua Data Studio. It supports complete major database vendors, works on complete major operating systems and is localized to 9 languages.

    RazorSQL

    Download page: RazorSQLRelease date: 2016-09-29Support Version: 2008/2012/2014/2016Author: Richardson SoftwareFree version: NoPrice: $100

    The MS SQL Server database query utensil features provided by RazorSQL comprise a custom MS SQL Server database browser tailored to SQL Server, a Transact-SQL SQL editor with Transact SQL and SQL Server specific features and syntax highlighting, custom SQL Server visual tools, and SQL Server specific database administration tools.

    SQL Pretty Printer

    Download page: SQL Pretty PrinterRelease date: 2016-02-19Support Version: 2008/2012/2014/2016Author: Gudu SoftwareFree version: NoPrice: $50

    SQL Pretty Printer Desktop Version allows you to format your SQL wherever you are regardless of your Internet connection. It generates various output formats, including text, colorful html (Used in web, blog, wiki, forums) and RTF. Batch mode enables you to immaculate up SQL in multifiles under a nested directory. While sitting in the tray, you can format SQL in any editor dote Microsoft Query Analyzer, UltraEditor or notepad with just one hotkey.

    Database .NET

    Download page: Database .NETRelease date: 2018-08-20Support Version: 2008-2017Author: fish's dotNETFree version: Non-commercialPrice: $69

    Database .NET is an innovative, powerful and intuitive multiple database management tool. You can browse/grant objects, design tables, edit rows, accelerate queries, generate scripts, analyze/monitor SQL and import/export/migrate/sync data with a consistent interface.

    dbMigration .NET

    Download page: dbMigration .NETRelease date: 2018-08-20Support Version: 2008-2017Author: fish's dotNETFree version: Non-commercialPrice: $49

    dbMigration .NET is a simple, smooth and intuitive multiple database migration and sync tool. With it you can easily migrate schema and data between different databases without complicated procedures.

    Is It SQL

    Download page: Is It SQLRelease date: 2017-04-06Support Version: 2005/2008/2012/2014/2016Author: Bill GrazianoFree version: Non-commercialPrice: No

  • Supports SQL Server 2005 through SQL Server 2016
  • Monitor CPU usage for SQL Server and non-SQL Server tasks
  • Capture batch requests per second
  • Monitor Disk I/onsite
  • Monitor waits
  • Show actively running queries
  • Capture basic demographic information including version, start time, database sizes, etc.
  • Can accelerate with no installation or it can exist accelerate as a service
  • Database Experimentation aide Technical Preview 2

    Download page: Database Experimentation AssistantRelease date: 2017-03-24Support Version: 2005/2008/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    Database Experimentation aide is the new A/B testing solution for SQL Server upgrades, enables customers to congregate performance insights for upgrades by conducting experiments across two SQL Server versions using production workloads enabling customers to conduct experiments on database workloads across two versions of SQL Server.

    Data Platform Studio

    Download page: Data Platform StudioRelease date: ?Support Version: SQL Server, SQL AzureAuthor: Red Gate SoftwareFree version: YesPrice: ?

    Simplify the process of migrating data from your on-premise SQL Server to Azure SQL Data Warehouse with the Data Platform Studio importer. Automatically, and in far less time than it takes to wield migrations manually, it:

  • Makes schema compatibility fixes to prepare your Azure SQL Data Warehouse for your database
  • Compresses your data so it uploads to Azure efficiently
  • Utilizes the MPP power of Azure SQL Data Warehouse to ingest the data quickly
  • Flyway

    Download page: Data Platform StudioRelease date: 2018-01-30Support Version: Oracle, SQL Server, SQL Azure, MySQL, OtherAuthor: boxfuseFree version: Open SourcePrice: $950

    Flyway is an open-source database migration tool. It strongly favors simplicity and convention over configuration. It is based around just 6 basic commands: Migrate, Clean, Info, Validate, Baseline and Repair. Migrations can exist written in SQL (database-specific syntax (such as PL/SQL, T-SQL, …) is supported) or Java (for advanced data transformations or dealing with LOBs). It has a Command-line client. If you are on the JVM, they recommend using the Java API (also works on Android) for migrating the database on application startup. Alternatively, you can moreover use the Maven plugin, Gradle plugin, SBT plugin or the Ant tasks.

    Liquibase

    Download page: LiquibaseRelease date: 2018-04-11Support Version: Oracle, PostgreSQL, MySQL, OtherAuthor: LiquibaseFree version: Open SourcePrice: No

    Liquibase is an open source database-independent library for tracking, managing and applying database schema changes. It was started in 2006 to allow easier tracking of database changes, especially in an agile software development environment.

    All changes to the database are stored in text files (XML, YAML, JSON or SQL) and identified by a combination of an "id" and "author" tag as well as the name of the file itself. A list of complete applied changes is stored in each database which is consulted on complete database updates to determine what new changes exigency to exist applied. As a result, there is no database version number but this approach allows it to toil in environments with multiple developers and code branches. Liquibase automatically creates DatabaseChangeLog Table and DatabaseChangeLogLock Table when you first execute a changeLog File.

    My Batis

    Download page: My BatisRelease date: 2018-03-20Support Version: Oracle, PostgreSQL, MySQL, OtherAuthor: My BatisFree version: Open SourcePrice: No

    MyBatis Schema Migration System (or MyBatis Migrations for short) seeks to:

  • Work with any database, new or existing
  • Leverage the source control system (e.g. Subversion)
  • Enable concurrent developers or teams to toil independently
  • Allow conflicts very visible and easily manageable
  • Allow for forward and backward migration (evolve, devolve respectively)
  • Make the current status of the database easily accessible and comprehensible
  • Enable migrations despite access privileges or bureaucracy
  • Work with any methodology
  • Encourages good, consistent practices
  • SentryOne map Explorer

    Download page: SentryOne map ExplorerRelease date: 2017-05-25Support Version: 2008-2017Author: SentryOneFree version: YesPrice: No

  • Index Analysis: learn a new, smooth route to gauge the repercussion of potential index changes.
  • Statistics Analysis with Histogram
  • Query Performance Profiling and Playback
  • Actual map Recosting
  • Plan Diagram
  • Management Studio Add-In
  • Tuning History and Comments
  • Multiple Documents
  • SQL Sentry

    Download page: SQL SentryRelease date: 2016-12-07Support Version: ?Author: SentryOneFree version: NoPrice: ?

    Get the most complete coverage for SQL Server and Windows. Simplify performance tuning by visualizing where problems exist for faster resolution. Streamline your defragmentation process and query tuning complete in one place. They absorb combined complete the worthy SQL Sentry tools into a single unified solution to succor you monitor and optimize the Microsoft data platform. Everything you exigency for: SQL Server and Windows Performance Monitoring, Event Management, Index Defragmentation and Query map Analysis, with Desktop, Web, and Mobile UIs.

    dbMonitor

    Download page: dbMonitorRelease date: 2012-11-01Support Version: ?Author: DevartFree version: YesPrice: No

    To extend monitoring capabilities of their data access products there is an additional utensil called dbMonitor. It is easy-to-use utensil to provide visual monitoring of your database applications. dbMonitor performs per-component tracing of database events such as commit, rollback, SQL statement execute, creating and destroying components, connection pooling events etc.

    DBmaestro TeamWork

    Download page: DBmaestro TeamWorkRelease date: ?Support Version: ?Author: DBmaestroFree version: NoPrice: ?

    DBmaestro is bringing the agility of Automation and DevOps, with an innovative solution for evolutionary database development, safe build automation, and failsafe continuous delivery in any environment.

  • Database Release Automation
  • Database Merge and Build Automation
  • Database Enforced Source Control
  • Database Enhanced Security and Regulatory Compliance
  • xSQL Schema Compare

    Download page: xSQL Schema CompareRelease date: 2017-03-01Support Version: 2005/2008/2012/2014/2016, AzureAuthor: xSQL SoftwareFree version: YesPrice: $399

    Compare the schemas of two SQL Server databases, review differences, generate synchronization script and execute it.

    xSQL Data Compare

    Download page: xSQL Data CompareRelease date: 2017-06-26Support Version: 2005/2008/2012/2014/2016, AzureAuthor: xSQL SoftwareFree version: YesPrice: $399

    Data Compare for SQL Server is a utensil for comparing and synchronizing the data in two SQL Server databases. You can use it for data migration, auditing, replication verification, populating development databases with production data etc.

    xSQL Script Executor

    Download page: xSQL Script ExecutorRelease date: 2015-02-25Support Version: 2000 and higherAuthor: xSQL SoftwareFree version: YesPrice: $249

    Script Executor is a professional grade database utensil that allows you to deploy multiple Sql scripts on one or more target servers with a click of a button. Scripts can exist deployed directly from the GUI, from the command line or they can exist wrapped into an executable.

    xSQL Builder

    Download page: xSQL BuilderRelease date: 2017-03-15Support Version: 2005/2008/2012/2014/2016, AzureAuthor: xSQL SoftwareFree version: NoPrice: $799

    xSQL Builder is a SQL Server utensil that allows for automating the deployment of SQL Server based solutions. It generates executable packages that hold complete the information and logic required to deploy the database to the clients' environments regardless of whether it is a first time deployment or an upgrade from a previous version.

    xSQL Documenter

    Download page: xSQL DocumenterRelease date: 2017-01-04Support Version: 2000 to 2016Author: xSQL SoftwareFree version: NoPrice: $199

    Comprehensive, uniform, and easily navigable database documentation in HTML and compiled CHM format.

    xSQL Profiler

    Download page: xSQL ProfilerRelease date: 2017-06-28Support Version: 2005/2008/2012/2014/2016, AzureAuthor: xSQL SoftwareFree version: YesPrice: $999

    xSQL Profiler is a SQL tracing utensil that provides for monitoring multiple SQL Servers from one central location. Traces can exist customized and scheduled to accelerate on inevitable servers at inevitable times and complete trail data is automatically collected into the central repository.

    xSQL Schema Compare SDK

    Download page: xSQL Schema Compare SDKRelease date: 2017-10-25Support Version: 2000 to 2016Author: xSQL SoftwareFree version: NoPrice: $1499

    Schema Compare SDK is a set of class libraries that allows you to fulfill schema comparison and synchronization for SQL Server databases in your .NET or ASP.NET applications.

    xSQL RSS Reporter

    Download page: xSQL RSS ReporterRelease date: 2014-11-25Support Version: 2005/2008/2012/2014Author: xSQL SoftwareFree version: NoPrice: $169

    RSS Reporter is a utensil that generates standard Atom or RSS feeds for:

  • SQL Server job execution history
  • SQL Server job definition
  • The output of any T-SQL query
  • Database size and space usage
  • xSQL Database Searcher

    Download page: xSQL Database SearcherRelease date: 2017-05-09Support Version: 2005/2008/2012/2014/2016, AzureAuthor: xSQL SoftwareFree version: YesPrice: No

    Database Searcher, previously known as "xSQL kick Search", is a free utensil that allows you to search the schema of SQL Server databases.

    Cloud-based DB Monitoring Platform

    Download page: Cloud-based DB Monitoring PlatformRelease date: ?Support Version: ?Author: SQLTreeoFree version: NoPrice: €180

  • Charts-on-charts technology, 24/7/365.
  • Alerting via Windows, Android and iOS.
  • Drill down into detailed history charts.
  • Send instant messages within your secured network.
  • SchemaCrawler

    Download page: SchemaCrawlerRelease date: 2017-02-27Support Version: Oracle, PostgreSQL, MySQL, OtherAuthor: Sualeh FatehiFree version: Open SourcePrice: No

    SchemaCrawler is a free database schema discovery and comprehension tool. SchemaCrawler has a pleasurable mix of useful features for data governance. You can search for database schema objects using regular expressions, and output the schema and data in a readable text format. The output serves for database documentation, and is designed to exist diff-ed against other database schemas. SchemaCrawler moreover generates schema diagrams. You can execute scripts in any standard scripting language against your database. You can find potential schema design issues with lint. SchemaCrawler supports almost any database that has a JDBC driver, but for convenience is bundled with drivers for some commonly used RDBMS systems. SchemaCrawler works with any operating system that supports Java SE 8, Compact Profile 2 or better.

    SA MaaS Microsoft SQL Server

    Download page: SA MaaS Microsoft SQL ServerRelease date: ?Support Version: ?Author: SENTINELAGENTFree version: NoPrice: ?

    SA MaaS Microsoft SQL Server for on-premise and virtual Microsoft SQL servers gathers, stores and analyzes raw Microsoft recommended health & performance diagnostics to succor network admins and DBAs maintain SQL servers running at peak performance and find the logs they need.

    CatCompare v2

    Download page: CatCompare v2Release date: 2017-01-07Support Version: ?Author: Andy LeonardFree version: NoPrice: $295

    CatCompare provides automate-able command-line management of SSIS Catalog project configuration, deployment, migration, code promotion, and comparison.

    SSIS Catalog Compare v2.0 Bundle

    Download page: SSIS Catalog Compare v2.0 BundleRelease date: 2017-01-06Support Version: ?Author: Andy LeonardFree version: NoPrice: $495

    Deploying SSIS Catalog Projects succor deploying environments, references, mappings, and overrides. The SSIS Catalog Compare Version 2.0 Bundle includes SSIS Catalog Compare and CatCompare, a CLI (Command-Line Interface) utility.

    MS Kerberos Configuration Manager

    Download page: MS Kerberos Configuration ManagerRelease date: 2017-01-31Support Version: 2008/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    Microsoft Kerberos Configuration Manager for SQL Server is a diagnostic utensil that helps troubleshoot Kerberos related connectivity issues with SQL Server, SQL Server Reporting Services, and SQL Server Analysis Services.

    Spotlight

    Download page: [Spotligh]Release date: ?Support Version: 2008/2012/2014/2016Author: Quest SoftwareFree version: YesPrice: ?

    Can diagnose SQL Server performance issues quickly and accurately, ensuring a hale database infrastructure.

    DBConvert Studio

    Download page: DBConvert StudioRelease date: 2017-03-01Support Version: ?Author: DMSoft TechnologiesFree version: YesPrice: 499

    DBConvert Studio Software combines familiar and powerful features from the ripen DBConvert and DBSync product succession along with a redesigned and improved UI. The following scenarios are available:

  • Simple master to slave migration
  • One-way Synchronization
  • Bidirectional synchronization
  • Data distribution (data flows from one source database to multiple destinations)
  • DbDefence

    Download page: DbDefenceRelease date: 2017-03-01Support Version: 2005/2008/2012/2014/2016Author: ActiveCrypt SoftwareFree version: YesPrice: $698

    DbDefence for Microsoft SQL Server implements server-side encryption and additional plane of protection for databases. With DbDefence you can screen table structure and data from prying eyes, even from DBA. Free version for databases less than 200 MB.

    SQL Server Migration aide for MySQL

    Download page: SQL Server Migration aide for MySQLRelease date: 2017-02-17Support Version: 2005/2008/2012/2014/2016/AzureAuthor: MicrosoftFree version: YesPrice: No

    Microsoft SQL Server Migration aide (SSMA) for MySQL is a utensil to automate migration from MySQL database(s) to SQL Server and Azure SQL DB.

    sqlcmd for Mac and Linux

    Download page: sqlcmd for Mac and LinuxRelease date: 2017-01-26Support Version: 2005/2008/2012/2014/2016/AzureAuthor: Soheil RashidiFree version: Open SourcePrice: No

    sqlcmd utility for Mac and Linux

    SQL Migrator

    Download page: SQL MigratorRelease date: ?Support Version: 2005/2008/2012/2014/2016Author: Datamate TechnologyFree version: ?Price: ?

    Automatically upgrade objects within a SQL Server Instance from lower to higher versions or just refresh Objects between the identical Versions

    MS FoxPro to MS SQL Migration and Sync

    Download page: MS FoxPro to MS SQL Migration and SyncRelease date: 2013-10-08Support Version: 2005/2008/2012/AzureAuthor: DMSoft TechnologiesFree version: NoPrice: $149

    Our software helps to migrate and synchronize MS Visual FoxPro databases .DBC or MS Visual FoxPro free tables .DBF to MS SQL Server. It combines an easy-to-use interface with bunch of customization options, so your migration and replication of data can exist fulfilled smoothly and rapidly.

    Approximately 1 Million of records from FoxPro to MSSQL Server with "Bulk" option activated can exist converted in 8 minutes.

    MySQL to MS SQL Migration and Sync

    Download page: MySQL to MS SQL Migration and SyncRelease date: 2013-10-08Support Version: 2005/2008/2012/AzureAuthor: DMSoft TechnologiesFree version: NoPrice: $149

    Our software automates conversion and synchronization of your databases from MySQL to MS SQL Server. Transfer the entire database or select only needed dataset at customization stage in easy-to-use wizard style GUI.

    Views migration between MS SQL and MySQL in both directions is available. You don’t exigency to know any differences in SQL syntax. Every view will exist converted from source db to target automatically.

    Integrated Data Types Mapping feature helps to find and map similar data types between MySQL and MS SQL Server to Make cross database conversion more flexible.

    Oracle to MS SQL Migration and Sync

    Download page: Oracle to MS SQL Migration and SyncRelease date: 2013-10-09Support Version: 2005/2008/2012/AzureAuthor: DMSoft TechnologiesFree version: NoPrice: $149

    Convert and synchronize databases from Oracle to MS SQL Server efficiently and fast. Automatic views conversion from Oracle to MS SQL is easily performed with their software even with no any learning in differences between SQL dialects. Besides, any server access restrictions may exist overcome by creating dump files instead of direct connection to a target database.

    Our utensil easily handles huge databases and tables. A clear easy-to-use wizard interface helps you to stagger the total database or only selected tables, indexes and alien keys effortlessly.

    PostgreSQL to MS SQL Migration and Sync

    Download page: PostgreSQL to MS SQL Migration and SyncRelease date: 2013-10-08Support Version: 2005/2008/2012/AzureAuthor: DMSoft TechnologiesFree version: NoPrice: $149

    Convert and synchronize your databases from PostgreSQL to MS SQL server or to SQL Azure databases using their powerful software. Wizard style interface will usher you through several steps performing migration and replication jobs easily and effectively.

    In case you absorb any server restrictions, you can stuff MS SQL Dump file with complete data out of the PostgreSQL database.

    Our software will reclaim you hours of learning SQL commands as any large PostgreSQL db can exist converted and synchronized approximately in 5-10 min.

    MS outdo to MS SQL Migration

    Download page: MS outdo to MS SQL MigrationRelease date: 2013-09-23Support Version: 2005/2008/2012/AzureAuthor: DMSoft TechnologiesFree version: NoPrice: $149

    Ability to create tables from MS outdo file with Integrated Data Selector Microsoft outdo 2000 or higher 2003/2007/2010 Views conversion from MS SQL to MySQL and Oracle and back advocate Bi-directional synchronization between MS SQL, MySQL, Oracle and PostgreSQL Saving data into a MS SQL Dump for export to MS SQL database

    SQLite to MS SQL Migration and Sync

    Download page: SQLite to MS SQL Migration and SyncRelease date: 2014-05-08Support Version: 2005/2008/2012/AzureAuthor: DMSoft TechnologiesFree version: NoPrice: $149

    Conversion utensil for data migration and synchronization between SQLite and MS SQL databases in both directions. One of the main benefit of this converter is the range of efficient features that succor you to transfer complete database objects together or each individually, skipping unnecessary tables, fields, indexes, alien keys and constrains; change data types for various fields; rename each database element and many other options.

    If you absorb any restrictions on direct access to MS SQL server their product provides you with the chance to create Dump files for further data uploading to MS SQL server.

    IBM DB2 to MS SQL Migration and Sync

    Download page: IBM DB2 to MS SQL Migration and SyncRelease date: 2013-09-09Support Version: 2005/2008/2012/AzureAuthor: DMSoft TechnologiesFree version: NoPrice: $149

    Our robust and cost-effective solution is a key for successful conversion and synchronization from IBM DB2 to MS SQL server.Software is able to connect to source and destination databases directly without any other additional software installed. Optionally target SQL Dump file may exist generated if you haven’t a direct access to the MS SQL server.

    MS Access to MS SQL Migration and Sync

    Download page: IBM DB2 to MS SQL Migration and SyncRelease date: 2013-10-08Support Version: 2005/2008/2012/AzureAuthor: DMSoft TechnologiesFree version: NoPrice: $149

    Powerful cross database software that will upsize and synchronize Access data into MS SQL database.

    The program allows migrating MS Access queries to MSSQL views automatically with no exigency to know about the differences between SQL dialects.

    Firebird to MS SQL Migration and Sync

    Download page: Firebird to MS SQL Migration and SyncRelease date: 2013-09-11Support Version: 2005/2008/2012/AzureAuthor: DMSoft TechnologiesFree version: NoPrice: $149

    All Firebird / InterBase versions advocate Saving data into a Firebird Dump Views conversion from MS SQL to MySQL and Oracle and back advocate Bi-directional synchronization between MS SQL, MySQL, Oracle and PostgreSQL

    SQLines SQL Converter

    Download page: SQLines SQL ConverterRelease date: ?Support Version: ?Author: DmtolpekoFree version: Open SourcePrice: No

    SQLines SQL Converter is an open source utensil (Apache License 2.0) that allows you to transfigure database schema (DDL), queries and DML statements, views, stored procedures, packages, functions and triggers between Microsoft SQL Server, Oracle, MariaDB, MySQL, PostgreSQL, IBM DB2, Sybase, Informix, Teradata, Greenplum and Netezza.

    SQLite & SQL Server Compact Toolbox

    Download page: SQLite & SQL Server Compact ToolboxRelease date: ?Support Version: ?Author: ErikEJFree version: Open SourcePrice: No

    Visual Studio & SSMS 2016 extension, standalone app and command line tools, for managing complete aspects of your SQL Server Compact/SQLite database files' data and schema, including generation of code, database diagrams and database documentation.

    SqlPad

    Download page: SqlPadRelease date: ?Support Version: ?Author: RickbergfalkFree version: Open SourcePrice: No

    A web app for writing and running SQL queries and visualizing the results. Supports Postgres, MySQL, SQL Server, Crate, Vertica, and Presto. Written in Node.js.

    Html-query-plan

    Download page: Html-query-planRelease date: ?Support Version: ?Author: JustinPealingFree version: Open SourcePrice: No

    Html-query-plan is a JavaScript library for showing Microsoft SQL Server execution plans in HTML.

    SqlQueryStress

    Download page: SqlQueryStressRelease date: ?Support Version: ?Author: Adam MachanicFree version: Open SourcePrice: No

    SQL query stress simulator created by Adam Machanic http://sqlblog.com/blogs/adam_machanic/archive/2016/01/04/sqlquerystress-the-source-code.aspx

    SQL Server Migration aide for DB2

    Download page: SQL Server Migration aide for DB2Release date: 2017-02-17Support Version: 2005/2008/2012/2014/2016/AzureAuthor: MicrosoftFree version: YesPrice: No

    Microsoft SQL Server Migration aide (SSMA) for DB2 is a utensil to automate migration from DB2 database(s) to SQL Server and Azure SQL DB.

    SQL Server Migration aide for Oracle

    Download page: SQL Server Migration aide for OracleRelease date: 2017-02-17Support Version: 2005/2008/2012/2014/2016/AzureAuthor: MicrosoftFree version: YesPrice: No

    Microsoft SQL Server Migration aide (SSMA) for Oracle is a utensil to automate migration from Oracle database(s) to SQL Server and Azure SQL DB.

    SQL Server Migration aide for Access

    Download page: SQL Server Migration aide for AccessRelease date: 2017-02-17Support Version: 2005/2008/2012/2014/2016/AzureAuthor: MicrosoftFree version: YesPrice: No

    Microsoft SQL Server Migration aide (SSMA) for Access is a utensil to automate migration from Access database(s) to SQL Server and Azure SQL DB.

    mssql for Visual Studio Code

    Download page: mssql for Visual Studio CodeRelease date: 2017-02-02Support Version: ?Author: MicrosoftFree version: Open SourcePrice: No

    mssql for Visual Studio Code an extension for developing Microsoft SQL Server, Azure SQL Database and SQL Data Warehouse everywhere with a moneyed set of functionalities, including:

  • Connect to Microsoft SQL Server, Azure SQL Database and SQL Data Warehouses
  • Create and manage connection profiles and most recently used connections
  • Write T-SQL script with IntelliSense, vanish to Definition, T-SQL snippets, syntax colorizations, T-SQL error validations and vanish batch separator
  • Execute your scripts and view results in a simple to use grid
  • Save the result to json or csv file format and view in the editor
  • Customizable extension options including command shortcuts and more
  • Microsoft Assessment and Planning

    Download page: Microsoft Assessment and PlanningRelease date: 2017-02-10Support Version: 2008/2008R2/2012Author: MicrosoftFree version: YesPrice: No

    The Microsoft Assessment and Planning Toolkit makes it smooth to assess your current IT infrastructure for a variety of technology migration projects. This Solution Accelerator provides a powerful inventory, assessment, and reporting utensil to simplify the migration planning process.

    mssql-scripter

    Download page: mssql-scripterRelease date: ?Support Version: ?Author: MicrosoftFree version: Open SourcePrice: No

    mssql-scripter is the multiplatform command line equivalent of the widely used Generate Scripts Wizard sustain in SSMS. You can use mssql-scripter on Linux, macOS, and Windows to generate data definition language (DDL) and data manipulation language (DML) T-SQL scripts for database objects in SQL Server running anywhere, Azure SQL Database, and Azure SQL Data Warehouse.

    DBFS

    Download page: DBFSRelease date: ?Support Version: ?Author: MicrosoftFree version: Open SourcePrice: No

    DBFS uses FUSE to mount MS SQL Server DMVs as a virtual file system. This gives you the ability to explore information about your database (Dynamic Management Views) using autochthonous bash commands.

    Comparator

    Download page: ComparatorRelease date: 2017-06-06Support Version: 2008-2017Author: PumpetFree version: Open SourcePrice: No

    Simple application for compare data

    Navicat for SQL Server

    Download page: Navicat for SQL ServerRelease date: 2017-06-14Support Version: 2008-2017/Azure/AmazonRDSAuthor: PremiumSoftFree version: NoPrice: $699

    Navicat for SQL Server gives you a fully graphical approach to database management and development. Quickly and easily create, edit, and delete complete database objects, or execute SQL queries and scripts. Connect to any local/remote SQL Server, and compatible with cloud databases dote Amazon RDS and SQL Azure.

    Navicat Premium

    Download page: Navicat PremiumRelease date: 2017-06-14Support Version: 2008-2017/Azure/AmazonRDSAuthor: PremiumSoftFree version: NoPrice: $1299

    Navicat Premium is a database development utensil that allows you to simultaneously connect to MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, and SQLite databases from a single application. Compatible with cloud databases dote Amazon RDS, Amazon Aurora, Amazon Redshift, SQL Azure, Oracle Cloud and Google Cloud. You can quickly and easily build, manage and maintain your databases.

    DbVisualizer

    Download page: DbVisualizerRelease date: 2017-08-22Support Version: 2008-2017Author: DbVis Software AB.Free version: YesPrice: $197

    DbVisualizer is the universal database utensil for developers, DBAs and analysts. It is the flawless solution since the identical utensil can exist used on complete major operating systems accessing a wide range of databases.

    DbSchema

    Download page: DbSchemaRelease date: 2017-06-19Support Version: 2008-2017/Azure/AmazonAuthor: prudent Coders SolutionsFree version: NoPrice: $127

  • DbSchema is a diagram-oriented database designer with integrated data and query tools
  • DbSchema is build for large diagrams and schemes. No database sustain required – the utensil is visual.
  • For deployment of the schema on multiple databases, management of multiple versions of the schema and migration scripts, toil in a team on the design project. This are possible as DbSchema is using its own image of the schema and saves it to XML file.
  • DBGhost

    Download page: DBGhostRelease date: 2017-01-31Support Version: 2008/2012/2014/2016Author: Innovartis LtdFree version: NoPrice: £430

    The Change Manager gives you complete the tools to implement the complete DB Ghost Process enabling you to script out your databases into individual DROP/CREATE scripts, site those scripts under source control, modify them there and then build and deploy from those scripts.

    SQLAutomate

    Download page: SQLAutomateRelease date: 2017-06-19Support Version: 2008/2012/2014/2016Author: OnLine ToolWorksFree version: NoPrice: $99

    SQLAutomate is an advanced database automation solution for SQL Server, Oracle, MySQL, DB2 or other advanced database management system. It provides the ability to manage the necessary repetitive DBMS maintenance to succor maintain your databases efficient over time. SQLAutomate makes it smooth to manage a single database server instance, hundreds or even thousands of instances.

    BimlExpress

    Download page: BimlExpressRelease date: ?Support Version: ?Author: VarigenceFree version: NoPrice: No

    BimlExpress Visual Studio Add-in built specifically to toil with SQL Server 2016.

  • Generate packages within Visual Studio and avoid slow, repetitive, "drag 'n drop" workflow.
  • Write Biml code with syntax highlighting, making it easier to read and write Biml.
  • Updates are released more rapidly to toil with the most current versions of SQL Server.
  • BIDS Helper

    Download page: BIDS HelperRelease date: 2015-03-17Support Version: ?Author: MicrosoftFree version: Open SourcePrice: No

    A Visual Studio add-in that enhances development functionality in traffic Intelligence development Studio (BIDS) and SQL Server Data Tools (SSDTBI).

    Azure Data Warehouse Migration Utility

    Download page: Azure Data Warehouse Migration UtilityRelease date: ?Support Version: ?Author: MicrosoftFree version: ?Price: ?

    The Data Warehouse Migration Utility is a utensil designed to migrate schema and data from SQL Server and Azure SQL Database to Azure SQL Data Warehouse. During schema migration, the utensil automatically maps the corresponding schema from source to destination. After the schema has been migrated, the tools provides the option to stagger data with automatically generated scripts.

    Dell Benchmark Factory

    Download page: Dell Benchmark FactoryRelease date: ?Support Version: 2008/2012/2014/2016/AzureAuthor: Quest SoftwareFree version: NoPrice: $4413

  • database workload generation
  • database code scalability testing
  • industry-standard benchmark testing
  • virtual user and transaction load simulation
  • manduka

    Download page: mandukaRelease date: 2017-03-08Support Version: ?Author: Virtusa CorporationFree version: YesPrice: No

    The Free Static code analyzer

  • PL-SQL & T-SQL
  • Support for more than 50 violation rules
  • Light weight & fast
  • Easy to install & use
  • XML reports
  • PowerBI

    Download page: PowerBI DesktopRelease date: 2017-07-11Support Version: 2008-2017Author: MicrosoftFree version: YesPrice: ?

    Power BI is a suite of traffic analytics tools to dissect data and share insights. Monitor your traffic and fetch answers quickly with moneyed dashboards available on every device.

    Stellar Phoenix SQL Database Repair

    Download page: Stellar Phoenix SQL Database RepairRelease date: 2017-07-05Support Version: 2008/2012/2014/2016Author: Stellar Information TechnologyFree version: NoPrice: $349

  • Repairs corrupt MDF and NDF file of SQL Server database
  • Recovers tables, triggers, indexes, keys, rules and defaults
  • Perform deleted records recovery from MS SQL Server database
  • Saves Scan result of SQL Server database file automatically
  • Allows to search and recover specific database objects
  • Allows saving the repaired file in MS SQL, HTML, XLS & CSV formats
  • Supports MS SQL Server 2016, 2014, 2012, 2008 and complete lower versions
  • DataNumen SQL Recovery

    Download page: DataNumen SQL RecoveryRelease date: 2017-03-20Support Version: 2008/2012/2014/2016Author: DataNumenFree version: NoPrice: $500

    Recovery rate is the most vital criterion of a SQL recovery product. Based on their comprehensive tests, DataNumen SQL Recovery has the best recovery rate, much more better than any other competitors in the market!

    Recovery Toolbox for SQL Server

    Download page: Recovery Toolbox for SQL ServerRelease date: ?Support Version: 7/2000/2005/2008/2008 R2/2012/2014Author: Recovery ToolboxFree version: NoPrice: $99

    Recovery Toolbox for SQL Server is a comprehensive recovery solution for damaged MS SQL Server database files.

    SQL MDF Viewer

    Download page: SQL MDF ViewerRelease date: ?Support Version: 2000-2016Author: SysToolsFree version: NoPrice: $129

    Read and open MDF database file along with its related elements

  • Preview complete tables, indexes, triggers of the MDF file
  • Auto detects the SQL Server version
  • Save scanned MDF file data in .str file format
  • SQL MDF Recovery Tool

    Download page: SQL MDF Recovery ToolRelease date: ?Support Version: 2014 and complete lower versionsAuthor: SysToolsFree version: NoPrice: $129

    Repair corrupt MDF file data with ease and accuracy

  • Recover tables, function, stored procedure, triggers, etc
  • Performs Quick and foster Scan to repair MDF & NDF file
  • Export selective file with Schema or Schema and Data
  • SQL Passord Recovery

    Download page: SQL Passord RecoveryRelease date: ?Support Version: 2008 & complete below versionsAuthor: SysToolsFree version: NoPrice: $69

    Tool to Reset SQL Server Database Password

  • Recover passwords of multiple SQL Server databases
  • Reset both unknown and bare SQL DB passwords
  • Remove and reset passwords of complete SQL Server users
  • SQL Decryptor

    Download page: SQL DecryptorRelease date: ?Support Version: 2014 & complete below versionsAuthor: SysToolsFree version: NoPrice: $69

    User Friendly Solution to Remove Encryption From SQL Database

  • Remove encryption from batch SQL objects
  • Display complete preview of MS SQL database
  • Export data to SQL Server and compatible script
  • SQL Backup Database Recovery

    Download page: SQL Backup Database RecoveryRelease date: ?Support Version: ?Author: SysToolsFree version: NoPrice: $149

    Recover corrupt SQL Backup File with .bak Repair Tool

  • Repair corrupt SQL Server backup file with confidence
  • Fix complete SQL backup error messages quickly
  • Advanced and affordable solution to recover SQL BAK file
  • Simple and nifty graphical user interface
  • SQL Log File Viewer

    Download page: SQL Log File ViewerRelease date: ?Support Version: 2016/2014/2012/2008 and complete below versionsAuthor: SysToolsFree version: NoPrice: $999

    Read SQL Server database transaction log file with SQL log analysis tool

  • Analyze and view SQL Server LDF file transactions
  • View complete the transactions, i.e. insert, update, delete etc.
  • Export log file into SQL Server, SQL script or as CSV file
  • DAX Studio

    Download page: DAX StudioRelease date: ?Support Version: ?Author: SqlbiFree version: YesPrice: No

    DAX Studio is a utensil to write, execute, and dissect DAX queries in Power BI Designer, Power Pivot for Excel, and Analysis Services Tabular.

    SQL Cop

    Download page: SQL CopRelease date: ?Support Version: ?Author: LessThanDotFree version: YesPrice: No

    SQL Cop is a static code analysis utensil to automatically detect issues with your database.

    Dataedo

    Download page: DataedoRelease date: 2017-09-15Support Version: 2008-2017Author: SqlbiFree version: YesPrice: $239

    Document SQL Server, Oracle and MySQL databases

    Azure Database Migration Service

    Download page: DataedoRelease date: 2017-12-01Support Version: 2008-2017Author: MicrosoftFree version: YesPrice: No

    Reduce the complexity of your cloud migration by using a single comprehensive service instead of multiple tools. The public preview release of Azure Database Migration Service is designed as a seamless, end-to-end solution for touching on-premises SQL Server databases to the cloud.

    FlowHeater

    Download page: flowheaterRelease date: 2017-10-02Support Version: 2008-2017Author: FlowHeater GmbHFree version: NoPrice: $79

    The FlowHeater functionality closely resembles the concept of a continuous-flow water heater. A wide variety of data sources can exist interconnected with FlowHeater and by making use of exchangeable adapters, there is no restriction to the data flow.

    EDIS

    Download page: EDISRelease date: ?Support Version: 2008-2017Author: SQL ETLFree version: YesPrice: $599

    EDIS is an Extract-Transform-Load (ETL) application for Microsoft SQL Server. No 3rd Party Language, No Packages, Just SQL.

    SchemaSpy

    Download page: SchemaSpyRelease date: 2018-08-05Support Version: 2008-2017Author: Rafal KasaFree version: Open SourcePrice: No

    Document your database simply and easily. SchemaSpy is a Java-based utensil (requires Java 8 or higher) that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships as represented by both HTML links and entity-relationship diagrams. It’s moreover designed to succor resolve the obtuse errors that a database sometimes gives related to failures due to constraints. It is free software that is distributed under the terms of the MIT License.

    Adminer

    Download page: AdminerRelease date: 2018-02-20Support Version: 2005-2017Author: AdminerFree version: Open SourcePrice: No

    Adminer (formerly phpMinAdmin) is a full-featured database management utensil written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. Adminer is available for MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Firebird, SimpleDB, Elasticsearch and MongoDB.

    Full transfigure Enterprise

    Download page: complete ConvertRelease date: 2018-08-20Support Version: 2005-2017Author: Spectral CoreFree version: NoPrice: $699

    Full transfigure allows smooth copying of tables and data between 40 or so supported databases. It will create complete the tables, copy complete of your data, then create indexes and alien keys. It has powerful mapping and customization features and uses optimal copying mode for each table separately to achieve the best possible throughput.

    Replicator Pro

    Download page: ReplicatorRelease date: 2018-08-20Support Version: 2005-2017Author: Spectral CoreFree version: NoPrice: $799

    Replicator allows table data comparison and sync – even with heterogeneous databases. It is unique in the fact it can replicate changes only even if source is non-relational (CSV, DBF, outdo documents, Paradox…). Replicator has a built-in scheduler for smooth periodic change replication.

    JackDB

    Download page: JackDBRelease date: ?Support Version: 2008-2017/AzureAuthor: JackDBFree version: NoPrice: $49

    JackDB is a modern database client. Collaborate with data securely across your entire organization.

    SQL Workbench

    Download page: SQL WorkbenchRelease date: 2018-08-20Support Version: 2008-2017Author: Thomas KellererFree version: YesPrice: No

    SQL Workbench/J is a free, DBMS-independent, cross-platform SQL query tool. It is written in Java and should accelerate on any operating system that provides a Java Runtime Environment. Its main focus is on running SQL scripts (either interactively or as a batch) and export/import features. Graphical query building or more advanced DBA tasks are not the focus and are not planned.

    Valentina Studio

    Download page: Valentina StudioRelease date: 2018-09-24Support Version: 2008-2017Author: Paradigma SoftwareFree version: YesPrice: $200

    Valentina Studio is your universal database management utensil for working with MySQL, MariaDB, SQL Server, PostgreSQL, SQLite and Valentina DB databases. Valentina Studio lets you connect with complete major databases, accelerate queries and generate


    Upgrading to SQL Server 2012/2014 - How to Overcome the Top 5 ‘Gotchas’ | killexams.com actual questions and Pass4sure dumps

    Jan 7, 2015

    Varun Singh

    Image courtesy of Shutterstock

    SQL Server 2012/2014 delivers compelling new capabilities that Make an upgrade worthwhile. Many IT professionals conform that the AlwaysOn Availability Group (AG) feature offers the most value with its elevated availability (HA) capabilities to ensure continuous application availability.

    Synchronous replication technology in AlwaysOn lets applications scale out dote never before, using more resources on more servers. With read-only access to secondary databases, SQL Server 2012/2014 can dramatically increase database I/O capacity on the back end. Grouping databases together into an AG moreover allows companies to specify that inevitable databases connect to particular applications, ensuring that they failover together.

    However, along the upgrade path, companies absorb moreover discovered key obstacles to achieving the new opportunities. Without awareness and understanding about these challenges – and their potential consequences – an organization’s upgrade to SQL Server 2012/2014 can exist costly, inefficient, and plagued by system errors.

    Here are the top 5 SQL Server 2012/2014 ‘gotchas’ as well as tips for addressing them:
  • Backward compatibility
  • Licensing changes
  • Read/write split
  • Replication awareness
  • Automatic failover
  • 1-Maintain backward compatibility

    To avoid problems, as well as significant future rework, organizations exigency to address deprecated T-SQL features. For SQL Server 2012/2014, Microsoft will no longer advocate non-ANSI outer unite syntax, requiring that complete code exist ANSI compliant.

    Because every new release brings deprecation of earlier compatibility levels, companies must exist sensible of plane changes and the repercussion on their applications. In the case of SQL Server 2012, applications will deprecate to 2000 compatibility, while SQL Server 2014 deprecates to 2005.

    Companies moreover exigency to check with their ISVs to verify application support. advocate may not exist a given when compatibility levels become switched. An ISV with a compress to advocate an application on 2005 might not necessarily advocate it on 2012 running compatibility levels for 2005.

    If at complete possible, companies should test their applications and scale them to the most modern standards during any upgrade. Best practices prescribe that organizations switch to the highest compatibility plane of the upgraded SQL Server version. Not doing this puts off the inevitable and the toil associated with it, making more toil for companies in the long run.

    2-Be sensible of licensing changes

    With SQL Server 2012/2014, Microsoft has moved to a core-based licensing model for its Enterprise Edition. Regardless of the number of sockets or cores per-socket, organizations must now pay per core, and the licensing requires a minimum of 4 core licenses per physical processor. While minor variations exist due to individual licensing terms, touching to a 4-core enterprise license from a server license equates to a 4x cost dissimilarity on paper for most companies

    The licensing changes moreover move customers installing SQL Server 2012/2014 in a virtual environment. If a company runs SQL Server on a VM guest, a minimum of 4 cores must exist licensed in the Enterprise Edition. This requirement can exist frustrating, as a company using a 2-core VM, for example, must silent license for 4 cores even if they are only using half of them.

    It’s not complete unfavorable news. With significantly increased resource limits to the standard Edition (up to 64 GB reminiscence and 16 cores), companies moreover absorb a viable alternative to Enterprise Edition for the first time, as well as a solid migration path for the future. In addition, Microsoft has created the traffic Intelligence Edition, delivering a standard Edition SQL engine with the Enterprise Edition intelligence features.

    In addition to paying attention to core import and understanding the licensing pitfalls, companies should reckon other ways to offset the higher licensing costs. By maximizing usage of secondary servers to process read loads, organizations can reduce the exigency to buy larger servers with more cores. Caching can moreover succor reduce the number of queries to exist processed, letting companies maintain the needed performance while buying fewer cores. In some instances, database query caching has been able to wield 80% of the database load, sending just 20% to the SQL Server database.

    3-Leverage read/write split – with app changes

    By allowing secondary servers to process read traffic instead of just sitting idle, AlwaysOn enables companies to serve more traffic and better their application response times.

    However, to leverage this capability, applications must exist modified to build advocate for read-intent strings to connect to secondaries. Furthermore, applications exigency to exist modified to identify which queries/stored procedures to route to secondaries. This application modification takes up a lot of time and resources, often delaying companies from benefitting from SQL Server 2012/2014’s new scale out features.

    To unravel this problem and avoid application modification, some companies absorb implemented either homegrown or third-party database traffic management software. Sitting between the application and the database, database traffic management software understands SQL syntax and can classify them as reads or writes. It can moreover learn the definition of a stored procedure from the database server to find out whether a particular stored procedure is a read-only or a read/write operation. With this detailed SQL condition knowledge, the software can automatically load balance SQL traffic amongst primary and secondary servers, sending transactions and writes to the primary and distributing read-only traffic amongst the secondaries.

    By offloading the exigency to build this intelligence into the application, companies can quickly hold advantage of SQL Server 2012/2014’s advanced features.

    4-Ensure replication awareness

    Because AlwaysOn is constantly replicating data from the primary server to the secondaries, the possibility emerges for replication lag. If the secondaries descend too far behind in replication, the data on secondary servers can become stale.

    While the primary server remains the authoritative source for writing to the database in SQL Server 2012/2014, the secondary server now has the identical data, which allows users to read from it. However, in supporting reads from the secondary, organizations must exist sensible that 1) the secondary server will always exist a limited behind the primary server; and 2) applications exigency to define the threshold of tolerance for delay, i.e., to what plane that data can exist “behind” in timing.

    If applications are reading stale data, it can lead to discordant behavior. Different users might discern different values for the identical query, or – even worse – users might discern older, incomplete data even when they absorb finished a transaction.

    Modifying applications to advocate replication awareness can exist a highly knotty and costly process, requiring the organization to build a replication-monitoring engine and integrate it with application code. That modified application can then check to Make confident that each server to which it is sending reads is in sync with the primary server. Adding to the complexity, most applications, such as .NET or PHP, are written dote an integrated script, making it even more difficult and time-consuming to achieve replication awareness.

    By integrating replication monitoring with load balancing and SQL flood control through the use of software, companies can establish a maximum replication delay threshold – without modifying any applications. Such software will not send reads to a secondary server that is more than one second behind the primary, for example. This approach keeps data access consistent even when supporting reads from secondary servers. The replication monitoring process can even alert administrators of potential networking or database issues that might absorb caused the replication lag or breakage in the first place.

    5-Enable automated failover

    SQL Server 2012/2014 limits automated failover to servers sitting within a single data center, despite having the ability to scale beyond a single data center. With virtual network name (VNN, moreover referred to as the vigorous Group Listener), SQL Server 2012/2014 provides a mode to learn the new primary when a server fails.

    However, VNN has significant limitations since it redirects read-intent connections directly to the secondary server and does not act as an aggregation endpoint. This redirection can lead to increased downtime and application errors during failover as both the primary being failed and the secondary being promoted will drop their connections.

    One route around this limitation is to deploy software that acts as an abstraction layer between the database and the application. In this architecture, that software replaces the VNN as the destination for SQL connections. The software then routes SQL queries on behalf of the app, with detailed understanding of complete queries. This architecture enables failover that is transparent to the application – with no dropping of the connections and queuing of inbound traffic so applications discern few to no errors.

    Bottom Line - Focus on the majestic Picture

    At the conclude of the day, a database upgrade is never just about the database. SQL Server 2012/2014’s new capabilities, including the AlwaysOn HA features, vow huge benefits, but they moreover create significant complexity.

    Companies must reckon how an upgrade affects not only performance and costs but moreover other parts of their infrastructure. The challenges of programming applications to understand and leverage scaled out database infrastructure are many.  

    An upgrade can exist a pleasurable time to reckon making other architectural changes – such as creating an abstraction layer using a SQL proxy or database load balancing software.

    About the author:

    Varun Singh, Founder and CTO, ScaleArc

    As Chief Technology Officer, Varun leads ScaleArc’s product development and technology strategy. Varun moreover served as ScaleArc’s CEO from March 2009 to Sept 2013. Varun is a technologist with broad sustain in several fields, from running Linux-based BBS systems in the pre-Internet days to writing about technology and open source software at PC Quest, CHIP, Digit, and Network Computing, to creating India’s top online technology brands such as TechTree and Tech2, to hosting technology shows on CNBC, TV18, CNN-IBN and ET Now. He led large web and application development teams as CTO at Network 18's web division and built the highly scalable technology behind large websites dote IN.com, MoneyControl.com, and various other portals.


    Column Store Index in MS SQL 2012 / 2014 | killexams.com actual questions and Pass4sure dumps

    Introduction

    Column store index is the unique feature of Microsoft SQL Server starting from Microsoft SQL 2012 and improving with Microsoft SQL Server 2014. Here in this article I am going to argue about the architecture of Column store Index.

    Please note that this Column store Index architecture is suitable only for OLAP or BI environment not in OTLP environment, others the performance down.

    Architecture of Column Store Index

    Before going to the depth of the architecture of column store index in MS SQL 2012, they assume that the they complete well known about the row based index and how it load in the reminiscence to fulfill the request of a query.

    First of complete they peep at the design to understand the column store index properly

    Segment Concept:

    Each column in the column store index is it own segment. A Segment contains the value from one column only. Each and every column in a table that comprise in the column store index forms individual segment. Which allows the column data access individually. Each segment can from by multiple pages.

    A segment has the limitation of 1 millions of rows. So for a majestic table it is not exist possible to meet single entire columns within a single segment, so single column of a table may exist meet with multiple segments.

    Data is transferred from the disk to reminiscence by segment, not by page. A segment is a highly compressed large kick (LOB) that can hold up to one million rows. The data within each column’s segment matches row-by-row so that the rows can always exist assembled correctly.

    In their specimen the disk data came from three pages that is Page -1, Page-2 and Page-3. If they crate column store index in the column named “Name” then the segment is created from Page-1, Page-2 and Page-3.

    Group Concept:

    When a column is not meet in a single segment as the data of columns exceed the one million then columns takes multiple segments to store data. In such cases, multiple segments are created for each column and grouped into multiple row groups, one for each set of segments.

    When a column store index is broken into multiple row groups, each row group contains a set of complete rows.  Please peep at the bellow design to understand it properly.

    Dictionary Concept:

    Besides column segments a column store index consists of another data storage element: dictionaries. Dictionaries are widely used in columnar storage as a means to efficiently encode large data types, dote strings. The values stores in the column segments will exist just entry numbers in the dictionary, and the actual values are stored in the dictionary. This technique can capitulate very pleasurable compression for repeated values, but yields unfavorable results if the values are complete part (the required storage actually increases). This is what makes large columns (strings) with part values very poverty-stricken candidates for column store indexes. Column store indexes hold part dictionaries for each column and string columns hold two types of dictionaries.

    Primary Dictionary

    This is a global dictionary used by all segments of a column.

    Secondary Dictionary

    This is an overflow dictionary for entries that did not meet in the primary dictionaries. It can be shared by several segments of a column: the relation between dictionaries and column segments is one-to-many.

    Data Compression:

    Column store indexes are based on xVelocity (formerly known as VertiPaq), an advanced storage and compression technology that originated with Power Pivot and Analysis Services but has been adapted to SQL Server 2012 databases.

    New feature of Column Store in SQL 2014

  • We can create only one non-clustered column store index on a table although they can comprise complete the columns of the table in the single index.
  • SQL Server 2014 enhances it to add advocate for creating Clustered Column store Index.
  • When they create a column store index and it makes the table read only.
  • With SQL Server 2014, they can create a column store index without having much repercussion on write-ability on the table. This means they can issue some INSERT, UPDATE, DELETE statements with a table with clustered column store index. No more tedious workaround is required for writing data to a table with column store index in this release dote the previous release.
  • Hope you dote it.



    Direct Download of over 5500 Certification Exams

    3COM [8 Certification Exam(s) ]
    AccessData [1 Certification Exam(s) ]
    ACFE [1 Certification Exam(s) ]
    ACI [3 Certification Exam(s) ]
    Acme-Packet [1 Certification Exam(s) ]
    ACSM [4 Certification Exam(s) ]
    ACT [1 Certification Exam(s) ]
    Admission-Tests [13 Certification Exam(s) ]
    ADOBE [93 Certification Exam(s) ]
    AFP [1 Certification Exam(s) ]
    AICPA [2 Certification Exam(s) ]
    AIIM [1 Certification Exam(s) ]
    Alcatel-Lucent [13 Certification Exam(s) ]
    Alfresco [1 Certification Exam(s) ]
    Altiris [3 Certification Exam(s) ]
    Amazon [2 Certification Exam(s) ]
    American-College [2 Certification Exam(s) ]
    Android [4 Certification Exam(s) ]
    APA [1 Certification Exam(s) ]
    APC [2 Certification Exam(s) ]
    APICS [2 Certification Exam(s) ]
    Apple [69 Certification Exam(s) ]
    AppSense [1 Certification Exam(s) ]
    APTUSC [1 Certification Exam(s) ]
    Arizona-Education [1 Certification Exam(s) ]
    ARM [1 Certification Exam(s) ]
    Aruba [6 Certification Exam(s) ]
    ASIS [2 Certification Exam(s) ]
    ASQ [3 Certification Exam(s) ]
    ASTQB [8 Certification Exam(s) ]
    Autodesk [2 Certification Exam(s) ]
    Avaya [101 Certification Exam(s) ]
    AXELOS [1 Certification Exam(s) ]
    Axis [1 Certification Exam(s) ]
    Banking [1 Certification Exam(s) ]
    BEA [5 Certification Exam(s) ]
    BICSI [2 Certification Exam(s) ]
    BlackBerry [17 Certification Exam(s) ]
    BlueCoat [2 Certification Exam(s) ]
    Brocade [4 Certification Exam(s) ]
    Business-Objects [11 Certification Exam(s) ]
    Business-Tests [4 Certification Exam(s) ]
    CA-Technologies [21 Certification Exam(s) ]
    Certification-Board [10 Certification Exam(s) ]
    Certiport [3 Certification Exam(s) ]
    CheckPoint [43 Certification Exam(s) ]
    CIDQ [1 Certification Exam(s) ]
    CIPS [4 Certification Exam(s) ]
    Cisco [318 Certification Exam(s) ]
    Citrix [48 Certification Exam(s) ]
    CIW [18 Certification Exam(s) ]
    Cloudera [10 Certification Exam(s) ]
    Cognos [19 Certification Exam(s) ]
    College-Board [2 Certification Exam(s) ]
    CompTIA [76 Certification Exam(s) ]
    ComputerAssociates [6 Certification Exam(s) ]
    Consultant [2 Certification Exam(s) ]
    Counselor [4 Certification Exam(s) ]
    CPP-Institue [2 Certification Exam(s) ]
    CPP-Institute [2 Certification Exam(s) ]
    CSP [1 Certification Exam(s) ]
    CWNA [1 Certification Exam(s) ]
    CWNP [13 Certification Exam(s) ]
    CyberArk [1 Certification Exam(s) ]
    Dassault [2 Certification Exam(s) ]
    DELL [11 Certification Exam(s) ]
    DMI [1 Certification Exam(s) ]
    DRI [1 Certification Exam(s) ]
    ECCouncil [21 Certification Exam(s) ]
    ECDL [1 Certification Exam(s) ]
    EMC [129 Certification Exam(s) ]
    Enterasys [13 Certification Exam(s) ]
    Ericsson [5 Certification Exam(s) ]
    ESPA [1 Certification Exam(s) ]
    Esri [2 Certification Exam(s) ]
    ExamExpress [15 Certification Exam(s) ]
    Exin [40 Certification Exam(s) ]
    ExtremeNetworks [3 Certification Exam(s) ]
    F5-Networks [20 Certification Exam(s) ]
    FCTC [2 Certification Exam(s) ]
    Filemaker [9 Certification Exam(s) ]
    Financial [36 Certification Exam(s) ]
    Food [4 Certification Exam(s) ]
    Fortinet [14 Certification Exam(s) ]
    Foundry [6 Certification Exam(s) ]
    FSMTB [1 Certification Exam(s) ]
    Fujitsu [2 Certification Exam(s) ]
    GAQM [9 Certification Exam(s) ]
    Genesys [4 Certification Exam(s) ]
    GIAC [15 Certification Exam(s) ]
    Google [4 Certification Exam(s) ]
    GuidanceSoftware [2 Certification Exam(s) ]
    H3C [1 Certification Exam(s) ]
    HDI [9 Certification Exam(s) ]
    Healthcare [3 Certification Exam(s) ]
    HIPAA [2 Certification Exam(s) ]
    Hitachi [30 Certification Exam(s) ]
    Hortonworks [4 Certification Exam(s) ]
    Hospitality [2 Certification Exam(s) ]
    HP [752 Certification Exam(s) ]
    HR [4 Certification Exam(s) ]
    HRCI [1 Certification Exam(s) ]
    Huawei [21 Certification Exam(s) ]
    Hyperion [10 Certification Exam(s) ]
    IAAP [1 Certification Exam(s) ]
    IAHCSMM [1 Certification Exam(s) ]
    IBM [1533 Certification Exam(s) ]
    IBQH [1 Certification Exam(s) ]
    ICAI [1 Certification Exam(s) ]
    ICDL [6 Certification Exam(s) ]
    IEEE [1 Certification Exam(s) ]
    IELTS [1 Certification Exam(s) ]
    IFPUG [1 Certification Exam(s) ]
    IIA [3 Certification Exam(s) ]
    IIBA [2 Certification Exam(s) ]
    IISFA [1 Certification Exam(s) ]
    Intel [2 Certification Exam(s) ]
    IQN [1 Certification Exam(s) ]
    IRS [1 Certification Exam(s) ]
    ISA [1 Certification Exam(s) ]
    ISACA [4 Certification Exam(s) ]
    ISC2 [6 Certification Exam(s) ]
    ISEB [24 Certification Exam(s) ]
    Isilon [4 Certification Exam(s) ]
    ISM [6 Certification Exam(s) ]
    iSQI [7 Certification Exam(s) ]
    ITEC [1 Certification Exam(s) ]
    Juniper [65 Certification Exam(s) ]
    LEED [1 Certification Exam(s) ]
    Legato [5 Certification Exam(s) ]
    Liferay [1 Certification Exam(s) ]
    Logical-Operations [1 Certification Exam(s) ]
    Lotus [66 Certification Exam(s) ]
    LPI [24 Certification Exam(s) ]
    LSI [3 Certification Exam(s) ]
    Magento [3 Certification Exam(s) ]
    Maintenance [2 Certification Exam(s) ]
    McAfee [8 Certification Exam(s) ]
    McData [3 Certification Exam(s) ]
    Medical [69 Certification Exam(s) ]
    Microsoft [375 Certification Exam(s) ]
    Mile2 [3 Certification Exam(s) ]
    Military [1 Certification Exam(s) ]
    Misc [1 Certification Exam(s) ]
    Motorola [7 Certification Exam(s) ]
    mySQL [4 Certification Exam(s) ]
    NBSTSA [1 Certification Exam(s) ]
    NCEES [2 Certification Exam(s) ]
    NCIDQ [1 Certification Exam(s) ]
    NCLEX [2 Certification Exam(s) ]
    Network-General [12 Certification Exam(s) ]
    NetworkAppliance [39 Certification Exam(s) ]
    NI [1 Certification Exam(s) ]
    NIELIT [1 Certification Exam(s) ]
    Nokia [6 Certification Exam(s) ]
    Nortel [130 Certification Exam(s) ]
    Novell [37 Certification Exam(s) ]
    OMG [10 Certification Exam(s) ]
    Oracle [282 Certification Exam(s) ]
    P&C [2 Certification Exam(s) ]
    Palo-Alto [4 Certification Exam(s) ]
    PARCC [1 Certification Exam(s) ]
    PayPal [1 Certification Exam(s) ]
    Pegasystems [12 Certification Exam(s) ]
    PEOPLECERT [4 Certification Exam(s) ]
    PMI [15 Certification Exam(s) ]
    Polycom [2 Certification Exam(s) ]
    PostgreSQL-CE [1 Certification Exam(s) ]
    Prince2 [6 Certification Exam(s) ]
    PRMIA [1 Certification Exam(s) ]
    PsychCorp [1 Certification Exam(s) ]
    PTCB [2 Certification Exam(s) ]
    QAI [1 Certification Exam(s) ]
    QlikView [1 Certification Exam(s) ]
    Quality-Assurance [7 Certification Exam(s) ]
    RACC [1 Certification Exam(s) ]
    Real-Estate [1 Certification Exam(s) ]
    RedHat [8 Certification Exam(s) ]
    RES [5 Certification Exam(s) ]
    Riverbed [8 Certification Exam(s) ]
    RSA [15 Certification Exam(s) ]
    Sair [8 Certification Exam(s) ]
    Salesforce [5 Certification Exam(s) ]
    SANS [1 Certification Exam(s) ]
    SAP [98 Certification Exam(s) ]
    SASInstitute [15 Certification Exam(s) ]
    SAT [1 Certification Exam(s) ]
    SCO [10 Certification Exam(s) ]
    SCP [6 Certification Exam(s) ]
    SDI [3 Certification Exam(s) ]
    See-Beyond [1 Certification Exam(s) ]
    Siemens [1 Certification Exam(s) ]
    Snia [7 Certification Exam(s) ]
    SOA [15 Certification Exam(s) ]
    Social-Work-Board [4 Certification Exam(s) ]
    SpringSource [1 Certification Exam(s) ]
    SUN [63 Certification Exam(s) ]
    SUSE [1 Certification Exam(s) ]
    Sybase [17 Certification Exam(s) ]
    Symantec [135 Certification Exam(s) ]
    Teacher-Certification [4 Certification Exam(s) ]
    The-Open-Group [8 Certification Exam(s) ]
    TIA [3 Certification Exam(s) ]
    Tibco [18 Certification Exam(s) ]
    Trainers [3 Certification Exam(s) ]
    Trend [1 Certification Exam(s) ]
    TruSecure [1 Certification Exam(s) ]
    USMLE [1 Certification Exam(s) ]
    VCE [6 Certification Exam(s) ]
    Veeam [2 Certification Exam(s) ]
    Veritas [33 Certification Exam(s) ]
    Vmware [58 Certification Exam(s) ]
    Wonderlic [2 Certification Exam(s) ]
    Worldatwork [2 Certification Exam(s) ]
    XML-Master [3 Certification Exam(s) ]
    Zend [6 Certification Exam(s) ]





    References :


    Blogspot : http://killexamz.blogspot.com/2017/05/killexamscom-70-461-braindumps-and.html
    Youtube : https://youtu.be/Bz-58D9BgHg
    weSRCH : https://www.wesrch.com/business/prpdfBU1HWO000AMUM
    Dropmark : http://killexams.dropmark.com/367904/10847575
    Issu : https://issuu.com/trutrainers/docs/70-461
    Scribd : https://www.scribd.com/document/352582795/Pass4sure-70-461-Querying-Microsoft-SQL-Server-2012-2014-exam-braindumps-with-real-questions-and-practice-software
    Wordpress : http://wp.me/p7SJ6L-1XH
    Dropmark-Text : http://killexams.dropmark.com/367904/12850953
    RSS Feed : http://feeds.feedburner.com/ExactlySame70-461QuestionsAsInRealTestWtf
    Box.net : https://app.box.com/s/8tw4b86rpizdxay5xqvnp0s4wg960bem






    Back to Main Page

    www.pass4surez.com | www.killcerts.com | www.search4exams.com | http://www.lightandcolour.net/