Month: September 2017

Script all Agent Jobs Using SQL Server Management Studio

While doing a recent server move, I came across the need to script all agent jobs and save them to a file so that if we needed to reference what was there after the move we could get at the

Posted in Uncategorized Tagged with: , , ,

Backup and Restore – Pass Chapter Presentation

Yesterday I had the opportunity to practice one of my sessions on Backup and Restore that I will be presenting at PASS Summit this year. I presented it at two different SQL Server Users Group meetings, one in Bellingham WA,

Posted in PASS Chapter Tagged with: , , , , ,

Visualizing VLFs – Another update

A while back a wrote a blog post with a query to Visualize the VLF’s in your database. Today I have an update to that script. The previously updated script added another column called “TextStatus” to the output to give

Posted in SQL Server Tagged with:

Determining how much of your data file has been modified

SQL Server 2017 introduces a new column in the sys.dm_db_file_space_usage system table. The column is modified_extent_page_count, which tells how many pages have been modified in your data file since the last full backup. What is really interesting about this is that with

Posted in SQL 2017, TSQL Tagged with: , , , , , , ,