One of the most important requirements in the process of SQL database refactoring is that any change made in a database schema requires all dependences to be updated and changed to reflect the changes you madeApril 2, 2014
What is database refactoring?
Database refactoring is a change in a database schema with a goal to improve a database design and retain both informational and behavior semanticsMarch 14, 2014
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 rowsMarch 10, 2014
Replacing a natural key with a surrogate key is structural refactoring method of replacing an existing natural key with a surrogate key.February 20, 2014
There is a number of object types in SQL Server database system. Each has its own purpose and role in proper data management. However, sometimes it is required to check how some of them are usedFebruary 19, 2014
Rename Table, Rename Column, and Rename View are structural refactorings. The main purpose to apply Rename Column, Rename Table, and Rename View are increasing readability, adopting database naming conventions, or clarifying the meaning of an object. In the case of renaming objects you should consider a cost of refactoring both database and external applications that access the database vs. an impact of the achieved readabilityFebruary 18, 2014
In this article we’ll make an introduction in a series of articles on SQL database refactoring and solutions using ApexSQL Refactor a free SSMS and VS add-in with 11 SQL database refactorsFebruary 14, 2014
In this article we’ll give some most common guidance in naming conventions and show how ApexSQL Refactor, a free SQL formatting Visual Studio and SSMS add-in with nearly 200 formatting options, can help in achieving capitalization consistency among team members.February 13, 2014
In this article we’ll give some tips on T-SQL code commenting and improving your productivity using ApexSQL Refactor’s Comments feature. ApexSQL Refactor is a free SQL Server and Visual Studio SQL Formatting add-in with nearly 200 formatting options.
The main purpose of comments is to document our code and write descriptions of what code is doing.February 12, 2014
More and more companies are creating online catalogues to allow customers to browse their objects prior to coming to their store
Having a list with a price and description just doesn’t cut it anymore. People want to see what the product looks like and as such having images associated to each item is pivotalFebruary 10, 2014