Tag: DATETIME

By Posted on Posted in 70-461 Training, TSQL 2012 No Comments Tagged with , , , , , ,

Here is a quick video training on how to use the T-SQL EOMONTH function on SQL Server. This was originally part of my free SQL query training for the 70-461 certification exam. The EOMONTH function returns the last day of a given month, or a future or past month by using the second parameter of offset. EOMONTH was introduced in SQL Server …

Using The TSQL EOMONTH Function Read more »

By Posted on Posted in Recovery No Comments Tagged with , , , , , , ,

This is a followup to my Whats more important than a backup plan article posted a couple of months ago. When you do a database restore, including log backups, it is very important to get the log chain in the right order, or it won’t work.  To restore a full backup, then log backups, the chain of logs could be …

Restoring A Log Chain Read more »