Database Development

Leveraging an organization’s data stores is crucial to enabling strategic decision-making. My articles below illustrate skills necessary for an firm to achieve its goals.

Common tasks during database development

Normalization

SQL Server: SSMS Object Explorer Filter

xSQL Data Compare

T-SQL

T-SQL: Binary_Checksum	T-SQL: Bitwise Arithmetic	T-SQL: Checksum
T-SQL: Complex Queries	T-SQL: Compound Operators	T-SQL: Control Flow
T-SQL: Cross-Database Logic	T-SQL: Cursor	T-SQL: DELETE FROM
T-SQL: Divide	T-SQL: NTile	T-SQL: Parsing Values
T-SQL: Pivot	T-SQL: Rank	T-SQL: Ranking Functions
T-SQL: Row_Number	T-SQL: Stored Procedure Default Values	T-SQL: String Search
T-SQL: Subquery – Select	T-SQL: Synonym	T-SQL: Trigger – Insert After
T-SQL: User Defined Functions	T-SQL: WITH	T-SQL Format Date Values
T-SQL: Common Table Expressions