Category
Topic
Subtopic
SQL Formatting standards – Capitalization, Indentation, Comments, Parenthesis (4296382)
Nobody likes to read a wall of text, even when it’s just plain text. ... When it comes to reading code, the problem is even bigger. ... Code can have different formatting styles, which could make a job either easier or more difficult.
How to rename database objects in a SQL Server safely – Part 2 (4214717)
After the principles of the Safe rename feature were explained in the Part 1, in this sequel an insight in the execution steps will be provided. ... If there is the possibility that renaming the object can put a database integrity at risk, the Safe rename feature will immediately, after a click on the Preview button, display a warning icon next to the New name field, and it will not generate the preview script:
How to secure stored procedures against SQL injection (4290146)
doesn't mean that applications, database and SQL Server are safe from all types of SQL injection attacks. ... In addition, the <span class="csharpcode"><span class="keyword">EXEC</span></span> command, which takes a string as a parameter and executes it as a SQL statement, is being used.
Replacing one-to-many relationships with association tables automatically – Part 2 (4214889)
After explaining basic principles for replacing one-to-many relationships with associative tables in Part 1 of the article, this sequel will show how to easily accomplish that via the Replace one-to-many relationship feature.
Top things you need in a SQL formatter tool (4295703)
Nobody likes to check and read a ton of messy, unformatted text. ... When it comes to read a complex SQL code that problem can become even more difficult, especially if you are the one who has to untangle it.
Replacing one-to-many relationships with association tables automatically– Part 1 (4213591)
The Replace one-to-many relationship feature in ApexSQL Refactor, an SSMS/VS add-in, will isolate the relationship between two tables and add a separate association table. ... A one-to-many relationship is one of the most common relationship types in relational databases.
SQL Refactoring techniques – How to split a table in SQL (4215910)
Splitting a table by moving set of columns into a new table is called vertical partitioning. ... Horizontal partitioning is having different tables with the same columns but contain different (distinct) sets of rows
How to refactor a SQL Server database table to add a surrogate key (4213498)
Choosing a primary key is one of the most important steps in a database design. ... There are two types of a primary key – a natural key and a surrogate key. ... In this article it will be described how to apply database refactoring on a SQL Server database and replace a natural key with a surrogate key by using ApexSQL Refactor a free SQL Server Management Studio and a Visual Studio add-in that provides numerous features for refactoring of SQL code and uses one of fastest SQL formatters.
How to rename database objects in a SQL Server database safely – Part 1 (4211183)
This feature makes possible to rename objects in SQL Server without breaking the database dependencies. ... It generates a SQL script that changes the object name and updates all the dependent database objects.
How to quickly convert SQL code to language-specific client code (4216085)
Integrating SQL Server with business infrastructure often requires that developers prepare T-SQL code for use within various client codes, such as C#, PHP, and Perl. ... This means adding language specific code that will be inserted before and after every SQL statement, as well as escape characters for quotes and code to terminate a line, so that the other languages can parse and execute it correctly.
How to clean up SQL database code by removing unused parameters (4299861)
Finding parameters and SQL variables that are only defined in the existing SQL Server stored procedures and functions, but never actually used, is not a problem, but for maintaining complex code, with dozens of parameters and variables a tool like ApexSQL Refactor can be used, which is a free SQL Server Management Studio and Visual Studio add-in, and useful SQL query formatter.
How to format a SQL query to qualify object names explicitly (4298170)
ApexSQL Refactor is a SQL Server Management Studio and Visual Studio add-in, which formats SQL query and refactors SQL code using 11 code refactors and more than 200 formatting options. ... The Object name qualifying feature allows users to refactor a SQL script so that all object names are qualified.
Send logs feature in ApexSQL tools (4288785)
In this article, it will be explained how to use the Send logs feature for sending application log files through ApexSQL tools to the support team. ... Every ApexSQL tool collects all important information regarding work processes and stores them in the log files.
How to create, use, edit and delete SQL formatting profiles with ApexSQL Refactor (4321605)
In this article, we will introduce how to use ApexSQL Refactor SQL formatting profiles and is a guide through the process of managing SQL formatting profiles. ... Hello, and welcome to this video presentation in which we will introduce how to use ApexSQL Refactor SQL formatting profiles and is a guide through the process of managing SQL formatting profiles.
Is my ApexSQL application version vulnerable to Log4j - CVE-2021-44228? (4309395)
Determine if the installed ApexSQL application version is vulnerable to <a href="https://nvd.nist.gov/vuln/detail/CVE-2021-44228" target="_blank">Log4j - CVE-2021-44228</a>. The discovery of critical vulnerability <a href="https://nvd.nist.gov/vuln/detail/CVE-2021-44228" target="_blank">CVE-2021-44228</a> in the Apache Log4j library (CVSS severity level 10 out of 10). <p><strong>Unaffected products:</strong></p><p>ApexSQL Analyze<br>ApexSQL Audit<br>ApexSQL Backup<br>ApexSQL Build<br>ApexSQL Compare<br>ApexSQL Complete<br>ApexSQL Data Diff<br>ApexSQL Data Diff for MySQL<br>ApexSQL Database Power Tools for VS Code<br>ApexSQL Decrypt<br>ApexSQL Defrag<br>ApexSQL DevOps Toolkit<br>ApexSQL Diff<br>ApexSQL Diff for MySQL<br>ApexSQL Discover<br>ApexSQL Doc<br>ApexSQL Doc for MySQL<br>ApexSQL Enforce<br>ApexSQL Generate<br>ApexSQL Job<br>ApexSQL Log<br>ApexSQL Manage<br>ApexSQL Mask<br>ApexSQL Model<br>ApexSQL Monitor<br>ApexSQL Plan<br>ApexSQL Propagate<br>ApexSQL Pump<br>ApexSQL Recover<br>ApexSQL Refactor<br>ApexSQL Script<br>ApexSQL Search<br>ApexSQL Source Control<br>ApexSQL Trigger<br>ApexSQL Unit Test</p><p></p>
Integration of ApexSQL Compare in SSMS causing SSMS 18.8+ to crash (4328922)
Installing the Fundamentals toolkit on a number of workstations and when an Azure SQL Database is queried after logging in with AAD SSMS will crash ~8-10 seconds after displaying results. ... SQL Auth does not have the problem.
Database Tools License Portal - How to download and activate term or perpetual offline licenses? (4370567)
Database Tools License Portal - How to download and activate term or perpetual offline licenses? <p>For term and perpetual offline licenses, users can follow the below steps to download and activate the license from the online license management portal.<br><br>1.
Microsoft SQL Server 2022 Support for ApexSQL Log? - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
Source Control Action Center: how can one ignore user changes and not default select - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
Understand the true significance of "perpetual." - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
Unable to download free trail ApexSql doc. - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
Unable to download free trail ApexSQL Devops Plus toolkit for ApexSQL doc - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
When will SourceControl work with MSSMS 2019? - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
ApexSQL Diff - Object filter - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
Auto-deploy schema changes? Affordable tool options? - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
New Product Association
- Self Service Tools
- Knowledge Base
- Notifications & Alerts
- Product Support
- Software Downloads
- Technical Documentation
- User Forums
- Video Tutorials
- RSS Feed
- Contact Us
- Technical Support
- View All