SQL Server DBA, BI Analyst and Microsoft MVP

Posts Archive

Month: June 2014

Back to Archive

Importing CSV files into SQL Server database

June 14, 2014 4 min read

Continue reading

Searching text in all columns of all tables in SQL Server

June 14, 2014 3 min read

Continue reading

File operations using OLE Automation in SQL Server

June 14, 2014 10 min read

Continue reading

Searching for a string in a job (or step) in SQL Server

June 14, 2014 3 min read

Continue reading

SQL Server - Splitting strings into substrings using a separator (Split string)

June 14, 2014 9 min read

Continue reading

Writing numbers in words in PHP

June 8, 2014 2 min read

Continue reading

Removing number formatting in PHP

June 8, 2014 1 min read

Continue reading

Dropping All Objects from an Owner in Oracle Database

June 7, 2014 3 min read

Continue reading

Generating reverse engineering (Creation DDL) of Users, Tablespaces, Roles, Jobs and Profiles in Oracle Database

June 7, 2014 1 min read

Continue reading

AWR reports via script in Oracle Database 11g

June 7, 2014 1 min read

Continue reading

Converting date formats in PHP

June 7, 2014 1 min read

Continue reading

Generating reverse engineering of objects (DDL Backup) in Oracle Database 11g

June 7, 2014 1 min read

Continue reading

Creating Gradient Effects with CSS

June 7, 2014 1 min read

Continue reading

How to remove HTML tags from a string in SQL Server

June 7, 2014 5 min read

Continue reading

Removing all files from a directory with PHP

June 7, 2014 2 min read

Continue reading

Adding and subtracting dates and times in PHP

June 7, 2014 3 min read

Continue reading

Listing files with PHP

June 7, 2014 2 min read

Continue reading

Reading and writing text files in PHP

June 7, 2014 1 min read

Continue reading