If you work with large scale SSIS ETL processes and sequences, you are bound to have to work with UTF-8 encoded text files. Without proper handling, UTF-8 / Unicode characters can cause havoc with your SSIS load tasks. Here are some ideas for handling the UTF-8 file formats with SSIS.
Nigel Sammy will be presenting this PASS Data Architecture VC webinar on December 19 at 12PM CST. The webinar will share insight on how basic query structure and logic works so you can avoid wasting too much time on trial and error when writing queries.
A more detailed look at the DAX language and some of its more frequently used functions
In this document I will attempt to talk you through writing your first very simple DAX queries. For the purpose of this document I will query the rather familiar Adventure Works Tabular Cube.
Phil Scrace, a test engineer at Red Gate, talks about adopting Model Based Testing (MBT), a technique that combines graph theory and code writing to help keep pace with frequently changing functionality.
SQL Saturday is coming to Slovenia on December 21, 2013. This is a free all-day training and networking event for SQL Server professionals.
Today Steve Jones talks about those PVPs, private virtual properties, that your company may own. There are challenges with maintaining these items that show the technology field's immaturity.
Grant Fritchey, SQL Server MVP will be hosting a free seminar in Cambridge on January 10 2014. Join fellow database professionals to learn tips and best practices for SQL Server version control, continuous integration and deployment.
Someone has dropped a table from your database and you want to track who did it. Or someone has deleted some data from a table, but no one will say who did. In this tip, we will look at how you can use the transaction log to track down some of this information.
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Is there a good syllabus for reading these two together? (Yes, it's called the...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers