Year: 2017

Database Corruption Presentation at Pass Summit 2017

Today I had  the opportunity to present on Database Corruption at the PASS Summit 2017 conference. You can download the presentation as a PDF here: Summit 2017 Corruption.pdf Here is the agenda from the corruption presentation. What is Database Corruption Causes

Tagged with: , , , , , ,

Microsoft SQL Operations Studio

Today at PASS Summit Microsoft announced a new SQL “Tool” for running queries against SQL Server, called the Microsoft SQL Operations Studio. So what is the Microsoft SQL Operations Studio This appears to be a new cross platform (Mac, Linux,

Tagged with: ,

Database Health Monitor October 2017 Version Released Today

With over 2000 downloads since the last updated to Database Health Monitor, I figured it was time to get another release of the product out. New Features in 2.6 Added a Job Schedule instance level report. Added an option on

Tagged with: , , , , , , ,

Building a SQL Restore Script When Your Backup Runs

It is handy to have a SQL Restore script ready to go for every backup that you run.  Here is a script that will help with that.  

Tagged with: , , , , , , ,

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: , , , , , , ,

My lucky day

It appears to be my lucky day. Who would have thought that someone I don’t even know would want me to invest $48,000,000 for them. Wow it is so exciting.   ok… now that I am through the sarcasm, I

Tagged with:

Using Antivirus with SQL Server

In a perfect world, your SQL Server would be so secure that you would not need antivirus software, you would have behind layers of firewalls, nobody would ever connect with remote desktop to install anything, and it would always have

Tagged with: , , ,
Top