database

Compressing all tables in a database in SQL Server

March 17th, 2015
13
Database Maintenance SQL Server

Installing Oracle Database 11g R2 on Windows

March 16th, 2015
1
Database Oracle

Validating CPF, CNPJ, Email, Phone, and Zip Code in SQL Server

February 17rd, 2015
19
Database Query Development Data Formatting and Validation SQL Server

Similarities and Differences between DELETE, TRUNCATE and DROP TABLE

February 17rd, 2015
0
Database Query Development MySQL / MariaDB Oracle SQL Server

Importing CSV Files into the SQL Server Database

June 14st, 2014
2
Database Query Development JSON, XML, CSV and Excel File Handling OLE Automation SQL Server

Performing a textual search on all columns of all tables in SQL Server

June 14st, 2014
7
Database Query Development DMVs and Catalog Views SQL Server

File Operations Using OLE Automation in SQL Server

June 14st, 2014
0
Database File Handling OLE Automation SQL Server

SQL Server - Breaking strings into sub-strings using a separator (Split string)

Removing HTML Tags from a String in SQL Server

June 7st, 2014
0
Database Query Development Data Formatting and Validation SQL Server

Generating Reverse Engineering (Creation DDL) from Oracle Database Users, Tablespaces, Roles, Jobs, and Profiles

June 7st, 2014
0
Database Oracle