![]() ![]() You probably have a set of scripts that you often run, like troubleshooting scripts or query. Other rules are Best Practice, Execution, Performace, and many others. As of this writing, you cannot create custom rules but the existing ones are good enough to ensure that you are writing efficient codes. Most important of these, in my opinion, are the Deprecated Rules that warn you of, well, deprecated objects.Īs the analysis is performed in real-time, you can correct your codes as you write. An explanation of each rule is provided and also some suggestions on how to improve your code. As you type, the tool scans your code against a set of rules and mark the lines that violate these rules. ![]() The Code Analysis feature guides you to writing better codes and avoiding common pitfalls of code smell. I like all the features of SQL Prompt, but these are the few that I like most. I have long been a fan of SQL Prompt even before I became part of FoRG and, I think, even before Redgate acquired the tool (If my memory serves me right, it was not an original product of Redgate, or maybe that was something else). I am part of the Friends of Redgate Program (FoRG). SQL Prompt is just the best code completion and refactoring tool on the market.Ī little disclaimer, though. In fact, I wonder how anyone could do their job productively and efficiently without it or any other type of IntelliSense tool for that matter. I think I have told my co-workers more often than I should that I couldn’t write TSQL without it. The features and code-complete capabilities of SQL Prompt makes a productive SQL Developer or DBA more efficient. It’s the IntelliSense everyone needs for productivity. Whether I’m writing stored procedures or crunching TSQL codes to troubleshoot data issues in SQL Server, I depend on it to show me the things that I need – and even the things that I don’t think I need. Well, that’s probably an exaggeration but I use it daily in my job. SQL Prompt from Redgate Software is one of the tools that I cannot live without. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |