Tag: SQL Server

DBCC CheckDB and CheckTable doesn’t check In-Memory OLTP.

Special thanks to my friend Theresa Iserman for introducing me to Jos de Bruijn the Senior Program Manager for the In Memory OLTP (Hekaton) project to help get my questions answered at PASS Summit. So, the Hekaton – In Memory

Posted in Corruption, Hekaton Tagged with: , , , , ,

Bellingham SQL Server Users Group November Meeting

Bellingham SQL Server Users Group (Pass Chapter) – November 30th at 6:00pm. Features Presentation by Randolph West: “Back up and Restore your Database with Azure Blob Storage”. Making use of good disaster recovery fundamentals and modern off-site storage, you will

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

Visualizing VLF’s – Updated

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. Here is an updated script that has adds another column called “TextStatus” to the

Posted in Uncategorized Tagged with: , , , , , , ,

When Database Corruption Strikes – PASS Summit 2016

It has been a great week at PASS Summit 2016. Tomorrow I will be presenting on Database Corruption.  The session is called “When Database Corruption Strikes.”   This session is at 3:30pm in Room 2AB, if you are interested in how to

Posted in Corruption, Summit 2016 Tagged with: ,

PASS Summit 2016

Last night I arrived in Seattle for PASS Summit 2016. This is my 4th consecutive PASS Summit, and my second time to be here as a speaker, and I am certainly looking forward to the week. Before I had even

Posted in PASS Summit Tagged with: ,

Presenting at PASS Summit Next Week

Next week I will be presenting on Database Corruption on Friday afternoon at Pass Summit.  The session is called “When Database Corruption Strikes.”   This session is on Friday afternoon, if you are interested in how to deal with database corruption,

Posted in Corruption, Summit 2016 Tagged with: , ,

Presenting this Friday at the CHUG Conference

This Friday, October 14th I will be presenting at the Centricity Healthcare Users Group (CHUG) conference in Austin TX. The session is on “Tune, Monitor and Analyze the Health of Your Centricity SQL Server” and I will be co-presenting with

Posted in CHUG, Performance Tuning Tagged with: , ,

Don’t Reboot SQL Server So Often

How often should I reboot SQL Server? It is a common belief with computers that rebooting cleans things up in memory and that they run better if they are rebooted more often. With your windows desktop or your cell phone

Posted in Performance Tagged with: , ,

Database Corruption Overview for Beginners

Database Corruption Overview: Database corruption is one of those things that you can only plan for by practicing your response plan. Out of all of the things that can happen to your SQL Server this is the one that you

Posted in Corruption Tagged with: , , , , , , ,

Instant File Initialization (IFI)

One way to improve performance on SQL Server is with IFI or Instant File Initialization. Normally files are zeroed out on a database growth during an AUTOGROW, RESTORE, CREATE DATABASE or ALTER DATABASE. This is done by SQL Server when

Posted in Performance, Performance Tuning Tagged with: , , , , , , ,