Compressing all tables in a database in SQL Server March 17th, 2015 13 Database Maintenance SQL Server
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) June 14st, 2014 7 Database Query Development SQL Server
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