SQL database refactoring – Introduction

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 semantics

March 14, 2014

Tracking SQL Server object usage

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 used

February 19, 2014

SQL database refactoring techniques – Rename method

Why rename?

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 readability

February 18, 2014

Rules of SQL formatting – SQL code commenting

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

How to recover a deleted image from SQL Server into a file

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 pivotal

February 10, 2014