I am very new to SQL and honestly not very good at it yet. I depend on the kindness of others sharing their knowledge like yourselves when faced with an issue.
I need to add a field to a couple of tables in SQL that contain a standard date (date format) or they maybe VARCHAR format so we may need two different solutions. What I need to do is to take that date field and add a new field that would provide the date in serial format. (example: 10/2/2014 would be 41914) Again, some tables have the date in a varchar format so I guess that really isn't a date, at least as far as SQL is concerned so this would have to be converted to a date first then to a serial date. Other tables have the date in a DATE format already.
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed