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

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,

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

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

Tagged with: , , , , , , ,