Blog Archives

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

Cortana Intelligence Suite – Podcast Episode #62.

This weeks latest podcast is an interview with Melissa Coates, on the topic of Cortana Intelligence Suite. From this weeks podcast: The Cortana Intelligence Suite is actually a huge collection of services in Azure for the purposes of providing big

Posted in Podcast 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: , , , , , , ,

Duplicate Indexes, What a Waste

Today on the tuning minute on the SQL Data Partners Podcast, we discussed duplicate indexes, which lead me to think more about and and write this post. You know there are many different ways of doing things in SQL Server,

Posted in Indexing Tagged with: , , , , ,

Database Corruption Video – HA DR Chapter

The following Database Corruption Video is from the High Availability Disaster Recovery Virtual Chapter Presentation on September 13, 2016. Today I had the opportunity to present at the High Availability Disaster Recovery Virtual Chapter meeting on the topic of Database

Posted in Corruption Tagged with:

Podcast Episode 60 : U-SQL

I can’t believe that this was the 11th episode that I have been part of with the SQL Data Partners podcast with Carlos Chacon. Starting at Episode 50 we have been through some great episodes. Here is a list of the

Posted in Podcast Tagged with: , , ,

Episode 59: Mirroring, Availability Groups, Replication, and Log shipping

This week on the SQL Data Partners Podcast Episode #59 we discussed Mirroring, Availability Groups, Replication and Log Shipping. There were 4 of us on the podcast, two guests Mariano Kovo and Andy Mallon, along with Carlos Chacon and I.

Posted in Podcast Tagged with: , , , , , , ,

The Use of WITH NOLOCK Query Hint

There is a great deal of confusion about the WITH NOLOCK query hint. The following is a transcription of a conversation that I had with Carlos Chacon on the SQL Data Partners Podcast #57 about the WITH NOLOCK hint, and some

Posted in Performance, Podcast Tagged with: ,

Podcast Episode 58: Four Ways to Stay Sharp with Technical Learning

This week on the SQL Data Partners podcast, Podcast Episode #58, we focused on Four Ways to Stay Sharp with Technical Learning.    I can’t believe this is the 8th in a row of the SQL Data Partners podcast that I have

Posted in Podcast Tagged with: , ,

Podcast Episode 57: the SQL Server Hit List – Our Least Favorite Features

For this weeks SQL Data Partners podcastCarlos Chacon and I followed up on one of the #sqlfamily questions that we usually ask at the end of the podcast. If you could change one thing about SQL Server, what would it be?

Posted in Podcast Tagged with: , , , , , ,

SQL Server Performance Tuning

Need help with SQL Server Performance Tuning, contact Steve at Stedman Solutions, LLC for help, or take a look at the performance tuning page at the SteveStedman.com blog. We can help with tuning a single query or with figuring out why your SQL Server is running slow. Free 30 minute consultation.

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at SteveStedman.com with my newsletter.
Newsletter signup form.

Stedman Solutions

StedmanSolutionsRemoteSkilledDBA

Archives