Data Engineering – Learn from the experts
-
March 2013 UG Meet
March 2013 UG is finally scheduled !! We are stepped into one more month and this month UG is scheduled on 30th March. We hope to see you all again this month with the same energy. Pass this information to your friends who can join the event. We are expecting more participants.
-
Retrieve Auditing Configuration Details
Script to retrieve auditing configuration details in sql server. Auditing feature is released from SQL Server 2008 onward so if you have utilized this feature then you can make use of this script to get quick information about audit configuration.
-
February 2013 UG Meet
Thanks to all the participants who came to Jan 2013 UG meeting, we are happy to see you all and hope the same continues to Feb UG meeting. This month UG meet is scheduled on 23rd . Please pass this information to your colleagues and friends who are interested to learn SQL Server. We would…
-
Find Indexed column details in a database
I was looking for a script to find out the indexed column details as part of our migration. I tried to use sp_helpindex however it requires a object name which means you can find details for only one table at a time. My requirement is to get details about all indexed columns across the database…
-
Loading Flat File – Row Delimiter Not Recognized
I was working in a migration project where we migrated SQL Server 2000 to SQL Server 2008 R2. Everything went fine except one SSIS package. It’s a simple package where we are importing data from a csv file. This csv file is created from Unix environment with TAB as column delimiter and CR\LF as row…
Got any recommendations?