database

Compressing all tables in a database in SQL Server

March 17th, 2015
13
Database SQL Server Maintenance

Installing Oracle Database 11g R2 on Windows

March 16th, 2015
1
Oracle Database

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

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

Similarities and Differences between DELETE, TRUNCATE and DROP TABLE

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

Importing CSV Files into the SQL Server Database

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

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

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

File Operations Using OLE Automation in SQL Server

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

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
Query Development Data Formatting and Validation Database SQL Server

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

June 7st, 2014
0
Database Oracle