Some databases lack dynamic row column conversion capability in SQL, and column names must be written when converting rows to columns. Many databases can only use stored procedures instead. esProc SPL ...

Convert all SQL Server database logic entries into PostgreSQL format, including stored procedures, functions, triggers, and views. Perform functional and performance tests to verify the resulting ...

How to Convert Rows to Columns in OpenOffice. Apache OpenOffice's Calc application contains a handy feature for restructuring spreadsheet tables or data lists.

When designing objects in SQL Server, we must follow certain best practices. For example, a table should have primary keys, identity columns, clustered and unclustered indexes, data integrity and ...

SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships. As I noted in an earlier column, JSON is great ...

If you are given urorganized raw data and wish to convert data in one column to organized data in Excel, then this this article will help you.

Here is a list of common wait types and techniques that every DBA (or wannabe DBA) should know. While there are many more wait types than listed here, understanding these will give you a leg up when ...

‘CreatedOnDateTime’ is a date/time value, so we can map it to the datetimeoffset in SQL Server (see this post for reasons why to choose it instead of datetime). The ‘Image’ column is an image, and ...

When we connect an app to a SQL Server table that has a column of type time, the values don't show in a user-friendly format by default in PowerApps. In this post we'll go over some expressions that ...