I'm open to expanding my horizons and taking on new challenges in Information Systems.
My C#, HTML, CSS, and T-SQL coding skills are very strong. I have an even stronger interest in learning more. Interested in a position as a data analyst/developer using the experience and skills I have learned.
With over two years with SQL coding while going to college, I'm interested in enhancing the skills that I already have, while working in a professional productive environment.
I also have near 4 years of Data Control, engineering design, VBA, Visual Basic Coding. I’m expanding my horizons to use more of my skill sets in Information Systems Business Intelligence. I'm very strong with T-SQL Query, SQL Server 2014 and Visual Studio.Net 2015 Enterprise.
Business Intelligence Analyst / Software Developer:
Note: If a foreign key is referenced to the table, truncate will give an error. You must delete the foreign key to that table in order to truncate it and then replace the key after truncating.
Make sure you have Identity_Insert Set to ON for the corresponding table you wish to truncate or populate with information.
SETIDENTITY_INSERTDatabase. dbo. Table ON
Note: All other tables that have Identity_Insert set to on will cause an error. Set all other tables Identity_Insert to off.
SETIDENTITY_INSERTDatabase. dbo. Table OFF
Notes to Remember:
--========================Set Me As The Only User Working============================ Note: Before you set the database to SINGLE_USER, verify that the AUTO_UPDATE_STATISTICS_ASYNC option is set to OFF.
When this option is set to ON, the background thread that is used to update statistics takes a connection
against the database, and you will be unable to access the database in single-user mode. https://support.microsoft.com/en-us/kb/2754171
Check to see which databases have UPDATE STATISTICS_ASYNC set to enabled (ON) using the script below:
SELECT name, is_auto_update_stats_on, is_auto_update_stats_async_on