Importing Flat Files with embedded text qualifiers

Importing Flat Files with Embedded Text Qualifiers to SQL Server Some systems (especially Linux) can generate flat files where a text qualifier is escaped within quoted text. Think about a list of plumbing parts where you have the SKU number and description. Some of these lines could look like the following in a database: SKU … Continue reading "Importing Flat Files with embedded text qualifiers"...
By sqletl | September 23, 2017 | Uncategorized

Processing Complex Text Files with SQL Server

Many organizations work with files that contain header information at the top of the file before the data rows begin. This header information typically contains critical information of the file such as when it was processed, any transaction identity markers or batch ID’s, and other important information. In order to retrieve this information, IT departments … Continue reading "Processing Complex Text Files with SQL Server"...
By sqletl | September 16, 2017 | Uncategorized

Sending a Text Message from SQL Server

Sending a Text Message from SQL Server Sending a text message from SQL Server is actually pretty easy. I had no idea, but text messages go just like a standard email does. As long as you know your service provider’s smtp host, you can use the MSDB..sp_send_dbmail proc and put the recipient as their phone … Continue reading "Sending a Text Message from SQL Server"...
By sqletl | July 6, 2017 | Uncategorized

Creating a Robust Database for Business Users Without Blocking

Over the years of building and maintaining business user facing databases for adHoc and reporting analysis, I’ve had numerous situations where I would need to truncate/reload a table or perform an update on it. However, if one of the business users was querying the table, I would have to wait for them to finish their … Continue reading "Creating a Robust Database for Business Users Without Blocking"...
By sqletl | July 5, 2017 | Uncategorized

Quick script to catch sneaky people

I have come across many instances in the past where users would try to elevate their permissions through sneaky ways, and below is a link to a quick script that I use to check for this. Have fun!   SP Check for Sneaky Peeps...
By sqletl | June 24, 2017 | Uncategorized

New Website Launched

We are very excited to announce the launch of our new website. Additionally, we are now offering a free version of EDIS called EDIS Standard. Please check out our products page for more information. Thanks, SQL ETL Team...
By sqletl | March 22, 2017 | Uncategorized

One thought on “New Website Launched”

Leave a Reply

Your email address will not be published. Required fields are marked *